, , , CDR (Call Detail Record) . , , .
, CDR . , .
, :
- 192.168.1.2 - IP Asterisk FreePBX;
- 192.168.1.3 - , MySQL;
MySQL (MariaDB) PostgreSQL;
, IP ( pg_hba.conf PostgreSQL MySQL) freepbxuser. . Asterisk:
mysql --host=192.168.1.3 -ufreepbxuser -p asteriskcdrdb
. , FreePBX.
FreePBX
Settings → Advanced Settings. , Display Readonly Settings Override Readonly Settings Yes.

Submit Apply Config. Remote CDR Database :

- Remote CDR DB Host - IP , . 192.168.1.3;
- Remote CDR DB Name - . asteriskcdrdb;
- Remote CDR DB Password - MySQL freepbxuser;
- Remote CDR DB Port - , ;
- Remote CDR DB Table - , , . cdr;
- Remote CDR DB Type - . MySQL;
- Remote CDR DB User - , ;
asteriskcdrdb ;
. FreePBX:
fwconsole stop
odbc.ini
. , server, IP , :
vim /etc/odbc.ini
[MySQL-asteriskcdrdb] Description=MySQL connection to 'asteriskcdrdb' database driver=MySQL server=192.168.1.3 // database=asteriskcdrdb Port=3306 Socket=/var/lib/mysql/mysql.sock option=3 Charset=utf8
FreePBX:
fwconsole start
. .