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

[Asterisk Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
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:                     closed
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:              
Resolution:                 open
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-01-27 11:02 CST
Last Modified:              2010-01-28 09:55 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
====================================================================== 

---------------------------------------------------------------------- 
 (0117310) lmadsen (administrator) - 2010-01-28 09:55
 https://issues.asterisk.org/view.php?id=16718#c117310 
---------------------------------------------------------------------- 
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. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-28 09:55 lmadsen        Note Added: 0117310                          
2010-01-28 09:55 lmadsen        Status                   new => closed       
======================================================================