Hi, I have moved asteriskcdrdb to the new database on the new host, but need help on configuring the connection in FreePBX.
From what i gather, Asterisk seems to be using ODBC to describe and connect to the current database on localhost. The configuration seems to be in /etc/odbc.ini
I’ve got asteriskcdrdb used in:
cel_odbc.conf
res_odbc_additional.conf
cdr_adaptive_odbc.conf
If i am correct, i only need to update odbc.ini with the detauls of the new server. It’s contents are currenly:
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asteriskcdrdb’ database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3
Charset=utf8
There is no user/password here, i guess ODBC connections are different from standard MySQL connections…
Do i need to install a plugin on the new MySQL server and can i connect to it over the network? I am not familiar with ODBC.
FreePBX 13.0.197.21
Asterisk 13.29.2
Thanks in advance!