[Asterisk-Users] voicemail.conf from DB

Iqbal iqbal at gigo.co.uk
Mon May 16 12:05:21 MST 2005


Hi

I have been playing with trying to get voicemail.conf from DB, I am 
using cvs-head, but when I start asterisk, it dies a horrible death, 
because it cant load any voicemil setting.

I looked at my mysql logs to see what query was being sent, and I get

SELECT category, var_name, var_val, cat_metric FROM voicemail_users 
WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, 
cat_metric desc, var_metric asc, category, var_name, var_val, id;

which is in no way related to the table I created following the example 
on the wiki.

Is there another table format , I have

+-------------+---------------+------+-----+---------+----------------+
| Field       | Type          | Null | Key | Default | Extra          |
+-------------+---------------+------+-----+---------+----------------+
| uniqueid    | int(11)       |      | PRI | NULL    | auto_increment |
| customer_id | int(11)       |      |     | 0       |                |
| context     | varchar(50)   |      |     |         |                |
| mailbox     | int(5)        |      | MUL | 0       |                |
| password    | varchar(4)    |      |     | 0       |                |
| fullname    | varchar(50)   |      |     |         |                |
| email       | varchar(50)   |      |     |         |                |
| pager       | varchar(50)   |      |     |         |                |
| stamp       | timestamp(14) | YES  |     | NULL    |                |
+-------------+---------------+------+-----+---------+----------------+


tks
Iqbal



More information about the asterisk-users mailing list