[asterisk-bugs] [Asterisk 0014481]: ODBC-based function crashes Asterisk

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14481 
====================================================================== 
Reported By:                lmsteffan
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   14481
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 176019 
Request Review:              
====================================================================== 
Date Submitted:             2009-02-16 00:01 CST
Last Modified:              2009-02-18 23:22 CST
====================================================================== 
Summary:                    ODBC-based function crashes Asterisk
Description: 
I have defined a simple function in func_odbc.conf to read (SELECT) one
value from MySQL database. It works the first time, and crashes very soon
after, sometimes as soon as the next invocation.

The CLI command that I use is "odbc read MY_FUNCTION arg1 exec".

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

---------------------------------------------------------------------- 
 (0100354) lmsteffan (reporter) - 2009-02-18 23:22
 http://bugs.digium.com/view.php?id=14481#c100354 
---------------------------------------------------------------------- 
Well it does not crash any more. However I no longer have access to the
database:

- for the query that had a problem:

*CLI> odbc read FILTRAGE_INFO 6210 exec
Failed to execute query. [SELECT filtre_par FROM ast_sipfriends WHERE
name=6210]

- but also the registrations do not work any more:

[Feb 19 16:18:08] ERROR[10368]: res_config_odbc.c:144 realtime_odbc: No
database handle available with the name of 'asterisk' (check res_odbc.conf) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-02-18 23:22 lmsteffan      Note Added: 0100354                          
======================================================================