Enabled ANSI driver, CDR Reports works correctly, but the CEL table:
[2017-05-16 21:08:20] WARNING[2655]: cel_odbc.c:773 odbc_log: 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-05-16 21:08:20.943455'},'Алексей Иванович','202','','','','*65','from-internal','SIP/202-00000000','','',3,'','1494968900.0','1494968900.0','','','')
[2017-05-16 21:08:20] WARNING[2655]: cel_odbc.c:773 odbc_log: 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-05-16 21:08:20.945029'},'Алексей Иванович','202','202','','*65','*65','from-internal','SIP/202-00000000','Answer','',3,'','1494968900.0','1494968900.0','','','')
Driver Unicode not working ;(
cat /etc/odbc.ini
[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL-ANSI
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/lib/mysql/mysql.sock
option=3
Charset=utf8
cat /etc/odbcinst.ini
[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1
[MySQL-Unicode]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=1
[MySQL-ANSI]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=1
It looks like a problem in the driver libmyodbc5w in CentOS 7 ![]()