[asterisk-bugs] [JIRA] (ASTERISK-21811) CDR ODBC Not working with MySQL Master Server

[Emiliano (JIRA)]

Emiliano created ASTERISK-21811:
-----------------------------------

             Summary: CDR ODBC Not working with MySQL Master Server
                 Key: ASTERISK-21811
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-21811
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: CDR/cdr_odbc
    Affects Versions: 11.2.2
         Environment: Debian Squeeze, MySQL Server 5.5 (Master), Asterisk 11.2
Debian Wheezy, MySQL Server 5.5 (Slave).
            Reporter: Emiliano


The ODBC connection is working properly. If the MySQL server is not configured as master works fine, but when you activate master option stop working.
The replica is working properly. For example I execute SQLQuery in mysql or isql and work fine but at same time CDR not work.

MySQL Server configure character is utf8 and DB and tables are InnoDB.


       > cdr_odbc: Error in ExecDirect: -1
[May 23 12:33:45] WARNING[30318][C-00000036]: res_odbc.c:608 ast_odbc_direct_execute: SQL Execute error! Verifying connection to local [MySQL-Local]...
       > cdr_odbc: Error in ExecDirect: -1
[May 23 12:33:45] ERROR[30318][C-00000036]: cdr_odbc.c:163 odbc_log: CDR direct execute failed

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira