[asterisk-bugs] [Asterisk 0015196]: [patch] Asterisk crash when using ODBC to insert record on table that does not exist

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15196 
====================================================================== 
Reported By:                ajohnson
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15196
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.2.0-beta2 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-05-26 10:35 CDT
Last Modified:              2009-05-28 13:14 CDT
====================================================================== 
Summary:                    [patch] Asterisk crash when using ODBC to insert
record on table that does not exist
Description: 
When using func_odbc to insert a record into a table that does not exist,
asterisk will crash after attempting to reconnect to the database.  I have
not tested this in other error scenarios.

MySQL Server version: mysql-server.x86_64 5.0.45-7.el5

unixODBC.i386       2.2.11-7.1
unixODBC-devel.i386 2.2.11-7.1

func_odbc.conf
[SET]
prefix=DB
dsn=mysql
writesql = INSERT INTO asterisk.CallVariables (uid,name,value) VALUES
('${SQL_ESC(${ARG1})}','${SQL_ESC(${VAL1})}','${SQL_ESC(${VAL2})}')
writesql += ON DUPLICATE KEY UPDATE value='${SQL_ESC(${VAL2})}'



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

---------------------------------------------------------------------- 
 (0105670) tilghman (administrator) - 2009-05-28 13:14
 https://issues.asterisk.org/view.php?id=15196#c105670 
---------------------------------------------------------------------- 
Yay!  Now it's no longer an Asterisk crash, but a UnixODBC crash.  Just to
make sure, try upgrading to the latest UnixODBC from source (as opposed to
distribution package) as this usually solves crash issues like this. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-28 13:14 tilghman       Note Added: 0105670                          
======================================================================