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(a)yahoo.com>
To: users(a)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(a)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