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

Lookup Domain Passwords

Discussion in 'Plesk for Linux - 8.x and Older' started by b-nut, Aug 16, 2006.

  1. b-nut

    b-nut Guest

    I have a script that I created to lookup domain(ftp) passwords for support purposes. The script was designed for plesk 7 but I recently migrated to a plesk 8 box and the script no longer works. The structure of the PSA database has changed and now I don't know how to lookup the passwords in the Plesk 8 database. It seems that the passwords are now stored in a different table in BLOB format and I don't know how to retrieve them.

    Here is the query that I used on Plesk 7:
    $SQL "SELECT d.name, d.cl_id, s.login, a.password, c.login as client_login, c.passwd as client_password
        FROM domains d, hosting h, sys_users s, accounts a, clients c
        WHERE d.id = h.dom_id 
        AND s.id = h.sys_user_id 
        AND a.id = s.account_id 
        AND c.id = d.cl_id
        AND d.name = '
    Does anyone know how to restructure this query for plesk 8?