{"id":86,"date":"2009-09-27T15:19:39","date_gmt":"2009-09-27T19:19:39","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=86"},"modified":"2013-03-20T08:39:37","modified_gmt":"2013-03-20T12:39:37","slug":"howto-retrieve-email-account-passwords","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/howto-retrieve-email-account-passwords","title":{"rendered":"HowTo: retrieve email account passwords in Plesk?"},"content":{"rendered":"<p>Plesk uses a database called &#8216;psa&#8217; to save all the details about the domains, settings, users and their passwords in plain text. A person with root access to the server can easily <span style=\"color: #000000;\"><strong>retrieve email account passwords in a Plesk server<\/strong><\/span> from the Mysql prompt.<\/p>\n<p>SSH to the server and connect to the Mysql server<\/p>\n<blockquote>\n<pre><span style=\"color: #0000ff;\"># mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/span><\/pre>\n<\/blockquote>\n<p>At the mysql prompt, goto the &#8216;psa&#8217; database which is used by Plesk.<\/p>\n<blockquote>\n<pre><span style=\"color: #0000ff;\">mysql&gt; use psa;<\/span><\/pre>\n<\/blockquote>\n<p>and execute the following command to retrieve passwords of all the email accounts on a domain<\/p>\n<blockquote>\n<pre><span style=\"color: #0000ff;\">mysql&gt; select mail_name, password from domains, mail, accounts where \\\r\ndomains.name='domainname.com' and domains.id=mail.dom_id and \\\r\nmail.id=accounts.id;<\/span><\/pre>\n<\/blockquote>\n<p>where,<br \/>\nreplace <strong>domainname.com<\/strong> with the actual domain name whose email account passwords you wish to retrieve.<br \/>\n<span style=\"color: #000000;\"><strong>domains, mail, accounts<\/strong> are the table names <\/span>where different entries of an email account is stored.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plesk uses a database called &#8216;psa&#8217; to save all the details about the domains, settings, users and their passwords in plain text. A person with root access to the server can easily retrieve email account passwords in a Plesk server from the Mysql prompt.<br \/>\nSSH to the server and connect to the Mysql server<\/p>\n<p># mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/p>\n<p>At the mysql prompt, goto the &#8216;psa&#8217; database which is used by Plesk.<\/p>\n<p>mysql&gt; use psa;<\/p>\n<p>and execute the following command to retrieve passwords of all the email accounts on a domain<\/p>\n<p>mysql&gt; select mail_name, [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[1467,1470,1468,1469],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/86"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":7,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"predecessor-version":[{"id":2102,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/86\/revisions\/2102"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}