Re: [OpenSER-Users] how to register xlite user for testing with openser - sr-users

22 Sep 2007

----- Original Message ----
From: Norman Brandinger &lt;norm(a)goes.com&gt;
To: Live Great &lt;livegreat007(a)yahoo.com&gt;
Cc: users(a)openser.org
Sent: Saturday, September 22, 2007 9:43:54 PM
Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser

Is is possible that you turned on database support but forgot to make
the database tables ?  The error message you posted is pretty explicit:
"Unknown column"....
I used openser_mysql.sh create to populate openser database and its tables.
Here is all its tables:
mysql> show tables;
+-----------------------+
| Tables_in_openser     |
+-----------------------+
| acc                   |
| active_sessions       |
| active_watchers       |
| address               |
| admin_privileges      |
| aliases               |
| cpl                   |
| dbaliases             |
| domain                |
| domainpolicy          |
| grp                   |
| gw                    |
| gw_grp                |
| imc_members           |
| imc_rooms             |
| lcr                   |
| location              |
| missed_calls          |
| pdt                   |
| pending               |
| phonebook             |
| presentity            |
| pua                   |
| re_grp                |
| server_monitoring     |
| server_monitoring_agg |
| silo                  |
| sip_trace             |
| speed_dial            |
| subscriber            |
| trusted               |
| uri                   |
| usr_preferences       |
| usr_preferences_types |
| version               |
| watchers              |
| xcap_xml              |
+-----------------------+
37 rows in set (0.00 sec)

The warnings about missing permissions files can be ignored (unless you
really do need them), but in your case, it seems that you are not at
that point yet.

Take a look at openserdbctl as it automates the process of creating the
database and tables needed by the various openser modules.  openserctlrc
(usually located in /usr/local/etc/openser) contains a number of startup
settings, some of which are database related.

The standard request you will receive from people trying to assist you
is to post your config file (or at least the interesting sections of it).

The part of the content of openser.cfg is:
listen = udp:127.0.0.1:5060
listen = udp:125.255.1.2:5060
mpath = "/usr/local/lib/openser/modules"
children = 8
debug = 3
fork = yes
group = "openser"
user = "openser"
disable_tcp = no
log_facility = LOG_DAEMON
#log_facility = LOG_LOCAL7
log_stderror = no
tcp_children = 4
mhomed = no
server_signature = yes
sock_group = "openser"
sock_mode = 0600
sock_user = "openser"
unix_sock = "/tmp/openser.sock"
unix_sock_children = 1
reply_to_via = no
sip_warning = no
check_via = no
dns = no
rev_dns = no
disable_core_dump = no
dns_try_ipv6 = yes
dns_use_search_list = yes

openserctlrc:
## your SIP domain
 SIP_DOMAIN=ip6.com.au

## database type: MYSQL or PGSQL, by defaulte none is loaded
 DBENGINE=MYSQL

## database host
 DBHOST=localhost

## database name
 DBNAME=openser

## database read/write user
 DBRWUSER=openser
# DBRWUSER=admin

## database read only user
 DBROUSER=openserro

## password for database read only user
 DBROPW=openserro

## database super user
 DBROOTUSER="root"

 HAS_SERWEB="yes"

I am not too sure the correct way to define openserctlrc file.
Your comment is much appreciated.

Thanks
SW

Norm

Live Great wrote:
...
  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 &lt;livegreat007(a)yahoo.com&gt;
 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

 ------------------------------------------------------------------------

 _______________________________________________
 Users mailing list
 Users(a)openser.org
 http://openser.org/cgi-bin/mailman/listinfo/users