<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">We are using kamailio 4.2.0 with auth_db enabled and connected to a MySQL server. Occasionally, in the middle of the night when there is no activity we get the following errors out of the blue (the last three lines are repeated indefinitely). According to the <a href="http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html" class="">MySQL site</a>, this can be caused by a connect timeout that is too short (We verified that Aborted_connects is steadily rising). The kamailio server is right next to the database server so there is no network latency.</div><div class=""><br class=""></div><div class="">We increased the db_mysql timeout_interval parameter, but we still see MySQL’s Aborted_connects counter incrementing. So it’s like kamailio is still timing out on connection attempts. Ideas?</div><div class=""><br class=""></div><div class="">Thanks.</div><div class=""><br class=""></div><div class=""><div class="">Oct 1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11</div><div class="">Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host ‘X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'</div><div class="">Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</div><div class="">Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database</div><div class="">Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'</div></div><div class="">...</div></body></html>