How to reveal ftp passwords

[MariosM]

Hello,

I'm trying to make a sql query to reveal ftp passwords of plesk.

I yse this one

SELECT d.name, s.login, a.password
FROM domains d, sys_users s, accounts a, clients cl
WHERE a.id=s.account_id
AND cl.id=d.id
AND d.cl_id=cl.id
ORDER BY d.name, s.login;

it shows the logins and passwords but it shows the same domain again and again.

Any suggestion ?

 

[Loeffel]

Hi,

your WHERE clause doesn't connect the tables, so that you will get a unique entry for every row. Your SELECT statement shows all possible ways.

You must connect those tables with a INNER JOIN clause, so that they will be evaluated depending on each other.
But there is a mistake in your thinking, so I can't translate it.

You read the tables domains, sys_users, accounts and clients.

domains is connected to clients (cl_id <=> id)
accounts is connected to sys_users (id <=> account_id)

but where is the missing connection?
I think it is clients to sys_users (via sys_users_id <=> id)??

Haven't looked into the tables by now.

 

[figjam]

Try this: http://forum.parallels.com/showpost.php?p=351952&postcount=5

pleskhacker.com is probably my favourite site for plesk database info and has a few canned queries as well. i.e. http://pleskhacker.com/sql-queries/get-ftp-account-passwords/

 

[MariosM]

Loeffel , thank you for your answer,

Hi,
but where is the missing connection?
I think it is clients to sys_users (via sys_users_id <=> id)??

I cant find any connection between sys_users and clients,
I take a client for example , and between these two tables, all the columns of this client are totaly different,
not any sinle ID or any other number matches

 

[MariosM]

thank you very much, the links are very helpful!

Try this: http://forum.parallels.com/showpost.php?p=351952&postcount=5

pleskhacker.com is probably my favourite site for plesk database info and has a few canned queries as well. i.e. http://pleskhacker.com/sql-queries/get-ftp-account-passwords/

 

[phoenixisp]

Have you checked out Power Toys for Plesk?

http://www.web-hosting-control-panel-addons.com/