! , FreePBX, , , , IP-. , FreePBX 13 14 .
, CDR, CDR.
, FreePBX Distro SNG7-FPBX-64bit-1707-1, 571 ( VM)
, FreePBX 14 VM , 571 , , , . , , , , . , , FreePBX 14
, , - , . ,
. CDR? Reports → CDR Reports , .
? !
cdr asteriskcdrdb , :
! . , IP-. FreePBX Asterisk!
, charset = utf8 /etc/asterisk/cdr_mysql.conf core reload, , . , .
freepbx.org Bug FREEPBX-15268, (11.10.2017) DEV TESTING: Unresolved, .
MySQL mysql-connector-odbc-5.3.9 (ANSI Driver), /etc/odbc.ini :
[MySQL-asteriskcdrdb] driver=MySQL ODBC 5.3 ANSI Driver
CDR, , , , :
[2017-10-13 22:31:16] WARNING[8933] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('CHAN_START',{ts '2017-10-13 22:31:16.974567'},' ','175','','','','s','from-internal','SIP/175-00000001','','',3,'','1507923076.1','1507923076.0','','','')
[2017-10-13 22:31:18] WARNING[8933] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,extra) VALUES ('ANSWER',{ts '2017-10-13 22:31:18.631244'},' ','175','175','','','175','from-internal','SIP/175-00000001','AppDial','(Outgoing Line)',3,'','1507923076.1','1507923076.0','','','')
cel, , :
, CDR , , .
, , CDR .
, mysql-connector-odbc, , , , Asterisk. , , , . :
rpm -qa | grep mysql-connector-odbc
, mysql-connector-odbc-5.3.9-1.el7.x86_64, mysql-connector-odbc-5.3.6. , . , :
rpm -e --nodeps "mysql-connector-odbc-5.3.9-1.el7.x86_64"
, MySQL, MariaDB, :
! Asterisk!
yum install mariadb-connector-odbc
/etc/odbcinst.ini :
[MariaDB] Description=ODBC for MariaDB Driver=/usr/lib64/libmaodbc.so Setup=/usr/lib64/libodbcmyS.so UsageCount=1
fwconsole restart . , CDR FreePBX cdr asteriskcdrbd:
, , :)
. , , , . , .
