Realtime in remote SQL instance, MOH in V11.7.0 not working

Hi all,

I understand that support for V11.7.0 has been discontinued however I have an issue that I need to hopefully get resolved as I cannot upgrade to the latest version at this time.

I’m running realtim config through my prod environment and everything (queues, sip_conf, etc) works really well but MOH seems to be giving issues. If I load the MOH realtime from a local MYSQL instance I can get the files to load etc, however when trying to use my DB’s on a remote server (Same server sip_conf, queue_table, queue_member_table etc are located) it doesn’t load at all.

Wondering if anyone has experienced this before and how they resolved it? I’m running asterisk in Ubuntu 14.04.3 LTS and using Mysql v 5.7.19.

MOH table is :

±------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±------------±-------------±-----±----±--------±------+
| id | int(5) | NO | | 0 | |
| name | varchar(80) | NO | | NULL | |
| directory | varchar(255) | NO | | | |
| application | varchar(255) | NO | | | |
| mode | varchar(10) | YES | | files | |
| digit | char(1) | NO | | | |
| sort | varchar(16) | NO | | | |
| format | varchar(16) | NO | | | |
| random | varchar(3) | YES | | yes | |
±------------±-------------±-----±----±--------±------+

musiconhold.conf:

[general]
cachertclasses=yes ; use 1 instance of moh class for all users who are using it,
; decrease consumable cpu cycles and memory
; disabled by default
[default]
mode=files
directory=moh/default

extconfig:

musiconhold => mysql,general,musiconhold