List all FTP accounts under Plesk on Linux server

Very often as a tech I am receiving technical issues on VPS, dedicated servers with many customers which do not have their credentials. For example if you are reseller and the issue is obvious and you have reported it without the customer’s FTP password. All the rest credentials (root, Plesk admin) are present.
Well, you have them, but how without resetting the FTP account password to check whether the FTP is working. If you change such password some scripts (forms) using FTP will stop.

In such case, instead of wasting time asking the customer password, escalating the frustration from the not working service, you can use MySQL command which will list all FTP accounts under Plesk on Linux server.

First login to the server with user who has access to ‘MySQL’. Usually this is ‘root’, but depending on the setup of the server it could be different.

To access the Plesk database in order to collect the Plesk FTP passwords, use the Plesk administrator(admin) account.

To make sure that you are going to use the correct Plesk database, list the databases and make active the ‘psa’ one.

Now to list all Plesk FTP accounts, use the command in the next field.
I must tell that this command is working on current Plesk Linux versions as well as Plesk 8+.

The above is not so copy and paste friendly, so you can use this one line MySQL command to view the Plesk FTP passwords.

The result will show all available Plesk FTP accounts inside the ‘psa’ database.
It will look like this:

In case you have only root password, you can view Plesk admin password on Linux server

Tags

Filed Under: Plesk Control Panel

Anthony Gee About the Author: Anthony G. is an IT specialist with more than 9 years of solid working experience in the Web Hosting industry. Currently works as server support administrator, involved in consultative discussions about Web Hosting and server administration. One of the first writers in the Onlinehowto.net website, now writing for Free Tutorials community - he is publishing tutorials and articles for the wide public, as well as specific technical solutions.

Comments (4)

  1. Evangele says:

    Cheers mate! Great tutorial!

  2. Tony says:

    One line execution:

    mysql -uadmin -p cat /etc/psa/.psa.shadow -Dpsa -e”SELECT REPLACE(sys_users.home,’/home/httpd/vhosts/’,”) AS domain, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts on sys_users.account_id=accounts.id ORDER BY sys_users.home ASC;”

  3. Andy Crow says:

    Very nice ! I presume you may steal this passwords in this way.

  4. Tony says:

    Yes, you could do that if you have the conscience and … the root password

Leave a Reply