<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="monospace">Hi,<br>
      <br>
      I found the issue and have it fixed in master / 3.2 / 3.1 , see:<br>
      <br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/9bc117953730a0ea761e3ceaeea9fee7facea2cc">https://github.com/OpenSIPS/opensips/commit/9bc117953730a0ea761e3ceaeea9fee7facea2cc</a><br>
      <br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/cc20f738b83f5a9c7f24630309ddb5bab889bf56">https://github.com/OpenSIPS/opensips/commit/cc20f738b83f5a9c7f24630309ddb5bab889bf56</a><br>
      <br>
      Thanks for the report !<br>
    </font>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021 
  <a class="moz-txt-link-freetext" href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/">https://opensips.org/training/OpenSIPS_eBootcamp_2021/</a></pre>
    <div class="moz-cite-prefix">On 10/20/21 3:27 PM, jacky z wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAOB03DuMepK6_MqHjPUD_pjk8FyYYHJuke_qJU4g2j8W2NRh3A@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div dir="ltr">Hi Bogdan_Andrei,
            <div><br>
            </div>
            <div>You are right. The actual content is not attached.
              Attached is the log.</div>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr" class="gmail_attr"><br>
            </div>
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div> <font face="monospace">Hi,<br>
                  <br>
                  So the actual content of the message is not attached
                  to the MSG? Could you send me (maybe off list) the
                  opensips logs (level 4) for a m_dump() ?<br>
                  <br>
                  Best regards,<br>
                </font>
                <pre cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a href="https://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021 
  <a href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/" target="_blank" moz-do-not-send="true">https://opensips.org/training/OpenSIPS_eBootcamp_2021/</a></pre>
                <div>On 10/15/21 11:02 AM, jacky z wrote:<br>
                </div>
                <blockquote type="cite">
                  <div dir="ltr">
                    <div dir="ltr">
                      <div>Hi Bogdan-Andrei,</div>
                      <div><br>
                      </div>
                      <div>Did you also noticed the msilo module still
                        can't send the dumped message, but send
                        "[Offline message - Thu Jan  1 00:00:00 1970" no
                        matter what the message is? or just the setting
                        I used?</div>
                      <br>
                      <div class="gmail_quote">
                        <div dir="ltr" class="gmail_attr"><br>
                        </div>
                        <blockquote class="gmail_quote"
                          style="margin:0px 0px 0px
                          0.8ex;border-left:1px solid
                          rgb(204,204,204);padding-left:1ex">
                          <div> <font face="monospace">:+1:<br>
                              <br>
                              Regards,<br>
                            </font>
                            <pre cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a href="https://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021 
  <a href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/" target="_blank" moz-do-not-send="true">https://opensips.org/training/OpenSIPS_eBootcamp_2021/</a></pre>
                            <div>On 10/14/21 5:03 AM, jacky z wrote:<br>
                            </div>
                            <blockquote type="cite">
                              <div dir="ltr">
                                <div dir="ltr">
                                  <div dir="ltr">
                                    <div dir="ltr">
                                      <div dir="ltr">Hi Bogdan-Andrei,
                                        <div><br>
                                        </div>
                                        <div>Finally made it send
                                          offline message by setting</div>
                                        <div><br>
                                        </div>
                                        <div>modparam("msilo",
                                          "outbound_proxy", <a
                                            moz-do-not-send="true">"sip:name.domain.com:5061;transport=tls"</a>)<br>
                                        </div>
                                        <div>modparam("tls_mgm",
                                          "match_sip_domain", "[dom]*")</div>
                                        <div><br>
                                        </div>
                                        <div>It seems the port number
                                          needs to be included and the
                                          match_sip_domain needs to *.
                                          If the domain name is
                                          included, the error happens.
                                          Hope this info is helpful for
                                          others who may be interested.</div>
                                        <div><br>
                                        </div>
                                        <div>However, it still can't
                                          send the dumped message, but
                                          send "[Offline message - Thu
                                          Jan  1 08:00:00 1970" no
                                          matter what the message is. It
                                          seems the message
                                          was truncated. Based on the
                                          source code of the msilo
                                          module, the message should be
                                          something like  "[Offline
                                          message - Thu Jan  1 08:00:00
                                          1970] message here".</div>
                                        <div><br>
                                        </div>
                                        <div>In the log, I can see the
                                          correct message was read out
                                          from the silo table. Here is
                                          the log that shows the correct
                                          offline message that should be
                                          sent:</div>
                                        <div><br>
                                        </div>
                                        <div>DBG:db_mysql:db_mysql_str2val:
                                          converting BLOB
                                          [{"type":"1","cont":"the right
                                          message"}]<br>
                                        </div>
                                        <div><br>
                                        </div>
                                        <div>Thanks!</div>
                                      </div>
                                      <br>
                                      <div class="gmail_quote">
                                        <div dir="ltr"
                                          class="gmail_attr"><br>
                                        </div>
                                        <blockquote class="gmail_quote"
                                          style="margin:0px 0px 0px
                                          0.8ex;border-left:1px solid
                                          rgb(204,204,204);padding-left:1ex">
                                          <div> <font face="monospace">Hi
                                              Jacky,<br>
                                              <br>
                                              The m_dump() sends the
                                              MESSAGE to the AOR of the
                                              user, so, ideally, you
                                              should do take care of the
                                              "lookup(location)" in
                                              order to the get it
                                              properly routed.<br>
                                              <br>
                                              For the TLS part, do you
                                              use it between the
                                              end-point and opensips? if
                                              so, I guess the MESSAGE
                                              sent by m_dump() and
                                              looping back to opensips
                                              (for doing the
                                              lookup(location)) is via
                                              UDP ?<br>
                                              <br>
                                              I'm asking as from the TLS
                                              perspective the most
                                              important think to know is
                                              where (in the  routing
                                              logic) the TLS connection
                                              gets used/opened, as you
                                              need to be sure and
                                              correlate the destination
                                              IP (at the moment) with
                                              the IPs/mask you have in
                                              the TLS client domain.<br>
                                              <br>
                                              Best regards,<br>
                                            </font>
                                            <pre cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a href="https://www.opensips-solutions.com" target="_blank" moz-do-not-send="true">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021 
  <a href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/" target="_blank" moz-do-not-send="true">https://opensips.org/training/OpenSIPS_eBootcamp_2021/</a></pre>
                                            <div>On 9/28/21 3:03 AM,
                                              jacky z wrote:<br>
                                            </div>
                                            <blockquote type="cite">
                                              <div dir="ltr">
                                                <div dir="ltr">
                                                  <div dir="ltr">
                                                    <div dir="ltr">
                                                      <div dir="ltr">Hi
                                                        Team,
                                                        <div><br>
                                                        </div>
                                                        <div>I want to
                                                          use MSILO to
                                                          forward
                                                          offline
                                                          messages. I
                                                          use TLS
                                                          connections
                                                          and have set
                                                          up both server
                                                          domain and
                                                          client
                                                          domains. If we
                                                          don't
                                                          use outbound_proxy,
                                                          the logs show
                                                          no error, but
                                                          the message
                                                          just was not
                                                          sent. I
                                                          searched
                                                          online and it
                                                          was said that
                                                          the outbound
                                                          proxy needs to
                                                          be used.
                                                          However, if we
                                                          use
                                                          outbound_proxy,
                                                          there will be
                                                          errors- <span>no
                                                          TLS client
                                                          domain found</span>.
                                                          Actually, I
                                                          have set up
                                                          the client
                                                          domain. It
                                                          seems
                                                          the MSILO
                                                          module can't
                                                          recognize the
                                                          client domain.
                                                          I have checked
                                                          the messages
                                                          were all in
                                                          the database
                                                          table silo.
                                                          Have you ever
                                                          encountered
                                                          such issues?
                                                          Any clue to
                                                          debug? Thanks!</div>
                                                        <div><br>
                                                        </div>
                                                        <div>Here are
                                                          the scripts
                                                          and logs</div>
                                                        <div><br>
                                                        </div>
                                                        <div>
                                                          <p>When
                                                          m_dump() is
                                                          called in
                                                          "REGISTER":</p>
                                                          <div>
                                                          <pre style="white-space:pre-wrap;box-sizing:border-box;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;font-size:11.9px;margin-top:0px;margin-bottom:16px;padding:16px;overflow:auto;line-height:1.45;border-radius:6px"><code style="box-sizing:border-box;font-family:ui-monospace,SFMono-Regular,"SF Mono",Menlo,Consolas,"Liberation Mono",monospace;padding:0px;margin:0px;background:transparent;border-radius:6px;word-break:normal;border:0px;display:inline;overflow:visible;line-height:inherit">              if (m_dump()) {
                xlog("MSILO: offline messages dumped - if they were");
                }else{
                xlog("MSILO: no offline messages dumped");
                }; 
</code></pre>
                                                          </div>
                                                          <p>It can dump
                                                          the message
                                                          from the
                                                          database but
                                                          can't send the
                                                          message. Here
                                                          is the log:</p>
                                                          <p>Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_msg: method:<br style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_msg: uri: <a moz-do-not-send="true">sip:10000@xxx.com:5061;transport=tls</a><br
style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_msg: version: <SIP/2.0><br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_headers: flags=ffffffffffffffff<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_via_param: found param type 232, =
                                                          <z9hG4bKe0c6.787dad54.0>;
                                                          state=16<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_via: end of header reached, state=5<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_headers: via found, flags=ffffffffffffffff<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_headers: this is the first via<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_to_param: transport=tls<br style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:_parse_to: end of header reached, state=29<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:_parse_to: display={}, ruri={sip:<a href="mailto:10000@xxx.com"
style="box-sizing:border-box;background-color:transparent;text-decoration-line:none"
target="_blank" moz-do-not-send="true">10000@xxx.com</a>:5061}<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:get_hdr_field: [50]; uri=[sip:<a href="mailto:10000@xxx.com"
style="box-sizing:border-box;background-color:transparent;text-decoration-line:none"
target="_blank" moz-do-not-send="true">10000@xxx.com</a>:5061]<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:get_hdr_field: to body [sip:<a href="mailto:10000@xxx.com"
style="box-sizing:border-box;background-color:transparent;text-decoration-line:none"
target="_blank" moz-do-not-send="true">10000@xxx.com</a>:5061]<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:get_hdr_field: cseq : <10><br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:get_hdr_field: content_length=78<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:get_hdr_field: found end of header<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_headers: flags=ffffffffffffffff<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:parse_headers: flags=78<br style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:proto_tls:proto_tls_send: no open tcp connection found, opening new
                                                          one<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:probe_max_sock_buff: getsockopt: snd is initially 16384<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:probe_max_sock_buff: using snd buffer of 416 kb<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:init_sock_keepalive: TCP keepalive enabled on socket 119<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:print_ip: tcpconn_new: new tcp connection to: <a
                                                          href="http://142.107.16.203:5061/"
target="_blank" moz-do-not-send="true">142.107.16.203</a><br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:tcpconn_new: on port 5061, proto 3<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:proto_tls:tls_conn_init: Creating a whole new ssl connection<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
ERROR:proto_tls:tls_conn_init: no TLS client domain found<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
ERROR:core:tcp_conn_new: failed to do proto 3 specific init for conn
                                                          0x7f0559e116b8<br
style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
DBG:core:tcpconn_destroy: destroying connection 0x7f0559e116b8, flags
                                                          0018<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
ERROR:proto_tls:tls_sync_connect: tcp_conn_create failed, closing the
                                                          socket<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
ERROR:proto_tls:proto_tls_send: connect failed<br
                                                          style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
                                                          ERROR<span>™️</span>msg_send:
                                                          send() to <a
                                                          href="http://142.107.16.203:5061/"
target="_blank" moz-do-not-send="true">142.107.16.203:5061</a> for proto
                                                          tls/3 failed<br
style="box-sizing:border-box">
                                                          Sep 18
                                                          17:29:55
                                                          sipserver
                                                          /usr/sbin/opensips[9794]:
                                                          ERROR<span>™️</span>t_uac:
                                                          attempt to
                                                          send to 'sip:<a
href="mailto:10000@xxx.com"
style="box-sizing:border-box;background-color:transparent;text-decoration-line:none"
target="_blank" moz-do-not-send="true">10000@xxx.com</a>:5061;transport=tls'
                                                          failed</p>
                                                        </div>
                                                      </div>
                                                    </div>
                                                  </div>
                                                </div>
                                              </div>
                                              <br>
                                              <fieldset></fieldset>
                                              <pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank" moz-do-not-send="true">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
                                            </blockquote>
                                            <br>
                                          </div>
                                        </blockquote>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </blockquote>
                            <br>
                          </div>
                        </blockquote>
                      </div>
                    </div>
                  </div>
                </blockquote>
                <br>
              </div>
            </blockquote>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>