23 Nov
2016
23 Nov
'16
11:28 p.m.
Sent message to mailing list
From: "volga629" <volga629(a)skillsearch.ca>
To: miconda(a)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(a)skillsearch.ca>
To: miconda(a)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" <miconda(a)gmail.com>
To: "volga629" <volga629(a)skillsearch.ca>ca>, "sr-users"
<sr-users(a)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(a)gmail.com>
To: "sr-users" <sr-users(a)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(a)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(a)gmail.com >
To: "sr-users" < sr-users(a)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(a)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(a)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(a)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(a)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
24 Nov
24 Nov
5:40 a.m.
New subject: msilo
On 24/11/2016 05:28, Slava Bendersky wrote:
[]
------------------------------------------------------------------------
*From: *"volga629" <volga629(a)skillsearch.ca>
*To: *miconda(a)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.
One pair of <> is added by the debug message, perhaps we should change
that given they are used in headers to enclose the uri parts.
The errors seems to be that you try to set as request URI (r-uri or $ru)
or destination URI ($du) something that is like a header in the format
"<uri>;params". You must set it to only the uri, without <> and
params.
Cheers,
Daniel
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" <miconda(a)gmail.com>
*To: *"volga629" <volga629(a)skillsearch.ca>ca>, "sr-users"
<sr-users(a)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(a)gmail.com>
*To: *"sr-users" <sr-users(a)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:
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(a)skillsearch.ca <mailto:volga629@skillsearch.ca>> wrote:
Hello Daniel,
I am not programmer, but I want place request if kaamilio
devs can complete it .
Thanks
Slava.
------------------------------------------------------------------------
*From: *"Daniel-Constantin Mierla" <miconda(a)gmail.com
<mailto:miconda@gmail.com>>
*To: *"sr-users" <sr-users(a)lists.sip-router.org
<mailto: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:
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(a)lists.sip-router.org
<mailto: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://twitter.com/#%21/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(a)lists.sip-router.org
<mailto: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(a)lists.sip-router.org
<mailto: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(a)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(a)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
5:45 a.m.
New subject: msilo
I expect the encryption/decryption can be done with some triggers in
mysql server.
In kamailio config you can use crypto module to encrypt a text and store
it in a variable:
- https://www.kamailio.org/docs/modules/stable/modules/crypto.html
Then you can use sqlops to insert into the database. The issue comes
when dumping stored messages... probably you can just replace msilo with
sqlops+uac at the expense of a more complex configuration file.
On the other hand, probably adds some privacy to the local platform
operators, which have access only to the mysql, because the key will be
in kamailio.cfg. For full privacy, the endpoints should do the
encryption/decryption with a key they agreed before, without being known
by the server.
Cheers,
Daniel
On 24/11/2016 05:28, Slava Bendersky wrote:
Sent message to mailing list
------------------------------------------------------------------------
*From: *"volga629" <volga629(a)skillsearch.ca>
*To: *miconda(a)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.
--
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
3006
days inactive
3006
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Slava Bendersky