[SR-Users] db_mode 3 in usrloc module

[Daniel-Constantin Mierla]

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 at gmail.com <mailto:miconda at 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 at misak.dk
>>     <mailto:misak at 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 at lists.sip-router.org  <mailto:sr-users at 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://twitter.com/#%21/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 at lists.sip-router.org <mailto:sr-users at 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 at 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 -

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130327/8a59f0a7/attachment-0001.htm>