View email account password on plesk

View email account password on plesk server. (doesnt work for me with plesk 11 security update)

Just change the domain.

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name), '-',accounts.Password FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id where domains.name like '%DOMAIN.COM%';"

All accounts

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name), '-',accounts.Password FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id;"

There are many ways this can be done also

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

use psa

View all accounts on the server

SELECT mail.mail_name, domains.name from mail LEFT OUTER JOIN domains ON domains.id = mail.dom_id;

Find 1 account with username/domain

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 where mail.mail_name = 'email account(e.g info)' and domains.name = 'domain' INTO OUTFILE 'file_name';

Like the first one but done from within mysql

SELECT CONCAT_WS('@',mail.mail_name,domains.name), accounts.Password FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id where domains.name like '%domain.com%';