Linux 4 All

Best Linux tricks source

Getting Plesk email accounts and passwords is quite easy. Here are few ways of doing that:

mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
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;

or

mysql -uadmin -p$(cat /etc/psa/.psa.shadow) -D psa 
SELECT mail_name,name,password FROM mail 
LEFT JOIN domains on mail.dom_id = domains.id 
INNER JOIN accounts where mail.account_id = accounts.id;"

or

/usr/local/psa/admin/bin/mail_auth_view

or

mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT CONCAT(mail_name,"@",name) as email_address,accounts.password FROM mail
LEFT JOIN domains on domains.id=mail.dom_id
LEFT JOIN accounts on accounts.id=mail.account_id;

Some queries might not work on all Plesk versions. From 11.5 upwards the passwords are encrypted, thus only /usr/local/psa/admin/bin/mail_auth_view will work.

Restrict a folder from executing PHP files arrow-right
Next post

arrow-left Script to get users on a RHEL system
Previous post

Leave a Reply

Your email address will not be published. Required fields are marked *