<div dir="ltr"><div>Have you tried using the table definition that comes with the Asterisk source?<br><br></div>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.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 3, 2016 at 3:10 AM, Michele Pinassi <span dir="ltr"><<a href="mailto:michele.pinassi@unisi.it" target="_blank">michele.pinassi@unisi.it</a>></span> wrote:<br><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>
Here's res_config_mysql.conf:<br>
<br>
<i>[default]</i><i><br>
</i><i>dbhost = 192.168.1.1</i><i><br>
</i><i>dbname = asterisk</i><i><br>
</i><i>dbuser = asterisk</i><i><br>
</i><i>dbpass = [xxxxx]</i><i><br>
</i><i>dbport = 3306</i><i><br>
</i><i>requirements=warn ; or createclose or createchar</i><i><br>
</i><br>
extconfig.conf:<br>
<br>
<i>[settings]</i><i><br>
</i><i>sipusers => mysql,default,sipusers</i><i><br>
</i><i>sippeers => mysql,default,sipusers</i><i><br>
</i><i>sipregs => mysql,default,sipregs</i><i><br>
</i><i>voicemail => mysql,default,vmusers</i><i><br>
</i><i>meetme => mysql,default,meetme</i><i><br>
</i><br>
on Asterisk console:<br>
<br>
<i>asterisk*CLI> realtime mysql status </i><i><br>
</i><i>default connected to <a href="mailto:asterisk@192.168.1.1" target="_blank">asterisk@192.168.1.1</a>, port 3306 with
username asterisk for 56 minutes.</i><i><br>
</i><i>asterisk*CLI> </i><br>
<br>
"vmusers" table on MySQL:<br>
<br>
<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 !<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><br clear="all"><br>-- <br><div class="gmail_signature">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.<br>---Heinlein</div>
</div>