I believe the openser_mysql.sh script is being phased out.  It has been
replaced by openserdbctl (thanks to a big effort from Henning !!!).  If
your installation doesn't have /usr/local/sbin/openserdbctl I strongly
suggest that you upgrade to a version of OpenSER that contains it.

The rest of your settings appear to to be ok.

Regards,
Norm

Live Great wrote:
>
>
> ----- Original Message ----
> From: Norman Brandinger <norm@goes.com>
> To: Live Great <livegreat007@yahoo.com>
> Cc: users@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 <livegreat007@yahoo.com>
> > To: users@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@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@openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >  
>
>