<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2745.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Answering my own question - after a few more hours
googling, the way to prevent users changing there voicemail password via the
voicemal "advanced options (0) menu", is described at:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://bugs.digium.com/bug_view_page.php?bug_id=0002386">http://bugs.digium.com/bug_view_page.php?bug_id=0002386</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>All thats required is to preceed voicemail pins
with a "-" character. When they try to change the password, they are just played
"No". Now If they want to change there voicemail password I can force them to do
it via a web interface, which will ensure the mysql db remains consistent with
the Voicemail app, including after a reload!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>Seems to be included as of CVS HEAD
<SPAN class=small>09-06-04</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Brad</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=brad@staff.pnc.com.au href="mailto:brad@staff.pnc.com.au">Brad
Hughes</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=asterisk-users@lists.digium.com
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, December 12, 2004 3:13
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Asterisk-Users] voicemail from
mysql / change password</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Im having a problem where I've just switched from
static configs to "realtime" configs stored in mysql</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It's all working fine (in terms of it reading the
configs and loading them as it should), except my problem is that if a user
changes there voicemail password via the "Advanced Options (0)" in the
Voicemail menu via there SIP phone, the password doesn't get updated in the
mysql database (like it used to in the static voicemail.conf file) - and
consequently the next time I reload asterisk, there voicemail password gets
reset back to whatever it was/is in the mysql database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Am I overlooking something, or is there an easy
solution? If I could just disable the change password option in Voicemail,
that'd be enough for me (and force them to change it via a web interface). Is
that do-able?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Here's the line from my
extconfig.conf:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>voicemail => mysql,asterisk,users</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>And the mysql users table schema:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Courier>CREATE TABLE users ( <BR>
context char(79) DEFAULT '' NOT NULL, </FONT><BR><FONT
face=courier> mailbox
char(79) DEFAULT '' NOT NULL, </FONT><BR><FONT
face=courier>
password char(79) DEFAULT '' NOT NULL,
</FONT><BR><FONT face=courier>
fullname char(79) DEFAULT '' NOT NULL,
</FONT><BR><FONT face=courier> email char(79)
DEFAULT '' NOT NULL, </FONT><BR><FONT face=courier>
pager char(79) DEFAULT '' NOT NULL, </FONT><BR><FONT
face=courier> options
char(159) DEFAULT '' NOT NULL, </FONT><BR><FONT
face=courier> stamp timestamp, </FONT><BR><FONT
face=courier> PRIMARY KEY (context,mailbox)
</FONT><BR><FONT face=courier>);</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Brad</FONT></DIV>
<P><FONT face=Arial size=2></FONT> </P></BLOCKQUOTE></BODY></HTML>