[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-26 17:28 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})}'



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

---------------------------------------------------------------------- 
 (0105477) ajohnson (reporter) - 2009-05-26 17:28
 https://issues.asterisk.org/view.php?id=15196#c105477 
---------------------------------------------------------------------- 
Compile error:

res_odbc.c: In function ârelease_transactionâ:
res_odbc.c:319: error: too many arguments to function
âodbc_release_obj2â
res_odbc.c: At top level:
res_odbc.c:981: error: conflicting types for âodbc_release_obj2â
res_odbc.c:145: error: previous declaration of âodbc_release_obj2â was
here
cc1: warnings being treated as errors
res_odbc.c: In function âodbc_release_obj2â:
res_odbc.c:1051: warning: passing argument 3 of â_ao2_ref_debugâ
discards qualifiers from pointer target type
res_odbc.c: In function âast_odbc_release_objâ:
res_odbc.c:1057: error: too few arguments to function
âodbc_release_obj2â
make[1]: *** [res_odbc.o] Error 1
make: *** [res] Error 2 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-26 17:28 ajohnson       Note Added: 0105477                          
======================================================================