[Home]

Summary:ASTERISK-15532: Unable to link Voicemail to voicemail accounts created using MySQL
Reporter:Jehanzeb Mansoor (jehanzeb)Labels:
Date Opened:2010-01-27 11:02:53.000-0600Date Closed:2011-06-07 14:00:29
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Applications/app_voicemail
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:Hi, I am trying to setup a voicemail server using Asterisk 1.6.2.0. My issues is i need to manage voicemail accounts using mySQL (something i used to do in the past using pre 1.4 version. I have created a database named asteriskvm with a table name users which i have populated with the required fields i.e.

+----------+-----------+------+-----+-------------------+-----------------------------+
| Field    | Type      | Null | Key | Default           | Extra                       |
+----------+-----------+------+-----+-------------------+-----------------------------+
| context  | char(79)  | NO   | PRI | NULL              |                             |
| mailbox  | char(79)  | NO   | PRI | NULL              |                             |
| password | char(79)  | NO   |     | NULL              |                             |
| fullname | char(79)  | NO   |     | NULL              |                             |
| email    | char(79)  | NO   |     | NULL              |                             |
| pager    | char(79)  | NO   |     | NULL              |                             |
| options  | char(159) | NO   |     | NULL              |                             |
| stamp    | timestamp | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+----------+-----------+------+-----+-------------------+-----------------------------+
I have also configured the voicemail.conf file as follows

[general]

dbuser = asteriskvm
dbpass = e1ncnrrb
dbhost = localhost
dbname = asteriskvm

My problem is i am still unable to make asterisk recognize a voicemail account even though there is an entry in the SQL database for the voicemail account.

Please can you help

Regards,
Jehanzeb
Comments:By: Walter Doekes (wdoekes) 2010-01-28 01:51:32.000-0600

You need to configure database support properly first: those database config values shouldn't be voicemail.conf.

Set up extconfig.conf and the appropriate database engine (res_config_mysql.conf in your case) first.

Then start asterisk using "asterisk -c" and check for warnings or errors regarding your database connection.

See also:
http://www.voip-info.org/wiki/view/Asterisk+RealTime
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail


By: Leif Madsen (lmadsen) 2010-01-28 09:55:05.000-0600

This is a support issue, and not a bug report. Please utilize the appropriate support forums, such as asterisk-users mailing list, or the #asterisk IRC channel on the Freenode network.