<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <div class="moz-cite-prefix">On 4/2/13 11:34 PM, Morten Isaksen
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAAyFOkFjeipBs33r8dPy39xaaPf1VPCOvbZJs5OzL6hnDeGYiw@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>I have tried backport the usrloc and permissions module
            from 3.1.6 but I get the same error. :(<br>
            <br>
          </div>
          I have just tried to backport commit
          d173cc2dab95dba6ededdaa352bf1e2bde1faa0f (srdb1: keep PID per
          DB connection) and so far it seems to work in the test
          enviroment.<br>
        </div>
      </div>
    </blockquote>
    <br>
    Yes, that is related to the issue. I know there were a series of
    fixes at that time, so it is better to just move to latest stable in
    the series, as it guarantees the compatibility for database
    structure and configuration file.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <blockquote
cite="mid:CAAyFOkFjeipBs33r8dPy39xaaPf1VPCOvbZJs5OzL6hnDeGYiw@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <br>
        </div>
        /Morten<br>
        <div>
          <div>
            <div><br>
              <div>
                <div class="gmail_extra"><br>
                  <br>
                  <div class="gmail_quote">On Wed, Mar 27, 2013 at 2:49
                    PM, Morten Isaksen <span dir="ltr">&lt;<a
                        moz-do-not-send="true"
                        href="mailto:misak@misak.dk" target="_blank">misak@misak.dk</a>&gt;</span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0px
                      0px 0px 0.8ex;border-left:1px solid
                      rgb(204,204,204);padding-left:1ex">
                      <div dir="ltr">
                        <div>I did a diff on the usrloc from version
                          3.1.1 and 3.1.6 and the db handles is the only
                          change.<span class=""><font color="#888888"><br>
                              <br>
                            </font></span></div>
                        <span class=""><font color="#888888">/Morten<br>
                          </font></span></div>
                      <div class="">
                        <div class="h5">
                          <div class="gmail_extra"><br>
                            <br>
                            <div class="gmail_quote">On Wed, Mar 27,
                              2013 at 2:44 PM, Daniel-Constantin Mierla
                              <span dir="ltr">&lt;<a
                                  moz-do-not-send="true"
                                  href="mailto:miconda@gmail.com"
                                  target="_blank">miconda@gmail.com</a>&gt;</span>
                              wrote:<br>
                              <blockquote class="gmail_quote"
                                style="margin:0px 0px 0px
                                0.8ex;border-left:1px solid
                                rgb(204,204,204);padding-left:1ex">
                                <div bgcolor="#FFFFFF" text="#000000">
                                  <div> <br>
                                    <div>On 3/27/13 2:25 PM, Morten
                                      Isaksen wrote:<br>
                                    </div>
                                    <blockquote type="cite">
                                      <div dir="ltr">
                                        <div>
                                          <div>Thanks, Daniel.<br>
                                            <br>
                                          </div>
                                          We have a few custom patches
                                          in this version, so I will try
                                          this patch first, and if it
                                          does not work I will try to
                                          upgrade to 3.1.6.<br>
                                        </div>
                                      </div>
                                    </blockquote>
                                    <br>
                                  </div>
                                  Look at the log in branch 3.1, there
                                  might be other related patches to the
                                  module done before this one.<br>
                                  <br>
                                  Cheers,<br>
                                  Daniel
                                  <div>
                                    <div><br>
                                      <br>
                                      <blockquote type="cite">
                                        <div dir="ltr">
                                          <div><br>
                                          </div>
                                          /Morten<br>
                                        </div>
                                        <div class="gmail_extra"> <br>
                                          <br>
                                          <div class="gmail_quote">On
                                            Wed, Mar 27, 2013 at 1:35
                                            PM, Daniel-Constantin Mierla
                                            <span dir="ltr">&lt;<a
                                                moz-do-not-send="true"
                                                href="mailto:miconda@gmail.com"
                                                target="_blank">miconda@gmail.com</a>&gt;</span>
                                            wrote:<br>
                                            <blockquote
                                              class="gmail_quote"
                                              style="margin:0px 0px 0px
                                              0.8ex;border-left:1px
                                              solid
                                              rgb(204,204,204);padding-left:1ex">
                                              <div bgcolor="#FFFFFF"
                                                text="#000000"> Hello,<br>
                                                <br>
                                                very likely is related
                                                to:<br>
                                                <br>
                                                - <a
                                                  moz-do-not-send="true"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=97f788a3f1e4e993c99fb1225a1fbcbe4ff0ffc8"
                                                  target="_blank">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=97f788a3f1e4e993c99fb1225a1fbcbe4ff0ffc8</a><br>
                                                <br>
                                                You should upgrade to
                                                latest in 3.1.x series,
                                                nothing needs to be
                                                changed in terms of
                                                configuration file or
                                                database. You install
                                                over the latest version
                                                in that branch.<br>
                                                <br>
                                                Not recommended, but
                                                ultimately you can get
                                                only the patch. But if
                                                you apply the patches
                                                for the other fixed
                                                issues in the branch,
                                                you end up in latest
                                                version.<br>
                                                <br>
                                                Cheers,<br>
                                                Daniel
                                                <div>
                                                  <div><br>
                                                    <br>
                                                    <div>On 3/27/13 1:07
                                                      PM, Morten Isaksen
                                                      wrote:<br>
                                                    </div>
                                                  </div>
                                                </div>
                                                <blockquote type="cite">
                                                  <div>
                                                    <div>
                                                      <div dir="ltr">
                                                        <div>
                                                          <div>Hi again,<br>
                                                          <br>
                                                          </div>
                                                          <div>A small
                                                          update.<br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          If I raise
                                                          debug from
                                                          debug=2 to
                                                          debug=3 it
                                                          starts every
                                                          time.<br>
                                                          <br>
                                                        </div>
                                                        And once about
                                                        every 20 times I
                                                        start kamailio
                                                        it also runs
                                                        fine.<br>
                                                      </div>
                                                      <div
                                                        class="gmail_extra"><br>
                                                        <br>
                                                        <div
                                                          class="gmail_quote">On
                                                          Wed, Mar 27,
                                                          2013 at 11:02
                                                          AM, Morten
                                                          Isaksen <span
                                                          dir="ltr">&lt;<a
moz-do-not-send="true" href="mailto:misak@misak.dk" target="_blank">misak@misak.dk</a>&gt;</span>
                                                          wrote:<br>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px
                                                          0px 0px
                                                          0.8ex;border-left:1px
                                                          solid
                                                          rgb(204,204,204);padding-left:1ex">
                                                          <div dir="ltr">
                                                          <div>
                                                          <div>
                                                          <div>
                                                          <div>Hi,<br>
                                                          <br>
                                                          </div>
                                                          I have an
                                                          older
                                                          installation
                                                          of Kamailio
                                                          (3.1.1).<br>
                                                          <br>
                                                          It is
                                                          configured
                                                          with <br>
                                                          <br>
                                                          modparam("usrloc",
                                                          "db_mode", 2)<br>
                                                          <br>
                                                          </div>
                                                          I tried to
                                                          change this to<br>
                                                          <br>
                                                          modparam("usrloc",
                                                          "db_mode", 3)<br>
                                                          <br>
                                                          </div>
                                                          to not have to
                                                          restart
                                                          kamailio when
                                                          I change the
                                                          alias table
                                                          directly from
                                                          SQL.<br>
                                                          <br>
                                                          </div>
                                                          But then
                                                          kamailio
                                                          shutsdown
                                                          after about
                                                          one second
                                                          with this
                                                          error:<br>
                                                          <br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11510]:
                                                          ERROR:
                                                          &lt;core&gt;
                                                          [db.c:408]:
                                                          invalid
                                                          version 0 for
                                                          table trusted
                                                          found,
                                                          expected 5
                                                          (check table
                                                          structure and
                                                          table
                                                          "version")<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11510]:
                                                          ERROR:
                                                          permissions
                                                          [trusted.c:250]:
                                                          error during
                                                          table version
                                                          check.<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11510]:
                                                          ERROR:
                                                          &lt;core&gt;
                                                          [sr_module.c:832]:
                                                          init_mod_child():
                                                          Error while
                                                          initializing
                                                          module
                                                          permissions
                                                          (/usr/local/lib/kamailio/modules_k/permissions.so)<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11510]:
                                                          ERROR:
                                                          &lt;core&gt;
                                                          [pt.c:481]:
                                                          ERROR:
                                                          fork_tcp_process():
                                                          init_child
                                                          failed for
                                                          process 28,
                                                          pid 11510,
                                                          "tcp receiver
                                                          child=6"<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11510]:
                                                          ERROR:
                                                          &lt;core&gt;
                                                          [tcp_main.c:4811]:
                                                          ERROR:
                                                          tcp_main: fork
                                                          failed:
                                                          Success<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11512]:
                                                          : &lt;core&gt;
                                                          [pass_fd.c:293]:
                                                          ERROR:
                                                          receive_fd:
                                                          EOF on 44<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11482]:
                                                          ALERT:
                                                          &lt;core&gt;
                                                          [main.c:738]:
                                                          child process
                                                          11510 exited
                                                          normally,
                                                          status=255<br>
                                                          Mar 26
                                                          20:38:55
                                                          sip-3-1
                                                          /usr/local/sbin/kamailio[11482]:
                                                          INFO:
                                                          &lt;core&gt;
                                                          [main.c:756]:
                                                          INFO:
                                                          terminating
                                                          due to SIGCHLD<br>
                                                          <br
                                                          clear="all">
                                                          <div>
                                                          <div>
                                                          <div>
                                                          <div>
                                                          <div>
                                                          <div>I have
                                                          not made any
                                                          changes to the
                                                          permissions/trusted

                                                          module, so I
                                                          suspect it is
                                                          some shared
                                                          database
                                                          conection
                                                          problem.<br>
                                                          <br>
                                                          <br>
                                                          </div>
                                                          <div>Is it a
                                                          known bug in
                                                          this version?
                                                          I would prefer
                                                          not to upgrade
                                                          the
                                                          installation
                                                          and hopes one
                                                          of you can
                                                          point me to a
                                                          patch I can
                                                          backport.<span><font
color="#888888"><br>
                                                          </font></span></div>
                                                          <span><font
                                                          color="#888888">
                                                          <div><br>
                                                          -- <br>
                                                          Morten Isaksen<br>
                                                          </div>
                                                          </font></span></div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </blockquote>
                                                        </div>
                                                        <br>
                                                        <br clear="all">
                                                        <br>
                                                        -- <br>
                                                        Morten Isaksen<br>
                                                      </div>
                                                      <br>
                                                      <fieldset></fieldset>
                                                      <br>
                                                    </div>
                                                  </div>
                                                  <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><span><font color="#888888">
</font></span></pre>
                                                  <span><font
                                                      color="#888888"> </font></span></blockquote>
                                                <span><font
                                                    color="#888888"> <br>
                                                    <pre cols="72">-- 
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, April 16-17, 2013, Berlin
 - <a moz-do-not-send="true" href="http://conference.kamailio.com" target="_blank">http://conference.kamailio.com</a> -</pre>
                                                  </font></span></div>
                                              <br>
_______________________________________________<br>
                                              SIP Express Router (SER)
                                              and Kamailio (OpenSER) -
                                              sr-users mailing list<br>
                                              <a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
                                              <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><br>
                                              <br>
                                            </blockquote>
                                          </div>
                                          <br>
                                          <br clear="all">
                                          <br>
                                          -- <br>
                                          Morten Isaksen<br>
                                        </div>
                                        <br>
                                        <fieldset></fieldset>
                                        <br>
                                        <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>
</pre>
                                      </blockquote>
                                      <br>
                                      <pre cols="72">-- 
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, April 16-17, 2013, Berlin
 - <a moz-do-not-send="true" href="http://conference.kamailio.com" target="_blank">http://conference.kamailio.com</a> -</pre>
                                    </div>
                                  </div>
                                </div>
                                <br>
_______________________________________________<br>
                                SIP Express Router (SER) and Kamailio
                                (OpenSER) - sr-users mailing list<br>
                                <a moz-do-not-send="true"
                                  href="mailto:sr-users@lists.sip-router.org"
                                  target="_blank">sr-users@lists.sip-router.org</a><br>
                                <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><br>
                                <br>
                              </blockquote>
                            </div>
                            <br>
                            <br clear="all">
                            <br>
                            -- <br>
                            Morten Isaksen<br>
                          </div>
                        </div>
                      </div>
                    </blockquote>
                  </div>
                  <br>
                  <br clear="all">
                  <br>
                  -- <br>
                  Morten Isaksen<br>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<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>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<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 World Conference, April 16-17, 2013, Berlin
 - <a class="moz-txt-link-freetext" href="http://conference.kamailio.com">http://conference.kamailio.com</a> -</pre>
  </body>
</html>