sr-users

sr-users@lists.kamailio.org

34 participants
37543 discussions

[Serusers] Acc not writing to MySQL
by POON Ben 21 Mar '07

21 Mar '07

Hi all, I am having a lot of trouble making the acc module work... I've googled and tried a lot of sample config but am still having no luck. Can someone please help me to get accounting on my server? Below is my ser.cfg file. It's basically the sample one with some editing. The auth stuff work really nicely :) Everything seems to load fine when I do a "ser -D -E" However, I noticed that nothing is ever entered into the acc table in the ser database. I am running ser 0.9.6 with mysql 5.0.37. Thank you so much! Ben # # $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $ # # simple quick-start config script # # ----------- global configuration parameters ------------------------ #debug=3 # debug level (cmd line: -dddddddddd) fork=yes #log_stderror=no # (cmd line: -E) listen=1.1.1.1 listen=127.0.0.1 # hostname matching an alias will satisfy the condition uri==myself". alias="localhost" alias=1.1.1.1 /* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */ check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) #port=5060 #children=4 fifo="/tmp/ser_fifo" fifo_db_url="mysql://admin:heslo@localhost/ser" # ------------------ module loading ---------------------------------- # Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so" loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/textops.so" loadmodule "/usr/local/lib/ser/modules/acc.so" # Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" # ----------------- setting module-specific parameters --------------- # -- usrloc params -- #modparam("usrloc", "db_mode", 0) # Uncomment this if you want to use SQL database # for persistent storage and comment the previous line modparam("usrloc", "db_mode", 2) # -- auth params -- # Uncomment if you are using auth module # modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # modparam("auth_db", "password_column", "password") # -- rr params -- # add value to ;lr param to make some broken UAs happy modparam("rr", "enable_full_lr", 1) # -- acc params -- # set the reporting log level modparam("acc", "log_level", 1) # number of flag, which will be used for accounting; if a message is # labeled with this flag, its completion status will be reported modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 2) # ------------------------- request routing logic ------------------- # main routing logic route{ # initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if (msg:len >= 2048 ) { sl_send_reply("513", "Message too big"); break; }; # we record-route all messages -- to make sure that # subsequent messages will go through our proxy; that's # particularly good if upstream and downstream entities # use different transport protocol if (!method=="REGISTER") record_route(); # subsequent messages withing a dialog should take the # path determined by record-routing if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); break; }; if (!uri==myself) { # mark routing logic in request append_hf("P-hint: outbound\r\n"); route(1); break; }; # if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) { if (method=="REGISTER") { # Uncomment this if you want to use digest authentication if (!www_authorize("localhost", "subscriber")) { www_challenge("localhost", "0"); break; }; save("location"); break; }; lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); break; }; # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; # Report missed calls setflag(2); append_hf("P-hint: usrloc applied\r\n"); route(1); } route[1] { # Set accounting flag setflag(1); # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; }

1 0

[Users] To: header in e.164 format - adding a plus
by Daryl Sanders 21 Mar '07

21 Mar '07

One of my providers requires the To: header to be in e.164 format with a "+" in front of it. Since there is no uac_replace_to() function yet, what are my options for adding this plus symbol? Before anyone suggests it... I cannot just use another provider. I must find a solution to add the plus symbol. Thanks, Daryl

3 2

[Users] Fresh OpenSER 1.2.0 Openserctl can only add 1 user?!
by Geir O. Jensen 21 Mar '07

21 Mar '07

I have two server, one in production and one for testing. Trying to debug something else entirely I upgraded the production server from 1.1.0 to 1.2.0 yesterday. Everything seems to work fine on it. So I wiped my testbed and compiled OpenSER 1.2.0 on the testing system, installed the mysql db and started it up. Worked fine. I then began adding testaccounts on the testsystem, - first user ok... - second user, not so ok... # openserctl add test test gojensen(a)uninett.no MySql password for user 'xxx@localhost': ERROR 1062 (23000) at line 1: Duplicate entry '' for key 3 ERROR: introducing the new user 'test' to the database failed Of course, I couldn't add a third or fourth either, so I'm basically stuck with one user and the admin account. Any idea where to start debugging this?! (As a note, I added 3 test accounts on the production server with no problems... Their config files are basically identical - the testing server only adds the presence module...) // sip:gojensen@uninett.no | h323: 004710012 pstn: +47 73 55 79 23 | fax: +47 73 55 79 01

2 2

[Users] Wesip C2C
by Helmut Kuper 21 Mar '07

21 Mar '07

Hello, after upgrading to wesip 0.1.3 I'm not able anymore to start c2c application. in WeSIP's logfile I can find this exception: 2007-03-21 18:11:52 StandardManager[/click2call-08_11_06]: Seeding random number generator class java.security.SecureRandom 2007-03-21 18:11:52 StandardManager[/click2call-08_11_06]: Seeding of random number generator has been completed 2007-03-21 18:11:52 HTMLManager: ManagerServlet.install[/click2call-08_11_06] java.lang.NoClassDefFoundError: com/voztele/wesip/apps/click2call/C2CDefaultServlet at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1379) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1307) at com.voztele.sipservlet.core.StandardSipWrapper.loadServlet(StandardSipWrapper.java:753) at com.voztele.sipservlet.core.StandardSipWrapper.load(StandardSipWrapper.java:701) at org.apache.catalina.core.StandardHttpContext.loadOnStartup(StandardHttpContext.java:3382) at org.apache.catalina.core.StandardHttpContext.start(StandardHttpContext.java:3605) at com.voztele.sipservlet.core.ConvergedContext.start(ConvergedContext.java:259) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:773) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:759) at org.apache.catalina.core.StandardHttpHost.addChild(StandardHttpHost.java:552) at com.voztele.sipservlet.core.ConvergedHost.addChild(ConvergedHost.java:157) at com.voztele.sipservlet.core.ConvergedHostDeployer.install(ConvergedHostDeployer.java:264) at com.voztele.sipservlet.core.ConvergedHost.install(ConvergedHost.java:170) at org.apache.catalina.servlets.ManagerServlet.install(ManagerServlet.java:663) at org.apache.catalina.servlets.HTMLManagerServlet.install(HTMLManagerServlet.java:265) at org.apache.catalina.servlets.HTMLManagerServlet.doPost(HTMLManagerServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:206) #################################################################################### When I cwitch back to wesip 0.1.2 C2C is loading and starting fine. I use click2call-08_11_06 When I search for the missed class C2CDefaultServlet I get this: hk@vm-en-test0:~/wesip/wesip$ find . -name "C2CDefaultServlet*" ./wesipapps/click2call-08_11_06/WEB-INF/classes/com/voztele/wesip/apps/click2call/C2CDefaultServlet.class So it#s there, but wesip doesn#t find it. Wher do I have to tell weSIP the location of that class ? regards helmut

1 0

Re: [Users] NAT Problem with OpenSER behind load balancer
by Daniel-Constantin Mierla 21 Mar '07

21 Mar '07

You should keep cc-ing mailing lists, so people coming after a while, with same issue, will be reading mail thread and see that the given solution was right. Thanks, Daniel On 03/20/07 21:42, Tim Madorma wrote: > Got it. thanks so much! > > Tim > > On 3/20/07, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote: >> Hello, >> >> On 03/20/07 17:39, Tim Madorma wrote: >> > Hi, >> > >> > I have put the OpenSER version 1.2 behind a BIG IP load balancer which >> > provides a static private IP address (10.1.1.20) via NAT to the >> > OpenSER. In our application, the clients will send to one of the three >> > public addresses that are defined as aliases: >> > >> > alias="65.185.232.62:5061" >> > alias="65.185.232.62:5062" >> > alias="65.185.232.62:5063" >> you have to remove quotes around the value of alias parameters. As it is >> now, the value between quotes is considered to be hostname. >> alias=65.185.232.62:5061 >> alias=65.185.232.62:5062 >> alias=65.185.232.62:5063 >> >> Same case as it was reported by Juha, today with loose routing ... >> >> Cheers, >> Daniel >> >> > >> > An incoming OPTIONS message is received with the host in the REQ URI >> > set to 65.185.232.62:5063 is received and when it hits this section of >> > openser.cfg: >> > >> > if (!uri==myself) { >> > # mark routing logic in request >> > append_hf("P-hint: outbound\r\n"); >> > route(1); >> > }; >> > >> > it executes within the if conditional and tries to route the OPTIONS >> > message. I am wondering why uri does not match myself. The debug >> > output from the log is as follows (it seems that the alias assignments >> > are not working): >> > >> > >> > Mar 19 16:41:11 homer openser[2267]: [ID 487083 local0.debug] >> > grep_sock_info - checking if host==us: 13==9 && [65.185.232.62] == [1 >> > 0.1.1.20] >> > Mar 19 16:41:11 homer openser[2267]: [ID 375670 local0.debug] >> > grep_sock_info - checking if port 5061 matches port 5063 >> > Mar 19 16:41:11 homer openser[2267]: [ID 487083 local0.debug] >> > grep_sock_info - checking if host==us: 13==9 && [65.185.232.62] == [1 >> > 0.1.1.20] >> > Mar 19 16:41:11 homer openser[2267]: [ID 375670 local0.debug] >> > grep_sock_info - checking if port 5062 matches port 5063 >> > Mar 19 16:41:11 homer openser[2267]: [ID 487083 local0.debug] >> > grep_sock_info - checking if host==us: 13==9 && [65.185.232.62] == [1 >> > 0.1.1.20] >> > Mar 19 16:41:11 homer openser[2267]: [ID 375670 local0.debug] >> > grep_sock_info - checking if port 5063 matches port 5063 >> > Mar 19 16:41:11 homer openser[2267]: [ID 140248 local0.debug] >> > DEBUG:check_self: host != me >> > >> > >> > Any suggestions? I have not tried this in any other version. Is this a >> > possible bug in 1.2? >> > >> > thanks, >> > Tim >> > >> > _______________________________________________ >> > Users mailing list >> > Users(a)openser.org >> > http://openser.org/cgi-bin/mailman/listinfo/users >> > >> >

3 3

[Users] ENC: Presence Module - Eyebeam 1.5
by Hildebrando Trannin 21 Mar '07

21 Mar '07

Hi all, I configured the presence module in OpenSER v1.2 and it looks like ok. But when tested with EyeBeam 1.5 (buil 30037) it doesn't work. I used the WireShark to see the SIP messages and observed that in NOTIFY messages there aren't PIDF document, neither message body. Furthermore, OpenSER didn't parse xml BODY from PRESENTITY table when try to build notify. The PIDF document that EyeBeam creates and the error that OpenSER gave me when try to parser this document are below. Can someone help me with this problem? Is it a bug from OpenSER? Regards, Hildebrando PIDF Document <?xml version="1.0" encoding="UTF-8" standalone="no" ?> <pr:presence xmlns:pr="urn:ietf:params:xml:ns:pidf" entity="sip:hildebrando@voip.maritaca" xmlns:caps="urn:ietf:params:xml:ns:pidf:caps" xmlns:cipid="urn:ietf:params:xml:ns:pidf:cipid" xmlns:counterpath="www.counterpath.com/presence/ext" xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model" xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid"> <pr:tuple id="se43ac217"> <pr:status> <pr:basic>open</pr:basic> </pr:status> <pr:note>Busy</pr:note> <rpid:user-input last-input="2007-03-19T19:21:49Z">active</rpid:user-input> <pr:timestamp>2007-03-19T19:21:49Z</pr:timestamp> </pr:tuple> <dm:person id="p0d4e4429"> <rpid:activities> <rpid:busy/> </rpid:activities> <dm:note>Busy</dm:note> </dm:person> </pr:presence> OpenSER Error 2(6498) Chegou um PUBLISH de (hildebrando) para (sip:hildebrando@voip.maritaca) 2(6498) PRESENCE:update_presentity: querying presentity 2(6498) PRESENCE:get_subs_dialog:querying database table = active_watchers 2(6498) PRESENCE:get_p_notify_body: querying presentity 2(6498) PRESENCE:agregate_xmls: ERROR while parsing xml body message 2(6498) PRESENCE:notify:dialog informations: 2(6498) [p_user]= hildebrando [p_domain]= voip.maritaca [w_user]= gustavo [w_domain]= voip.maritaca 2(6498) [event]= presence [staus]= active [expires]= 3340 2(6498) [to_tag]= 10.6503.1174328485.15 [from_tag]= 80746145

3 5

[Users] xmpp module
by Sebastian Murray-Roberts 21 Mar '07

21 Mar '07

Hi, I just have a question about the new xmpp module. I have set up an OpenSER box as a presence server using the presence module, and everything is working fine, messaging and presence. Now I would like to allow those users to communicate with users logged into a jabber server. My first question is can presence information be exchanged between OpenSER and the jabber server? If so, how is this achieved since the xmpp module only has an xmpp_send_message() method. Also, just to make sure I understand how the module works, would this be a correct summary of the module's functionality for a SIP to Jabber message with a response: User A registers with OpenSER. User B registers with jabber server (OpenFire) User A sends a message to sip:User B*<jabber_domain>@<gateway_domain> with from details : sip:User A*<openser_domain>@<gateway_domain> OpenSER forwards the request to the gateway Gateway translates the message and sends it to the jabber server Jabber server delivers message to User B Jabber server sends response to gateway with to details: User A*<openser_domain>@<gateway_domain> Gateway forwards response to sip:User A@<openser_domain> Is that more or less correct, or am I off the mark? Finally, if that is the case, would User A need to be registered on the jabber server already? I've never worked with presence before, so I'm still trying to get to grips with it. Any comments/insights are much appreciated. Many thanks, Sebastian -- Sebastian Murray-Roberts (B.Sc Hons) Server Developer Yeigo Communications http://www.yeigo.com Tel: +27 21 409 7807 Fax: +27 21 409 7050 Mobile: +27 72 183 5998 CONFIDENTIALITY NOTICE: E-MAIL This e-mail is confidential. If you receive it by mistake, please delete it and notify the sender immediately. If you are not the intended recipient, you may not use, disclose, distribute, copy or publish any information contained herein.

2 1

[Users] Commercial SIP Server
by Michel Bensoussan 21 Mar '07

21 Mar '07

Hello Is there a way to know which commercial SIP servers are based on openser or ser? Or if a specific SIP server is based on openser or ser? Thanks. Regards, Michel.

3 5

答复: [Users] ERROR 1062 (23000): Duplicate entry
by 郭军 21 Mar '07

21 Mar '07

Why don't you use openserctl add ....to add new user? -----邮件原件----- 发件人: alper ozbilen [mailto:alperbilen@hotmail.com] 发送时间: 2007年3月21日 16:45 收件人: users(a)openser.org 主题: [Users] ERROR 1062 (23000): Duplicate entry Dear All, I can not insert a new subscriber from mysql console. When I look at subscireber table, ha1 & ha1b & and phplib_id fields looks null. So, i can only insert one new subscriber. When i attempt to insert second one, i get error written below: ERROR 1062 (23000): Duplicate entry '' for key 3 Note : My insert sentence like that: insert into subscriber (username, domain, password, email_address) values ("testuser","myfon.com","testpasswd","emailoftestuser(a)myfon.com"); I am confused about what i should to do to fix null statement of ha1 & ha2 & and phplib_id fields. on the other side, there is no probem to add new user through openserctl What was the problem? I will wait your kind suggestion. Regards, Alper Ozbilen _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinema… _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

7 9

[Users] RHEL/Fedora equivalents of deb packages in RPM SPEC
by Alan Crosswell 21 Mar '07

21 Mar '07

The BuildPrereq lines in the RPM SPEC file for Fedora Core (openser.spec.fedora) supplied with 1.2.0 references debian names for the package (e.g. libxml2-dev -> libxml2-devel). Before I waste too much time finding the equivalent RHEL and/or Fedora Core packages that do the job, I thought I would ask her if anyone else has done so. If not, I'll make sure to submit patches for the SPECs once I figure them out. I am really looking to build on RHEL4 but clearly will need to grab some RPMs from Fedora Core.... Please no religious rants about Debian vs. RHEL vs. Fedora vs. SuSE and so on:-) /a

3 2

Jump to page:

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