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 <mico...@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 >> <mico...@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.ja...@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<govoi...@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.ja...@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
