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

Retrieve Email password -Plesk 9.5

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by ethanielc, Mar 30, 2011.

  1. ethanielc

    ethanielc New Pleskian

    17
    35%
    Joined:
    Mar 22, 2011
    Messages:
    12
    Likes Received:
    0
    Hi,

    When i tried to execute queries to retrieve email password from psa Database, it shows:

    SELECT mail.mail_name, accounts.password FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id WHERE domains.name = 'yourdomain.com';

    Result:

    | user01 | $1$dPmvBeIP$.DetKbwrYs6xxxxxxxx/ |

    For some reason some email password is displayed correctly but some not(as above). Is the password stored in plain text or encrypted format? Or the query is incorrect? Please advise.
     
Loading...