:)

CDR FreePBX

3

, , , 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

. .

?

: