Hi,<div>forget the whole list of errors and just resolve the DB connectivity between the Kamailio server and DB server first .</div><div><br></div><div><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span style>27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't<br></span><span style>connect to MySQL server on 'xxxxxxxxx' (4)</span> </blockquote><div><br></div>try connecting to the remote DB server <span style>'xxxxxxxxx' from linux shell i.e</span></div>
<div><span style><br></span></div><div><span style># mysql -u<user> -p<passwd> -h </span><span style>'xxxxxxxxx'</span></div><div><span style><br></span></div><div>Regards,</div><div>Sammy</div><div><br>
</div><div><br><div class="gmail_quote">On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad <span dir="ltr"><<a href="mailto:ali.jawad@splendor.net">ali.jawad@splendor.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi All<br>
I have tried the below with Kamailio 3.1.0 and 3.2.1. the problem is<br>
that Kamailio at times fails to start up for no obvious reasons, I.e.<br>
in 10 restarts Kamailio might fail to start 3,0 or 5 times. Te debug<br>
log "level 2 " shows the following :<br>
<br>
27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't<br>
connect to MySQL server on 'xxxxxxxxx' (4)<br>
27(24762) ERROR: <core> [db.c:303]: could not add connection to the<br>
pool27(24762) ERROR: group [group.c:211]: unable to connect to the<br>
database<br>
27(24762) ERROR: <core> [sr_module.c:889]: init_mod_child(): Error<br>
while initializing module group<br>
(/usr/local/kamailio/lib/kamailio/modules_k/group.so)<br>
27(24762) ERROR: <core> [pt.c:481]: ERROR: fork_tcp_process():<br>
init_child failed for process 27, pid 24762, "tcp receiver child=1"<br>
<br>
and then<br>
<br>
<br>
30(24765) : <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 45<br>
0(24735) ALERT: <core> [main.c:748]: child process 24762 exited<br>
normally, status=255<br>
0(24735) INFO: <core> [main.c:766]: INFO: terminating due to SIGCHLD<br>
<br>
The problem happens on 4 different servers, I did try to compile more<br>
than once, the servers are 32 Bit CentOS 5.6. The connection to the<br>
database is monitored and there are no issues with connecting to the<br>
DB "it works at times and times not for Kamailio so a user/pwd issue<br>
is not likely to cause this, manual cnnect worked", config file errors<br>
are not found.<br>
<br>
I did also check max no of connections on MySQL server which is set to<br>
500 on the server and only 100 cons are used. The group module uses<br>
the same connection string as other modules which is predefined and<br>
there are other modules that access the db before the group module and<br>
those do not have a problem.<br>
<br>
Please advice.<br>
<br>
Regards<br>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div><br></div>