<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>the ping option is set to the libmysqlclient, kamailio itself
doesn't do anything in this regard. Iirc, in some old versions of
the library, this option didn't work.</p>
<p>On the other hand, kamailio should try to reconnect if
disconnected, but in this case it seems that the connection was
broken during the query.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 14.12.20 17:51, Duarte Rocha wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAAJJHZinPpPukGVbXyNX2cn6Xj_zOaXEkFyiJ_02cHqx08af6g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="auto">Greetings all,
<div dir="auto"><br>
</div>
<div dir="auto">I'm having some dropped MySQL connections in my
Kamailio in times of low or no activity in the proxy. </div>
<div dir="auto"><br>
</div>
<div dir="auto">These are the errors i'm getting : </div>
<div dir="auto"><br>
</div>
<div dir="auto"> db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Lost
connection to MySQL server during query (2013)</div>
<div dir="auto"> <core> [db_query.c:348]:
db_do_update(): error while submitting query</div>
<div dir="auto"> usrloc [ucontact.c:1147]:
db_update_ucontact_ruid(): updating database failed</div>
<div dir="auto"> usrloc [ucontact.c:1663]:
update_contact_db(): failed to update database</div>
<div dir="auto"> registrar [save.c:784]: update_contacts():
failed to update contact</div>
<div dir="auto"> sl [sl_funcs.c:414]: sl_reply_error():
stateless error reply used: I'm terribly sorry, server error
occurred (1/SL)</div>
<div dir="auto"><br>
</div>
<div dir="auto">In order to try to fix this i've added
timeout_interval and ping_interval from the db_mysql module.
Is this the best approach?</div>
<div dir="auto"><br>
</div>
<div dir="auto">I've restarted my Kamailio but i don't see any
ping going to my BD. Is there any other config that I need to
add so that the pings are sent?</div>
<div dir="auto"><br>
</div>
<div dir="auto">Is it possible to do a ping to verify connection
and reconnect mannualy on the config file?</div>
<div dir="auto"><br>
</div>
<div dir="auto">Best Regards,</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</body>
</html>