On Tue, Jan 3, 2012 at 3:14 AM, Ali Jawad <ali.jawad@splendor.net> wrote:

Hi Daniel

SeLinux is disabled, as I have played around with Children and got a
stable startup at CHILDREN=3, at 4 and up I get the problem described
earlier right away, so it seems that MySQL is throttling Kamailio ?

1- What is the effect of running 3 children only ?
2- I know this is not a Kamailio thing, but any idea about what needs
to be changed on MySQL server to accommodate more children ? No of
connections is 500 conns out of which max 120 are utilized

Regards

On Mon, Jan 2, 2012 at 1:31 PM, Daniel-Constantin Mierla
<miconda@gmail.com> wrote:
> Hello,
>
>
> On 1/2/12 12:24 PM, Ali Jawad wrote:
>>
>> Hi Daniel
>> Running on a LAN with no firewalls enabled,
>
>
> limits can be from kernel, selinix, mysql server a.s.o. not only from
> firewalls.
>
>
>> will try you suggestion
>> though first thing tomorrow morning, what are the implications of
>> running children=1 ?
>
>
> This will create only one worker process (not advisable for production in
> long term, just for testing) -- in this way there should be very few mysql
> connections opened, revealing if there is a problem or not with the number
> of connections and the short period to create them.
>
> Cheers,
> Daniel
>
>> Thanks
>>
>> On Mon, Jan 2, 2012 at 2:03 PM, Daniel-Constantin Mierla
>> <miconda@gmail.com> wrote:
>>>
>>> Hello,
>>>
>>> check also for limits in the system/firewall, maybe there are limits on
>>> new
>>> connections per second. Try with children=1 and see if it happens again,
>>> if
>>> not, then it is something that blocks many new connections in short time.
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>> On 1/2/12 5:31 AM, Sammy Govind wrote:
>>>
>>> Hi,
>>> 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
>>> !?
>>>
>>> --
>>> Regards
>>> Sammy
>>>
>>> On Sun, Jan 1, 2012 at 10:06 PM, Ali Jawad<ali.jawad@splendor.net>
>>> wrote:
>>>>
>>>> Hi
>>>> Thanks for your input, but as said this works at times yes and times
>>>> now so I am not sure it is a definite DB issue, the servers are in the
>>>> same LAN, and there are other modules that use the DB string that work
>>>> when launched before this one while this one does not work.
>>>> Regards
>>>>
>>>> On Sun, Jan 1, 2012 at 4:13 PM, Sammy Govind<govoiper@gmail.com> wrote:
>>>>>
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>
>>>>
>>>> --
>>>> Ali Jawad
>>>> Information Systems Manager
>>>> Splendor Telecom (www.splendor.net)
>>>> Beirut, Lebanon
>>>> Phone: +9611373725/ext 116
>>>> FAX: +9611375554
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>> --
>>> Daniel-Constantin Mierla -- http://www.asipto.com
>>> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>
>>
>
> --
> Daniel-Constantin Mierla -- http://www.asipto.com
> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>

--
Ali Jawad
Information Systems Manager
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554

_______________________________________________
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