Asterisk cdr_adaptive_odbc Trouble2

So I have been fighting for two days straight on an issue in Asterisk with cdr_adaptive_odbc saying:
cdr_adaptive_odbc.c:686 odbc_log: Column type -9 (field ‘wavve:cdr:clid’) is unsupported at this time.

It would repeat this message for all my varchar columns, and of course wouldn’t insert any data, I googled every combination of everything I could think of and the closest I came to was this: https://issues.asterisk.org/jira/browse/ASTERISK-18278 Now I don’t want to talk bad about the Asterisk/Digium guys but from my experience the guys working on the ODBC part of Asterisk can kind of be short with the users. Take this blob of text for example:

; On Wednesday 10 September 2008 21:11:16 Tilghman Lesher wrote:
;
; I thought that the sample cdr_adaptive_odbc.conf was rather clear, but
; apparently not.

I mean come on guys what value does this sentence bring to anything.

Anyways here is how I fixed it.

show table status

I noticed that the Collation was utf8_general_ci I had a feeling that this was wrong so I ran:

alter table cdr CONVERT TO CHARACTER SET latin1;

and bingo, after a module reload I was storing all the cdr data in MySQL

I Hope this saves people some time.

Keep on trucking and have fun!

Be Sociable, Share!

•