You can try to run ngrep -qW byline port 3306 at kamailio server<br>and see if there are any errors, you should also use tcpdump and see if there are<br>any rejects on IP level.<br><br><br><br><br><br><div class="gmail_quote">
On Tue, Jan 3, 2012 at 3:14 AM, 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 Daniel<br>
<br>
SeLinux is disabled, as I have played around with Children and got a<br>
stable startup at CHILDREN=3, at 4 and up I get the problem described<br>
earlier right away, so it seems that MySQL is throttling Kamailio ?<br>
<br>
1- What is the effect of running 3 children only ?<br>
2- I know this is not a Kamailio thing, but any idea about what needs<br>
to be changed on MySQL server to accommodate more children ? No of<br>
connections is 500 conns out of which max 120 are utilized<br>
<br>
Regards<br>
<br>
On Mon, Jan 2, 2012 at 1:31 PM, Daniel-Constantin Mierla<br>
<<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>> wrote:<br>
> Hello,<br>
><br>
><br>
> On 1/2/12 12:24 PM, Ali Jawad wrote:<br>
>><br>
>> Hi Daniel<br>
>> Running on a LAN with no firewalls enabled,<br>
><br>
><br>
> limits can be from kernel, selinix, mysql server a.s.o. not only from<br>
> firewalls.<br>
><br>
><br>
>> will try you suggestion<br>
>> though first thing tomorrow morning, what are the implications of<br>
>> running children=1 ?<br>
><br>
><br>
> This will create only one worker process (not advisable for production in<br>
> long term, just for testing) -- in this way there should be very few mysql<br>
> connections opened, revealing if there is a problem or not with the number<br>
> of connections and the short period to create them.<br>
><br>
> Cheers,<br>
> Daniel<br>
><br>
>> Thanks<br>
>><br>
>> On Mon, Jan 2, 2012 at 2:03 PM, Daniel-Constantin Mierla<br>
>> <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>> wrote:<br>
>>><br>
>>> Hello,<br>
>>><br>
>>> check also for limits in the system/firewall, maybe there are limits on<br>
>>> new<br>
>>> connections per second. Try with children=1 and see if it happens again,<br>
>>> if<br>
>>> not, then it is something that blocks many new connections in short time.<br>
>>><br>
>>> Cheers,<br>
>>> Daniel<br>
>>><br>
>>><br>
>>> On 1/2/12 5:31 AM, Sammy Govind wrote:<br>
>>><br>
>>> Hi,<br>
>>> Its all upto you then, that's an intermittent issue and information is<br>
>>> not<br>
>>> complete to trace the issue. Did you see the same Errors every time it<br>
>>> fails<br>
>>> !?<br>
>>><br>
>>> --<br>
>>> Regards<br>
>>> Sammy<br>
>>><br>
>>> On Sun, Jan 1, 2012 at 10:06 PM, Ali Jawad<<a href="mailto:ali.jawad@splendor.net">ali.jawad@splendor.net</a>><br>
>>> wrote:<br>
>>>><br>
>>>> 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>
>>>><br>
>>>> On Sun, Jan 1, 2012 at 4:13 PM, Sammy Govind<<a href="mailto:govoiper@gmail.com">govoiper@gmail.com</a>> wrote:<br>
>>>>><br>
>>>>> Hi,<br>
>>>>> forget the whole list of errors and just resolve the DB connectivity<br>
>>>>> 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>><br>
>>>>> 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<br>
>>>>>> 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>
>>>> 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>
>>>><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>
>>> _______________________________________________<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>
>>> Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
>>> <a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a><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>
<span class="HOEnZb"><font color="#888888">><br>
> --<br>
> Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
> <a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a><br>
><br>
<br>
<br>
<br>
--<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>
<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>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>-- <br>Vitaly Nikolaev<br>