John,
I just saw that message today as well. I had to restart SER. I didn't know what it was, but I would be like to know if you find a solution. This seems to have something to do with the newest version of MySQL I think. I am running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.
Leo P.
________________________________________ From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of "???" Sent: Friday, March 31, 2006 9:01 AM To: serusers@lists.iptel.org Subject: [Serusers] ERROR message : MySQL server has gone away
please help..... If i restart MySQL(version 5.0.19), SER shows next error message. Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL server has gone away Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error while submitting query Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while querying database Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding '1234@192.9.2.1','sip:1234@192.9.2.11:5060' has expired As appear in upside message, SER does not auto-reconnect to mysql. If MySQL restarted, SER must be able to do Auto-Reconnect. Is no there way that SER can do Auto-Reconnect to MySQL?