<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>
<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"><<a href="mailto:misak@misak.dk" target="_blank">misak@misak.dk</a>></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"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></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"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></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 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"><<a href="mailto:misak@misak.dk" target="_blank">misak@misak.dk</a>></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:
<core> [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:
<core> [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:
<core> [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:
<core> [tcp_main.c:4811]: ERROR:
tcp_main: fork failed: Success<br>
Mar 26 20:38:55 sip-3-1
/usr/local/sbin/kamailio[11512]: :
<core> [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:
<core> [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:
<core> [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 href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<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><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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 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 href="mailto:sr-users@lists.sip-router.org" target="_blank">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>
<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 href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<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>
</pre>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 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 href="mailto:sr-users@lists.sip-router.org" target="_blank">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><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>