>> Get FTP passwords
# mysql psa -e "select sys_users.login,sys_users.home,domains.name,accounts.password from sys_users,domains,accounts,hosting where sys_users.id=hosting.sys_user_id AND domains.id=hosting.dom_id AND accounts.id=sys_users.account_id"
>> Get email passwords
# /usr/local/psa/admin/sbin/mail_auth_view/usr/local/psa/bin/admin --show-password <----- Plesk 10 and up
cat /etc/psa/.psa.shadow <----- Plesk 6 and up
>> Check which MTA
# alternatives --display mta
>> check mailq (yum install pfHandle)
# pfHandle -s
!!! if you use qmail -> qmHandle
>> Check list of messages queued
# pfHandle -d
!!! If pfHandle does not work, just check inside /var/spool/postfix/
>> Connect to MySQL
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
>> Check version
# cat /usr/local/psa/version
>> Setup Holland
backupsets/default.conf
[mysql:client]
user = admin
password = file:/etc/psa/.psa.shadow
>> Check license
/usr/bin/curl -s -k https://127.0.0.1:8443/enterprise/control/agent.php -H "HTTP_AUTH_LOGIN: admin" -H "HTTP_AUTH_PASSWD: `/usr/local/psa/bin/admin --show-password`" -H "HTTP_PRETTY_PRINT: true" -H "Content-Type: text/xml" -d "<packet> <server> <get> <key/> </get> </server> </packet>" | egrep -ohm 1 "PLSK\.[0-9]{8}"
>> Remove license (physically from the server)
[root@344668-web1 ~]# mv /etc/sw/keys/keys/keyXXNb8YmF /home/user/
[root@344668-web1 ~]#
>> Plesk main logs
MAIL: /usr/local/psa/var/log/maillog
ACCESS LOGS: /var/www/vhosts/*/logs/access_log
>> One-liner to generate reports from the Access Logs
> General report
grep -h "04.Jun.2015" /var/www/vhosts/*/logs/access_log | awk '{print $1}' | sort | uniq -c | sort -nr | head -n 20
> per site report
for i in `find /var/www/vhosts/*/logs/access_log -not -empty `;do echo -n "$i - " ; awk '{print $1}' $i | sort | uniq -c | sort -n | tail -1 ; done | sort –k3 -n | column –t
>> Add custom configuration to Apache under Plesk
# cd /var/www/vhosts/system/DOMAIN.com/conf
If there is no vhost.conf file then I can create it and add the necessary custom configuration
Need to reconfigure the Plesk Domain - this will Include the custome vhost.conf file
# /usr/local/psa/admin/sbin/httpdmng -h
# /usr/local/psa/admin/sbin/httpdmng --reconfigure-domain DOMAIN.com
>> Disable SSLv3 on Plesk
If you need to disable SSLv3 on Plesk boxes, here is how to do it:
If nginx is running on port 443, use the following KB: http://kb.sp.parallels.com/en/120083
If Apache is configured on port 443, create /etc/httpd/conf.d/ zz050-psa-disable-weak-ssl-ciphers.conf:
SSLHonorCipherOrder on
SSLProtocol -ALL +TLSv1
SSLCipherSuite ALL:!ADH:!LOW:!SSLv2:!EXP:+HIGH:+MEDIUM
# /usr/local/psa/bin/ipmanage -l
State Type IP Clients Hosting PublicIP
1 S eth0:172.54.10.212/255.255.252.0 0 0
0 E eth2:10.0.1.128/255.255.254.0 0 0
0 S eth0:172.54.10.27/255.255.252.0 0 161
0 E eth0:172.54.10.28/255.255.252.0 0 1
# /usr/local/psa/bin/ipmanage -r 172.54.10.212
Error occured while sending feedback. HTTP code returned: 502
SUCCESS: Removal of IP '172.54.10.212' completed.
# /usr/local/psa/bin/ipmanage -l
State Type IP Clients Hosting PublicIP
0 E eth2:10.0.1.128/255.255.254.0 0 0
0 S eth0:172.54.10.27/255.255.252.0 0 161
0 E eth0:172.54.10.28/255.255.252.0 0 1