<div dir="ltr"><div>This works for me fine:</div><div><br></div><div><br></div><div>loadmodule "msilo.so"</div><div><br></div><div>modparam("msilo","db_url",DBURL)</div><div>modparam("msilo","from_address","<a href="mailto:sip%3Aregistrar@sip.stribogkonsult.com">sip:registrar@sip.stribogkonsult.com</a>")</div>
<div>modparam("msilo","contact_hdr","Contact: registrar@sip.stribogkonsult.com:5060;msilo=yes\r\n")</div><div>modparam("msilo","content_type_hdr","Content-Type: text/plain\r\n")</div>
<div>modparam("msilo","offline_message","***$rU***$rb***")</div><div>...........</div><div>#storing offline messages</div><div><div>route[MSILO_MESSAGE]{</div><div><span class="" style="white-space:pre"> </span>if (lookup("location")){</div>
<div><span class="" style="white-space:pre"> </span>t_relay();</div><div><span class="" style="white-space:pre"> </span>}else{</div><div><span class="" style="white-space:pre"> </span>m_store("$ru");</div><div>
<span class="" style="white-space:pre"> </span>sl_send_reply("202", "Accepted");</div><div><span class="" style="white-space:pre"> </span>};</div><div><span class="" style="white-space:pre"> </span>exit();</div>
<div>}</div></div><div>#on registrar, check for offline messages and send them</div><div><div>route[REGISTRAR] {</div><div><span class="" style="white-space:pre"> </span>if (is_method("REGISTER"))</div><div><span class="" style="white-space:pre"> </span>{</div>
<div><span class="" style="white-space:pre"> </span>if(isflagset(FLT_NATS))</div><div><span class="" style="white-space:pre"> </span>{</div><div><span class="" style="white-space:pre"> </span>setbflag(FLB_NATB);</div>
<div><span class="" style="white-space:pre"> </span># uncomment next line to do SIP NAT pinging </div><div><span class="" style="white-space:pre"> </span>## setbflag(FLB_NATSIPPING);</div><div><span class="" style="white-space:pre"> </span>}</div>
<div><span class="" style="white-space:pre"> </span>if (!save("location",0x04))</div><div><span class="" style="white-space:pre"> </span>sl_reply_error();</div><div><span class="" style="white-space:pre"> </span># MSILO - dumping user's offline messages</div>
<div><span class="" style="white-space:pre"> </span>m_dump();</div><div><span class="" style="white-space:pre"> </span>exit;</div><div><span class="" style="white-space:pre"> </span>}</div><div>}</div></div><div><br></div>
<div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 20, 2013 at 12:50 PM, <span dir="ltr"><<a href="mailto:sipatse@in.gr" target="_blank">sipatse@in.gr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span style="color:#000000;font-size:16px"><span style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif">Dear All,</span>
</span></p><div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif"><br>
</div>
<div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif">Is there any update regarding the a<span style="font-size:11pt">forementioned issue</span><span style="line-height:22px;font-size:12pt">?</span></div>
<div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif"><span style="line-height:22px;font-size:12pt"><br>
</span></div>
<div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif"><span style="line-height:22px;font-size:12pt">Best regards.</span></div>
<br>
<br>
<br>
<br>
Dear All,<p></p>
<div style="font-size:16px;font-family:calibri,sans-serif"><br style="line-height:22px">
</div>
<div style="font-size:16px;font-family:calibri,sans-serif">We would like to store SIP text Messages when the destination Subscriber is Offline.</div>
<div style="font-size:16px;font-family:calibri,sans-serif">We have insert into kamailio cfg file the configuration lines below.</div>
<div style="font-size:16px;font-family:calibri,sans-serif">Unfortunately storing messages is unsuccessful.</div>
<div style="font-size:16px;font-family:calibri,sans-serif">Any ideas of what missing or what could be wrong?</div>
<div style="font-size:16px;font-family:calibri,sans-serif"><br style="line-height:22px">
</div>
<div style="font-size:16px;font-family:calibri,sans-serif">Best regards.</div>
<div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif"><br>
</div>
<div style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif">************************************************************************************************************</div>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>loadmodule "msilo.so"</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>#!ifdef WITH_MSILO</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo","db_url","mysql://[% kamailio.proxy.dbrwuser %]:[% kamailio.proxy.dbrwpw %]@[% database.dbhost %]/[% kamailio.proxy.dbname %]")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo", "db_table", "silo")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo","from_address","sip:registrar@xxxxxxx.local")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo", "from_address", "sip:$rU@xxxxxxx.local")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo","contact_hdr","Contact: <sip:registrar@xx.xx.xx.xx:5062>;msilo=yes\r\n")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo","content_type_hdr","Content-Type: text/plain\r\n")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("msilo","offline_message","*** User $rU is offline!")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>#!endif</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>modparam("usrloc", "db_mode", 0) initial value was “1”</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>########################################################################</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>#Store messages to offline Subs</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>########################################################################</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>route</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>{</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if ( !mf_process_maxfwd_header("10") )</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> sl_send_reply("483","To Many Hops");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (uri==myself) {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # for testing purposes, simply okay all REGISTERs</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (method=="REGISTER")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> save("location");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("REGISTER received -> dumping messages with MSILO\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # MSILO - dumping user's offline messages</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (m_dump())</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: offline messages dumped - if they were\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> }else{</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: no offline messages dumped\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # domestic SIP destinations are handled using our USRLOC DB</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if(!lookup("location"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (! t_newtran())</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> sl_reply_error();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # we do not care about anything else but MESSAGEs</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (!method=="MESSAGE")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (!t_reply("404", "Not found"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> sl_reply_error();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MESSAGE received -> storing using MSILO\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # MSILO - storing as offline message</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (m_store("$ru"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: offline message stored\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (!t_reply("202", "Accepted"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> sl_reply_error();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> }else{</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: offline message NOT stored\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (!t_reply("503", "Service Unavailable"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> sl_reply_error();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # if the downstream UA does not support MESSAGE requests</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # go to failure_route[1]</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> t_on_failure("1");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> t_relay();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # forward anything else</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> t_relay();</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>}</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>failure_route[1] {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # forwarding failed -- check if the request was a MESSAGE</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (!method=="MESSAGE")</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> exit;</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> </span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log(1,"MSILO:the downstream UA doesn't support MESSAGEs\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> # we have changed the R-URI with the contact address, ignore it now</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> if (m_store("$ou"))</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> {</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: offline message stored\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> t_reply("202", "Accepted");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> }else{</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> log("MSILO: offline message NOT stored\n");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> t_reply("503", "Service Unavailable");</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span> };</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>}</span></p>
<p style="line-height:21px;color:#444444;font-size:15px;font-family:calibri,sans-serif;margin:0px 0px 1.35em"><span>***********************************************************************************************</span></p>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<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><br>
<br></blockquote></div><br></div>