• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Lookup Domain Passwords

B

b-nut

Guest
I have a script that I created to lookup domain(ftp) passwords for support purposes. The script was designed for plesk 7 but I recently migrated to a plesk 8 box and the script no longer works. The structure of the PSA database has changed and now I don't know how to lookup the passwords in the Plesk 8 database. It seems that the passwords are now stored in a different table in BLOB format and I don't know how to retrieve them.

Here is the query that I used on Plesk 7:
PHP:
$SQL = "SELECT d.name, d.cl_id, s.login, a.password, c.login as client_login, c.passwd as client_password
	FROM domains d, hosting h, sys_users s, accounts a, clients c
	WHERE d.id = h.dom_id 
	AND s.id = h.sys_user_id 
	AND a.id = s.account_id 
	AND c.id = d.cl_id
	AND d.name = '$domain'";

Does anyone know how to restructure this query for plesk 8?
 
Back
Top