1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

sql query to find out ftp passwords

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by M.MARAVELIASD, Aug 8, 2009.

  1. M.MARAVELIASD

    M.MARAVELIASD Guest

    0
     
    Hello,

    I'm trying to make a query to see the passwords of some ftp accounts (for client's reminder).

    I'm using this query:

    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;

    the login and passwords are correct, but the same domain keeps appearing..

    any help?
     
  2. HrachT

    HrachT Guest

    0
     
    Hi,
    Here is query to find ftp password for "domain.tld":

    select login,password from sys_users join accounts on (account_id=accounts.id) where login=(select login from clients where clients.id=(select cl_id from domains where displayName='domain.tld'));
     
Loading...