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 MySQL site
<http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html>, 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.
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?
Thanks.
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
Oct 1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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
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
Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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
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
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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
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
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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
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
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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
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
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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'
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
Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db
[authorize.c:175]: get_ha1(): failed to query database
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'
...
_______________________________________________
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