[SR-Users] msilo

Thu Nov 24 05:28:23 CET 2016

Sent message to mailing list 

From: "volga629" <volga629 at skillsearch.ca> 
To: miconda at gmail.com 
Sent: Thursday, 24 November, 2016 00:25:30 
Subject: Re: [SR-Users] msilo 

Hello Everyone, 
I want to ask about another improvement for MSILO module. If possible encrypt BODY column in database. That will improve some privacy concerns for storing body in plain text. 

Slava. 

From: "volga629" <volga629 at skillsearch.ca> 
To: miconda at gmail.com 
Sent: Wednesday, 23 November, 2016 21:10:53 
Subject: Re: [SR-Users] msilo 

Hello Everyone, 
Need another set of eyes, can't find how to To: got << in uri. 

Nov 23 19:50:55 cavprx00 kamailio: 3(9625) DEBUG: <core> [parser/parse_uri.c:1280]: parse_uri(): parse_uri: bad uri, state 0 parsed: <<sip> (4) / <<sip:4200 at client_public_ip:49418>;messagetype=SMS> (47) 
Nov 23 19:50:55 cavprx00 kamailio: 3(9625) ERROR: tm [ut.h:254]: uri2dst2(): ERROR: uri2dst: bad_uri: [<sip:4200@ client_public_ip :49418>;messagetype=SMS] 
Nov 23 19:50:55 cavprx00 kamailio: 3(9625) ERROR: tm [t_fwd.c:1723]: t_forward_nonack(): ERROR: t_forward_nonack: failure to add branches 

route[MESSAGE_FORWARD] { 
xlog("L_INFO", "Incoming new SMS [$rm] from $tU --> $td\n"); 

if(fnmatch("$rs", "202") && fnmatch("$rr", "Accepted") && allow_trusted("$si", "$proto")) { 
$sht(b=>from) = $fu; 
$sht(b=>oldto) = $tu; 
$avp(new_to) = "<" + $sht(b=>oldto) + ">" + ";messagetype=SMS"; 
xlog("L_INFO", "MESSAGE: B2BUA send --> [$rs] with [$rr] from [$sht(b=>from)] to [$sht(b=>oldto)] -->[$td]\n"); 
} 

if(compare_ips("$td", "10.18.130.27")) { 
xlog("L_INFO", "Message from B2BUA contain domain --> $td user --> $(sht(b=>oldto){uri.user}) updating...\n"); 
sql_pvquery("cb", "select contact from location where username = '$(sht(b=>oldto){uri.user})'","$avp(dst)"); 
#$avp(new_dst) = $(hdr(Route){param.value,received}); 
xlog("L_INFO", "New destination --> $avp(dst)\n"); 
$avp(new_to) = "<" + $(avp(dst){tobody.uri}) + ">" + ";messagetype=SMS"; 
} 

if(fnmatch("$fU", "offline")) { 
xlog("L_INFO", "OFFLINE SMS: from [$fU] user --> $fU\n"); 
$avp(from) = $(sht(b=>oldto){uri.user}); 
xlog("L_INFO", "OFFLINE SMS: Searching destination user $avp(oexten)\n"); 
sql_pvquery("cb", "select contact from location where username = '$avp(from)'","$avp(dst)"); 
xlog("L_INFO", "OFFLINE SMS: set new destination --> $avp(dst)\n"); 
$avp(new_to) = "<" + $(avp(dst){tobody.uri}) + ">" + ";messagetype=SMS"; 
} 

xlog("L_INFO", "OFFLINE SMS: new AVP DST $avp(new_to)\n"); 
$sht(a=>to) = $avp(new_to); 
remove_hf("To"); 
insert_hf("To: $sht(a=>to)\r\n", "To"); 
$du = $sht(a=>to); 
xlog("SMS from --> $fU domain $fd\n"); 
xlog("-------------------------------------\n"); 
xlog("L_INFO", "FROM --> $avp(from)\n"); 
xlog("L_INFO", "OLD_TO --> $sht(b=>oldto)\n"); 
xlog("L_INFO", "NEW_TO --> $avp(new_to)\n"); 

} 

Slava. 

From: "Daniel-Constantin Mierla" <miconda at gmail.com> 
To: "volga629" <volga629 at skillsearch.ca>, "sr-users" <sr-users at lists.sip-router.org> 
Sent: Thursday, 17 November, 2016 05:44:22 
Subject: Re: [SR-Users] msilo 

Hello, 

if you want to fetch them for config usage is ok, otherwise m_dump() is still better, because it takes care of removing delivered messages, etc... 

Cheers, 
Daniel 

On 16/11/16 16:08, Slava Bendersky wrote: 

Hello Daniel, 
Yes that good alternative. I will use sql to fetch or insert staff. 

Slava 

From: "Daniel-Constantin Mierla" <miconda at gmail.com> 
To: "sr-users" <sr-users at lists.sip-router.org> 
Sent: Wednesday, 16 November, 2016 04:37:24 
Subject: Re: [SR-Users] msilo 

Hello, 

as an alternative, I think it should work by using sql_query(...) to insert whatever values one would like to have in msilo table. This might be a quick workaround until someone will code the extension to get the body via a function parameter. 

Cheers, 
Daniel 

On 15/11/16 16:07, Federico Cabiddu wrote: 

BQ_BEGIN

Hi Slava, 
if I understand correctly your scenario, 
you could call t_on_failure before relaying the MESSAGE. In this way you should have access to the original message in the failure route triggered after receiving a final reply and you should be able to store it with the regular msilo functions. 
Hope this helps. 

Cheers, 

Federico 

On 15 Nov 2016 3:47 pm, "Slava Bendersky" < volga629 at skillsearch.ca > wrote: 

BQ_BEGIN

Hello Daniel, 
I am not programmer, but I want place request if kaamilio devs can complete it . 
Thanks 

Slava. 

From: "Daniel-Constantin Mierla" < miconda at gmail.com > 
To: "sr-users" < sr-users at lists.sip-router.org > 
Sent: Tuesday, 15 November, 2016 03:00:19 
Subject: Re: [SR-Users] msilo 

Hello, 

for me it is fine to add a new parameter to m_store() that takes the body content. 

Are you asking for more details of how can be done? 
Cheers, 
Daniel 

On 13/11/16 07:08, Slava Bendersky wrote: 

BQ_BEGIN

Hello Everyone, 
I asking question/request to add improvement for msilo module where will have ability set $avp(i:body) in mod params. That will allow use it in m_store() by specifying body message $avp. In my case registration is on B2BUA so kamailio pass through/proxy to destination. In order to check user status online/offline kamailio wait for reply from B2BUA on MESSAGE status if it return error 503 that mean user offline and m_store(0 should store message in db, but the issue that error 503 is in final stage and MESSAGE body is not available any more. The improvement will allow specify body $var in m_store() so new way will be m_store($tu, $avp(body)). 

Any help thank you. 

Slava. 

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at 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 Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com 
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users at lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
BQ_END

BQ_END

-- 
Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com 

_______________________________________________ 
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list 
sr-users at lists.sip-router.org 
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 

BQ_END

-- 
Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20161123/12f6f3ed/attachment.html>