Had an issue reported today when a user created a new SQL Database, and then a new user. On creation of the new user in the Plesk control panel – they received the error “Table ‘mysql.servers’ doesn’t exist”.
mysql_fix_privilege_tables --user=admin --password= --verbose
After running, the below output was generated
If you didn’t add the ‘www’ prefix at the time of setting up the domain, even adding it back in later doesn’t seem to work. This fault seems to be present within all current versions of Plesk up to my current version v9.2
To work around this problem, firstly – turn on the ‘www’ prefix again within the Plesk control panel.
Domains > yourdomain.com > Modify > WWW Prefix – Tick this box
The www prefix will still not work… to correct this, we need to re-build the Apache config after turning it back on:
/usr/local/psa/admin/sbin/websrvmng -v -a
1. Connect to the Plesk Database
mysql -u admin -p`cat /etc/psa/.psa.shadow` use psa
2. Select one of the following commands:
Get all e-mail account passwords:
SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
ORDER BY domains.name ASC,mail.mail_name ASC;
Email account passwords for a specific domain:
SELECT account_id AS �ID�, mail_name AS �USERNAME�, password AS �PASSWORD�, postbox as �MAILBOX?�, name AS �DOMAIN�, redir_addr as REDIRECT FROM mail M, domains D, accounts A WHERE M.account_id = A.id AND M.dom_id = D.id AND D.name=�****DOMAIN_NAME****�;
Get e-mail account passwords that are made up of only letters:
SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
AND accounts.password RLIKE BINARY '^[a-z]+$'
ORDER BY domains.name ASC,mail.mail_name ASC;
Get e-mail account passwords that are made up of only numbers:
SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
AND accounts.password RLIKE '^[0-9]+$'
ORDER BY domains.name ASC,mail.mail_name ASC;
Find domains that are using catch-all accounts:
SELECT d.name AS domains, p.value AS catchall_address FROM Parameters p, DomainServices ds, domains d WHERE d.id = ds.dom_id AND ds.parameters_id = p.id AND p.parameter = 'catch_addr' ORDER BY d.name;
Lookup FTP credentials:
SELECT account_id AS �ID�, login AS �USERNAME�, password AS �PASSWORD�, home AS �HOMEDIR� FROM sys_users S, accounts A WHERE S.account_id = A.id;