- sr-users - kamailio.org

[Serusers] [Fwd: Re: domain name in route header]
by Klaus Darilion 24 Sep '07

24 Sep '07

forgot to cc the list ... -------- Original-Nachricht -------- Betreff: Re: domain name in route header Datum: Mon, 17 Sep 2007 18:58:33 +0200 Von: Klaus Darilion <klaus.mailinglists(a)pernau.at> An: Juha Heinanen <jh(a)tutpro.com> Referenzen: <18154.37441.743333.215104(a)tutpro.com> Juha Heinanen schrieb: > klaus, > > if you want to support domains in route headers, then you need to do > naptr and srv lookups for the domain when handling loose routing. it is > not enough to compare the domain to the ones domain module knows about. > domain in route header may namely be anything as long as it resolves to > your proxy. for this reason, i don't like the idea of domains in route > headers. it hurts performance far too much. I also do not like to configure openser all possible hostnames as alias - but it is not uncommon that the SIP domain is in the pre-loaded route - at least most exosip based clients do that. Thus, having support for those clients is IMO useful. regards klaus

2 1

[OpenSER-Users] How do I detect INVITE loop
by Andreas Sikkema 24 Sep '07

24 Sep '07

Hi, Is there a way for an OpenSER instance to detect if an incoming INVITE message has earlier been processed by itself? Record-Route is on, so there should be a Route message, but I suppose the Via headers could also contain the information. If it is detected I'd want OpenSER to ignore the incoming message, I suppose I could do nothing (no lookups etc.), but is there a better way? This is an issue because of the way we handle UA's registering at instance A and UA's registered at instance B wanting to call UA's at A. Due to race conditions with registrations going from A to B there are possible looping scenario's. -- Andreas Sikkema

2 1

[OpenSER-Users] Off topic: generating ringback tone from audio files
by Mark Anthony C. Delfin 24 Sep '07

24 Sep '07

Hi all, Is it possible to alter ring back tone on cisco gateways. For example I want change my ringback to an audio file. Some Mobile providers do this already. Thanks Mark D.

3 6

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 24 Sep '07

24 Sep '07

Hi, in openser.cfg file, there is a route[4] section where also involve avp_db_load(): ######################################################################## # Request route 'usr-preferences-callee' ######################################################################## route[4] { xlog("L_INFO", "Load callee preferences for uuid '$avp(s:callee_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); # load callee avps avp_db_load("$avp(s:callee_uuid)", "*"); if(is_avp_set("$avp(s:cfu)/s")) { xlog("L_INFO", "Call-forward-unconditional to '$avp(s:cfu)' found - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); route(8); avp_delete("$avp(s:caller_uuid)/g"); avp_copy("$avp(s:callee_uuid)", "$avp(s:caller_uuid)/d"); avp_pushto("$ru", "$avp(s:cfu)"); route(3); route(14); exit; } if(is_avp_set("$avp(s:ringtimeout)/n")) { xlog("L_INFO", "Setting ring timeout to $avp(s:ringtimeout) secs - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); avp_copy("$avp(s:ringtimeout)", "$avp(s:callee_fr_inv_timer)/d"); } } ----- Original Message ---- From: Live Great <livegreat007(a)yahoo.com> To: Norman Brandinger <norm(a)goes.com> Cc: users(a)openser.org Sent: Monday, September 24, 2007 2:02:19 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Hi, here is the configuration specific to avp_db_load in the openser.cfg file: route[3] { route(1); xlog("L_INFO", "Load caller preferences for uuid '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); # load caller avps avp_db_load("$avp(s:caller_uuid)", "*"); avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d"); if(is_avp_set("$avp(s:clir)/n") && avp_check("$avp(s:clir)", "eq/i:1")) { # mark for anonymization setflag(28); } } I never change this configuration. Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Sent: Monday, September 24, 2007 12:59:19 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Are you issuing an avp_db_load() call with no value ? That might explain the error message. Probably be a good idea to post the config you are using. Regards, Norm Live Great wrote: > Hi, thanks very much for the suggestion. > I have added the required columns in the acc and missed_calls table. > Now when I tried to call an off-line number, it still show one error: > > ERROR:avpops:load_avps: no value for first param > > The errors related to the acc and missed_calls tables are already gone. > In xlite panel, the error message says "Call failed: Proxy > Authentication Required.". > I am not sure what happened if I call a on-line phone number. > > Thanks > SW > > ----- Original Message ---- > From: Norman Brandinger <norm(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > Cc: users(a)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(a)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(a)goes.com> > > > To: Live Great <livegreat007(a)yahoo.com> > > > 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 <livegreat007(a)yahoo.com> > > > > 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 > > > > > > > > > > > > > > > >

2 1

[OpenSER-Users] perl + unixODBC
by Murilo Lacerda Yoshida 24 Sep '07

24 Sep '07

Hello all, I'm new in the list, so first of all I would like to say hi to all the list and say that openSer is a fantastic product, and that the documentation available on the internet is also fantastic. I managed to get my openSer server working with advanced features without having to subscribe to this list. Well, but if I subscribed, is because something has gone bad. Ok. The company I work for has a system for handling prepaid and postpaid calls. And I was designed to develop a new alternative for handling these prepaid and postpaid calls via VOIP, so I chose openSer as the server, after googleing on the web. One condition I had since the start is that I would have to integrate the solution to the company's DB, and that was another reason why I chose openSer, because of the perl module. With it I could write a script that would do that integration for me. So I started installing and developing the openSer server with the perl scripts. And it worked fine! The server did all that it had to do. So I went to the tests. First test: load test... And it fails for many reasons. After investigating I discovered that the debug option in the openser.cfg is very important in high load contexts. A debug value greater than 2 or 3 will decrease greatly the server's performance. I had to do some code cleanings in the openser.cfg and perl scripts also. The other and main reason is that for some unknown reason the openSer server crashes when using perl scripts that communicate with DB in high load contexts. For some reason the perl script receives a sig_segv (segmentation fault) and this signal is passed to all others threads and then the openSer server dies. This error is that kind of error that is specially difficult to find, because there are too many different systems involded. The path from openSer to the DB would be: openSer -> perl module -> perl -> perl DBI (DBD::ODBC) -> unixODBC -> FreeTDS -> MS SQLServer Can you guys provide me some light in fixing this problem? Thanks in advance, Murilo Yoshida

2 1

Re: [OpenSER-Users] Do we like the same books?
by Henning Westerholt 24 Sep '07

24 Sep '07

On Sunday 23 September 2007, rizwan_hisham wrote: > Just a friendly reminder that I invited you to Shelfari. Come see the books > I love and see if we have any in common. Then pick my next book so I can > keep on reading. Hello Rizwan, hello voipexpert, could you please stop to send this invitation to this book service to the user list? Some people considers such messages as spam. And please also stop this repeated invitations to my personal address to, i don't want to be invited and get already enough unwanted e-mail. Thank you, Henning Westerholt

1 0

Re: [Serusers] SER+Mediaproxy + X-LITE in the same LAN.
by pistara_bros＠tin.it 24 Sep '07

24 Sep '07

Bon jour à tout le monde, I have other news about my investigation on Mediaproxy and SER in the same Lan. In the first test i used X-lite, as UA clients, running on windowsXP and i saw that RTP traffic didn't pass through MEDIAproxy (IP 192.168.123.186). Now i'm using the client "Express Talk" runnig on windows XP (IP 192.168.123.168) and X-lite runnig on windows XP (IP 192.168.123.10) and I see that MEDIAproxy work correctly because works as "man in the middle" and proxies the RTP packets between two clients. Seems that it's necessary that one of two clients must be Express Talk, in order to Mediaproxy work correctly. I observe that, if one client is Express Talk, the second client could be X-lite or Yate or TiVi (http://m.tivi.com/) and MediaProxy work OK. But why Mediaproxy work correctly only if i use "Express Talk" as one peer client?? Any ideas? Target clients for my operational environment will be TiVi (http://m.tivi.com/) and i want that using them the RTP packet pass through Mediaproxy. There's anyone (sherlock holmes) in the forum that could solve the mystery? thanks a lot. >Hi all, i'm newbie in SER, >I want to route RTP packets between 2 >computers with x-lite client voip >in the same network through >Mediaproxy. I know this may have >no sense, but it's just a test >configuration. >The call use_media_proxy() seems to have no effect, >the RTP packets go directly from one computer to >another, no packet trough Mediaproxy. >This is my environment: >SER and Mediaproxy on the same PC >(192.168.123.186) >X-lite client_A running on 192.168.123.10 >X-lite >client_B running on 192.168.123.168 >Client_A call Client_B that accept, >but mediaproxy refuses to >proxy the call. >Is mediaproxy >working just between different networks >or it's an error in my >configuration file? >Please help me. Any suggestions? >Orazio

2 1

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 24 Sep '07

24 Sep '07

Hi, in openser.cfg file, there is a route[4] section where also involve avp_db_load(): ######################################################################## # Request route 'usr-preferences-callee' ######################################################################## route[4] { xlog("L_INFO", "Load callee preferences for uuid '$avp(s:callee_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); # load callee avps avp_db_load("$avp(s:callee_uuid)", "*"); if(is_avp_set("$avp(s:cfu)/s")) { xlog("L_INFO", "Call-forward-unconditional to '$avp(s:cfu)' found - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); route(8); avp_delete("$avp(s:caller_uuid)/g"); avp_copy("$avp(s:callee_uuid)", "$avp(s:caller_uuid)/d"); avp_pushto("$ru", "$avp(s:cfu)"); route(3); route(14); exit; } if(is_avp_set("$avp(s:ringtimeout)/n")) { xlog("L_INFO", "Setting ring timeout to $avp(s:ringtimeout) secs - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); avp_copy("$avp(s:ringtimeout)", "$avp(s:callee_fr_inv_timer)/d"); } } ----- Original Message ---- From: Live Great <livegreat007(a)yahoo.com> To: Norman Brandinger <norm(a)goes.com> Cc: users(a)openser.org Sent: Monday, September 24, 2007 2:02:19 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Hi, here is the configuration specific to avp_db_load in the openser.cfg file: route[3] { route(1); xlog("L_INFO", "Load caller preferences for uuid '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); # load caller avps avp_db_load("$avp(s:caller_uuid)", "*"); avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d"); if(is_avp_set("$avp(s:clir)/n") && avp_check("$avp(s:clir)", "eq/i:1")) { # mark for anonymization setflag(28); } } I never change this configuration. Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Sent: Monday, September 24, 2007 12:59:19 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Are you issuing an avp_db_load() call with no value ? That might explain the error message. Probably be a good idea to post the config you are using. Regards, Norm Live Great wrote: > Hi, thanks very much for the suggestion. > I have added the required columns in the acc and missed_calls table. > Now when I tried to call an off-line number, it still show one error: > > ERROR:avpops:load_avps: no value for first param > > The errors related to the acc and missed_calls tables are already gone. > In xlite panel, the error message says "Call failed: Proxy > Authentication Required.". > I am not sure what happened if I call a on-line phone number. > > Thanks > SW > > ----- Original Message ---- > From: Norman Brandinger <norm(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > Cc: users(a)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(a)goes.com> > > To: Live Great <livegreat007(a)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(a)goes.com> > > > To: Live Great <livegreat007(a)yahoo.com> > > > 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 <livegreat007(a)yahoo.com> > > > > 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 > > > > > > > > > > > > > > > >

1 0

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 24 Sep '07

24 Sep '07

Hi, here is the configuration specific to avp_db_load in the openser.cfg file: route[3] { route(1); xlog("L_INFO", "Load caller preferences for uuid '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n"); # load caller avps avp_db_load("$avp(s:caller_uuid)", "*"); avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d"); if(is_avp_set("$avp(s:clir)/n") && avp_check("$avp(s:clir)", "eq/i:1")) { # mark for anonymization setflag(28); } } I never change this configuration. Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Sent: Monday, September 24, 2007 12:59:19 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Are you issuing an avp_db_load() call with no value ? That might explain the error message. Probably be a good idea to post the config you are using. Regards, Norm Live Great wrote: > Hi, thanks very much for the suggestion. > I have added the required columns in the acc and missed_calls table. > Now when I tried to call an off-line number, it still show one error: > > ERROR:avpops:load_avps: no value for first param > > The errors related to the acc and missed_calls tables are already gone. > In xlite panel, the error message says "Call failed: Proxy > Authentication Required.". > I am not sure what happened if I call a on-line phone number. > > Thanks > SW > > ----- Original Message ---- > From: Norman Brandinger <norm(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > Cc: users(a)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(a)goes.com> > > To: Live Great <livegreat007(a)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(a)goes.com> > > > To: Live Great <livegreat007(a)yahoo.com> > > > 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 <livegreat007(a)yahoo.com> > > > > 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@openser..org > > > > http://openser.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > >

1 0

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 24 Sep '07

24 Sep '07

Hi, thanks very much for the suggestion. I have added the required columns in the acc and missed_calls table. Now when I tried to call an off-line number, it still show one error: ERROR:avpops:load_avps: no value for first param The errors related to the acc and missed_calls tables are already gone. In xlite panel, the error message says "Call failed: Proxy Authentication Required.". I am not sure what happened if I call a on-line phone number. Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Cc: users(a)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(a)goes.com> > To: Live Great <livegreat007(a)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(a)goes.com> > > To: Live Great <livegreat007(a)yahoo.com> > > 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 <livegreat007(a)yahoo.com> > > > 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 > > > > > > > > >

1 0

Re: [OpenSER-Users] Forward REGISTER to Asterisk
by Iñaki Baz Castillo 23 Sep '07

23 Sep '07

2007/9/21, Jeremy McNamara <jj(a)nufone.net>: > Is there anything specific we need to do within the openser > configuration that we need to know? > I presume just an append_branch() before sending it back at Asterisk. You can test it easier, just call from Asterisk to a OpenSer user: CLI> dial openser_user@ip_openser@context and do in OpenSer: rewriteuri(sip:test@ip_asterisk:5060) so the call will return to Asterisk. Without the patch Asterisk will reject it because "Loop detected". With the patch it will allow it and respect the "Route" header and so. If you need something else to test this tell me. -- Iñaki Baz Castillo <ibc(a)aliax.net>

2 1

[OpenSER-Users] Do we like the same books?
by rizwan_hisham 23 Sep '07

23 Sep '07

Just a friendly reminder that I invited you to Shelfari. Come see the books I love and see if we have any in common. Then pick my next book so I can keep on reading. Click below to join my group of friends on Shelfari! http://www.shelfari.com/Register.aspx?ActivityId=18088381&InvitationCode=3d… rizwan_hisham Shelfari is a free site that lets you share book ratings and reviews with friends and meet people who have similar tastes in books. It also lets you build an online bookshelf, join book clubs, and get good book recommendations from friends. You should check it out. -------- You have received this email because rizwan_hisham (rizwanhasham(a)gmail.com) directly invited you to join his/her community on Shelfari. It is against Shelfari's policies to invite people who you don't know directly. Follow this link (http://www.shelfari.com/actions/emailoptout.aspx?email=Users@openser.org&ac…) to prevent future invitations to this address. If you believe you do not know this person, you may view (http://www.shelfari.com/rizwan_hisham) his/her Shelfari page or report him/her in our feedback (http://www.shelfari.com/Feedback.aspx) section. Shelfari, 616 1st Ave #300, Seattle, WA 98104

1 0

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 23 Sep '07

23 Sep '07

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(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Cc: users(a)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(a)goes.com> > To: Live Great <livegreat007(a)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(a)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(a)yahoo.com> > > > 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 > > > > > > > > >

1 0

[OpenSER-Users] No sound
by Arya 23 Sep '07

23 Sep '07

Hello When I'm behind NAT or the other user is behind NAT sometimes calls don't connect and there is never sound when a call is placed. I think this is a issue with NAT right? Is there any solution to this? -- Thank You

2 3

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 23 Sep '07

23 Sep '07

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(a)goes.com> To: Live Great <livegreat007(a)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(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > 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 <livegreat007(a)yahoo.com> > > 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 > > > >

2 1

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 23 Sep '07

23 Sep '07

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

2 1

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 23 Sep '07

23 Sep '07

Hi, I found some comment in the openser.cfg file mentioned that I need to create the uuid manually. After created, I can register the default admin account from xlite now. But I can't find any instruction about how to create my own user login. The openserctl command does not describe hwo to create user's phone number. I can create user and their password using openserctl, but have no clue about how to create their phone number. Any help?/ Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)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(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > 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 <livegreat007(a)yahoo.com> > > 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 > > > >

1 0

[OpenSER-Users] 473 response
by lincolnnmail-serlistmail＠yahoo.com.br 23 Sep '07

23 Sep '07

Hi all. I'm just new to openser, and this list. I implemented a load balance server, but I'm getting some trouble with this 473 response from openser. I inserted a fake uri to test how the load balance server would handle the problem. Ok, it tries to send the request, fails, and then goes to the failure route. There, it goes to the next route. Next time the server tries to send the request to the fake uri, I'm getting the 473 response. Yes, the fake uri is black listed. But how should we be able to treat this error? Instead of immediatly returning this message to the UA, I'd like openser to go to the next uri found in the list. I'd prefer not to disable the blacklist function. I saw that other people had the same problem, but I couldn't find any final solution. Am I missing something or is it a bug? I'm posting my code just below. Thanks! route[0]{ ... if ( method=="INVITE" ) { # ds_select_dst( "GROUP", "HASH METHOD") t_on_failure("1"); ds_select_dst("1","4"); sl_send_reply("100","Trying"); t_relay(); exit(); } ... } ... failure_route[1] { if (!ds_next_dst()) { t_reply("503", "No Gateways"); return; } else { t_on_failure("1"); t_relay(); return; } } Flickr agora em português. Você clica, todo mundo vê. Saiba mais.

2 2

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 23 Sep '07

23 Sep '07

Hi, The openser version in freebsd is the latest one I got: # openser -V version: openser 1.2.2-notls (i386/freebsd) Is this the correct version for getting openserdbctl ? Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)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(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > 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 <livegreat007(a)yahoo.com> > > 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 > > > >

1 0

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 22 Sep '07

22 Sep '07

----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> 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 <livegreat007(a)yahoo.com> > 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 >

1 0

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 22 Sep '07

22 Sep '07

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(a)yahoo.com> 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

2 1

[OpenSER-Users] how to register xlite user for testing with openser
by Live Great 22 Sep '07

22 Sep '07

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

1 0

[OpenSER-Users] OpenSER + FreeRadius error
by Marc LEURENT 22 Sep '07

22 Sep '07

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Does this error means something to somebody?? Thanks ERROR:acc:acc_rad_request: radius-ing failed My openser.cfg # -- acc params (with radius )-- modparam("acc", "radius_config", "/etc/radiusclient-ng/radiusclient.conf") modparam("acc", "radius_flag", 1) modparam("acc", "radius_missed_flag", 2) ..... ################### SET RADIUS ACCOUTING FLAGS ################################# # Set the acc flags xlog("JUSTE BEFORE SETTING FLAGS FOR RADIUS\r\n"); if(is_method("INVITE") && !has_totag()) { xlog("L_INFO", "I AM SETTING THE FLAGS FOR RADIUS \r\n"); $avp(can_uri) = $ru; # SIP Request's URI $avp(billing_party) = "sip:" + $au + "@" + $ar; # From URI $avp(user_name) = $fu; xlog("!!!! FROM TAG = $ft\r\n"); xlog("SETTING FLAGS 1 & 2 FOR RADIUS \r\n"); setflag(1); # radius_flag setflag(2); # radius_missed_flag }; DEBUG OUTPUT: 3(26026) DEBUG: update_totag_set: new totag 3(26026) DEBUG: add_to_tail_of_timer[2]: 0x2b898c7eb9d0 (12) 3(26026) DEBUG:tm:relay_reply: sent buf=0x61d2e8: SIP/2.0 2..., shmem=0x2b898c7ed7a8: SIP/2.0 2 3(26026) DBG: trans=0x2b898c7eb950, callback type 128, id 0 entered 3(26026) ERROR:acc:acc_rad_request: radius-ing failed 3(26026) DEBUG: cleanup_uac_timers: RETR/FR timers reset 3(26026) DEBUG:tm:UNREF_UNSAFE: after is 0 3(26026) DEBUG:destroy_avp_list: destroying list (nil) 3(26026) receive_msg: cleaning up 1(26024) SIP Request: 1(26024) method: <ACK> 1(26024) uri: <sip:105@82.127.0.79:1030;user=phone;nat=yes> 1(26024) version: <SIP/2.0> 1(26024) parse_headers: flags=2 1(26024) Found param type 232, <branch> = <z9hG4bK2175363103192047157>; state=16 1(26024) end of header reached, state=5 1(26024) parse_headers: Via found, flags=2 1(26024) parse_headers: this is the first via -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG8jcCqjpLE0HiOBYRAlBWAJoD4mlTLi8MCSLJEceI4jUNP2LFSwCgnjQq ytiBJX6Q40CVgt+V0sB0JWk= =BVYV -----END PGP SIGNATURE-----

3 6

[Serusers] osp toolkit
by Arya 22 Sep '07

22 Sep '07

Hello Does osp toolkit support billing? and does it have a web interface? -- Thank You

3 4

[OpenSER-Users] 1.3 release schedule
by Bogdan-Andrei Iancu 21 Sep '07

21 Sep '07

Hi, Just as reminder about the 1.3 release schedule: 05.10.2007 - SVN freeze and start testing - please commit all new features or changes till this date 0x.12.2007 - release date (first days of December) Regards, Bogdan

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users