[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

[Michele Pinassi]

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 at 192.168.1.1, port 3306 with username
asterisk for 56 minutes.//
//asterisk*CLI> /

"vmusers" table on MySQL:


uniqueid
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60uniqueid%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	customer_id
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60customer_id%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	context
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60context%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	mailbox
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60mailbox%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	password
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60password%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	fullname
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60fullname%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	email
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60email%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	pager
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60pager%60+ASC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>
	stamp
<http://voip.unisi.it/phpmyadmin/sql.php?db=asterisk&table=vmusers&sql_query=SELECT+%2A+FROM+%60vmusers%60%0AORDER+BY+%60vmusers%60.%60stamp%60+DESC&session_max_rows=25&token=81771f45cae5714ad1fac75365e0e494>

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

-- 
Michele Pinassi
Responsabile Telefonia di Ateneo
Servizio Reti, Sistemi e Sicurezza Informatica - Università degli Studi di Siena
tel: 0577.(23)5000 - centralino at unisi.it

Per trovare una soluzione rapida ai tuoi problemi tecnici consulta le FAQ di Ateneo, http://www.faq.unisi.it 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160503/61215a10/attachment.html>