<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;">Hi,<br><br>The openser version in freebsd is the latest one I got:<br> # openser -V<br>version: openser 1.2.2-notls (i386/freebsd)<br><br>Is this the correct version for getting openserdbctl ?<br><br>Thanks<br>SW<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>Sent: Saturday, September 22, 2007 11:53:53 PM<br>Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser<br><br><div>I believe the openser_mysql.sh script is being phased out. It has been<br>replaced by openserdbctl (thanks to a big effort from Henning
!!!). If<br>your installation doesn't have /usr/local/sbin/openserdbctl I strongly<br>suggest that you upgrade to a version of OpenSER that contains it.<br><br>The rest of your settings appear to to be ok.<br><br>Regards,<br>Norm<br><br>Live Great wrote:<br>><br>><br>> ----- 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<br>> with openser<br>><br>> 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<br>> 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>><br><br></div></div><br></div></div></body></html>