I did a diff on the usrloc from version 3.1.1 and 3.1.6 and the db handles is the only change.

/Morten

On Wed, Mar 27, 2013 at 2:44 PM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

On 3/27/13 2:25 PM, Morten Isaksen wrote:

Thanks, Daniel.

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.

Look at the log in branch 3.1, there might be other related patches to the module done before this one.

Cheers,
Daniel

/Morten

On Wed, Mar 27, 2013 at 1:35 PM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

very likely is related to:

- http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=97f788a3f1e4e993c99fb1225a1fbcbe4ff0ffc8

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.

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.

Cheers,
Daniel

On 3/27/13 1:07 PM, Morten Isaksen wrote:

Hi again,

A small update.

If I raise debug from debug=2 to debug=3 it starts every time.

And once about every 20 times I start kamailio it also runs fine.

On Wed, Mar 27, 2013 at 11:02 AM, Morten Isaksen <misak@misak.dk> wrote:

Hi,

I have an older installation of Kamailio (3.1.1).

It is configured with

modparam("usrloc", "db_mode", 2)

I tried to change this to

modparam("usrloc", "db_mode", 3)

to not have to restart kamailio when I change the alias table directly from SQL.

But then kamailio shutsdown after about one second with this error:

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")
Mar 26 20:38:55 sip-3-1 /usr/local/sbin/kamailio[11510]: ERROR: permissions [trusted.c:250]: error during table version check.
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)
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"
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
Mar 26 20:38:55 sip-3-1 /usr/local/sbin/kamailio[11512]: : <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 44
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
Mar 26 20:38:55 sip-3-1 /usr/local/sbin/kamailio[11482]: INFO: <core> [main.c:756]: INFO: terminating due to SIGCHLD

I have not made any changes to the permissions/trusted module, so I suspect it is some shared database conection problem.

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.

--
Morten Isaksen

--
Morten Isaksen

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
 - http://conference.kamailio.com -

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--
Morten Isaksen

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
 - http://conference.kamailio.com -

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--
Morten Isaksen