Re: [SR-Users] Wrong dialog selected in on_reply/failure route in case of spirals.
Hello Daniel, I have re-installed kamailio from last 4.1 branch, but unfortunately, the problem persists. Failed call with callID=2-17858@10.25153.150. The log file i send to your private mail. Best regards, Julia On Sun, Jan 25, 2015 at 12:03 AM, Daniel-Constantin Mierla mico...@gmail.com wrote: Hello, got the time to analyze your last logs and I discovered that the previous patch was not resetting properly the dialog shortcuts. I pushed a fix, can you try again with the latest version from one of the branches: master, 4.2 or 4.1?Let me know the results. Cheers, Daniel On 15/01/15 23:42, Daniel-Constantin Mierla wrote: Hello, I looked at the logs, but I cannot see the log message I added with the patch for reseting local dialog shortcuts after onreply and failure route. It shuld be something like: ... resetting the local dialog shortcuts Are you sure you are running the latest branch 4.1? You can send the output of kamailio -v to double check here. I separated the logs per process and looked when a 301 was received, apparently the ones for Call-ID: 4-21712 are matching the same dialog. I found something not printing the same kind of logs like for other 301 for Call-ID: 2-21712. If you can point the line in the logs where you think it was the wrong dialog match, I can investigate from there, but now I couldn't find any lead. Anyhow, if it is the latest branch 4.1 and the problem still persists, can you add the following xlog at the beginning of main request_route (or the route {...} ), plus in each reply_route, onreply_route and failure_route: xlog(processing $rm ( $ci / %ft / $tt / $hdr(Via) ) [$fu = $tu]\n); Then redo the tests to catch the issue and send me the new logs. Because you use sipp with tags like '4', it is hard to search on a single tocken and I want to have the all message attribute when a relevant route block is executed. Cheers, Daniel On 14/01/15 15:07, Daniel-Constantin Mierla wrote: Hello Julia, ok, I will look over the logs very soon. As a short note for the future, make the archives zip or tgz, being more common formats that can be unarchived everywhere without installing additional app, being handy to open even on small devices. Now it is ok with rar, being at the desk. Cheers, Daniel On 14/01/15 14:43, Julia Boudniatsky wrote: Hello Daniel, Please find in attached file the debug 3 log. Failed call with Call-ID: 4-21712@10.25.153.150. The problem occurred with all modes of dlg_match_mode The same load test in 3.3 executed without failures. Thank you, Julia. -- Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda -- Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] remote mysql server
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://:@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://:@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] CDRs and MongoDB
Hi Daniel, Thank you, it works! However, I see both transactions and CDRs accounting. Is there a way to only enable CDR accounting? Mickael From: sr-users [mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Friday, January 23, 2015 10:55 AM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] CDRs and MongoDB Hello, it should work to write the cdrs to a database. I removed the note from the readme, it was there from an older version and overlooked when the feature was implemented. Cheers, Daniel On 23/01/15 08:15, Mickael Marrache wrote: 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 ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] lookup_branches and rtpengine_manage
Hello. I need parallel forking calls with the same username. (Call to all contacts with name for example User123), my endpoints may be WebSocket based and standart UDP endpoints. And I use rtpengine_manage for nmanaging calls wor webphones and standart softh/hard phones. I get all contacts manually and than at the branch route set rtpengine_manage settings for every call. It works fine but it works for one kamailio server. When I use 2 kamailio servers as load balansers Server that handle call get all endpoints from location but call to only one, that registred only at ths server for example I call user123 I have 3 contacts user123@1.2.3.4 - was registered at kamailio 1 user123@3.2.1.4 - was registered at kamailio 2 user123@4.3.2.1 - was registered at kamailio 1 So if call goes through kamailio 1 it call only to user123@1.2.3.4 and user123@4.3.2.1 I use this settings for usrloc at 2 kamailios to share all table between 2 servers modparam(usrloc, db_url, DBURL) modparam(usrloc, db_mode, 3) modparam(usrloc, user_column, username) modparam(usrloc, contact_column, contact) modparam(usrloc, expires_column, expires) modparam(usrloc, q_column, q) modparam(usrloc, callid_column, callid) modparam(usrloc, cseq_column, cseq) modparam(usrloc, methods_column, methods) modparam(usrloc, cflags_column, cflags) modparam(usrloc, user_agent_column, user_agent) modparam(usrloc, received_column, received) modparam(usrloc, socket_column, socket) modparam(usrloc, path_column, path) modparam(usrloc, ruid_column, ruid) modparam(usrloc, instance_column, instance) modparam(usrloc, use_domain, 1) and this code for calling them [GET_CONTACTS] { sql_query(ca, select contact from location where username='$tU', ra); xlog(rows: $dbr(ra=rows) cols: $dbr(ra=cols)\n); if($dbr(ra=rows)0){ $var(i)=0; while($var(i)$dbr(ra=rows)){ xlog(L_INFO,SQL query return contact {$dbr(ra=[$var(i),0])} for {$tU} at step {$var(i)}\n); if ($dbr(ra=[$var(i),0])=~transport=ws){ xlog(L_INFO, This is a Websocket call to endpoint); sql_pvquery(ca, select received from location where contact='$dbr(ra=[$var(i),0])',$var(recieved)); $du=$var(recieved); xlog(L_INFO,SQL query return recieved {$var(recieved)} for {$tU}. Destination is {$du}\n); append_branch(sip:$tU@$(du{s.select,1,:})); } else { xlog(L_INFO, This is a classic UDP call to endpoint); $var(recieved)=''; sql_pvquery(ca, select received from location where contact='$dbr(ra=[$var(i),0])',$var(recieved)); xlog(L_INFO, SQL query return RECIEVED {$var(recieved)}); if ($var(recieved)==0){ xlog(L_INFO, Recieved string is EMPTY); $du=sip:+$(dbr(ra=[$var(i),0]){s.select,1,@}); } else { xlog(L_INFO, Recieved string is {$var(recieved)}); $du=$var(recieved); } $var(UDP_contact)=sip:+$(dbr(ra=[$var(i),0]){s.select,1,@}); append_branch(sip:$tU@$(du{s.select,1,:})); xlog(L_INFO,Classic Destination URI is {$dbr(ra=[$var(i),0])} for {$tU}}. Destination is {$du}\n); } $var(i) = $var(i) + 1; } } t_on_branch(1); return; } } } branch_route[1]{ if($du=~transport=ws){ xlog(L_INFO,Websocket Branch is {$du} for {$tU}\n); rtpengine_manage(internal extenal force trust-address replace-origin replace-session-connection ICE=force RTP/SAVPF); t_on_reply(REPLY_FROM_WS); } else{ xlog(L_INFO,UDP Branch is {$du)} for {$tU}\n); rtpengine_manage(replace-origin replace-session-connection ICE=remove RTP/AVP); t_on_reply(MANAGE_CLASSIC_REPLY); } } When it try to branch endpoint without registration at server that handle call I get errors that tm module can not build Via header **via_builder(): TCP/TLS connection (id: 0) for WebSocket could not be found* *ERROR: core [msg_translator.c:1725]: build_req_buf_from_sip_req(): could not create Via header* *ERROR: core [forward.c:607]: forward_request(): ERROR: forward_request: building failed* * UDP calls get errors something like above (sorry than can not share error code, This situation not often). So I think I have this trouble because I use manually handling call and tried to substitute to lookup_branches function. but I have no Idea how to set rtpengine_manage paraments for each endpoint depending this is websocket or standart call. IF there is write problem for callings thhrough 2 kamailios as loadbalansers pleas let me know about how to set rtpengine_manage parametrs wor endpoints for every fork. If not- can you tell me how I can call to all endpoints endepending of registration server (kamailio 1 or 2). Thanks. ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] How to forward sip message statefully so that the dialogue is preserved
We want to implement the following topology : INVITE---kamailio1-forward---kamailio2---route[NATMANAGE]---Next Sip endpoint Client route[NATMANAGE]kamailio1--forward-kamailio2 reply with SDP So the caller to callee will be processed by one kamailio and callee to caller will be processed by another kamailio. Both kamailio will be up with a public IP. How this can be achieved? ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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 volga...@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://:@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://:@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@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:cars...@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] remote mysql server
Hello Everyone, Thank you for help, fixed by adding to dialog module parameters. modparam(dialog, db_url, DBURL) Slava. From: Carsten Bock cars...@ng-voice.com To: sr-users sr-users@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 volga...@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://:@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://:@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@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:cars...@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@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 cars...@ng-voice.com To: sr-users sr-users@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 volga...@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://:@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://:@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@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:cars...@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