[Home]

Summary:ASTERISK-18278: cdr_adaptative_odbc does not write CHAR fields
Reporter:Alexandre Keller (alexandrekeller)Labels:
Date Opened:2011-08-15 18:27:42Date Closed:2011-08-16 07:54:37
Priority:MajorRegression?
Status:Closed/CompleteComponents:CDR/cdr_adaptive_odbc
Versions:1.8.5.0 Frequency of
Occurrence
Constant
Related
Issues:
Environment:Debian Squeeze, Kernel 2.6.32-5-686, MySQL Server 5.1, UnixODBCAttachments:
Description:After I upgraded my Linux Server from Debian Lenny to Debian Squeeze, CDR_ADAPTATIVE_ODBC stopped writing CHAR fields. The following messages appear:

[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:dst') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:dcontext') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:channel') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:dstchannel') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:lastapp') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:lastdata') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:disposition') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:uniqueid') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:c_dst') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:c_audioreadformat') is unsupported at this time.
[Aug 15 20:26:08] WARNING[18308]: cdr_adaptive_odbc.c:642 odbc_log: Column type -9 (field 'asteriks:ast_cdr:c_audiowriteformat') is unsupported at this time.

I put back Debian Lenny and came back to work just fine. But I need to use Squeeze since Lenny isn't been developed any more.

Thanks.
Comments:By: Alexandre Keller (alexandrekeller) 2011-08-16 07:54:37.351-0500

It's a ODBC driver problem with Debian Squeeze. Not related to Asterisk.



By: Paul Belanger (pabelanger) 2012-12-09 11:16:32.529-0600

Great, I just ran into this issue.