[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

[John Kiniston]

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>