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

How to reveal ftp passwords

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

  1. MariosM

    MariosM Guest

    0
     
    Hello,

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

    I yse this one

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

    Any suggestion ?
     
  2. Loeffel

    Loeffel New Pleskian

    19
     
    Joined:
    Aug 2, 2009
    Messages:
    3
    Likes Received:
    0
    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.
     
  3. figjam

    figjam New Pleskian

    22
    57%
    Joined:
    Mar 28, 2007
    Messages:
    19
    Likes Received:
    0
  4. MariosM

    MariosM Guest

    0
     
    Loeffel , thank you for your answer,

    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 :(
     
  5. MariosM

    MariosM Guest

    0
     
  6. phoenixisp

    phoenixisp Silver Pleskian

    27
    57%
    Joined:
    Feb 2, 2002
    Messages:
    840
    Likes Received:
    0
Loading...