Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/protected_directories_in_plesk.sql

Created November 4, 2013 14:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save siliconmeadow/7303391 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303391 to your computer and use it in GitHub Desktop.
Download ZIP
To find details about protected directories in Plesk.
Raw
protected_directories_in_plesk.sql
SELECT domains.name, protected_dirs.path, protected_dirs.realm, pd_users.login, SUBSTRING(accounts.password, 1), `protected_dirs`.`ssl`, protected_dirs.non_ssl
FROM protected_dirs, pd_users, domains, accounts
WHERE domains.name LIKE '%<domain.dom>%'
AND protected_dirs.dom_id = domains.id
AND pd_users.pd_id = protected_dirs.id
AND pd_users.account_id = accounts.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment