[asterisk-users] Asterisk 1.8.13.0 / problem with cdr logging (mysql, odbc)

[Michael L. Young]

----- Original Message -----
> From: "Thorsten Göllner" <tg at ovm-group.com>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com>
> Sent: Monday, June 18, 2012 11:52:15 AM
> Subject: [asterisk-users] Asterisk 1.8.13.0 / problem with cdr logging	(mysql, odbc)
> 
>
> /etc/odbcinst.ini
> --------------------
> [MySQL]
> Description = MySQL ODBC MyODBC Driver
> Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
> FileUsage = 1

Try adding:

"Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so"

Adjust the path according to where this file can be found on your system.


> So here are the config file for asterisk.
> 
> /etc/asterisk/res_odbc.conf
> -----------------------------
> [mysql]
> enabled => yes
> dsn => MySQL-asterisk
> username => asterisk
> password => qpalym
> pre-connect => yes

For MySQL, I think you also need:

"backslash_is_escape => yes"

Give those two things a try and see if that helps.

Regards,
Michael