The details provided were helpful in identifying the problem.  According to the documentation (http://kamailio.org/docs/modules/4.4.x/modules/mohqueue.html#mohqueues.dbase) the file name in the database should be the "the base name of the audio file".  This wording could be misunderstood and should probably be clarified.  It means that if you want to use PCMA/8000 (alaw) audio files and you want to use a base name of "novanet", the mohdir directory needs to contain a file called novanet.8 and the database mohfile field would be "novanet".

I will look into clarifying this wording and providing examples to assist other users.

On Tue, Apr 25, 2017 at 7:08 AM, santosh gupta <santosh.gupta.g@gmail.com> wrote:
Hi,


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 |
+----+-----------+-------------------------------------------+-------------------+------------+-------+
|  1 | operators | sip:main@192.168.2.6;maddr=203.153.53.130 | /var/kamailio/MOH | novanet.8  |     6 |
|  2 | main      | sip:main@192.168.2.6                      | /var/kamailio/MOH | HeWillCall |     1 |
+----+-----------+-------------------------------------------+-------------------+------------+-------+




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.*)!







On Tue, Apr 25, 2017 at 1:35 AM, Robert Boisvert <rdboisvert@gmail.com> wrote:
Santosh,

Looks like you didn't include the mohdir information (see http://kamailio.org/docs/modules/4.4.x/modules/mohqueue.html#dir.parms) or there are no files in that directory.

BTW, I rarely use this email address so please address your questions to sr-users@lists.kamailio.org.

Hope this helps,
Bob

On Thu, Apr 20, 2017 at 11:26 AM, santosh gupta <santosh.gupta.g@gmail.com> wrote:
HI,

Was working on Kamailio for MohQueue n getting the below error.
Let me know if you can help me.

I had already checked everything.
1. Files are located in proper directory.
2. Files are having proper permissions.
3. Database is having proper tables.
4. Tried many versions of Kamailio i.e 4.4,5.0 also 5.0.1

ERROR: mohqueue [mohq_db.c:504]: update_mohq_lst(): Queue,Field (operators,mohdir): Unable to find MOH files

--------------------
With Regards
Santosh Gupta
+91 9323043570




--
--------------------
With Regards
Santosh Gupta
+91 9323043570