<div dir="ltr"><div class="gmail_extra"><div><div class="gmail_signature">On 3 May 2016 at 11:10, Michele Pinassi <span dir="ltr"><<a href="mailto:michele.pinassi@unisi.it" target="_blank">michele.pinassi@unisi.it</a>></span> wrote:<br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hi all,<br>
<br>
i'm experiencing a really frustrating issue with my Asterisk 13.7.2
with realtime configuration on MySQL and Voicemail.<br>
<br><snip><br></div></blockquote><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div text="#000000" bgcolor="#FFFFFF">
<table style="border-collapse:collapse;color:rgb(68,68,68);font-family:sans-serif;font-size:13.12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<tbody>
<tr>
<th colspan="9" style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span></span><br>
</th>
</tr>
<tr>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">uniqueid</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">customer_id</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">context</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">mailbox</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">password</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">fullname</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">email</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">pager</a></span></th>
<th style="font-weight:bold;color:rgb(0,0,0);border-right-width:1px;border-right-style:solid;border-right-color:rgb(255,255,255);text-align:left;padding:0.3em;margin:0.1em;vertical-align:top;background:-webkit-linear-gradient(top,rgb(255,255,255),rgb(204,204,204))"><span style="display:block;overflow:hidden;margin-right:10px"><a href="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" style="text-decoration:none;color:rgb(35,90,129);outline:none" target="_blank">stamp</a></span></th>
</tr>
<tr style="text-align:left;background:rgb(255,255,255)">
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5002</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5002</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">default</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5002</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"></span>xxxx</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)">AAA<br>
</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><br>
</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;font-style:italic;text-align:right;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"><i>NULL</i></span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;white-space:nowrap;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">0000-00-00
00:00:00</span></td>
</tr>
<tr style="text-align:left;background:rgb(223,223,223)">
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5005</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5005</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">default</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5005</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"></span>xxxx</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">bbb</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><br>
</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;font-style:italic;text-align:right;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"><i>NULL</i></span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;white-space:nowrap;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">0000-00-00
00:00:00</span></td>
</tr>
<tr style="text-align:left;background:rgb(255,255,255)">
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5018</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5018</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">default</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5018</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"></span>xxxx</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">ccc</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><br>
</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;font-style:italic;text-align:right;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"><i>NULL</i></span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;white-space:nowrap;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">0000-00-00
00:00:00</span></td>
</tr>
<tr style="text-align:left;color:rgb(0,0,0);background:-webkit-linear-gradient(top,rgb(206,214,223),rgb(182,198,215))">
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5007</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5007</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">default</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">5007</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"></span>xxxx</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">sdddd</span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><br>
</td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;font-style:italic;text-align:right;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden"><i>NULL</i></span></td>
<td style="padding:0.3em;margin:0px 0px 12px;vertical-align:top;white-space:nowrap;border-right-width:1px;border-right-style:solid;border-right-color:rgb(187,187,187)"><span style="display:block;overflow:hidden">0000-00-00
00:00:00</span></td>
</tr>
</tbody>
</table>
<br>
*BUT* when i type, on Asterisk console:<br>
<i><br>
</i><i>asterisk*CLI> voicemail show zones </i><i><br>
</i><i>There are no voicemail zones currently defined</i><i><br>
</i><i>Command 'voicemail show zones ' failed.</i><i><br>
</i><i>asterisk*CLI> </i><br>
<br>
the same, of course, for "show users default". And whet i try to
access a mailbox, i get a "Invalid password".<br>
<br>
Any hints ? Please, i'm really frustrated !</div></blockquote><div><br></div><div>I think the mailbox field in MySQL needs to be in the form 'mailbox@context' in Asterisk 13.</div><div><br></div><div>As for your zones, these are usually defined in /etc/asterisk/voicemail.conf</div><div><br></div><div><br></div><div>Hope this helps.</div><div><br></div><div>-Barry Flanagan</div><div><br></div><div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div text="#000000" bgcolor="#FFFFFF"><span class="HOEnZb"><font color="#888888"><br>
<br>
Michele<br>
<br>
<pre cols="72">--
Michele Pinassi
Responsabile Telefonia di Ateneo
Servizio Reti, Sistemi e Sicurezza Informatica - Università degli Studi di Siena
tel: 0577.(23)5000 - <a href="mailto:centralino@unisi.it" target="_blank">centralino@unisi.it</a>
Per trovare una soluzione rapida ai tuoi problemi tecnici consulta le FAQ di Ateneo, <a href="http://www.faq.unisi.it" target="_blank">http://www.faq.unisi.it</a> </pre>
</font></span></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" rel="noreferrer" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div></div>