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 <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 - central...@unisi.it Per trovare una soluzione rapida ai tuoi problemi tecnici consulta le FAQ di Ateneo, http://www.faq.unisi.it
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
