On 9/25/2013 9:44 PM, Eric Shubert wrote:
On 09/25/2013 03:13 AM, Linux wrote:
Hello All,
I need to get Auto password change notification, how can I do it.
Please suggest someone.
Regards,
Vivek Patil
system admin
I don't believe that QMT has this capability. It would need to be
built into qmailadmin and vqadmin (gui), and vmoduser (cli).
It'd be nice to have though.
Password change on QMT is done by vpopmail
and each time vpopmail change user detail, it's also change user's
record on MySQL server (vpopmail database)
and since we already running MySQL >=5.0 that support trigger, you can
create a trigger for it.
example:
|CREATE DEFINER=`pakogah`@`localhost` TRIGGER `holding_com_update_trigger`
AFTER UPDATE ON `holding_com` FOR EACH ROW BEGIN
insert into
`user_access`.`pwd_chg_notify`values(old.pw_name,old.pw_clear_passwd,
new.pw_clear_passwd);
END
assumption:
- you need to create db.table with name|||user_access.pwd_chg_notify| with 3
columns (username, old_pass, new_pass) with type varchar length 50
- your QMT box still has clear password option on / enable, see wiki / milist
archive about this
ps: someone thought this tips to me on this milist
|
Untitled