sr-users

sr-users@lists.kamailio.org

54 participants
37560 discussions

Re: [SR-Users] remote mysql server
by Slava Bendersky 25 Jan '15

25 Jan '15

Hello Everyone, Thank you for help, fixed by adding to dialog module parameters. modparam("dialog", "db_url", DBURL) Slava. From: "Carsten Bock" <carsten(a)ng-voice.com> To: "sr-users" <sr-users(a)lists.sip-router.org> Sent: Sunday, January 25, 2015 8:36:52 AM Subject: Re: [SR-Users] remote mysql server Hi Slava, is most modules a default database connection is defined. Probably this is the case here. As this error is coming from the dialog module: Did you configure some sort of "db_mode"? e.g.: modparam("dialog", "db_mode", 1) Thanks, Carsten 2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629(a)skillsearch.ca>: > Hello Everyone, > > I am trying start kamailio 4.2 with remote mysql server and on debug I see > DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening > connection: mysql://xxxx:xxxx@localhost/kamailio > but in cfg defined actual mysql server ip and not localhost > > 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record(): > find_export_record: found <db_bind_api> in module db_mysql > [/usr/lib64/kamailio/modules/db_mysql.so] > 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for > db_mysql > 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8 > not found in pool > 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): > opening connection: mysql://xxxx:xxxx@localhost/kamailio > 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): > driver error: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2 "No such file or directory") > 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection > to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db(): > unable to connect to the database > > > Slava. > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users(a)lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > -- Carsten Bock CEO (Geschäftsführer) ng-voice GmbH Schomburgstr. 80 D-22767 Hamburg / Germany http://www.ng-voice.com mailto:carsten@ng-voice.com Office +49 40 5247593-0 Fax +49 40 5247593-99 Sitz der Gesellschaft: Hamburg Registergericht: Amtsgericht Hamburg, HRB 120189 Geschäftsführer: Carsten Bock Ust-ID: DE279344284 Hier finden Sie unsere handelsrechtlichen Pflichtangaben: http://www.ng-voice.com/imprint/ _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users oon why I see in log connection attempt to localhost ? From: "Carsten Bock" <carsten(a)ng-voice.com> To: "sr-users" <sr-users(a)lists.sip-router.org> Sent: Sunday, January 25, 2015 8:36:52 AM Subject: Re: [SR-Users] remote mysql server Hi Slava, is most modules a default database connection is defined. Probably this is the case here. As this error is coming from the dialog module: Did you configure some sort of "db_mode"? e.g.: modparam("dialog", "db_mode", 1) Thanks, Carsten 2015-01-25 9:27 GMT+02:00 Slava Bendersky <volga629(a)skillsearch.ca>: > Hello Everyone, > > I am trying start kamailio 4.2 with remote mysql server and on debug I see > DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening > connection: mysql://xxxx:xxxx@localhost/kamailio > but in cfg defined actual mysql server ip and not localhost > > 0(28885) DEBUG: <core> [sr_module.c:695]: find_mod_export_record(): > find_export_record: found <db_bind_api> in module db_mysql > [/usr/lib64/kamailio/modules/db_mysql.so] > 0(28885) DEBUG: <core> [db.c:213]: db_bind_mod(): using db bind api for > db_mysql > 0(28885) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7faca59eced8 > not found in pool > 0(28885) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): > opening connection: mysql://xxxx:xxxx@localhost/kamailio > 0(28885) ERROR: db_mysql [km_my_con.c:109]: db_mysql_new_connection(): > driver error: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2 "No such file or directory") > 0(28885) ERROR: <core> [db.c:322]: db_do_init2(): could not add connection > to the pool 0(28885) ERROR: dialog [dlg_db_handler.c:147]: init_dlg_db(): > unable to connect to the database > > > Slava. > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users(a)lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > -- Carsten Bock CEO (Geschäftsführer) ng-voice GmbH Schomburgstr. 80 D-22767 Hamburg / Germany http://www.ng-voice.com mailto:carsten@ng-voice.com Office +49 40 5247593-0 Fax +49 40 5247593-99 Sitz der Gesellschaft: Hamburg Registergericht: Amtsgericht Hamburg, HRB 120189 Geschäftsführer: Carsten Bock Ust-ID: DE279344284 Hier finden Sie unsere handelsrechtlichen Pflichtangaben: http://www.ng-voice.com/imprint/ _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

1 0

remote mysql
by Slava Bendersky 25 Jan '15

25 Jan '15

Hello Everyone, I am trying start kamailio 4.2 with remote mysql server and on debug I see DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening connection: mysql://xxxx:xxxx@localhost/kamailio but in cfg defined actual mysql server ip and not localhost Any help thank you, Slava.

3 2

CDRs and MongoDB
by Mickael Marrache 25 Jan '15

25 Jan '15

Hi, Is it possible to write CDRs directly to MongoDB using the new db_mongodb module? modparam("acc", "db_url", DB_MONGO_URL) modparam("acc", "cdr_enable", 1) modparam("acc", "cdr_extra", " . ") modparam("acc", "cdr_log_enable", 0) modparam("acc", "cdrs_table", "cdrs") In the acc module documentation, I found the following statement: Note that CDR generation does not involve any kind of database storage (yet). In order to persist the CDRs into a database you will have to set up an exterior process (i.e., a script living outside of Kamailio) and implement the storage task yourself. Thanks, Mickael

2 2

Wrong dialog selected in on_reply/failure route in case of spirals.
by Julia Boudniatsky 25 Jan '15

25 Jan '15

After kamailio upgrade from v3.3 to v4.1.7 in production ~5% of calls with spirals dialog are failed with wrong dialog variables in on-reply/failure routes. The problem has been reproduced in the LAB (load test generated by SIPP). Please see the attached file with debug3 log. Scenario: Proxy Location Kamailio P1 Nbr translation Redirect | INVITE | | | dlg 0x7f8f8501aba0 | | | Call-ID:(5-8286@10.25.153.150) | | |------------------------------->| | | 100 Trying | | | dlg 0x7f8f8501aba0 | | | Call-ID:(5-8286@10.25.153.150) | | |<-------------------------------| | | | | | INVITE | | | dlg 0x7f8f8501aba0 | | | Call-ID:(5-8286@10.25.153.150) | | |<-------------------------------| | | 100 Trying | | | dlg 0x7f8f8501aba0 | | | Call-ID:(5-8286@10.25.153.150) | | |------------------------------->| | | | | | INVITE | | | dlg 0x7f8f8501aba0 | | | Call-ID:(5-8286@10.25.153.150) | |-------------------------------------------------------------->| | 100 Trying | | dlg 0x7f8f8504cda0 !!!!!!!! | | Call-ID:(5-8286@10.25.153.150)| |<--------------------------------------------------------------| | 301 Moved Permanently | | dlg 0x7f8f8504cda0 !!!!!!!! | | Call-ID:(5-8286@10.25.153.150)| |<--------------------------------------------------------------| | | Thank you, Julia.

2 11

mistakenly detected NAT in IPv6 setup
by Sebastian Damm 23 Jan '15

23 Jan '15

Hi, it looks to me that Kamailio detects NAT without NAT being there, when used in IPv6 scenarios. I have a register, which comes in like this: U 2015/01/23 11:42:31.013284 2a01:1234:123:1234::2:16732 -> 2001:9876:98:9876::aa01:5060 REGISTER sip:domain SIP/2.0 Via: SIP/2.0/UDP [2a01:1234:123:1234::2]:16732;branch=z9hG4bK45528eba After it has run through Kamailio, the packet is sent out like this: U 2015/01/23 11:42:31.015126 1.2.3.4:5060 -> 9.8.7.6:5060 REGISTER sip:domain SIP/2.0 Via: SIP/2.0/UDP 1.2.3.4;branch=z9hG4bK8d21.7fa5fb060c2acc9583f05a93b93f9873.0 Via: SIP/2.0/UDP [2a01:1234:123:1234::2]:16732;received=2A01:1234:123:1234:0:0:0:2;branch=z9hG4bK45528eba As far as I know, the received part should only get appended, if the source IP of the packet differs from the IP advertised in the topmost Via header. But to me it looks like it always gets appended. In just IPv4 scenarios, the received parameter only gets appended if a difference is detected. And if it gets appended, shouldn't the received parameter IP be in square brackets, too? Later on, we have something like this in our code: if(method=="REGISTER") { if (nat_uac_test("23")) { append_hf("X-nathint: nat\r\n"); force_rport(); if (!add_path_received()) { sl_send_reply("503", "Internal Path Error"); }; } else { if (!add_path()) { sl_send_reply("503", "Internal Path Error"); }; }; } In our code, Kamailio always jumps into the add_path_received() part, so I guess, NAT detection triggers. But why? And then the Path header appended looks like this: Path: <sip:1.2.3.4;lr;received=sip:2A01:1234:123:1234:0:0:0:2:16732> The path module probably doesn't know anything about IPv6, too, so the IP in the received parameter is not enclosed in square brackets. When using the Path header later to send packets to the client, Kamailio complains about a parse error for the destination URI again. I tried looking into the path module, but I guess my C skills aren't sufficient to submit a patch. Best regards, Sebastian

2 2

Siremis Installation Web Page NOT Displayed.
by Mahmoud Ramadan Ali 23 Jan '15

23 Jan '15

Hi Dears, I'm trying to install Siremis 4.1 on Debian and whenever i open the URL in IE i get location.href='$url'"; exit; } ?> and in Firefox i see <?php if(is_file(dirname(__FILE__).'/install.lock')){ include 'bin/_forward.php'; }else{ $script_name = $_SERVER['SCRIPT_NAME']; $url = str_replace("index.php","install/",$script_name); echo "<script>location.href='$url'</script>"; exit; } ?> I've verified the permissions of - siremis/log - siremis/session - siremis/files - siremis/themes/default/template/cpl files without success also no logs gets written to the logs file...please help to fix this issue... Thanks in advance

1 0

RFC: best way to create dialogs
by Klaus Darilion 22 Jan '15

22 Jan '15

Hi! I use the dialog module to count and limit concurrent calls per user. It worked fine with 4.1.7 but fails with 4.2.2. My config basically looks like: route{ ... dlg_manage() ... authentication (stateless replies + exit) ... t_on_reply() t_on_branch() ... t_relay() exit; } initial_cbs_inscript uses the default value 1. Using 4.1.7, after stateless reply+exit, Kamailio executes dialog callbacks and deletes the dialog: [dlg_var.c:55]: dlg_cfg_cb(): new dialog with no trasaction after config execution [dlg_hash.c:872]: dlg_unref(): unref dlg 0xb233c3a0 with 1 -> 1 [dlg_hash.c:872]: dlg_unref(): unref dlg 0xb233c3a0 with 1 -> 0 [dlg_hash.c:872]: dlg_unref(): ref <=0 for dialog 0xb233c3a0 [dlg_hash.c:355]: destroy_dlg(): destroying dialog 0xb233c3a0 (ref 0) With 4.2.2, after stateless reply+exit, Kamailio just exits without calling any dialog callback (to destroy the dialog) I think I could work around the problem by creating the transaction later. Here are some ideas and I would be happy about your comments and best practices. - set initial_cbs_inscript to 0 - call dlg_manage() just before t_relay - do not use dlg_manage() but use the dialog flag and set the flag somewhere before t_relay Finally, do t_on_reply() and t_on_branch() already create the transaction or is it created with t_relay()? Thanks Klaus

1 0

reINVITE with uac_req_send()
by Le Truong Giang 22 Jan '15

22 Jan '15

Hi ! I have the following simple scenario A <---> Kamailio <---> Asterisk <---> B now i'm trying to handle Timeout reply when B is unavailable. First i suspend transaction and wait for B available. i use uac_reg_send() to reINVITE B .The problem is when B available, it receive INVITE but A doesn't receive ACK therefore the call is incomplete I guess the reason is source IP in reINVITE is Kamailio's not A's IP, so ACK can't reach A. How can i set this source IP to A's IP ? Any idea is appreciated Thank you !

1 0

RedHat 7 packages issue
by Alberto Panizzo 22 Jan '15

22 Jan '15

Hi all, Thanks for your hard working on Kamailio! I was just trying to install kamailio 4.2.X on a RedHat 7 machine but I got checksum mismatch: I took the yum configuration from: http://rpm.kamailio.org/ [kamailio] name=RPMs for Kamailio on RHEL 7 type=rpm-md baseurl=http://rpm.kamailio.org/stable/RHEL_7/ gpgcheck=1 gpgkey=http://rpm.kamailio.org/stable/RHEL_7/repodata/repomd.xml.key enabled=1 Than started yum update $ sudo yum update Loaded plugins: amazon-id, rhui-lb kamailio | 1.2 kB 00:00:00 kamailio/primary FAILED ] 0.0 B/s | 0 B --:--:-- ETA http://rpm.kamailio.org/stable/RHEL_7/repodata/primary.xml.gz: [Errno -1] Metadata file does not match checksum] 0.0 B/s | 0 B --:--:-- ETA Trying other mirror. kamailio/primary | 7.4 kB 00:00:00 http://rpm.kamailio.org/stable/RHEL_7/repodata/primary.xml.gz: [Errno -1] Metadata file does not match checksum Trying other mirror. Indeed http://rpm.kamailio.org/stable/RHEL_7/repodata/repomd.xml says: <data type="primary"> <checksum type="sha">4cc322a95d4a978e383903feaf8fbbe8ccc2ff9e</checksum> <open-checksum type="sha">9fd04e59185a8e844133b834a662cae3cc0837b7</open-checksum> <location href="repodata/primary.xml.gz"/> <timestamp>1413465311</timestamp> <size>7344</size> <open-size>70829</open-size> </data> while http://rpm.kamailio.org/stable/RHEL_7/repodata/primary.xml.gz I can download is: $ ls -l primary.xml.gz -rw-rw-r-- 1 alberto alberto 7562 gen 22 10:58 primary.xml.gz $ shasum primary.xml.gz e8e052970984feb0cdb16b98f05aefc516295aba primary.xml.gz Do I have to switch to other repository? Thank you, Best Regards -- Alberto Panizzo CTO - Co-Founder Amarula Solutions BV Cruquiuskade 47 Amsterdam 1018 AM NL T. +31(0)851119171 F. +31(0)204106211 www.amarulasolutions.com

1 0

How to make presence module allocating an etag only for an initial Publish??
by Nuno Reis 21 Jan '15

21 Jan '15

Hello all. I've been testing presence module for a while and I do notice that presentity table grows endlessly over time. Each time a call is made a new record is added in presentity with a different etag. In documentation, namely developers guide we can read this: int etag_not_new; /* * 0 - the standard mechanism (allocating new etag for each Publish) * 1 - allocating an etag only for an initial Publish */ How can I tell the presence module in kamailio config to work using the second form of the above? Looking forward to hear from you. BR, -- *Nuno Miguel Reis* | *Unified Communication** Systems* M. +351 913907481 | nreis(a)wavecom.pt WAVECOM-Soluções Rádio, S.A. Cacia Park | Rua do Progresso, Lote 15 3800-639 AVEIRO | Portugal T. +351 309 700 225 | F. +351 234 919 191 *GPS <http://maps.google.com/maps/ms?msa=0&msid=202333747613191340808.0004b4b227a…> | www.wavecom.pt <http://www.wavecom.pt/>** <http://www.wavecom.pt/>* [image: Description: Description: WavecomSignature] <http://www.wavecom.pt/pt/wavecom/premios.php> [image: Publicity] <http://www.wavecom.pt/pt/mail_eventos.php>

2 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