Listing email address and password in plesk
Written on 3:53 PM by David S Anand
FYI: This article is only for cutting down the resolving time of email issue in plesk.
to get the email address and password list login to shell via root
1. [root@shark03 ~]# cat /etc/psa/.psa.shadow
Thepass
2.[root@shark03 ~]# mysql -u admin -p
Enter password:
3. mysql> use psa;
4. SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id;
Run the above query all the email account with their respective password and
domain names will be displayed .
