[asterisk-bugs] [Asterisk 0016146]: Need a CLI command to force a reconnect of ODBC connections

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16146 
====================================================================== 
Reported By:                btrain1227
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16146
Category:                   Resources/res_odbc
Reproducibility:            random
Severity:                   feature
Priority:                   normal
Status:                     closed
Asterisk Version:           1.4.26.1 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-10-28 13:59 CDT
Last Modified:              2009-11-02 11:47 CST
====================================================================== 
Summary:                    Need a CLI command to force a reconnect of ODBC
connections
Description: 
We have a sqlite db file that is updated by the following method:

1. A new file is pushed to the server.
2. This file is 'cp -f' to the name of the production db file.
3. A reload is issued through the cli.

Not the cleanest update, but 99% of the time it works.  Sometimes though
the lookups still return data from the db file that was overwritten. 
Subsequent reloads do not reconnect to the new db file.  The only solution
is to restart asterisk. A cli command to force a reconnect of the ODBC
resources would prevent the need for a full restart.

The res_odbc.conf option 'idlecheck' will correct the issue on newer
installs.  When the timeout is reached the connection to the new data file
is made.  On a busy server this requires setting it to a few seconds
though.

SQLite ODBC Driver http://www.ch-werner.de/sqliteodbc/

res_odbc.conf

[sqlitedb]
enabled => yes
dsn => sqlitedb
username => myuser
password => mypass
pre-connect => yes

func_odbc.conf - All simple selects.

====================================================================== 

---------------------------------------------------------------------- 
 (0112987) lmadsen (administrator) - 2009-11-02 11:47
 https://issues.asterisk.org/view.php?id=16146#c112987 
---------------------------------------------------------------------- 
This is a feature request without supplying a patch to implement this
functionality. Issue closed. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-11-02 11:47 lmadsen        Note Added: 0112987                          
2009-11-02 11:47 lmadsen        Status                   new => closed       
2009-11-02 11:47 lmadsen        Resolution               open => no change
required
======================================================================