[asterisk-users] Storing Custom greeting VM in DB

[Ahmed Munir]

Hi all,

I configured the voicemail using realtime and for record voice messages,
I'm storing it in to MySQL DB as this setup works perfectly without any
issues.  Later I tried to insert the custom greeting (busy) for VM in DB
for particular extension, it was unable to play the custom greeting but
play the default prompt.

Even though, I created the folders (busy and unavail) in the
/var/spool/asterisk/voicemail/default/'1234567 directory, converted the
.wav file to 8KHz 16 bit mono,converted to .gsm format and using default
context for voicemail.  Listing down the data and query;

+----------+-------------+---------+------------+----------+----------+-------+-------+----+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+-----------+-----------+------------+
| uniqueid | customer_id | context | mailbox    | password | fullname |
email | pager | tz | attach | saycid | dialout | callback | review |
operator | envelope | sayduration | saydurationm | sendvoicemail | delete |
nextaftercmd | forcename | forcegreetings | hidefromdir |
stamp               | profile   | forwardno | queue_extn |
+----------+-------------+---------+------------+----------+----------+-------+-------+----+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+-----------+-----------+------------+
|     8475 | 0           | default | 1234567 |          |          |
|       | en | yes    | yes    |         |          | no     | no       |
no       | no          |            1 | no            | no     |
yes          | no        | no             | yes         | 2012-10-12
15:42:40 | voicemail | NULL      | NULL       |
+----------+-------------+---------+------------+----------+----------+-------+-------+----+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+-----------+-----------+----------

INSERT INTO voicemessages
(msgnum,dir,mailboxuser,mailboxcontext,recording)
VALUES
(-1,'/var/spool/asterisk/voicemail/default/'1234567/busy','1234567','default',LOAD_FILE('/var/spool/asterisk/voicemail/default/'1234567/busy.wav')),
(-1,'/var/spool/asterisk/voicemail/default/'1234567/unavail',''1234567','default',LOAD_FILE('/var/spool/asterisk/voicemail/default/'1234567/unavail.wav'));


Do I need to modify any other configuration? Please advise to resolve this
issue.

-- 
Regards,

Ahmed Munir Chohan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121012/73ea6cb2/attachment.htm>