Hi,
After changed the port 5077 to 5060 in openser.cfg file, restarted openser.
When xlite initiate a registartion request, openser system log file shown a different message:
Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default allow file (/usr/local/etc/openser/permissions.allow) not found => empty rule set
Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: WARNING: File not found: /usr/local/etc/openser/permissions.deny
Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default deny file (/usr/local/etc/openser/permissions.deny) not found => empty rule set
Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22
16:19:01 core /usr/local/sbin/openser[49953]: db_query: Error while submitting query
Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: get_ha1(): Error while querying database
Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: db_query: Error while submitting query
Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: get_ha1(): Error while querying database
Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: db_query: Error while submitting query
Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: get_ha1(): Error while querying database
Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: db_query: Error while
submitting query
Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: get_ha1(): Error while querying database
Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: db_query: Error while submitting query
Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: get_ha1(): Error while querying database
Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: db_query: Error while submitting query
Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: get_ha1(): Error while querying database
Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: db_query: Error while submitting query
Sep 22 16:19:11 core
/usr/local/sbin/openser[49957]: get_ha1(): Error while querying database
Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: db_query: Error while submitting query
Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: get_ha1(): Error while querying database
Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: db_query: Error while submitting query
Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: get_ha1(): Error while querying database
Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: db_query: Error while submitting query
Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: get_ha1(): Error while querying
database
Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: db_query: Error while submitting query
Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: get_ha1(): Error while querying database
Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: db_query: Error while submitting query
Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: get_ha1(): Error while querying database
Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: db_query: Error while submitting query
Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: get_ha1(): Error while querying database
Sep 22 16:19:29 core /usr/local/sbin/openser[49954]:
submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: db_query: Error while submitting query
Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: get_ha1(): Error while querying database
Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: db_query: Error while submitting query
Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: get_ha1(): Error while querying database
Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: submit_query: Unknown column 'uuid' in 'field list'
Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: db_query: Error while submitting query
Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: get_ha1(): Error while querying database
In Xlite, it said Registration error 500, server internal error.
What is possibility wrong in my openser server
configuration?
Thanks
SW
----- Original Message ----
From: Live Great <livegreat007@yahoo.com>
To: users@openser.org
Sent: Saturday, September 22, 2007 2:03:07 PM
Subject: [OpenSER-Users] how to register xlite user for testing with openser
Hi,
I used the following command to add xlite user, but xlite failed to register the user in openser server.
# openserctl add 1234 1234 sam@my.domain.com
where 1234 is user id and password.
If this is not the correct way to add user for testing from xlite to openser, what are the alternative way I can use?
Thanks
SW