cdr_adaptative_odbc does not write CHAR fields

Asterisk Asterisk Support
1

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.

2

This is typically not an Asterisk, but a ODBC-driver problem. What’s the type of database/driver You’re using with cdr_adaptive_odbc.so?

3

I’m using:

  • Debian Squeeze
  • MySQL Server 5.1
  • Asterisk 1.8
  • UnixODBC

If I use CDR_MYSQL instead of CDR_ADAPTATIVE_MYSQL, or Debian Lenny with CDR_ADAPTATIVE_MYSQL everything works just fine.

Any ideas?

Thanks in advance.

4

The problem is the package libmyodbc in squeeze as it is version 5.1.6 which is known to not work properly.
What You should do is to download the package libmyodbc for Your architecture from http://packages.debian.org/lenny/libmyodbc and install it manually (it’s a 3.51-version which works).
If You encounter any problems with installing You may first deinstall the package libmyodbc and install the driver from mysql directly (have a look at http://www.mysql.de/downloads/connector/odbc/3.51.html#downloads).
After You’ve got driver version 3.51 up and running Your problems will be solved.

5

Thanks man.

With 3.51 version of libmyodbc worked just fine.

Any ideas if it’s going to be any corrections on 5.1.6 version?

Thanks.

6

Unfortunately not. But I had the same problem with newer ODBC-drivers for other backends too thus I keep the older versions always saved for such purposes here at my private box …