[Asterisk-Dev] voicemail not working with mysql!!!!

[Paul Cadach]

Hi,

1st - you have not specified dbpass parameter at section [general];
2nd - are you granted select and update(password) access to specified user?;
3rd - what Asterisk says when tries to connect to the database? What MySQL
records in logs when its started with log option?


WBR,
Paul.


----- Original Message -----
From: "atif" <atif at convergence.com.pk>
To: <asterisk-users at lists.digium.com>; <asterisk-dev at lists.digium.com>
Sent: Wednesday, February 25, 2004 6:25 PM
Subject: [Asterisk-Dev] voicemail not working with mysql!!!!


> I need some tips on configuration of voicemail with mysql...
>
> here is my voicemail.conf
>
> **************************voicemail.conf***************************
> [general]
> dbhost=localhost
> dbname=asteriskvmusers
> dbuser=root
>
> format=wav
> serveremail=asterisk
> attach=yes
> maxmessage=60
> maxgreet=60
> maxlogins=3
>
> [default]
> 1234 => 7654,Atif Rasheed,root at localhost
> **************************voicemail.conf***************************
>
> I have created the database"asteriskvmusers" in mysql and then created the
table 'users' in that database.
>
> mysql> select * from users;
>
+---------+---------+----------+--------------+----------------+-------+--------
-+----------------+
> | context | mailbox | password | fullname     | email          | pager |
options | stamp          |
>
+---------+---------+----------+--------------+----------------+-------+--------
-+----------------+
> | default | 1234    | 7654     | Atif Rasheed | root at localhost |       |
| 00000000000000 |
>
+---------+---------+----------+--------------+----------------+-------+--------
-+----------------+
>
> but it's not working...i mean when I change the passward through the zap
interface it is changed in the file 'voicemail.conf' but database is not
effected at all...
>
> one more thing which one is newer version....and has mysql support
> voicemail or voicemail2
>
> can someone figure out this...
> Thank you
>
>
>
> --
> Atif Rasheed
> Convergence (Buisness solutions)
> http://www.convergence.com.pk
> --
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
>