How to retrieve the email account password (Plesk + Qmail) ?
We can reset the password of the accounts from Plesk panel easily as follows.
Plesk Control Panel >> Domains >> Select the domain >> Mail Accounts >> Click on the account >> Change the password >> Save
You can retrieve the current password of an email account in plesk, from the psa database as follows.
1. Login to mysql
mysql -u admin -p`cat /etc/psa/.psa.shadow`
2. select the psa database
use psa;
3. list the accounts (Its a one line command do not split)
SELECT mail.mail_name, accounts.password, domains.name FROM mail, accounts,
domains WHERE domains.id=mail.dom_id AND mail.account_id=accounts.id;