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

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
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-27 11:02 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
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-27 11:02 jehanzeb       New Issue                                    
2010-01-27 11:02 jehanzeb       Asterisk Version          => 1.6.2.0         
2010-01-27 11:02 jehanzeb       Regression                => No              
2010-01-27 11:02 jehanzeb       SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================