Change password via browser

[redcarrot]

Hi

I'm using Atmail (www.atmail.com) as a drop in replacement for horde.

I'd like to write a password change script so that customers do not need to log in to Horde or the Plesk control panel in order to change their email passwords.

I have found the user passwords in MySQL > psa > accounts, but if I change these passwords it appears to have no effect.

Are the passwords also stored somewhere else? Or do I need to restart Plesk, or something?

Charlotte

 

[unika]

All passwords really stored in mysql_database:
#/usr/bin/mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

Get all mailnames with their passwords that belong to domain.tld:

>SELECT d.name, m.mail_name, a.password FROM domains d, accounts a, mail m WHERE d.id=m.dom_id AND m.account_id=a.id AND d.name='domain.tld';

Get domain.tld domain level user password:

SELECT d.name, a.password FROM domains d, dom_level_usrs du, accounts a WHERE d.id=du.dom_id AND du.account_id=a.id AND d.name='domain.tld';


Also I do not recommend you changing them in database!!!!

There are special utilities to perform it (in case you want to write scripts):

/usr/local/psa/bin/domain --help
/usr/local/psa/bin/mail --help

 

[tiramisu]

absolutely agree with unika