<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;">Thanks for your suggestion.<br>I don't wanna mess up the package in freebsd. <br>Actually when I added the colnum uuid, my xlite program is able to register with the default admin user in the 'subscriber' table.<br>I also used openserctl created my account name with password, but in the subscriber table, I found the phone number field is empty.<br>Do you know how to create a phone number for a newly created user account?<br>eg. openserctl sam passwd sam@my.dot.com<br>create my openser account, but how to add a phone number to my account?<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: Sunday, September 23, 2007 1:42:18 PM<br>Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser<br><br><div>It's possible that openserdbctl is only available on the development<br>versions. I've found that the current development version is very<br>stable and you might want to give it a try.<br><br>If you are going to stay with 1.2.2, then you might want to try dropping<br>the openser database, then recreate it and keep a close eye out for any<br>errors. After the database has been rebuilt, check the subscriber<br>table. I believe it used to have a uuid column (the current development<br>version does not have a uuid column).<br><br>The ha1 field is the encrypted password and is probably used in your<br>config during the registration of your xlite phones. Without a<br>successful registration, it's unlikely
you will be able to complete any<br>calls.<br><br>A quick look at the database structures from the online doc at:<br><a target="_blank" href="http://openser.org/dokuwiki/doku.php">http://openser.org/dokuwiki/doku.php</a> shows that the subscriber table had<br>a uuid column in 1.0.x, but in 1.2.x that column is gone. Is it<br>possible that the openser database was created with version 1.2.x but<br>you are running openser 1.0.x ?<br><br>Regards,<br>Norm<br><br><br>Live Great wrote:<br>> 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>> ----- 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<br>> with openser<br>><br>> 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<br>> 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>> > > _______________________________________________<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>><br><br></div></div><br></div></div></body></html>