----- Original Message ---- From: Norman Brandinger <[EMAIL PROTECTED]> To: Live Great <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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 [EMAIL PROTECTED] > > 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 >
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users