Summary:	ASTERISK-04913: Voicemail with MySQL won't find mailbox if db connection is lost
Reporter:	Joseph Benden (jbenden)	Labels:
Date Opened:	2005-08-27 23:43:41	Date Closed:	2011-06-07 14:10:23
Priority:	Minor	Regression?	No
Status:	Closed/Complete	Components:	Applications/app_voicemail
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) mysql-vm-routines.h.patch-1.txt
Description:	If you are using MySQL voicemail support, and the connection is lost, then the current call's lookup for a mailbox will fail. Also, without the timeout parameter, you could hang the asterisk process forever, waiting for the db to come back. ****** ADDITIONAL INFORMATION ****** The attached patch will attempt to ping the server connection. If that fails, it will retry up to 5 times to reconnect to the database server.  It also adds a hard coded 20 second connection time-out. (Needs moved to a configuration variable at some point.) This is really a bug, from my standpoint, but a tweak from the developer standpoint.  So, with this patch, then the few calls that make it through on timed-out connections, lost connections, etc., will still be able to find the mailbox.... (Happy customers = paying customers!)
Comments:	By: Michael Jerris (mikej) 2005-08-27 23:55:23 Can you create verify if this is also the case for cvs head, and if so, create a patch for cvs head. By: Joseph Benden (jbenden) 2005-08-28 09:18:59 It looks like this was removed in favor of the realtime engine. So, this patch only applies to people using the stable branch, not cvs head. By: Russell Bryant (russell) 2005-11-04 11:14:33.000-0600 I appologize for taking so long to respond to this issue. Because of the pending release of 1.2, the 1.0 branch will only receive severe-bug or security fixes.  There were some other patches to other modules that did not make it into 1.0, either.  So, I'm going to close this out, but the patch will still be available here for anyone that wants to use it. Thank you for your contribution!