• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Retrieving Domain/Client Passwords

T

troy.porter

Guest
can anyone help me out with a query that i can use to retrieve my clients' domain FTP passwords

...and also one to retrieve thier plesk admin password (client password)


i am running PLESK 7.1


thanks much!!!


PS. I know about Powertools but i dont want to have to install anything..i just need the passwords
 
make a script for eg "my_users.sh"

and put this inside :

echo "select d.name, c.login, a.password from accounts a, clients c, domains d where a.id=c.account_id and d. cl_id=c.id order by d.name, c.login;" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa


Then run :
./users.sh |grep domain.tld

I hope it will work for you cause it works for me!
 
Originally posted by ZaNaToS
make a script for eg "my_users.sh"

and put this inside :

echo "select d.name, c.login, a.password from accounts a, clients c, domains d where a.id=c.account_id and d. cl_id=c.id order by d.name, c.login;" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa


Then run :
./users.sh |grep domain.tld

I hope it will work for you cause it works for me!


this works fine...but what about a query for the FTP passwords also.....and even the mail names as well???

thank you in advance...
 
hey can someone plzzzz help me out...i still urgently need the query to get the FTP passwords and the mailname passwrds!!!
 
Back
Top