<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <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"
      type="cite">
      <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" <a class="moz-txt-link-rfc2396E" href="mailto:miconda@gmail.com"><miconda@gmail.com></a><br>
          <b>To: </b>"sr-users" <a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org"><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 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 moz-do-not-send="true"
                  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
                          moz-do-not-send="true"
                          href="mailto:miconda@gmail.com"
                          target="_blank">miconda@gmail.com</a>><br>
                        <b>To: </b>"sr-users" <<a
                          moz-do-not-send="true"
                          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 moz-do-not-send="true" class="m_-2503472498804380182moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" class="m_-2503472498804380182moz-txt-link-freetext" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true"
                            href="mailto:sr-users@lists.sip-router.org"
                            target="_blank">sr-users@lists.sip-router.org</a>
                          <a moz-do-not-send="true"
                            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 moz-do-not-send="true"
                    href="mailto:sr-users@lists.sip-router.org"
                    target="_blank">sr-users@lists.sip-router.org</a>
                  <a moz-do-not-send="true"
                    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 moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" 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 moz-do-not-send="true" 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">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">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
        </div>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">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">http://www.asipto.com</a></pre>
  </body>
</html>