[asterisk-bugs] [Asterisk 0017421]: Asterisk crashes on sip_realtime using MySQL via ODBC

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17421 
====================================================================== 
Reported By:                kowalma
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17421
Category:                   Resources/res_config_odbc
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.7 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-05-28 17:52 CDT
Last Modified:              2010-06-02 10:51 CDT
====================================================================== 
Summary:                    Asterisk crashes on sip_realtime using MySQL via
ODBC
Description: 
Hi,

 Recently I migrated sip peers to database and since then I expirience
system crashes, mostly in BT I can see that it crashed following:

 sql = "SELECT * FROM sip_peers WHERE name = ? AND host = ?", 
====================================================================== 

---------------------------------------------------------------------- 
 (0122782) kowalma (reporter) - 2010-06-02 10:51
 https://issues.asterisk.org/view.php?id=17421#c122782 
---------------------------------------------------------------------- 
I'm using following versions:

ii  libiodbc2                            3.52.6-2                   iODBC
Driver Manager
ii  libmyodbc                            3.51.15r409-4              the
MySQL ODBC driver
ii  unixodbc                             2.2.11-16                  ODBC
tools libraries
ii  unixodbc-bin                         2.2.11-16                 
Graphical tools for ODBC management and brow
ii  unixodbc-dev                         2.2.11-16                  ODBC
libraries for UNIX (development files)

I will upgrade libODBC to most recent one version and check. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-06-02 10:51 kowalma        Note Added: 0122782                          
======================================================================