Thanks I have remove the default admin account and added phone number as my account. Now xlite is registered with the phone number I created.
I actually have mediaproxy running, but still getting those errors related to the mediaproxy.
# ps -auxww | grep media root 57346 0.0 0.5 6140 5332 ?? S 5:51PM 0:09.44 python /usr/local/mediaproxy/mediaproxy.py
I found the mediaproxy.ini.sample file is in the /usr/local/mediaproxy/ directory. I renamed it to mediaproxy.ini, restarted mediaproxy.py, but still getting the same error. The content of the mediaproxy.ini file is shown below: start = yes socket = /var/run/mediaproxy.sock group = openser listen = None allow = None ;proxyIP = 10.0.0.1 portRange = 60000:65000 ;TOS = 0xb8 idleTimeout = 60 holdTimeout = 3600 forceClose = 0
[Accounting] ; one of none, radius or database accounting = none
[Database] user = dbuser password = dbpass host = dbhost database = radius table = radacct
[Radius] secret = secret server = localhost authport = 1812 acctport = 1813 dictionaries = /etc/radiusclient-ng/dictionary, /etc/openser/radius/dictionary, /usr/local/mediaproxy/dictionary retries = 2 timeout = 3
What should be change in the mediaproxy.ini file to correct the error?
Thanks SW
----- Original Message ---- From: Norman Brandinger norm@goes.com To: Live Great livegreat007@yahoo.com Cc: users@openser.org Sent: Sunday, September 23, 2007 10:50:38 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser
Hi,
The subscriber "username" IS the "phone number".. The phone number field in the subscriber table is only used by SERWEB. I believe the "username" column name is better than "phone" because in SIP, the idea of a telephone number is being blurred.
Please refer to the online doc at: http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber
There is alot of material at the openser.org web site that can help you.
The mediaproxy errors are a result of your script calling a mediaproxy function but mediaproxy isn't running. This can be downloaded thanks to AG Projects from http://ag-projects.com/MediaProxy.html
The src_leg / dst_leg errors are a result of you trying to save additional (accounting) fields into the "acc" and/or "missed_calls" table. This is generally used for multi-leg call accounting (for example, in a call forwarding situation where the initial callee changes to the caller .. of the forwarded call). You will have to manually add these column to the acc and missed_calls tables (varchar(64)) should be fine for most purposes.
Regards, Norm
Live Great wrote:
Now is getting other errors. When I tried to dial a number, eg. 123 - the default Admin account, I got the following errors shown in /var/log/messages:
ERROR:avpops:load_avps: no value for first param error: mediaproxy/sendMediaproxyCommand(): can't connect to MediaProxy error: mediaproxy/sendMediaproxyCommand(): can't connect to MediaProxy submit_query: Unknown column 'src_leg' in 'field list' db_insert: Error while submitting query ERROR:acc:acc_db_request: Error while inserting to database
----- Original Message ---- From: Norman Brandinger norm@goes.com To: Live Great livegreat007@yahoo.com Sent: Saturday, September 22, 2007 11:53:53 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser
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