. WIKIMERIONET
Merion Mertics , ,

-
-
CRM

4

! , FreePBX, , , , IP-. , FreePBX 13 14 .

, CDR, CDR.


, FreePBX Distro SNG7-FPBX-64bit-1707-1, 571 ( VM)

, FreePBX 14 VM , 571 , , , . , , , , . , , FreePBX 14

, , - , . ,

   FreePBX 13

. CDR? ReportsCDR Reports , .

   FreePBX 13

? !

cdr asteriskcdrdb , :

   FreePBX 13

! . , 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, , :

   FreePBX 13

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

   FreePBX 13    FreePBX 13

, , :)

. , , , . , .


?