Michael MacDonald
Basic Pleskian
Greetings:
How do I structure a query to return the FTP passwords for all the hosted domains on my Plesk server? I have the query string for mail and domain accounts. I would like to be able to query for FTP passwords as well.
Example below returns mail passwords:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select d.name, m.mail_name, a.password from domains d, accounts a, mail m where d.id=m.dom_id and m.account_id=a.id;"
I need the same thing for FTP passwords.
Thank you.
How do I structure a query to return the FTP passwords for all the hosted domains on my Plesk server? I have the query string for mail and domain accounts. I would like to be able to query for FTP passwords as well.
Example below returns mail passwords:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select d.name, m.mail_name, a.password from domains d, accounts a, mail m where d.id=m.dom_id and m.account_id=a.id;"
I need the same thing for FTP passwords.
Thank you.