[Asterisk-Users] voicemail from mysql / change password

[Brad Hughes]

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 at 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