Lookup mail passwords

[Amin Taheri]

Hi,

We're looking at a customer that we need to be able to look at their email passwords so we can migrate them off Plesk 9.5.4 Qmail to a completely homegrown email system - how can I retrieve their passwords - is that stored in the db somewhere?

 

[IgorG]

Try to use

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;

If password is crypted use

perl -MMIME::Base64 -le 'print decode_base64("$password")'

 

[Amin Taheri]

Thanks for that, I had to modify it slightly to add in a check to only return back the pop accounts
and postbox='true'

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "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 and postbox='true' order by name asc, mail_name asc; " > popmail.log

 

[MarkM]

Here's a little script i wrote a long time ago, upload to server and save as recover.php;

http://markmuyskens.com/dev/recover.txt