Sent message to mailing list
From: "volga629" <volga...@skillsearch.ca>
To: mico...@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" <volga...@skillsearch.ca>
To: mico...@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@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" <mico...@gmail.com>
To: "volga629" <volga...@skillsearch.ca>, "sr-users"
<sr-users@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" <mico...@gmail.com>
To: "sr-users" <sr-users@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" < volga...@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" < mico...@gmail.com >
To: "sr-users" < sr-users@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@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@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@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@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
_______________________________________________
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
