Get Plesk e-mail addresses and passwords

Need a handy way to list all the email accounts and their passwords?

select CONCAT(mail_name,"@",name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;

This entry was posted on 01/02/2007 (Thursday) at 8:33 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.
Printed from: http://rackerhacker.com/2007/02/01/get-plesk-e-mail-addresses-and-passwords/ .
© Major Hayden 2012.

6 Comments   »

  • ghosti says:
    03.02.09 at 04:58

    but.... how to show password in plain text? thanks a lot....

  • Joel says:
    25.05.09 at 00:36

    Just stumbled across this article and thought I'd share my own quick fix to display the mailbox password. Modify the SQL query to the following:

    select CONCAT(mail_name,"@",name) as email_address, substring(accounts.password, '1') from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;

    There's probably a more elegant solution but this seems to work :-)

  • Richard says:
    27.07.09 at 05:02

    Beautiful major & Joel

  • shawnkltucker says:
    03.12.09 at 12:47

    Very Handy, Thanks.

  • Muharrem says:
    22.07.10 at 19:32

    Hello;

    Thanks for tip. I want ask question about email passwords. I need see password with md5 on mysql database this is possible ?

    Thanks Muharrem

  • Karl says:
    09.05.11 at 02:09

    Muharrem would this help:

    select CONCAT(mail_name,"@",name) as email_address, md5(substring(accounts.password, '1')) from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;


RSS feed for comments on this post

Leave a Reply

 

  • Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you find the information useful. If you spot something that's incorrect or confusing, please write a comment and let me know. Drop me a line if there's something you want to know more about and I'll do my best to write a post on the topic.
    -- Major Hayden

    Flattr this