Retrieve Horde passwords on Plesk Linux Server

1. Log in Via Shell using Putty

   

2. Gain access to mysql prompt

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

   

3. Select psa database

   use psa;

   

4. Display Email Users and Passwords

   select mail.mail_name, accounts.password from mail, accounts where mail.account_id = accounts.id;

   

You now have a list of all email users and their corresponding passwords.