[OpenSER-Users] how to register xlite user for testing with openser

Live Great livegreat007 at yahoo.com
Sat Sep 22 08:24:59 CEST 2007


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 at yahoo.com>
To: users at 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 at 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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070922/bb097959/attachment.htm>


More information about the sr-users mailing list