get protected directory user and password

one query to grab the user and pass from the Plesk psa database:

SELECT pd.login, a.password,, dirs.path FROM accounts a, pd_users pd, protected_dirs dirs, domains d WHERE dirs.path = 'admin' AND = pd.account_id AND pd.pd_id = AND dirs.dom_id = AND = DOMAIN_ID;

Leave a Reply

Your email address will not be published. Required fields are marked *