[asterisk-bugs] [Asterisk 0009389]: res_config_odbc never reconnects

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=9389 
====================================================================== 
Reported By:                norman
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   9389
Category:                   Core/Configuration
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.2 
SVN Branch (only for SVN checkouts, not tarball releases):  1.4 
SVN Revision (number only!): 59255 
Disclaimer on File?:        No 
Request Review:              
====================================================================== 
Date Submitted:             03-27-2007 10:48 CDT
Last Modified:              08-05-2007 09:46 CDT
====================================================================== 
Summary:                    res_config_odbc never reconnects
Description: 
If I restart my ODBC-connected database, MS SQL in my case, Astersik will
not re-connect to the database when accessed via res_config_odbc, i.e. the
ast_load_realtime() functions. res_odbc will try to do so, but since
res_config_odbc calls SQLPrepare directly instead of using res_odbc's
ast_odbc_prepare_and_execute functions, res_config_odbc will this never
reconnect and all subsequent queries fail.
====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 08-05-07 09:46  
---------------------------------------------------------------------- 
As noted in the previous bugnote, this is no longer applicable to 1.2, as
1.2 is now in security-fixes-only mode.  I have left the patch for people
who would like to use it in 1.2, however.

New candidate code uploaded for 1.4, which includes the necessary
conversions to app_voicemail, app_directory, and res_config_odbc. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
08-05-07 09:46  Corydon76      Note Added: 0068448                          
======================================================================