Plesk - Retrieve FTP & Mail Details

I am often tasked with checking something out over FTP, or retrieving a customers mail details. The shared hosting servers I use all use Plesk, which makes it fairly easy!

Change to the Plesk Database

USE psa;

Check FTP Details

SELECT REPLACE(sys_users.home,'/var/www/vhosts/','') AS domain,
sys_users.login,accounts.password, sys_users.home AS home_directory
FROM sys_users
LEFT JOIN accounts on sys_users.account_id=accounts.id
ORDER BY sys_users.home ASC;

The mail details query will even show NULL for the mail_name & password if they don’t have any email accounts on their domain. Useful for checking when you are told that a mailbox exists that turns out to be on a different server!!!

About me

Matt Clements is a Web Developer based in the vibrant town of Milton Keynes, specialising in PHP, MySQL, Sass, Javascript and much more.

Matt is an adaptive developer who will adjust and adapt to any development project, and will help you reach your final goal.