[asterisk-dev] Problem in Voicemail Database Connectivity

Mon Feb 19 05:44:52 MST 2007

I'm not sure, but I think DB user has no access to mysql tables. Try to
connect to mysql database from the command prompt and give grant options to
myuser.

Something like that:

shell> mysql --user=root mysql

If you have assigned a password to the root account, you'll also need to
supply a --password or -p
option for this mysql command and also for those later in this section.
After connecting to the server as root, you can add new accounts. The
following statements use

GRANT to set up four new accounts:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';

For Asterisk Voice mail you have to write something like
mysql> GRANT ALL PRIVILEGES ON Asterisk.Voicemail TO
'myuser'@'localhost' IDENTIFIED
BY 'mypass' WITH GRANT OPTION;

Note: In the example above Asterisk is a Database name and Voicemail is a
Voice mail table.

On 2/19/07, jamshed zaidi <jamshed_z at hotmail.com> wrote:
>
>
> 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/
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
>

-- 
Best Regards
Alexandr Olekhnovich
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20070219/661d016d/attachment.htm