[asterisk-bugs] [Asterisk 0014838]: [patch] Asterisk cannot process calls if it cannot reach the voicemail database

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
http://bugs.digium.com/view.php?id=14838 
====================================================================== 
Reported By:                moliveras
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   14838
Category:                   Applications/app_voicemail/ODBC
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     confirmed
Asterisk Version:           1.4.24 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-04-06 16:12 CDT
Last Modified:              2009-04-08 11:35 CDT
====================================================================== 
Summary:                    [patch] Asterisk cannot process calls if it cannot
reach the voicemail database
Description: 
I am using asterisk 1.4.24 built with ODBC voicemail. If network
connectivity is lost between asterisk and the voicemail database, asterisk
cannot process calls.  It seems that while asterisk is trying to establish
the tcp connection to the DB is it blocking. Can this be changed?
====================================================================== 

---------------------------------------------------------------------- 
 (0102915) tilghman (administrator) - 2009-04-08 11:35
 http://bugs.digium.com/view.php?id=14838#c102915 
---------------------------------------------------------------------- 
This is a patch that enables negative connection caching and configurable
connection timeouts.  This was derived from a developer branch, but it
should work for this, as well.  You'll need to additionally set the
connect_timeout and negative_connection_cache for this to have an effect. 
If you're using MySQL as your backend, the values 1 and 300, respectively,
should work fine. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-04-08 11:35 tilghman       Note Added: 0102915                          
2009-04-08 11:35 tilghman       Summary                  Asterisk cannot process
calls if it can reach the voicemail database => [patch] Asterisk cannot process
calls if it cannot reach the voicemail database
======================================================================