[SR-Users] Intermittent start up issue

[Ali Jawad]

When it fails I see the same errors yes. Thanks !

On Mon, Jan 2, 2012 at 7:31 AM, Sammy Govind <govoiper at gmail.com> wrote:
> Hi,
> Its all upto you then, that's an intermittent issue and information is not
> complete to trace the issue. Did you see the same Errors every time it fails
> !?
>
> --
> Regards
> Sammy
>
>
> On Sun, Jan 1, 2012 at 10:06 PM, Ali Jawad <ali.jawad at splendor.net> wrote:
>>
>> Hi
>> Thanks for your input, but as said this works at times yes and times
>> now so I am not sure it is a definite DB issue, the servers are in the
>> same LAN, and there are other modules that use the DB string that work
>> when launched before this one while this one does not work.
>> Regards
>>
>> On Sun, Jan 1, 2012 at 4:13 PM, Sammy Govind <govoiper at gmail.com> wrote:
>> > Hi,
>> > forget the whole list of errors and just resolve the DB connectivity
>> > between
>> > the Kamailio server and DB server first .
>> >
>> >> 27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't
>> >> connect to MySQL server on 'xxxxxxxxx' (4)
>> >
>> >
>> > try connecting to the remote DB server 'xxxxxxxxx' from linux shell i.e
>> >
>> > # mysql -u<user> -p<passwd> -h 'xxxxxxxxx'
>> >
>> > Regards,
>> > Sammy
>> >
>> >
>> > On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad <ali.jawad at splendor.net>
>> > wrote:
>> >>
>> >> Hi All
>> >> I have tried the below with Kamailio 3.1.0 and 3.2.1. the problem is
>> >> that Kamailio at times fails to start up for no obvious reasons, I.e.
>> >> in 10 restarts Kamailio might fail to start 3,0 or 5 times. Te debug
>> >> log "level 2 " shows the following :
>> >>
>> >> 27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't
>> >> connect to MySQL server on 'xxxxxxxxx' (4)
>> >> 27(24762) ERROR: <core> [db.c:303]: could not add connection to the
>> >> pool27(24762) ERROR: group [group.c:211]: unable to connect to the
>> >> database
>> >> 27(24762) ERROR: <core> [sr_module.c:889]: init_mod_child(): Error
>> >> while initializing module group
>> >> (/usr/local/kamailio/lib/kamailio/modules_k/group.so)
>> >> 27(24762) ERROR: <core> [pt.c:481]: ERROR: fork_tcp_process():
>> >> init_child failed for process 27, pid 24762, "tcp receiver child=1"
>> >>
>> >> and then
>> >>
>> >>
>> >> 30(24765) : <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 45
>> >>  0(24735) ALERT: <core> [main.c:748]: child process 24762 exited
>> >> normally, status=255
>> >>  0(24735) INFO: <core> [main.c:766]: INFO: terminating due to SIGCHLD
>> >>
>> >> The problem happens on 4 different servers, I did try to compile more
>> >> than once, the servers are 32 Bit CentOS 5.6. The connection to the
>> >> database is monitored and there are no issues with connecting to the
>> >> DB "it works at times and times not for Kamailio so a user/pwd issue
>> >> is not likely to cause this, manual cnnect worked", config file errors
>> >> are not found.
>> >>
>> >> I did also check max no of connections on MySQL server which is set to
>> >> 500 on the server and only 100 cons are used. The group module uses
>> >> the same connection string as other modules  which is predefined  and
>> >> there are other modules that access the db before the group module and
>> >> those do not have a problem.
>> >>
>> >> Please advice.
>> >>
>> >> Regards
>> >>
>> >> _______________________________________________
>> >> 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
>> >
>> >
>> >
>> > _______________________________________________
>> > 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
>> >
>>
>>
>>
>> --
>> Ali Jawad
>> Information Systems Manager
>> Splendor Telecom (www.splendor.net)
>> Beirut, Lebanon
>> Phone: +9611373725/ext 116
>> FAX: +9611375554
>>
>> _______________________________________________
>> 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
>
>
>
> _______________________________________________
> 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
>



-- 
Ali Jawad
Information Systems Manager
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554