<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Joining the development efforts and taking over the maintenance
      of db_perlvdb is more than welcome and appreciated!</p>
    <p>As for this specific case, do you need to fetch data from Elastic
      that has to be used inside Kamailio (e.g., passwords for
      authentication), or just push data from Kamailio to Elastic stack?
      Maybe giving some specific example of what you need to pass from
      kamailio To elastic and the other way around would help us provide
      better hints about what can be used.</p>
    <p>Cheers,<br>
      Daniel<br>
    </p>
    <br>
    <div class="moz-cite-prefix">On 05.05.18 09:54, M S wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAFZQphxWMkTEfXoBqr0K2TxFXOrPLA_kgB=T4hQwzxS-2gumHA@mail.gmail.com">
      <div dir="ltr">Thank you very much for you help.
        <div><br>
        </div>
        <div>Actually I need to support Elastic Search Engine (ESE) for
          a large data mining project integrated with Kamailio. The
          easiest way i thought to achieve that was to use Perl VDB or
          else i have to write up ESE module for kamailio myself.</div>
        <div><br>
        </div>
        <div>I am going to test the changes you did to PERL VDB module
          and will fix up any minor issues to make it working again.
          Kindly do not remove it from kamailio repo. I am not expert in
          Kamailio APIs but have good coding experience with C / C++, so
          I am willing to provide maintenance and bug fixes for the
          module with your help on API side if needed.</div>
        <div><br>
        </div>
        <div>Also, the new DB API for Kamailio, is there any
          documentation related to it available online. I want to study
          it and may be add later on a separate kamailio module
          exclusively for ESE for better performance and features
          specific to ESE.</div>
        <div><br>
        </div>
        <div>Thank you.</div>
        <div><br>
        </div>
        <div><br>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Sat, May 5, 2018 at 9:27 AM,
          Daniel-Constantin Mierla <span dir="ltr"><<a
              href="mailto:miconda@gmail.com" target="_blank"
              moz-do-not-send="true">miconda@gmail.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF">
              <p>Hello,</p>
              <p>quite a surprise that someone is trying to use this
                module, I was considering to move it to obsolete repo,
                because nobody used it for so long and no developer
                updated it over the time.</p>
              <p>The module was still compiling due to some casts, but
                the DB API was changed in the past and this module was
                left behind.</p>
              <p>I did the update of the API (still some warnings that
                needs to be taken care), so you can try now with master
                branch. Maybe it goes on pretty well.<br>
              </p>
              <p>Otherwise I do not have to test or maintain the module,
                if you want to use it, you have to spend some time with
                it. I can help fixing bugs when they are obvious in the
                C code (like API changes) or a proper report is filled,
                but that's all I can do.<br>
              </p>
              Cheers,<br>
              Daniel
              <div>
                <div class="h5"><br>
                  <br>
                  <div class="m_-7132219572948909404moz-cite-prefix">On
                    04.05.18 23:37, M S wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <div dir="ltr">Hi,
                      <div><br>
                      </div>
                      <div>Seems there are some serious problems with
                        db_perlvdb. It gives segmentation fault as soon
                        as i set it as db url for any module e.g. acc,
                        sip_trace, msilo and so on.</div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                      <div>Here is back-trace of core dump,</div>
                      <div><br>
                      </div>
                      <div>--</div>
                      <div>
                        <div>#0  0xb57653dd in parseurl (url=0xaf41ba5c
                          "\340\352\245\266\062") at perlvdbfunc.c:60</div>
                        <div>        cn = 0x1 <Address 0x1 out of
                          bounds></div>
                        <div>#1  0xb5765af6 in perlvdb_db_init
                          (url=0xaf41ba5c "\340\352\245\266\062") at
                          perlvdbfunc.c:123</div>
                        <div>        res = 0x5</div>
                        <div>        cn = 0xaf539cdb "\270"</div>
                        <div>        obj = 0x0</div>
                        <div>        consize = 32</div>
                        <div>        __FUNCTION__ = "perlvdb_db_init"</div>
                        <div>#2  0xaf3f81c2 in mod_init () at
                          msilo.c:335</div>
                        <div>        avp_spec = {type = PVT_AVP, getf =
                          0xb5f86c50 <pv_get_avp>, setf =
                          0xb5f8a8a2 <pv_set_avp>, pvp = {pvn =
                          {type = 0, nfree = 0, u = {</div>
                        <div>                isname = {type = 1, name =
                          {n = -1230637607, s = {s = 0xb6a5f5d9
                          "msilo_extra_hdrs)", len = 16}, re =
                          0xb6a5f5d9}}, </div>
                        <div>                dname = 0x1}}, pvi = {type
                          = 0, u = {ival = 0, dval = 0x0}}}, trans =
                          0x0}</div>
                        <div>        __FUNCTION__ = "mod_init"</div>
                        <div>#3  0x081e6b7c in init_mod (m=0xb6a4d9b0)
                          at core/sr_module.c:972</div>
                        <div>        __FUNCTION__ = "init_mod"</div>
                        <div>#4  0x081e6e82 in init_modules () at
                          core/sr_module.c:1001</div>
                        <div>        t = 0x544c1e2c</div>
                        <div>        i = -1</div>
                        <div>        __FUNCTION__ = "init_modules"</div>
                      </div>
                      <div>--</div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                      <div>Thank you.</div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                    </div>
                    <div class="gmail_extra"><br>
                      <div class="gmail_quote">On Fri, May 4, 2018 at
                        7:29 PM, M S <span dir="ltr"><<a
                            href="mailto:shaheryarkh@gmail.com"
                            target="_blank" moz-do-not-send="true">shaheryarkh@gmail.com</a>></span>
                        wrote:<br>
                        <blockquote class="gmail_quote" style="margin:0
                          0 0 .8ex;border-left:1px #ccc
                          solid;padding-left:1ex">
                          <div dir="ltr">
                            <div>Hi,<br>
                              <br>
                            </div>
                            <div>I am trying to load db_perlvdb.so
                              module using latest Kamailio branch v5.0.6
                              with git revision
                              49bd81ad7856dac9b2efd53597fb1c<wbr>182de7440b
                              on Debian Wheezy 32bit. The compilation
                              and installation went successful however
                              the module gives following error.<br>
                              <br>
                              --<br>
                              May  4 19:03:59 webrtc[8895]: INFO:
                              app_perl [app_perl_mod.c:351]: mod_init():
                              perl interpreter has been initialized
                              (1525453439.237584 =>
                              1525453439.454432) <br>
                              May  4 19:03:59 webrtc[8895]: CRITICAL:
                              db_perlvdb [db_perlvdb.c:79]: mod_init():
                              perl module not loaded. Exiting. <br>
                              May  4 19:03:59 webrtc[8895]: ERROR:
                              <core> [core/sr_module.c:970]:
                              init_mod(): Error while initializing
                              module db_perlvdb
                              (/usr/local/adx-webrtc/lib/kam<wbr>ailio/modules/db_perlvdb.so)
                              <br>
                              --<br>
                              <br>
                            </div>
                            <div><br>
                              I tried to find module perl.so in modules
                              folder of kamailio installation but there
                              is none. Then i looked through the source
                              code but no success.<br>
                              <br>
                            </div>
                            <div>After some googling, i found following
                              link which states that perl.so was
                              remained to app_perl.so since v4.x.<br>
                              <br>
                            </div>
                            <div>I have created a small patch for
                              db_perlvdb.c which corrects this error.<br>
                              <br>
                              <br>
                              --<br>
                              diff --git a/src/modules/db_perlvdb/db_pe<wbr>rlvdb.c
                              b/src/modules/db_perlvdb/db_pe<wbr>rlvdb.c<br>
                              index 7a2b63e..266ece2 100644<br>
                              --- a/src/modules/db_perlvdb/db_pe<wbr>rlvdb.c<br>
                              +++ b/src/modules/db_perlvdb/db_pe<wbr>rlvdb.c<br>
                              @@ -75,8 +75,8 @@ struct module_exports
                              exports = {<br>
                               <br>
                               static int mod_init(void)<br>
                               {<br>
                              -    if (!module_loaded("perl")) {<br>
                              -        LM_CRIT("perl module not loaded.
                              Exiting.\n");<br>
                              +    if (!module_loaded("app_perl")) {<br>
                              +        LM_CRIT("app_perl module not
                              loaded. Exiting.\n");<br>
                                       return -1;<br>
                                   }<span
                                class="m_-7132219572948909404HOEnZb"><font
                                  color="#888888"><br>
                                  -- <br>
                                  <br>
                                  <br>
                                </font></span></div>
                            <span class="m_-7132219572948909404HOEnZb"><font
                                color="#888888">
                                <div>Kindly update Kamailio master and
                                  branch trunks.<br>
                                  <br>
                                  <br>
                                </div>
                                <div>Thank you.<br>
                                  <br>
                                  <br>
                                </div>
                              </font></span></div>
                        </blockquote>
                      </div>
                      <br>
                    </div>
                    <br>
                    <fieldset
                      class="m_-7132219572948909404mimeAttachmentHeader"></fieldset>
                    <br>
                  </div>
                </div>
                <pre>______________________________<wbr>_________________
Kamailio (SER) - Development Mailing List
<a class="m_-7132219572948909404moz-txt-link-abbreviated" href="mailto:sr-dev@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-dev@lists.kamailio.org</a>
<a class="m_-7132219572948909404moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>dev</a><span class="HOEnZb"><font color="#888888">
</font></span></pre>
                <span class="HOEnZb"><font color="#888888"> </font></span></blockquote>
              <span class="HOEnZb"><font color="#888888"> <br>
                  <pre class="m_-7132219572948909404moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="m_-7132219572948909404moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a class="m_-7132219572948909404moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a>
Kamailio World Conference - May 14-16, 2018 - <a class="m_-7132219572948909404moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank" moz-do-not-send="true">www.kamailioworld.com</a></pre>
                </font></span></div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio World Conference - May 14-16, 2018 - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
  </body>
</html>