<html><body><div 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><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Slava</div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"Daniel-Constantin Mierla" <miconda@gmail.com><br><b>To: </b>"sr-users" <sr-users@lists.sip-router.org><br><b>Sent: </b>Wednesday, 16 November, 2016 04:37:24<br><b>Subject: </b>Re: [SR-Users] msilo<br></div><br><div data-marker="__QUOTED_TEXT__"><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">
<div>
<div 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>
<div><br>
</div>
<div><br>
</div>
<div>Slava.</div>
<div><br>
</div>
<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">
<div><br>
</div>
<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">
<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>
<div><br>
</div>
<div>Any help thank you.</div>
<div><br>
</div>
<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/#!/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>sr-users@lists.sip-router.org<br>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br></div></div></body></html>