Im having a problem where I've just switched from static configs to "realtime" configs stored in mysql 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. 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? Here's the line from my extconfig.conf: voicemail => mysql,asterisk,users And the mysql users table schema: CREATE TABLE users ( context char(79) DEFAULT '' NOT NULL, mailbox char(79) DEFAULT '' NOT NULL, password char(79) DEFAULT '' NOT NULL, fullname char(79) DEFAULT '' NOT NULL, email char(79) DEFAULT '' NOT NULL, pager char(79) DEFAULT '' NOT NULL, options char(159) DEFAULT '' NOT NULL, stamp timestamp, PRIMARY KEY (context,mailbox) ); Thanks Brad -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20041211/48177833/attachment.htm
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:
http://bugs.digium.com/bug_view_page.php?bug_id=0002386
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!
Seems to be included as of CVS HEAD 09-06-04
Brad
----- Original Message -----
From: Brad Hughes
To: asterisk-users@lists.digium.com
Sent: Sunday, December 12, 2004 3:13 AM
Subject: [Asterisk-Users] voicemail from mysql / change password
Im having a problem where I've just switched from static configs to
"realtime" configs stored in mysql
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.
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?
Here's the line from my extconfig.conf:
voicemail => mysql,asterisk,users
And the mysql users table schema:
CREATE TABLE users (
context char(79) DEFAULT '' NOT NULL,
mailbox char(79) DEFAULT '' NOT NULL,
password char(79) DEFAULT '' NOT NULL,
fullname char(79) DEFAULT '' NOT NULL,
email char(79) DEFAULT '' NOT NULL,
pager char(79) DEFAULT '' NOT NULL,
options char(159) DEFAULT '' NOT NULL,
stamp timestamp,
PRIMARY KEY (context,mailbox)
);
Thanks
Brad
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20041211/accebaf9/attachment.htm
Matthew Boehm
2004-Dec-13 07:53 UTC
[Asterisk-Users] voicemail from mysql / change password
Have you examined your debug log for a possible SQL error? Updating user passwords works fine on our systems. There should be no need to force anyone to do it a certain way. -Matthew ----- Original Message ----- From: "Brad Hughes" <brad@staff.pnc.com.au> To: <asterisk-users@lists.digium.com> Sent: Saturday, December 11, 2004 10:13 AM Subject: [Asterisk-Users] voicemail from mysql / change password Im having a problem where I've just switched from static configs to "realtime" configs stored in mysql 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. 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? Here's the line from my extconfig.conf: voicemail => mysql,asterisk,users And the mysql users table schema: CREATE TABLE users ( context char(79) DEFAULT '' NOT NULL, mailbox char(79) DEFAULT '' NOT NULL, password char(79) DEFAULT '' NOT NULL, fullname char(79) DEFAULT '' NOT NULL, email char(79) DEFAULT '' NOT NULL, pager char(79) DEFAULT '' NOT NULL, options char(159) DEFAULT '' NOT NULL, stamp timestamp, PRIMARY KEY (context,mailbox) ); Thanks Brad ---------------------------------------------------------------------------- ----> _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users