Asterisk not playing unavailable message from odbc

#1

I’m updating Asterisk to 16.0.1 and for some reason, Asterisk will not play the unavailable message recorded in voicemail_messages. The odbc is working great and I can use VoicemailMain to record messages in the database.
Asterisk keep playing the default one:

Playing 'vm-theperson.ulaw

Instead of getting the recording in the db and playing it back like in my production system:

Playing '/var/spool/asterisk/voicemail/default/2951/unavail.slin

I can see this error in the debug log:

media_cache.c: Failed to obtain media at '/var/spool/asterisk/voicemail/default/2951/temp

In fact, Asterisk will not play the regular messages either, but it recorded fine because I can play the wav if I extract the blob file.

App_voicemail.c: No origtime?!
#2

It’s a bug related to the MySQL ODBC driver.
I am using CentOS 7.5 and MariaDB
This post is talking about it: https://community.asterisk.org/t/app-voicemail-c-no-origtime/76129/10

I had to install version 8.0.11 from the MySQL archive to make it work:

https://downloads.mysql.com/archives/get/file/mysql-connector-odbc-8.0.11-1.el7.x86_64.rpm

#3

Thanks for the post, just ran into this myself with version 5.3.11. Downgrading to 5.3.10 fixed it.