[asterisk-bugs] [JIRA] (ASTERISK-21811) cdr_odbc "CDR direct execute failed" Not working with MySQL Master Server

[Emiliano (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-21811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=206775#comment-206775 ] 

Emiliano commented on ASTERISK-21811:
-------------------------------------

Sorry, but all the guides said to use the settings that you put in res_odbc. If you put another DSN is not in res_odbc gives the error above.

Sorry my bad english.
                
> cdr_odbc "CDR direct execute failed" 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
>         Attachments: cdr_odbc.conf, error.txt, res_odbc.conf
>
>
> 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