Asterisk realtime in Debian

Asterisk Asterisk Support
1

Hi. Running latest Debian 9 64 bit and i have installed Asterisk 13 LTS. I would like to change it to realtime. i have installed mysql-server but i cannot find the libmyodbc.
Apart from the libmyodbc, what else does it need to be done in the system? Is there a guide on that, please?

2

I’m using ubuntu server who is debian based, and I downloaded libmyodbc from the mysql site.

3

Thanks for the reply. I downloaded the connector, then

cp -v mysql-connector-odbc-.-linux-debian9-x86-64bit/lib/libmyodbc /usr/lib/x86_64-linux-gnu/odbc/
and

root@debian:~# cat /etc/odbc.ini
[MySQL-asteriskcdrdb]
Description=MySQL Asterisk database
Driver=MySQL
Server=localhost
User=asteriskcdruser
Password=whatever
Database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
Option=3
root@debian:~# cat /etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8S.so
FileUsage = 1
root@debian:~#

but the error is:

root@debian:~# echo “select 1” | isql -v MySQL-asteriskcdrdb
[S1000][unixODBC][MySQL][ODBC 8.0(a) Driver]Access denied for user ‘asteriskcdruser’@‘localhost’ (using password: YES)
[ISQL]ERROR: Could not SQLConnect
root@debian:~#

Also, what is the content of the Database? is there any .sql file that i could get advice from?
Any ideas please?

4

I posted the instrucions here Call detail records are not saving in cdr