In Plesk, passwords are stored in “psa” database and it is easy to retrieve the passwords using Mysql queries. Given below are the steps to retrieve email account’s password and FTP account’s password for a domain.

Get Email account passwords per dominio

1. Login al server via SSH;
2. Login al prompt Mysql:

   mysql -u admin -p`cat /etc/psa/.psa.shadow`

3. Passare al database psa:

   use psa;

4. Eseguire la query seguente per recuperare tutte le password email di un determinato dominio:

   SELECT accounts.id, mail.mail_name, accounts.password, domains.name, domains.id, mail.dom_id, mail.account_id FROM domains, mail, accounts Where domains.id = mail.dom_id and mail.account_id = accounts.id and domains.name ='DOMAIN_NAME';

UPDATE

Per le nuove versioni di Plesk lanciare:

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

Get FTP account passwords per dominio

1. Seguire gli step 1., 2., 3. come sopra;
2. Eseguire la query seguente per recuperare la password  ftp di un determinato dominio:

   SELECT login AS FTP_USER,password AS FTP_PASS,home AS DOMAIN_ROOT,accounts.id,sys_users.account_id FROM accounts, sys_users WHERE accounts.id=sys_users.account_id AND home='/var/www/vhosts/DOMAIN_NAME';

Mysql_Queries_to_retrieve_email_accounts_password_FTP_password_in_Linux__Plesk_server