[Serusers] ser fails after mysql restart

Mike Williams mwilliams at etc1.net
Fri Aug 12 13:40:48 CEST 2005


Hello,

OpenSER 0.9.5 fails if the connection to MySQL is broken or times out 
while ser is running. Is there any way to have the server reconnect 
intelligently? I currently have the MySQL timeout set to five days, but 
I would prefer a real fix. Ser and mysql are both running on the same 
server.

Thanks,
    Mike Williams

Here's some of my syslog output:

Aug 12 07:33:43 sip /usr/local/sbin/openser[12542]: submit_query(): 
MySQL server has gone away
Aug 12 07:33:43 sip /usr/local/sbin/openser[12542]: submit_query(): 
Error while submitting query
Aug 12 07:33:43 sip /usr/local/sbin/openser[12542]: get_ha1(): Error 
while querying database
Aug 12 07:33:51 sip /usr/local/sbin/openser[12558]: submit_query(): 
MySQL server has gone away
Aug 12 07:33:51 sip /usr/local/sbin/openser[12558]: submit_query(): 
Error while submitting query
Aug 12 07:33:51 sip /usr/local/sbin/openser[12558]: get_ha1(): Error 
while querying database
Aug 12 07:34:11 sip /usr/local/sbin/openser[12542]: submit_query(): 
MySQL server has gone away
Aug 12 07:34:11 sip /usr/local/sbin/openser[12542]: submit_query(): 
Error while submitting query
Aug 12 07:34:11 sip /usr/local/sbin/openser[12542]: get_ha1(): Error 
while querying database
Aug 12 07:34:13 sip /usr/local/sbin/openser[12558]: submit_query(): 
MySQL server has gone away
Aug 12 07:34:13 sip /usr/local/sbin/openser[12558]: submit_query(): 
Error while submitting query
Aug 12 07:34:13 sip /usr/local/sbin/openser[12558]: get_ha1(): Error 
while querying database




More information about the sr-users mailing list