[asterisk-bugs] [Asterisk 0016718]: Unable to link Voicemail to voicemail accounts created using MySQL

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16718 
====================================================================== 
Reported By:                jehanzeb
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16718
Category:                   Applications/app_voicemail
Reproducibility:            always
Severity:                   feature
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.0 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-01-27 11:02 CST
Last Modified:              2010-01-28 01:51 CST
====================================================================== 
Summary:                    Unable to link Voicemail to voicemail accounts
created using MySQL
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
====================================================================== 

---------------------------------------------------------------------- 
 (0117287) wdoekes (reporter) - 2010-01-28 01:51
 https://issues.asterisk.org/view.php?id=16718#c117287 
---------------------------------------------------------------------- 
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.so 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 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-28 01:51 wdoekes        Note Added: 0117287                          
======================================================================