[SR-Users] msilo
Slava Bendersky
volga629 at skillsearch.ca
Sun Dec 4 01:37:34 CET 2016
Hello Everyone,
I need help with while loop. Can't find why it try go over only first value from db search and not each value.
https://paste.fedoraproject.org/497911/48081139/
Any help thank you.
Slava.
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Sunday, 27 November, 2016 02:12:21
Subject: Re: [SR-Users] msilo
Hello Daniel,
I am trying more simple example of $dbr in REGISTER first. Insert into location temporary data. The problem is not looping though all entries in database only last one. Which compare same entry 100 times.
if(is_method("REGISTER")) {
add_path_received();
xlog("L_INFO", "MSILO: New user request saving contact [$ct]\n");
lua_dofile("/usr/bin/ruid.lua");
xlog("L_INFO", "AOR: New user Ruid -->[$var(ruid)]\n");
sql_query("cb", "SELECT * FROM location", "result");
xlog("rows: $dbr(result=>rows) cols: $dbr(result=>cols)\n");
$var(result) = 0;
while($var(i)<$dbr(result=>rows)) {
sql_pvquery("cb", "SELECT ruid FROM location WHERE callid = '$ci'", "$var(dbruid)");
if(fnmatch("$var(dbruid)", "$var(ruid)")) {
xlog("L_INFO", "AOR: Found match --> [$var(dbruid)] = [$var(ruid)]\n");
} else {
sql_query_async("cb","DELETE FROM location WHERE ruid = '$var(dbruid)'");
sql_query_async("cb","INSERT INTO location(id, username, expires, contact, user_agent, domain, callid, ruid) VALUES(0, '$au', NOW(), '$ct', '$ua', '$fd', '$ci', '$var(ruid)')");
}
}
}
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Sunday, 27 November, 2016 00:58:29
Subject: Re: [SR-Users] msilo
Ok lua works right now. I was need remove "" in the value.
Slava
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Sunday, 27 November, 2016 00:29:39
Subject: Re: [SR-Users] msilo
Hello Everyone,
I tried use sr.pv.sets, but not sure how to pass value to it.
#!/usr/bin/lua
math.randomseed(os.time())
ruid = string.format("uloc-%08x-%03x-%x", math.random(0xffffffff), math.random(0xfff), math.random(0xf))
print(ruid) ---> Works
sr.pv.sets("$var(ruid)", "ruid") ---> In kamailio just static ruid
Output
AOR: New user Ruid -->[ruid]
Slava.
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Saturday, 26 November, 2016 23:41:46
Subject: Re: [SR-Users] msilo
Hello Everyone,
Can't find how actually return actual value from lua script not 1.
Because my setup is pass through REGISTER to B2BUA, I can't use registrar module. I though insert manually, but location table require ruid entry. I installed small lua script to generate it. Not sure if this good approach for it.
When user send first REGISTER in request do like this
if(is_method("REGISTER")) {
add_path_received();
xlog("L_INFO", "MSILO: New user request saving contact [$ct]\n");
$var(ruid) = lua_dofile("/usr/bin/ruid.lua");
xlog("L_INFO", "AOR: New user Ruid -->[$var(ruid)]\n");
sql_query_async("cb","INSERT INTO location(id, username, expires, contact, user_agent, domain, callid, ruid) VALUES(0, '$au', $TS, '$ct', '$ua', '$fd', '$ci', '$var(ruid)')");
}
Slava.
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Friday, 25 November, 2016 02:14:59
Subject: Re: [SR-Users] msilo
Hello Everyone,
I am trying run small lua script to generate random formatted string, but always get 1. Is script need be set in special way ? That related
to MSILO setup which I am trying to do.
xlog("L_INFO", "MSILO: New user request saving contact [$ct]\n");
$var(ruid) = lua_dofile("/usr/bin/ruid.lua");
xlog("L_INFO", "AOR: New user Ruid -->[$var(ruid)]\n");
Output
Nov 25 01:06:54 cavprx00 /usr/sbin/kamailio[3345]: INFO: <script>: AOR: New user Ruid -->[1]
Actual output
[root at cavprx00 kamailio]# /usr/bin/ruid.lua
uloc-8b7dae10-c17-2
[root at cavprx00 kamailio]# cat /usr/bin/ruid.lua
#!/usr/bin/lua
math.randomseed(os.time())
print(string.format("uloc-%08x-%03x-%x", math.random(0xffffffff), math.random(0xfff), math.random(0xf)))
Slava.
From: "volga629" <volga629 at skillsearch.ca>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Thursday, 24 November, 2016 12:15:45
Subject: Re: [SR-Users] msilo
Hello Everyone,
For dump I though do something like this. No sure if possible optimise it. Also how if possible convert inc_time to human readable ?
xlog("L_INFO", "[$rm], Got Register request for <$tU> dumping OFFLINE SMS\n");
while(sql_pvquery("cb","SELECT id FROM silo ORDER BY id ASC","$avp(id)")) {
sql_pvquery("cb", "SELECT dst_addr, src_addr, body, inc_time FROM silo WHERE id = '$avp(id)'","$avp(dst), $avp(src), $avp(body), $avp(time)");
crypto_aes_decrypt("$var(body)", "decryption key", "$avp(decrypted)");
$uac_req(method)="MESSAGE";
$uac_req(furi)=$avp(src);
$uac_req(turi)=$avp(dst);
$uac_req(body)= $avp(decrypted) ;
uac_req_send();
}
Slava.
From: "volga629" <volga629 at skillsearch.ca>
To: miconda at gmail.com, "sr-users" <sr-users at lists.sip-router.org>
Sent: Thursday, 24 November, 2016 09:34:18
Subject: Re: [SR-Users] msilo
Hello Daniel,
That good idea, I will need help with sqlops to update information properly. Make sure the query is optimal. I will still can use if(m_store("$tu")), because it maintain offline notification, but I can use something like this. For dump I will put uac.
route[OFFLINE_MESSAGE] {
if(!is_method("MESSAGE")) {
return;
}
if(isflagset(FLAG_FROM_PEER)) {
if(!lookup("location")) {
xlog("L_INFO", "User $tU domain $td offline. Trying store SMS for later delivery\n");
xlog("L_INFO", "SMS received from $fU to $tU domain [$td] --> storing using MSILO\n");
# MSILO - storing as offline message
if(m_store("$tu")) {
xlog("L_INFO", "MSILO: offline message stored\n");
# Encrypt stored offline message
crypto_aes_encrypt("$rb", "mykey", "$avp(encrypted)");
sql_pvquery("cb", "select * from silo ORDER BY id DESC LIMIT 1","$avp(id)");
sql_query_async("cb","UPDATE silo SET body = $avp(encrypted) WHERE id = $avp(id)");
if(is_request()) {
if(!sl_send_reply("202", "Accepted")) {
sl_reply_error();
}
} else {
xlog("L_INFO", "MSILO: offline message NOT stored\n");
#if(!sl_send_reply("503", "Service Unavailable")) {
# sl_reply_error();
#}
}
}
t_on_failure("SMS_FAIL_ROUTE");
exit;
}
}
}
Slava.
From: "Daniel-Constantin Mierla" <miconda at gmail.com>
To: "sr-users" <sr-users at lists.sip-router.org>
Sent: Thursday, 24 November, 2016 06:45:48
Subject: Re: [SR-Users] 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 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.
--
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
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20161203/841e7296/attachment.html>
More information about the sr-users
mailing list