[Asterisk-Users] voicemail from mysql / change password

[Matthew Boehm]

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 at staff.pnc.com.au>
To: <asterisk-users at 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 at 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