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, 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