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

[George Joseph (JIRA)]

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

George Joseph updated ASTERISK-28112:
-------------------------------------

    Assignee: Leandro Dardini  (was: Unassigned)
      Status: Waiting for Feedback  (was: Triage)

Can you confirm that there is an integer column named origtime in your database.  Is it populated?

We've had reports of other mysql related issues due to mysql getting more strict about how columns are populated.  I just wanted to make sure we didn't have a similar issue.  

Also, what version of mysql itself are you running and are oyu running both mysql and the connector from Centos packages?


> 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: Leandro Dardini
>            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)