[SR-Users] Intermittent start up issue

Vitaly Nikolaev nvitaly at gmail.com
Tue Jan 3 14:54:44 CET 2012


You can try to run  ngrep -qW byline port 3306 at kamailio server
and see if there are any errors, you should also use tcpdump and see if
there are
any rejects on IP level.





On Tue, Jan 3, 2012 at 3:14 AM, Ali Jawad <ali.jawad at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>



-- 
-- 
Vitaly Nikolaev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120103/40c340dc/attachment.htm>


More information about the sr-users mailing list