Re: [asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

2016-05-03 Thread 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 
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 = [x]*
> *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
> 
> customer_id
> 
> context
> 
> mailbox
> 
> password
> 
> fullname
> 
> email
> 
> pager
> 
> stamp
> 
> 5002 5002 default 5002  AAA
>
> *NULL* -00-00 00:00:00
> 5005 5005 default 5005  bbb
> *NULL* -00-00 00:00:00
> 5018 5018 default 5018  ccc
> *NULL* -00-00 00:00:00
> 5007 5007 default 5007  s
> *NULL* -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 Ast

Re: [asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

2016-05-03 Thread Barry Flanagan 
On 3 May 2016 at 11:10, Michele Pinassi  wrote:

> Hi all,
>
> i'm experiencing a really frustrating issue with my Asterisk 13.7.2 with
> realtime configuration on MySQL and Voicemail.
>
> 
>


>
> uniqueid
> 
> customer_id
> 
> context
> 
> mailbox
> 
> password
> 
> fullname
> 
> email
> 
> pager
> 
> stamp
> 
> 5002 5002 default 5002  AAA
>
> *NULL* -00-00 00:00:00
> 5005 5005 default 5005  bbb
> *NULL* -00-00 00:00:00
> 5018 5018 default 5018  ccc
> *NULL* -00-00 00:00:00
> 5007 5007 default 5007  s
> *NULL* -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@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 - 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
>
-- 
_
-- 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

[asterisk-users] Asterisk 13 Realtime Voicemail frustrating issue

2016-05-03 Thread Michele Pinassi 
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 = [x]//
//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

customer_id

context

mailbox

password

fullname

email

pager

stamp


50025002default 5002AAA

/NULL/  -00-00 00:00:00
50055005default 5005bbb 
/NULL/  -00-00 00:00:00
50185018default 5018ccc 
/NULL/  -00-00 00:00:00
50075007default 5007s   
/NULL/  -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