Thanks for your prompt response.
Below is the complete working logs and configuration if you can pinpoint the issues.
Server Description
Server OS Ubuntu 16.04.2 Server
root@ubuntu-lua:/var/kamailio/MOH# uname -a
Linux ubuntu-lua 4.4.0-64-generic #85-Ubuntu SMP Mon Feb 20 11:50:30 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
File Path and Permissions
root@ubuntu-lua:/var/kamailio/MOH# ls -l
-rwxr-xr-x 1 root root 42459 Mar 7 18:47 HeWillCall.alaw
-rw-r--r-- 1 root root 2103772 Apr 19 14:31 novanet.8.wav
Mysql description
Server version: 5.7.17-0ubuntu0.16.04.1 (Ubuntu)
mysql -u root -p
mysql> select * from mohqueues;
+----+-----------+-------------------------------------------+-------------------+------------+-------+
| id | name | uri | mohdir | mohfile | debug |
+----+-----------+-------------------------------------------+-------------------+------------+-------+
+----+-----------+-------------------------------------------+-------------------+------------+-------+
Modules Path
mpath="/usr/local/kamailio-5.0.1/lib64/kamailio/modules/"
# ----- queue desc -----
modparam("mohqueue", "db_url", DBURL)
modparam("mohqueue", "db_qtable", "mohqueues")
modparam("mohqueue", "db_ctable", "mohqcalls")
modparam("mohqueue", "mohdir", "/var/kamailio/MOH")
Kamailio Process
root@ubuntu-lua:/usr/local/kamailio-5.0.1/sbin# ps aux | grep kamailio
root 1958 0.1 1.4 175100 14672 ? S 16:27 0:00 /usr/local/kamailio-5.0.1/sbin/kamailio -P /var/run/kamailio.pid -f /usr/local/kamailio-5.0.1/etc/kamailio//kamailio.cfg
Syatem syslog
Apr 25 16:30:31 ubuntu-lua /usr/local/kamailio-5.0.1/sbin/kamailio[2274]: ERROR: mohqueue [mohq_db.c:504]: update_mohq_lst(): Queue,Field (operators,mohdir): Unable to find MOH files (/var/kamailio/MOH/novanet.8.*)!
Apr 25 16:30:31 ubuntu-lua /usr/local/kamailio-5.0.1/sbin/kamailio[2274]: ERROR: mohqueue [mohq_db.c:504]: update_mohq_lst(): Queue,Field (main,mohdir): Unable to find MOH files (/var/kamailio/MOH/HeWillCall.*)!