[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

[Barry Flanagan]

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>