[asterisk-dev] Problem in Voicemail Database Connectivity

Mon Feb 19 05:29:31 MST 2007

Hi Guys, I am new to asterisk development. I am facing real problems in 
accessing voicemail contents like its password, username etc.... I am 
writing the perl script for web interface that will reset the the password 
of voicemail from mysql database as  commedian voicemail does change it in 
asterisk.  I am facing list of problems

1). How do i enable mysql support for voicemail in Asterisk1.4.0. For this i 
have gone through the following article
http://www.voip-info.org/wiki/view/Asterisk+voicemail+database
but i didnt find "mysql-vm-routines.h"  in asterisk-addonns-1.4.0.

i updated my voicemail.conf file with
dbuser=myuser
dbname=asterisk
dbpass=mypass
dbhost=localhost

when i run my following perl script
my $DB_Name="asterisk";
my $DB_Host= "127.0.0.1";
my $DB_User="myuser";
my $DB_Pass="mypass";

my $dbh = DBI->connect("DBI:mysql:$dbname=$DB_Name","$DB_User","$DB_Pass");
my $sth = $dbh->prepare(qq{select fullname,context from voicemail where 
mailbox='1234' and password='1234' and context='[default]'});

THEN IT SHOWS THE FOLLOWING ERROR

"DBI connect('=asterisk','myuser',...) failed: Access denied for user 
'myuser'@'localhost' (using password: YES) at resetPass.pl line 15
Can't call method "prepare" on an undefined value at resetPass.pl line 16, 
<STDIN> line 1."

Please reply me as soon as possible.....thanx in advance

<html><div><PRE class=quote><IMG height=2 
src="http://graphics.hotmail.com/greypixel.gif" width="100%" 
vspace=9></PRE><PRE class=quote><FONT face="Courier New, Courier, Monospace" 
color=#000033 size=2>Syed Jamshed Zaidi
<BR>Asterisk Admin/Developer
<BR>@ Axvoice +92-0321-4087492
<BR>(JAMY-VIRUS)</FONT></PRE><PRE class=quote><PRE class=quote><FONT 
face="Courier New, Courier, Monospace" color=#000033 size=2>"Shoot for the 
moon. Even if you miss, you'll land among the 
stars"</FONT></PRE></PRE></div></html>

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.com/