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@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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users