<html><body><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div>Sent message to mailing list</div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"volga629" <volga629@skillsearch.ca><br><b>To: </b>miconda@gmail.com<br><b>Sent: </b>Thursday, 24 November, 2016 00:25:30<br><b>Subject: </b>Re: [SR-Users] msilo<br></div><br><div data-marker="__QUOTED_TEXT__"><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000" data-mce-style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div>Hello Everyone,</div><div>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.</div><br><div>Slava. </div><br><hr id="zwchr"><div><b>From: </b>"volga629" <volga629@skillsearch.ca><br><b>To: </b>miconda@gmail.com<br><b>Sent: </b>Wednesday, 23 November, 2016 21:10:53<br><b>Subject: </b>Re: [SR-Users] msilo<br></div><br><div><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000" data-mce-style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div>Hello Everyone,</div><div>Need another set of eyes, can't find how to To: got << in uri.</div><br><br><div>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)<br>Nov 23 19:50:55 cavprx00 kamailio: 3(9625) ERROR: tm [ut.h:254]: uri2dst2(): ERROR: uri2dst: bad_uri: [<sip:4200@<span style="color: rgb(0, 0, 0); font-family: "lucida console", sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;" data-mce-style="color: rgb(0, 0, 0); font-family: "lucida console", sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">client_public_ip</span>:49418>;messagetype=SMS]<br>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<br></div><br><br><div>route[MESSAGE_FORWARD] {<br> xlog("L_INFO", "Incoming new SMS [$rm] from $tU --> $td\n");<br><br> if(fnmatch("$rs", "202") && fnmatch("$rr", "Accepted") && allow_trusted("$si", "$proto")) {<br> $sht(b=>from) = $fu;<br> $sht(b=>oldto) = $tu;<br> $avp(new_to) = "<" + $sht(b=>oldto) + ">" + ";messagetype=SMS";<br> xlog("L_INFO", "MESSAGE: B2BUA send --> [$rs] with [$rr] from [$sht(b=>from)] to [$sht(b=>oldto)] -->[$td]\n");<br> }<br><br> if(compare_ips("$td", "10.18.130.27")) {<br> xlog("L_INFO", "Message from B2BUA contain domain --> $td user --> $(sht(b=>oldto){uri.user}) updating...\n");<br> sql_pvquery("cb", "select contact from location where username = '$(sht(b=>oldto){uri.user})'","$avp(dst)");<br> #$avp(new_dst) = $(hdr(Route){param.value,received});<br> xlog("L_INFO", "New destination --> $avp(dst)\n");<br> $avp(new_to) = "<" + $(avp(dst){tobody.uri}) + ">" + ";messagetype=SMS";<br> }<br><br> if(fnmatch("$fU", "offline")) {<br> xlog("L_INFO", "OFFLINE SMS: from [$fU] user --> $fU\n");<br> $avp(from) = $(sht(b=>oldto){uri.user});<br> xlog("L_INFO", "OFFLINE SMS: Searching destination user $avp(oexten)\n");<br> sql_pvquery("cb", "select contact from location where username = '$avp(from)'","$avp(dst)");<br> xlog("L_INFO", "OFFLINE SMS: set new destination --> $avp(dst)\n");<br> $avp(new_to) = "<" + $(avp(dst){tobody.uri}) + ">" + ";messagetype=SMS";<br> }<br><br> xlog("L_INFO", "OFFLINE SMS: new AVP DST $avp(new_to)\n"); <br> $sht(a=>to) = $avp(new_to);<br> remove_hf("To");<br> insert_hf("To: $sht(a=>to)\r\n", "To");<br> $du = $sht(a=>to);<br> xlog("SMS from --> $fU domain $fd\n");<br> xlog("-------------------------------------\n");<br> xlog("L_INFO", "FROM --> $avp(from)\n");<br> xlog("L_INFO", "OLD_TO --> $sht(b=>oldto)\n");<br> xlog("L_INFO", "NEW_TO --> $avp(new_to)\n");<br><br>}<br></div><br><br><div>Slava.</div><br><hr id="zwchr"><div><b>From: </b>"Daniel-Constantin Mierla" <miconda@gmail.com><br><b>To: </b>"volga629" <volga629@skillsearch.ca>, "sr-users" <sr-users@lists.sip-router.org><br><b>Sent: </b>Thursday, 17 November, 2016 05:44:22<br><b>Subject: </b>Re: [SR-Users] msilo<br></div><br><div><p>Hello,</p><p>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...</p><p>Cheers,<br> Daniel<br></p><br><div class="moz-cite-prefix">On 16/11/16 16:08, Slava Bendersky wrote:<br></div><blockquote cite="mid:951494804.23187171.1479308892252.JavaMail.zimbra@skillsearch.ca"><div style="font-family: lucida console,sans-serif; font-size:
12pt; color: #000000" data-mce-style="font-family: lucida console,sans-serif; font-size:
12pt; color: #000000"><div>Hello Daniel,</div><div>Yes that good alternative. I will use sql to fetch or insert staff.</div><br><br><div>Slava</div><br><hr id="zwchr"><div><b>From: </b>"Daniel-Constantin Mierla" <a class="moz-txt-link-rfc2396E" href="mailto:miconda@gmail.com" target="_blank"><miconda@gmail.com></a><br> <b>To: </b>"sr-users" <a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org" target="_blank"><sr-users@lists.sip-router.org></a><br> <b>Sent: </b>Wednesday, 16 November, 2016 04:37:24<br> <b>Subject: </b>Re: [SR-Users] msilo<br></div><br><div><p>Hello,</p><p>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.</p><p>Cheers,<br> Daniel<br></p><br><div class="moz-cite-prefix">On 15/11/16 16:07, Federico Cabiddu wrote:<br></div><blockquote cite="mid:CAFOaF_jn7W6B2SiabCZPdu5BKWk+jb_Fs+vi2=4J31Geq6giCQ@mail.gmail.com"><p dir="ltr">Hi Slava,<br> if I understand correctly your scenario,<br> 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.<br> Hope this helps.</p><p dir="ltr">Cheers,</p><p dir="ltr">Federico</p><div class="gmail_extra"><br><div class="gmail_quote">On 15 Nov 2016 3:47 pm, "Slava Bendersky" <<a href="mailto:volga629@skillsearch.ca" target="_blank">volga629@skillsearch.ca</a>> wrote:<br><blockquote class="quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex" data-mce-style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:lucida
console,sans-serif;font-size:12pt;color:#000000" data-mce-style="font-family:lucida
console,sans-serif;font-size:12pt;color:#000000"><div>Hello Daniel,</div><div>I am not programmer, but I want place request if kaamilio devs can complete it .</div><div>Thanks</div><br><br><div>Slava.</div><br><hr id="m_-2503472498804380182zwchr"><div><b>From: </b>"Daniel-Constantin Mierla" <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>><br> <b>To: </b>"sr-users" <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>><br> <b>Sent: </b>Tuesday, 15 November, 2016 03:00:19<br> <b>Subject: </b>Re: [SR-Users] msilo<br></div><div class="elided-text"><br><div><p>Hello,</p><p>for me it is fine to add a new parameter to m_store() that takes the body content.</p><p>Are you asking for more details of how can be done?<br></p>Cheers,<br> Daniel<br> <br><div class="m_-2503472498804380182moz-cite-prefix">On 13/11/16 07:08, Slava Bendersky wrote:<br></div><blockquote><div style="font-family:lucida
console,sans-serif;font-size:12pt;color:#000000" data-mce-style="font-family:lucida
console,sans-serif;font-size:12pt;color:#000000"><div>Hello Everyone,</div><div>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)). </div><br><div>Any help thank you.</div><br><div>Slava.</div></div><br><fieldset class="m_-2503472498804380182mimeAttachmentHeader"></fieldset><br><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="m_-2503472498804380182moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a class="m_-2503472498804380182moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre></blockquote><pre class="m_-2503472498804380182moz-signature">--
Daniel-Constantin Mierla
<a class="m_-2503472498804380182moz-txt-link-freetext" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="m_-2503472498804380182moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a class="m_-2503472498804380182moz-txt-link-freetext" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre>_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></div></div></div></div>_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></blockquote></div></div></blockquote><pre class="moz-signature">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a class="moz-txt-link-freetext" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre><br> _______________________________________________<br> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br> <a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br> <a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br></div></div></blockquote><br><pre class="moz-signature">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - <a class="moz-txt-link-freetext" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre></div></div></div></div><br></div></div></body></html>