Skip to Content

archive

Daily Archives: March 10, 2010

post

Plesk server – ‘www’ prefix not working

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
post

Lookup client passwords on Plesk

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;
post

Denyhosts – Blocking your own IP

Stop the Denyhosts service

/etc/init.d/denyhosts stop

Remove your IP from the log file

vi /etc/hosts.deny

(Look for your IP then “dd” on the line to remove it, then “ZZ” to save and exit)

Check to see if your IP is in any other files

grep "82.68.113.238" /var/lib/denyhosts/*

Start the Denyhosts service again

/etc/init.d/denyhosts start

Adapted from the following post : DenyHosts: Remove / Delete an IP address