Michele Pinassi
2016-May-03 10:10 UTC
[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue
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>
Barry Flanagan
2016-May-03 10:20 UTC
[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue
On 3 May 2016 at 11:10, Michele Pinassi <michele.pinassi at 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. > > <snip> >> > 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 ! >I think the mailbox field in MySQL needs to be in the form 'mailbox at context' in Asterisk 13. As for your zones, these are usually defined in /etc/asterisk/voicemail.conf Hope this helps. -Barry Flanagan> > 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 > > > -- > _____________________________________________________________________ > -- 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160503/13e195f8/attachment.html>
John Kiniston
2016-May-03 18:39 UTC
[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue
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 at 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 at 192.168.1.1 <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 > > > -- > _____________________________________________________________________ > -- 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160503/8c789a62/attachment.html>