{"id":412,"date":"2011-02-02T04:45:34","date_gmt":"2011-02-02T10:45:34","guid":{"rendered":"http:\/\/blog.supportpro.com\/2011\/02\/how-to-retrieve-ftp-username-and-password-in-plaintext-from-psa-db\/"},"modified":"2018-10-04T06:19:51","modified_gmt":"2018-10-04T12:19:51","slug":"how-to-retrieve-ftp-username-and-password-in-plaintext-from-psa-db","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/how-to-retrieve-ftp-username-and-password-in-plaintext-from-psa-db\/","title":{"rendered":"HOW TO RETRIEVE FTP USERNAME AND PASSWORD IN PLAINTEXT FROM PSA DB"},"content":{"rendered":"

We can easily retrieve all the FTP usernames and password under a domain in plain text, by following the below steps.<\/p>\n

1. Enter the MySQL Prompt.<\/p>\n

# mysql -u admin -p`cat \/etc\/psa\/.psa.shadow`<\/p>\n

2. use psa;<\/p>\n

3. mysql> select US.* FROM sys_users US, hosting HS, domains DM<\/p>\n

-> WHERE US.id = HS.sys_user_id AND HS.dom_id = DM.id AND DM.name =’domain.com’;<\/p>\n

The below given is a sample output of that command.<\/p>\n

+—–+———-+———-+———————————–+————+——-+<\/p>\n

| id | login | passwd | home | shell | quota |<\/p>\n

+—–+———-+———-+———————————–+————+——-+<\/p>\n

| 110 | ftpuser | password | \/home\/httpd\/vhosts\/domain.com | \/bin\/false | 0 |<\/p>\n

+—–+———-+———-+———————————–+————+——-+<\/p>\n

If you require help, contact SupportPRO Server Admin<\/a><\/p>\n

\"Server<\/a><\/span>