[Asterisk-Users] Better solution to mysql reconnect timeout

[Sig Lange]

vmail*CLI> realtime mysql status
Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Failed to reconnect. Check debug for more info.
vmail*CLI> realtime mysql status
Connected to asterisk_vm at tritonvoice.com, port 3306 with username voicemail
for 1 days, 5 hours, 32 minutes, 7 seconds.
vmail*CLI> realtime mysql status
Connected to asterisk_vm at tritonvoice.com, port 3306 with username voicemail
for 0 seconds.

-----

There seems to be a problem with the way mysql is reconnected, apparantly it
seems to be calling mysql_reconnect() but I find that hard to believe since
it doesn't connect. Then the second time I run the command, it says it's
been connected for 1 days, 5 hours, etc. That doesn't make any sense since
the connection already failed to reconnect. There is no connection. Running
the command again assures in fact, finally I do have a connection. My
particular purpose is a voicemail system, which isn't taking voicemail
messages all the time, it is important the system always be connected to
mysql.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060111/becffa1f/attachment.htm