Plesk SQL Statements
When you need to find information about anything in Plesk, here’s some SQL statements that you can use:
Start out with:
# mysql -u admin -p`cat /etc/psa/.psa.shadow`
mysql> use psa;
Find all e-mail passwords:
select concat_ws(’@',mail.mail_name,domains.name),accounts.password from domains,mail,accounts where domains.id=mail.dom_id and accounts.id=mail.account_id order by domains.name ASC,mail.mail_name ASC;
Find e-mail passwords made out of only letters:
select concat_ws(’@',mail.mail_name,domains.name),accounts.password from domains,mail,accounts where domains.id=mail.dom_id and [...]
Texas1EMT
Texas1EMT
majorh at gmail
rackerhacker / +1-830-584-1564
rackerhacker