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 find out all username and password

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by yatint, Sep 9, 2012.

  1. yatint

    yatint Basic Pleskian

    19
    60%
    Joined:
    Aug 2, 2010
    Messages:
    91
    Likes Received:
    0
    Hello,

    I am using windows server 2008 r2. Please 10.4. Please let me know how can I find out login details of all accounts . I want to migrate all my domains but facing some problem. so I am planning to create all accounts manually.

    Waiting for your reply.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
  3. yatint

    yatint Basic Pleskian

    19
    60%
    Joined:
    Aug 2, 2010
    Messages:
    91
    Likes Received:
    0
    Hello,

    Thanks for your reply..

    Can you tell me how to use API RPC. I am newbe in this...
     
  4. yatint

    yatint Basic Pleskian

    19
    60%
    Joined:
    Aug 2, 2010
    Messages:
    91
    Likes Received:
    0
    Hello,

    I am trying this query to find all username and password :

    SELECT domains.name AS domain_name,
    data_bases.name AS database_name, db_users.login, accounts.password
    FROM data_bases, db_users, domains, accounts
    WHERE data_bases.dom_id = domains.id
    AND db_users.db_id = data_bases.id
    AND db_users.account_id = accounts.id
    ORDER BY domain_name;

    But password is in sym format. is there any way to convert in plain text ?
    +
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
  6. yatint

    yatint Basic Pleskian

    19
    60%
    Joined:
    Aug 2, 2010
    Messages:
    91
    Likes Received:
    0
Loading...