asterisk users - Jan 2006 - Better solution to mysql reconnect timeout

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@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@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

Sig Lange wrote:
> 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@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@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.
Have you had a look at the source?

Sounds like the connection stats are not refreshed on a reconnect.

If you are not versed in C, you can still just look through the source 
at the plaintext and comments.

-- 
Cheers,

Matt Riddell
_______________________________________________

http://www.sineapps.com/news.php (Daily Asterisk News - html)
http://freevoip.gedameurope.com (Free Asterisk Voip Community)
http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss)