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