<html><head></head><body><div class="ydp91e4ecfbyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div>Hello Joel,<br><div><br><div>my use case will be:<br><ul><li>We use two Kamailio instances (A and B)<br></li><li>A Client registers to a Kamailio A using TLS (SIP over TLS). The TLS session data shall be stored into an external DB.</li><li>Kamailio A is now unreachable.</li><li>The client sends a register to Kamailio B over TLS.</li><li>Kamailio B shall look into the external DB and checks that there is already a TLS session data and can reuse it.<br></li></ul></div></div></div><div></div>
<div><br></div><div>Best regards,<br>Toffi<br></div>
</div><div id="yahoo_quoted_1916500422" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Am Mittwoch, 31. Oktober 2018, 18:03:48 MEZ hat Joel Serrano <joel@textplus.com> Folgendes geschrieben:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv5726016878"><div><div dir="ltr">I'm not sure how to answer correctly that question as it depends completely on what you are trying to accomplish.<div><br clear="none"></div><div>Say you get to save the TLS connection information in a database, how would that be helpful?</div></div><br clear="none"><div class="yiv5726016878gmail_quote"><div class="yiv5726016878yqt9906552331" id="yiv5726016878yqt48270"><div dir="ltr">On Wed, Oct 31, 2018 at 7:08 AM Toffi Bossol <<a rel="nofollow" shape="rect" ymailto="mailto:toffi.bossol@yahoo.com" target="_blank" href="mailto:toffi.bossol@yahoo.com">toffi.bossol@yahoo.com</a>> wrote:<br clear="none"></div><blockquote class="yiv5726016878gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div class="yiv5726016878m_-3593028380698319216ydp598ad99cyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><span>
</span><div><span></span><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>Hello Joel,<br clear="none"></span></p><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>many
thanks for your reply.</span></p></div><span>
</span><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>Background info: I
am trying to implement Kamailio as stateless as possible and wonder how I can
cache and reuse the information from a TLS connection within a database.</span></p>
<p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span> </span></p>
<div><span></span><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>And does caching
make sense?</span></p><div><span></span><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>Best regards,</span></p><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span>Toffi<br clear="none"></span></p></div><div><span></span><p class="yiv5726016878m_-3593028380698319216ydpc65e2aafMsoNormal"><span></span></p></div></div><span>
</span><br clear="none"><span></span><p class="yiv5726016878m_-3593028380698319216ydp5b0025f6MsoNormal"><i><span lang="DE"></span></i><span lang="DE"></span></p><div><div><span>
</span><br clear="none"></div></div></div><div></div>
<div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv5726016878m_-3593028380698319216yahoo_quoted" id="yiv5726016878m_-3593028380698319216yahoo_quoted_1780994533">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Am Mittwoch, 31. Oktober 2018, 02:01:04 MEZ hat Joel Serrano <<a rel="nofollow" shape="rect" ymailto="mailto:joel@textplus.com" target="_blank" href="mailto:joel@textplus.com">joel@textplus.com</a>> Folgendes geschrieben:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv5726016878m_-3593028380698319216yiv1498061141"><div><div dir="ltr"><div dir="ltr"><div dir="ltr">Maybe use a pseudovariable from the TLS module to get the data you want and then use sqlops to insert it to database?<div><br clear="none"></div><div>Have a look: </div><div><br clear="none"></div><div><a rel="nofollow" shape="rect" target="_blank" href="https://www.kamailio.org/wiki/cookbooks/5.1.x/pseudovariables#tls_module_pseudo-variables">https://www.kamailio.org/wiki/cookbooks/5.1.x/pseudovariables#tls_module_pseudo-variables</a></div><div><a rel="nofollow" shape="rect" target="_blank" href="https://kamailio.org/docs/modules/5.1.x/modules/sqlops.html">https://kamailio.org/docs/modules/5.1.x/modules/sqlops.html</a></div><div><br clear="none"></div></div></div></div><br clear="none"><div class="yiv5726016878m_-3593028380698319216yiv1498061141gmail_quote"><div class="yiv5726016878m_-3593028380698319216yiv1498061141yqt6334490993" id="yiv5726016878m_-3593028380698319216yiv1498061141yqt00658"><div dir="ltr">On Tue, Oct 30, 2018 at 8:11 AM Toffi Bossol <<a rel="nofollow" shape="rect" ymailto="mailto:toffi.bossol@yahoo.com" target="_blank" href="mailto:toffi.bossol@yahoo.com">toffi.bossol@yahoo.com</a>> wrote:<br clear="none"></div><blockquote class="yiv5726016878m_-3593028380698319216yiv1498061141gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div class="yiv5726016878m_-3593028380698319216yiv1498061141m_-2718317790736793062ydpb055baffyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">Dear community,<br clear="none"><div><br clear="none"><div>I am new in Kamailio hence the following question:<br clear="none"><div><div>Does any one know how to <span> <span><span><span>tell Kamailio to store the TLS session data in an external DB?</span></span></span></span></div><div><br clear="none"><div>Many Thanks in advance!<br clear="none"><div><br clear="none"><div>BR;<br clear="none">Toffi<br clear="none"></div></div></div></div><span></span><span></span><span></span><span></span><span></span><span></span><span>
</span></div></div></div></div></div>_______________________________________________<br clear="none">
Kamailio (SER) - Users Mailing List<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" target="_blank" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none">
</blockquote></div></div></div></div><div class="yiv5726016878m_-3593028380698319216yqt6334490993" id="yiv5726016878m_-3593028380698319216yqt89042">_______________________________________________<br clear="none">Kamailio (SER) - Users Mailing List<br clear="none"><a rel="nofollow" shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" target="_blank" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none"></div></div>
</div>
</div></div>_______________________________________________<br clear="none">
Kamailio (SER) - Users Mailing List<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" target="_blank" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none">
</blockquote></div></div></div></div><div class="yqt9906552331" id="yqt53610">_______________________________________________<br clear="none">Kamailio (SER) - Users Mailing List<br clear="none"><a shape="rect" ymailto="mailto:sr-users@lists.kamailio.org" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br clear="none"><a shape="rect" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br clear="none"></div></div>
</div>
</div></body></html>