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

Reply via email to