[asterisk-bugs] [JIRA] (ASTERISK-28112) Asterisk is not able to use newly released mysql connector odbc 8.0.12 for voicemail

[Sean Bright (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-28112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Bright closed ASTERISK-28112.
----------------------------------

    Resolution: Not A Bug

This appears to be a bug in the MySQL ODBC Driver: https://bugs.mysql.com/bug.php?id=92947

If you modify the SQL statement in {{retrieve_file}} in {{app_voicemail.c}} to exclude the {{recording}} and {{transcript}} columns from the table that [~ldardini] provided, the query returns a row. With those columns the driver reports that there were no rows, but you can see from network captures that the data is being returned by MySQL.

Until MySQL fixes the bug, you should continue to use version 8.0.11 of their driver.

> Asterisk is not able to use newly released mysql connector odbc 8.0.12 for voicemail
> ------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-28112
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28112
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 13.23.1
>         Environment: CentOS 6 and 7, 64bit
>            Reporter: Leandro Dardini
>            Assignee: Unassigned
>            Severity: Minor
>         Attachments: extconfig.conf, func_odbc.conf, odbc.ini, odbcinst.ini, res_odbc.conf, voicemail.conf
>
>
> When upgrading package on CentOS from mysql-connector-odbc version 8.0.11 to 8.0.12, it is no more possible to listen to voicemails. The message returned on the console is 
> {quote}
> Connected to Asterisk 13.23.0 currently running on mirtafrontend (pid = 7318)
> > 0x7f45f400a6a0 – Strict RTP learning complete - Locking on source address 79.37.122.94:4012
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-youhave.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘digits/1.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-INBOX.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-and.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘digits/2.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-Old.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-messages.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-onefor.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-first.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-message.ulaw’ (language ‘en’)
> [2018-09-12 23:01:13] WARNING[7738][C-00000007]: app_voicemail.c:8851 play_message: No origtime?!
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-advopts.ulaw’ (language ‘en’)
> – <SIP/79-Ve2Aze-00000006> Playing ‘vm-repeat.ulaw’ (language ‘en’)
> {quote}
> Downgrading ODBC connector to 8.0.11 restores working app_voicemail.



--
This message was sent by Atlassian JIRA
(v6.2#6252)