Hi,<div>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 !?</div><div><br></div><div>--</div><div>Regards</div><div>
Sammy<br><br><div class="gmail_quote">On Sun, Jan 1, 2012 at 10:06 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<br>
Thanks for your input, but as said this works at times yes and times<br>
now so I am not sure it is a definite DB issue, the servers are in the<br>
same LAN, and there are other modules that use the DB string that work<br>
when launched before this one while this one does not work.<br>
Regards<br>
<div class="HOEnZb"><div class="h5"><br>
On Sun, Jan 1, 2012 at 4:13 PM, Sammy Govind <<a href="mailto:govoiper@gmail.com">govoiper@gmail.com</a>> wrote:<br>
> Hi,<br>
> forget the whole list of errors and just resolve the DB connectivity between<br>
> the Kamailio server and DB server first .<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>
><br>
><br>
> try connecting to the remote DB server 'xxxxxxxxx' from linux shell i.e<br>
><br>
> # mysql -u<user> -p<passwd> -h 'xxxxxxxxx'<br>
><br>
> Regards,<br>
> Sammy<br>
><br>
><br>
> On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad <<a href="mailto:ali.jawad@splendor.net">ali.jawad@splendor.net</a>> wrote:<br>
>><br>
>> 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>
><br>
><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>
><br>
<br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Ali Jawad<br>
Information Systems Manager<br>
Splendor Telecom (<a href="http://www.splendor.net" target="_blank">www.splendor.net</a>)<br>
Beirut, Lebanon<br>
Phone: <a href="tel:%2B9611373725" value="+9611373725">+9611373725</a>/ext 116<br>
FAX: <a href="tel:%2B9611375554" value="+9611375554">+9611375554</a><br>
</font></span><div class="HOEnZb"><div class="h5"><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>
</div></div></blockquote></div><br></div>