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.pina...@unisi.it> wrote: > 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 > <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 > -- A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects. ---Heinlein
-- _____________________________________________________________________ -- 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