<!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>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></BODY></HTML>