VoIP Mailing List Archives

[michele.pinassi at uni...]

Hi all,

i'm experiencing a really frustrating issue with my Asterisk 13.7.2 with realtime configuration on MySQL and Voicemail.

Here's res_config_mysql.conf:

[default]
dbhost = 192.168.1.1
dbname = asterisk
dbuser = asterisk
dbpass = [xxxxx]
dbport = 3306
requirements=warn ; or createclose or createchar

extconfig.conf:

[settings]
sipusers => mysql,default,sipusers
sippeers => mysql,default,sipusers
sipregs => mysql,default,sipregs
voicemail => mysql,default,vmusers
meetme => mysql,default,meetme

on Asterisk console:

asterisk*CLI> realtime mysql status
default connected to asterisk@192.168.1.1 (asterisk@192.168.1.1), port 3306 with username asterisk for 56 minutes.
asterisk*CLI>

"vmusers" table on MySQL:


uniqueid customer_id context mailbox password fullname email pager stamp 5002 5002 default 5002 xxxx AAA

NULL 0000-00-00 00:00:00 5005 5005 default 5005 xxxx bbb
NULL 0000-00-00 00:00:00 5018 5018 default 5018 xxxx ccc
NULL 0000-00-00 00:00:00 5007 5007 default 5007 xxxx sdddd
NULL 0000-00-00 00:00:00
*BUT* when i type, on Asterisk console:

asterisk*CLI> voicemail show zones
There are no voicemail zones currently defined
Command 'voicemail show zones ' failed.
asterisk*CLI>

the same, of course, for "show users default". And whet i try to access a mailbox, i get a "Invalid password".

Any hints ? Please, i'm really frustrated !

Michele

[barryf-lists at flanag...]

On 3 May 2016 at 11:10, Michele Pinassi <michele.pinassi@unisi.it (michele.pinassi@unisi.it)> wrote:

[johnkiniston at gmail.com]

Have you tried using the table definition that comes with the Asterisk source?


the file mysql_config.sql is located in contrib/realtime/mysql and defines a very different voicemail table than what you have in your configuration.


On Tue, May 3, 2016 at 3:10 AM, Michele Pinassi <michele.pinassi@unisi.it (michele.pinassi@unisi.it)> wrote: