Re: [SR-Users] Wrong dialog selected in on_reply/failure route in case of spirals.

2015-01-25 Thread Julia Boudniatsky
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

2015-01-25 Thread Slava Bendersky
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

2015-01-25 Thread Mickael Marrache
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

2015-01-25 Thread Yuriy Gorlichenko
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

2015-01-25 Thread aft
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

2015-01-25 Thread Carsten Bock
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

2015-01-25 Thread Slava Bendersky
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