Summary:ASTERISK-14056: cdr_odbc ont work in some ver of to 1.6.1 (and next ?)
Reporter:Maziar navahan (maziar)Labels:
Date Opened:2009-05-03 07:46:01Date Closed:2011-06-07 14:00:26
Versions:Frequency of
Environment:Attachments:( 0) cdr_odbc.conf
( 1) cli.txt
( 2) isql.txt
( 3) odbc.tar.gz
( 4) res_odbc.conf
Description:i have one cdr via dbc true work for lower version but after upgrade alwayse see :
ERROR[9823]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle.  CDR failed.

t database and odbc is ok and true work but seems cdr odbc driver us buggy
Comments:By: Tilghman Lesher (tilghman) 2009-05-04 15:27:36

Please upload the files cdr_odbc.conf and res_odbc.conf to the file upload area of this issue.

By: Tilghman Lesher (tilghman) 2009-05-04 15:30:39

Please also read lines 164-167 in UPGRADE-1.6.txt in the root directory of your source package.

By: Maziar navahan (maziar) 2009-05-04 23:24:11

attachment comment : i test cdr_odbc  with and without  username&password the same as UPGRADE-1.6.txt  but no any change

By: Tilghman Lesher (tilghman) 2009-05-05 09:34:31

Clearly, you did not fully read the indicated note, because it states that the DSN in cdr_odbc.conf MUST be the section name in res_odbc.conf.  Hence, in cdr_odbc.conf, dsn=asterisk, not asterisk-connector.

By: Leif Madsen (lmadsen) 2009-05-05 13:10:19

Yep, this looks like a configuration error.

cdr_odbc.conf --> res_odbc.conf --> DSN connector

cdr_odbc.conf dsn should reference the [asterisk] (name in square braces) in res_odbc.conf, which then references the ODBC DSN.