Error DSN in CDR Reports Freepbx15

This error in cdr remote:

The file res_odbc_additional.conf:
[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
pre-connect=>yes
max_connections=>5
username=>freepbxuser
password=>bddc6e7f473b4e052o
database=>asteriskcdrdb

The file obc.ini:
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asteriskcdrdb’ database
Driver=MySQL
Server=localhost
Database=asteriskcdrdb
Port=3306
Socket=/run/mysqld/mysqld.sock
Option=3
Charset=utf8

I need connect to database freepbxcdrdb…
Can someone help me?

Is this a FreePBX Distro install?

Yes, this is in .iso format for installation

I already solved it thanks.

The solution for my use case was:
1.- Download controller odbc in MySQL :: Download Connector/ODBC and select Operating System: Linux-generic and select OS version x86 - 64 Bit

2.- Extract and Copy files libmyodbc8a.so & libodbcmyS.so to /usr/lib/x86_64-linux-gnu/odbc/

3.- Create or Edit /etc/odbcinst.ini
The file contain:
[MySQL]
Description = ODBC for MySQL
#Driver64 = /usr/lib/x86_64-linux-gnu/libodbc.so
Driver64 = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8a.so
Setup64 = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
#Driver64 = /usr/lib64/libmyodbc5.so
#Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
CPTimeout = 120

4.- After execute the next line in terminal linux:
1.- asterisk -rx “module reload res_odbc.so”
2.- asterisk -rx “module reload cdr_adaptive_odbc.so”
3.- fwconsole reload
4.- service asterisk restart

The result is:

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.