1 Jan 2012 15:13
Re: [SR-Users] Intermittent start up issue
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)
# mysql -u<user> -p<passwd> -h 'xxxxxxxxx'
Regards,
Sammy
On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad <ali.jawad-kFViwpaZTe3k1uMJSBkQmQ@public.gmane.org> 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-cR8azDVoa3IcDhw6gZKtMeG/Ez6ZCGd0@public.gmane.orgorg
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
<div> <p>Hi,</p> <div>forget the whole list of errors and just resolve the DB connectivity between the Kamailio server and DB server first .</div> <div><br></div> <div> <blockquote class="gmail_quote"> <span>27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't<br></span><span>connect to MySQL server on 'xxxxxxxxx' (4)</span> </blockquote> <div><br></div>try connecting to the remote DB server <span>'xxxxxxxxx' from linux shell i.e</span> </div> <div><span><br></span></div> <div> <span># mysql -u<user> -p<passwd> -h </span><span>'xxxxxxxxx'</span> </div> <div><span><br></span></div> <div>Regards,</div> <div>Sammy</div> <div><br></div> <div> <br><div class="gmail_quote">On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad <span dir="ltr"><<a href="mailto:ali.jawad@...">ali.jawad@...</a>></span> wrote:<br><blockquote class="gmail_quote"> 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 list<br><a href="mailto:sr-users@...">sr-users@...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> </blockquote> </div> <br> </div> </div>
But I don't know if this may have impact on other
> modules. I means I don't know if there are some modules use this
> function to check if the only real dialog (but not temporary dialog)
> is existing in the hash. In this case maybe is better to have 2 check
> functions, one for real, another for both or temporary. What do you
> think?
>
>
> Best Regards,
> Laura
>
>
>
>
>
>
>
> But the patches
>
> Yes, the second
>
>
>
> On Thu, Dec 29, 2011 at 4:41 PM, Daniel-Constantin Mierla
> <
RSS Feed