We can easily retrieve all the FTP usernames and password under a domain in plain text, by following the below steps.
1. Enter the MySQL Prompt.
# mysql -u admin -p`cat /etc/psa/.psa.shadow`
2. use psa;
3. mysql> select US.* FROM sys_users US, hosting HS, domains DM
-> WHERE US.id = HS.sys_user_id AND HS.dom_id = DM.id AND DM.name =’domain.com’;
The below given is a sample output of that command.
+—–+———-+———-+———————————–+————+——-+
| id | login | passwd | home | shell | quota |
+—–+———-+———-+———————————–+————+——-+
| 110 | ftpuser | password | /home/httpd/vhosts/domain.com | /bin/false | 0 |
+—–+———-+———-+———————————–+————+——-+
If you require help, contact SupportPRO Server Admin
