The Plesk Control Panel
-install a new vhost.conf file
# /usr/local/psa/admin/bin/websrvmng --install-vhost --vhost-name=www2.harvestating.com
# cat vhost.conf
<Directory /home/httpd/vhosts/harvesteating.com/subdomains/www2>
Options +FollowSymLinks
</Directory>
# pwd
/home/httpd/vhosts/harvesteating.com/subdomains/www2/conf
----------
UPGRADING
-Plesk Update to 8.x
edit /etc/sysconfig/rhn/sources
yum plesk8 http://autoinstall.plesk.com/PSA_8.4.0/dist-rpm-RedHat-el4-i386/
yum plesk8_thirdparty http://autoinstall.plesk.com/PSA_8.4.0/thirdparty-rpm-RedHat-el4-i386/
^change Plesk and RHEL version!
# up2date -u --dry-run // if no errors then punch it
# cat up2date | grep GPG
// change GPG to 0 to not use keys
useGPG=0
$ edit sa-learn with just "1" onthe second line to speed up the last process of the install
"bayes: synced database..."
# which sa-learn
/usr/bin/sa-learn
--------------
Top mail traffic domains
Domains with most mail traffic for date='2008-01-01' (change date as needed):
# mysql -uadmin -p$(</etc/psa/.psa.shadow) psa -e "select domains.name,sum(smtp_in+smtp_out) as MailTraffic from domains,DomainsTraffic where date='2008-01-01' and domains.id = DomainsTraffic.dom_id group by domains.name order by MailTraffic desc limit 10"
-------------
PSA Database
[links]
www.pleskhacker.com find Database Schema
trancendlinux.com
[tables]
accounts - only passwords; id, type, password; type could be plain or encoded
sys_users - all users; id, login, account_id, home; account_id is password from accounts table
domains - hosted domains; id, cr_date, name, displayName, status, htype, real_size, cl_id, cer_rep_id, limits_id, params_id, dns_zone_id
clients - holds client info including web user login; again account_id is password from accounts table
components - list of installed apps; name and version
data_bases - list of added databases from the panel
db_users - same
>select * from data_bases where dom_id=7;
>update data_bases set dom_id=13 where id=15;
IP_Addresses - list of ip addresses
hosting -
Repository - relation table to components table (component_id)
dns_zone - name of domains
dns_recs - records
# dnsmng
misc - various settings, periodic Apache restarts
Parameters -
key_history - history of all keys ever used
key_history_params -
[mail utilities and tables]
mail - everything about mail, account_id is password from accounts table
spamfilter -
spamfilter_prefrences -
# cd /usr/local/psa/
# less /etc/psa/psa.conf
bin/spamassassin.sh - to change spam assassin configs on per user basis, set up users in /var/qmail/mailnames and loop
admin/bin/spammng - train spam assassin on certain email messages
admin/bin/mailmng - set max mail messages size on user
admin/bin/mchk - rebuild all mail configurations with or with out spam assassin; regens .qmail files
> /domain/users/.qmail - holds spam assassin settings; a pipe to spam assassin (|)
[dns]
./dnsmng update domain.com
dns.sh - add, set, delete; set ttls
[web server]
admin/websrvmng -
bin/domain.sh -
----------
Horde Webmail Left Menu Not Showing
edit files:
/usr/share/psa-horde/ingo/lib/Storage.php
/usr/share/psa-horde/lib/Horde/IMAP/Tree.php
Old files...
require_once 'Horde/SessionObjects.php';
New files...
require_once '/usr/share/psa-horde/Horde/SessionObjects.php';
Plesk Version Issues
mysql> use psa;
mysql> update misc set val='0840' where param='version';
# cp /usr/local/psa/version{,.old}
echo "8.4.0 RedHat el4 84080514.18" > /usr/local/psa/version
----
vhost.conf:
<Directory /var/www/vhosts/londonschoolofcontemporarymusic.com/httpdocs>
php_admin_value open_basedir none
</Directory>
if vhost.conf is new, then run websrvmng -a