[SR-Users] Intermittent start up issue

[Sammy Govind]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120101/f577301a/attachment.htm>