<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Norman Brandinger <norm@goes.com><br>To: Live Great <livegreat007@yahoo.com><br>Cc: users@openser.org<br>Sent: Saturday, September 22, 2007 9:43:54 PM<br>Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser<br><br><div>Is is possible that you turned on database support but forgot to make<br>the database tables ? The error message you posted is pretty explicit:<br>"Unknown column"....<br>I used openser_mysql.sh create to populate openser database and its tables.<br>Here is all its tables:<br>mysql> show
tables;<br>+-----------------------+<br>| Tables_in_openser |<br>+-----------------------+<br>| acc |<br>| active_sessions |<br>| active_watchers |<br>| address |<br>| admin_privileges |<br>| aliases |<br>| cpl |<br>| dbaliases |<br>| domain |<br>|
domainpolicy |<br>| grp |<br>| gw |<br>| gw_grp |<br>| imc_members |<br>| imc_rooms |<br>| lcr |<br>| location |<br>| missed_calls |<br>|
pdt |<br>| pending |<br>| phonebook |<br>| presentity |<br>| pua |<br>| re_grp |<br>| server_monitoring |<br>| server_monitoring_agg |<br>| silo |<br>| sip_trace |<br>|
speed_dial |<br>| subscriber |<br>| trusted |<br>| uri |<br>| usr_preferences |<br>| usr_preferences_types |<br>| version |<br>| watchers |<br>| xcap_xml |<br>+-----------------------+<br>37 rows in set (0.00 sec)<br><br><br><br>The warnings about missing permissions files can be ignored (unless you<br>really do need them), but in your case, it seems that you are
not at<br>that point yet.<br><br>Take a look at openserdbctl as it automates the process of creating the<br>database and tables needed by the various openser modules. openserctlrc<br>(usually located in /usr/local/etc/openser) contains a number of startup<br>settings, some of which are database related.<br><br>The standard request you will receive from people trying to assist you<br>is to post your config file (or at least the interesting sections of it).<br><br>The part of the content of openser.cfg is:<br>listen = udp:127.0.0.1:5060<br>listen = udp:125.255.1.2:5060<br>mpath = "/usr/local/lib/openser/modules"<br>children = 8<br>debug = 3<br>fork = yes<br>group = "openser"<br>user = "openser"<br>disable_tcp = no<br>log_facility = LOG_DAEMON<br>#log_facility = LOG_LOCAL7<br>log_stderror = no<br>tcp_children = 4<br>mhomed = no<br>server_signature = yes<br>sock_group = "openser"<br>sock_mode = 0600<br>sock_user = "openser"<br>unix_sock =
"/tmp/openser.sock"<br>unix_sock_children = 1<br>reply_to_via = no<br>sip_warning = no<br>check_via = no<br>dns = no<br>rev_dns = no<br>disable_core_dump = no<br>dns_try_ipv6 = yes<br>dns_use_search_list = yes<br><br>openserctlrc:<br>## your SIP domain<br> SIP_DOMAIN=ip6.com.au<br><br>## database type: MYSQL or PGSQL, by defaulte none is loaded<br> DBENGINE=MYSQL<br><br>## database host<br> DBHOST=localhost<br><br>## database name<br> DBNAME=openser<br><br>## database read/write user<br> DBRWUSER=openser<br># DBRWUSER=admin<br><br>## database read only user<br> DBROUSER=openserro<br><br>## password for database read only user<br> DBROPW=openserro<br><br>## database super user<br> DBROOTUSER="root"<br><br> HAS_SERWEB="yes"<br><br>I am not too sure the correct way to define openserctlrc file.<br>Your comment is much appreciated.<br><br>Thanks<br>SW<br><br>Norm<br><br>Live Great wrote:<br>>
Hi,<br>><br>> After changed the port 5077 to 5060 in openser.cfg file, restarted<br>> openser.<br>> When xlite initiate a registartion request, openser system log file<br>> shown a different message:<br>> Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default allow<br>> file (/usr/local/etc/openser/permissions.allow) not found => empty<br>> rule set<br>> Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: WARNING: File not<br>> found: /usr/local/etc/openser/permissions.deny<br>> Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default deny file<br>> (/usr/local/etc/openser/permissions.deny) not found => empty rule set<br>> Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:01 core
/usr/local/sbin/openser[49953]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: db_query: Error<br>>
while submitting query<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:11 core
/usr/local/sbin/openser[49957]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: submit_query:<br>> Unknown column
'uuid' in 'field list'<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:22 core
/usr/local/sbin/openser[49952]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: get_ha1(): Error<br>> while querying database<br>> Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: get_ha1(): Error<br>>
while querying database<br>> Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: submit_query:<br>> Unknown column 'uuid' in 'field list'<br>> Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: db_query: Error<br>> while submitting query<br>> Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: get_ha1(): Error<br>> while querying database<br>><br>> In Xlite, it said Registration error 500, server internal error.<br>> What is possibility wrong in my openser server configuration?<br>><br>><br>> Thanks<br>> SW<br>><br>> ----- Original Message ----<br>> From: Live Great <livegreat007@yahoo.com><br>> To: users@openser.org<br>> Sent: Saturday, September 22, 2007 2:03:07 PM<br>> Subject: [OpenSER-Users] how to register xlite user for testing with<br>> openser<br>><br>> Hi,<br>><br>> I used the following command to add xlite user, but xlite failed to<br>> register the user in
openser server.<br>> # openserctl add 1234 1234 sam@my.domain.com<br>><br>> where 1234 is user id and password.<br>><br>> If this is not the correct way to add user for testing from xlite to<br>> openser, what are the alternative way I can use?<br>><br>><br>> Thanks<br>> SW<br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> Users mailing list<br>> Users@openser.org<br>> <a target="_blank" href="http://openser.org/cgi-bin/mailman/listinfo/users">http://openser.org/cgi-bin/mailman/listinfo/users</a><br>> <br><br></div></div><br></div></div></body></html>