sr-users July 2011

sr-users@lists.kamailio.org

75 participants
120 discussions

"select count(*)" with avp_db_query always returns null
by Andrade Ricardo (CI/AFU1) 05 Jul '11

05 Jul '11

Hi list, Perhaps this fits better into a bug report, but I'd like to know if somebody out there experienced a similar issue. I am executing a "select count" query using the avp_db_query function, but it is not storing the results in any avp. Other queries are working fine. I use db_mysql connected with a mysql 5.1 server. I have tested this with kamailio-3.1.0 and kamailio-3.1.3, both didn't work. In an old box (version 1.3.x), the same query was returning the correct value. --------------------------------------------------- Here is the case which is not working: Code: avp_delete("$avp(s:count)"); $var(ret) = avp_db_query("SELECT count(*) FROM subscriber where username='foo'", "$avp(s:count)"); xlog("L_INFO", "var(ret)=$var(ret) avp(s:count)=$avp(s:count)"); Output: INFO: <script>: var(ret)=1 avp(s:count)=<null> (notice the return code 1, which means that the query was successfull and there should be some output value stored in the avp, but it is <null>) --------------------------------------------------- And here is one case which works as expected: $var(ret) = avp_db_query("SELECT id FROM subscriber where username='foo'", "$avp(s:count)"); Output: INFO: <script>: var(ret)=1 avp(s:count)=11 --------------------------------------------------- Thanks in advance for any feedback. Best regards, Ricardo Andrade.

4 8

two uac behind same nat one uac remain Cflag:: 0
by MingHon 05 Jul '11

05 Jul '11

Hi List, both uac register successfully but the issue is the first uac who register the Cflag remain 0. im using nat_uac_test("19"). thank you in advance. here is the ul show: AOR:: 102 Contact:: sip:102@175.136.221.60:5062 Q= Expires:: 103 Callid:: 678936531(a)175.136.221.60 Cseq:: 2 User-agent:: T22 7.3.0.50 Received:: sip:175.136.221.60:1056 State:: CS_SYNC Flags:: 0 Cflag:: 192 Socket:: udp:60.53.82.184:5060 Methods:: 16383 AOR:: 103 Contact:: sip:103@175.136.221.60:5062 Q= Expires:: 62 Callid:: 1621958925(a)175.136.221.60 Cseq:: 3 User-agent:: Yealink SIP-T18 18.0.0.70 State:: CS_SYNC Flags:: 0 Cflag:: 0 Socket:: udp:60.53.82.184:5060 Methods:: 16383 and here is the wireshark on kamailio for ua 103 and 102. E@< \<<5Rw REGISTER sip:aextddns.dyndns.info SIP/2.0 Via: SIP/2.0/UDP 175.136.221.60:5062;branch=z9hG4bK2080454766 From: "103" <sip:103@175.136.221.60>;tag=681558690 To: "103" <sip:103@aextddns.dyndns.info> Call-ID: 1621958925(a)175.136.221.60 CSeq: 2 REGISTER Contact: <sip:103@175.136.221.60:5062> Authorization: Digest username="103", realm="aextddns.dyndns.info", nonce="Tgp7mU4Kem3Qqyd66hwhWgmU8bNpL463", uri="si$ Allow: INVITE, INFO, PRACK, ACK, BYE, CANCEL, OPTIONS, NOTIFY, REGISTER, SUBSCRIBE, REFER, PUBLISH, UPDATE, MESSAGE Max-Forwards: 70 User-Agent: Yealink SIP-T18 18.0.0.70 Expires: 3600 Content-Length: 0 E@<5R<PSIP/2.0 200 OK Via: SIP/2.0/UDP 175.136.221.60:5062;branch=z9hG4bK2080454766;rport=5062 From: "103" <sip:103@175.136.221.60>;tag=681558690 To: "103" <sip:103@aextddns.dyndns.info >;tag=cbf8071f5b02e3e2fd329ee5d72c3f65.d24e Call-ID: 1621958925(a)175.136.221.60 CSeq: 2 REGISTER Contact: <sip:103@175.136.221.60:5062>;expires=120 Server: kamailio (3.1.4 (i386/linux)) Content-Length: 0 -------------------------------------------------- E@< j<<5R 7REGISTER sip:aextddns.dyndns.info SIP/2.0 Via: SIP/2.0/UDP 175.136.221.60:5062;branch=z9hG4bK1080036976 From: "102" <sip:102@175.136.221.60>;tag=544575245 To: "102" <sip:102@aextddns.dyndns.info> Call-ID: 678936531(a)175.136.221.60 CSeq: 2 REGISTER Contact: <sip:102@175.136.221.60:5062> Authorization: Digest username="102", realm="aextddns.dyndns.info", nonce="Tgp8AU4KetWGb79MEU5MUHq+xA4xy+OW", uri="si$ Allow: INVITE, INFO, PRACK, ACK, BYE, CANCEL, OPTIONS, NOTIFY, REGISTER, SUBSCRIBE, REFER, PUBLISH, UPDATE, MESSAGE Max-Forwards: 70 User-Agent: T22 7.3.0.50 Expires: 3600 Content-Length: 0 E@<5R< {SIP/2.0 200 OK Via: SIP/2.0/UDP 175.136.221.60:5062;branch=z9hG4bK1080036976;rport=1056 From: "102" <sip:102@175.136.221.60>;tag=544575245 To: "102" <sip:102@aextddns.dyndns.info >;tag=cbf8071f5b02e3e2fd329ee5d72c3f65.5cb8 Call-ID: 678936531(a)175.136.221.60 CSeq: 2 REGISTER Contact: <sip:102@175.136.221.60:5062>;expires=120;received="sip: 175.136.221.60:1056" Server: kamailio (3.1.4 (i386/linux)) Content-Length: 0 -- Regards, MingHon

2 2

Hello,can you send me the useage of siremis?Thank you
by 吴明 05 Jul '11

05 Jul '11

HI: I'm a user of siremis from China.Now I install the siremis successfully.But I would not use it. So I want the useage of it. I'll wait for your letter.Thank you! Best regards. Calvin wu 2011-6-24

2 1

Kamailio 64bit Compile Errors
by Nathaniel L Keeling 05 Jul '11

05 Jul '11

I am trying to install Kamailio 3.1.0 on Solaris 10 that is a sparc machine (v120) and is running a 64bit OS. When I originally performed the compile utilizing the instructions from the website, I was getting warnings about using 32 bit headers. I was able to compile and install successfully, but when I started Kamailio, loading of modules were failing due to "not found" error. The warning messages: "atomic/atomic_sparc.h:41:2: warning: #warning "sparc32 atomic operations support not tested"" I thought was because the target architecture specified sparc and not sparc64, so I tried specified the target architecture as listed below which got rid of the warning messages but then I got ELFCLASS32 error messages. What is the proper way to create a 64bit version of Kamailio on a sparc Solaris 10. It seems like the target architecure is not being configured properly and that may be causing other problems. I have included output from different commands about the environment and the commands that I entered to compile Kamailio. # make FLAVOUR=kamailio cfg target architecture <sparc>, host architecture <sparc64> # isainfo -n sparcv9 # uname -p sparc # uname -m sun4u # isainfo -v 64-bit sparcv9 applications vis 32-bit sparc applications vis v8plus div32 mul32 # isainfo -b 64 Here is what I entered to try and force the building of a 64 bit version and a sample error that I was getting. make FLAVOUR=kamailio prefix=/usr/local/kamailio-3.1 CPU=ultrasparc ARCH=sparc64 cfg LD (gcc) [M lcr.so] lcr.so ld: fatal: file /usr/local/lib/libpcre.so: wrong ELF class: ELFCLASS32 ld: fatal: File processing errors. No output written to lcr.so collect2: ld returned 1 exit status make[1]: *** [lcr.so] Error 1 make: *** [modules] Error 1 LD_LIBRARY_PATH=/lib/sparcv9:/usr/lib/sparcv9:/usr/sfw/lib/sparcv9:/usr/local/postgres/9.0-pgdg/lib/64 LD_RUN_PATH=/lib/sparcv9:/usr/lib/sparcv9:/usr/sfw/lib/sparcv9:/usr/local/postgres/9.0-pgdg/lib/64 PATH=/opt/csw/bin:/usr/sfw/bin:/usr/local/bin:/usr/local/postgres/9.0-pgdg/bin:/usr/sbin:/usr/bin:/usr/ccs/bin: # find . -name libpcre.so -print ./usr/local/lib/libpcre.so Thanks

2 1

Playing with XCAP_SERVER and Postgresql
by Roberto Fichera 05 Jul '11

05 Jul '11

Hi all in the List, I'm playing with the xcap_server using the jitsi client. Kamailio is v3.1.4 and postgresql is v8.4.8 under Fedora 14 64bit. Basically I'm getting the error below. Jul 5 10:36:36 roberto /usr/sbin/kamailio[8529]: ERROR: <script>: ===== xhttp: xcap-caps : <null> Jul 5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR: <script>: ===== xhttp: resource-lists : sip:roberto@192.168.2.92 Jul 5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR: <script>: ===== xhttp: get sip:roberto@192.168.2.92 => /xcap-root/resource-lists/users/sip:roberto@192.168.2.92/index Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR: <script>: ===== xhttp: pres-rules : sip:roberto@192.168.2.92 Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR: <script>: ===== xhttp: get sip:roberto@192.168.2.92 => /xcap-root/pres-rules/users/sip:roberto@192.168.2.92/presrules Jul 5 10:36:36 roberto /usr/sbin/kamailio[8521]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:mattia@192.168.2.92 for event presence Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence [subscribe.c:711]: Missing or unsupported event header field value Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence [subscribe.c:714]: #011event= message-summary Jul 5 10:36:36 roberto /usr/sbin/kamailio[8522]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence.winfo *Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution aborted Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:428]: driver error: PGRES_FATAL_ERROR, ERROR: null value in column "sender" violates not-null constraint#012 Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: WARNING: db_postgres [km_dbase.c:473]: unexpected result returned* Any idea? Best regards, Roberto Fichera.

2 2

Presence and Presence_mwi
by Marvin59 05 Jul '11

05 Jul '11

Hi all, I am trying to configure kamailio-3.1.4 in order to send me MWI Notify when there is change in messages. I have already configure it, in order to use a FreeRadius to authenticate my users but I have no idea to use Presence and Presence_mwi module. I need this behavior : - The phone send me a subscribe, then if it authorize i send it the Notify with the messages-waiting. - I must write myself the notify request because an external script will tell me if there are messages waiting. I have looked here (http://www.kamailio.org/docs/modules/3.1.x/modules_k/presence.html#id2614273 and http://www.kamailio.org/docs/modules/3.1.x/modules_k/presence_mwi.html). If someone has further informations .... Thanks for your help. Best regards, Marvin59 -- View this message in context: http://old.nabble.com/Presence-and-Presence_mwi-tp31946526p31946526.html Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

2 1

Session authorization just before initiate it
by Roberto Fichera 05 Jul '11

05 Jul '11

Hi All in the list, I'm new to Kamailio but I'm actually able to quickly setup a server, including also the SIP presence, looking at the example I found at http://kb.asipto.com/kamailio:presence:k31-made-simple which explain very well how to do it. I also made some changes in the final setup and everything seems working well, I can have audio/video/chat session including the presence status of any user. Now I would like to improve my testing setup so that for each call request Kamailio receive, I would like to perform some SQL lookup for deciding if the conversation might be established or not. About the SQL lookup I read about the SQLOPS module, it seems really easy to use, but I don't know where to put such check before the INVITE. Could someone give me some hints? P.S: Indeed, I need to read some good documentation about how to code a Kamailio config file. Any URL to suggest? Thanks in advance, Roberto Fichera.

2 4

route_graph.py
by s.maertens＠telenet.be 04 Jul '11

04 Jul '11

Hi, I have a kamailio 3.1.4 installation installed from the APT repository kamailio.org. I have read about a python script route_graph which I would like to test. The only thing is, i cannot seem to find out what deb package I should install to have this. Could someone point me in the right direction please? :) Best regards Stefaan

3 2

force_rtp_proxy[flag, ipaddress] not rewriting c and o ?
by MingHon 04 Jul '11

04 Jul '11

im trying to replace the ip address in c= and o= with force_rtp_proxy. i tried different flag co,rc,ro,fo,fc,rfco but still doesnt work. hope some one can help me with this.. below is my noob simple script. hope someone can help.. thanks you :) route[RTPPROXY] { #!ifdef WITH_NAT if (is_method("BYE")) { unforce_rtp_proxy(); } else if (is_method("INVITE")){ xlog("L_INFO","force_rtp_proxy!!!! $rm from $fu (IP:$si:$sp)\n"); force_rtp_proxy("rfco","publicip"); } if (!has_totag()) add_rr_param(";nat=yes"); #!endif return; } -- Regards, MingHon

2 4

MWI Notify Request
by Marvin59 01 Jul '11

01 Jul '11

Hi all, I would like to know how kamailio sends Notify request by using the handle_subscribe of presence module. My purpose is to modify the request to add information for "message waiting indication" like : Messages-Waiting: yes, Voice-Message: 2/0 (0/0), ... I need your help ! Thanks in advance, Best regards Marvin -- View this message in context: http://old.nabble.com/MWI-Notify-Request-tp31954500p31954500.html Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.

2 2

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 July 2011