| Summary: | ASTERISK-14056: cdr_odbc ont work in some ver of 1.6.0.6 to 1.6.1 (and next ?) | ||
| Reporter: | Maziar navahan (maziar) | Labels: | |
| Date Opened: | 2009-05-03 07:46:01 | Date Closed: | 2011-06-07 14:00:26 |
| Priority: | Major | Regression? | No |
| Status: | Closed/Complete | Components: | CDR/cdr_odbc |
| Versions: | Frequency of Occurrence | ||
| Related Issues: | |||
| 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. | ||