Configuring and securing FC6/Plesk server with postgres.

Securing

Configure firewall to allow SSH/Plesk admin from only trused IP addresses.

Backup [TODO]

Check plesk backup locations. If needed add postgres dump.

Add transfer script to colate, compress, rotate remote files and upload the backup to the remote FTP server.

First – update software starting with Plesk, then configure yum (repros may need adding), then update all packages. Add postgres via yum.

Yum configuration -

<bash/>
[main]
cachedir=/var/cache/yum
keepcache=0
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
distroverpkg=redhat-release
tolerant=1
exactarch=1
obsoletes=1
gpgcheck=1
plugins=1
metadata_expire=1800
exclude=udev kernel* mkinitrd module-init-tools glibc* gcc* MAKEDEV*<code>[core]
name=Fedora Core $releasever - $basearch
baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/$releasever/$basearch/os/
mirrorlist=http://fedora.redhat.com/download/mirrors/fedora-core-$releasever
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora file:///etc/pki/rpm-gpg/RPM-GPG-KEY</code><code>[extras]
name=Fedora Extras $releasever - $basearch
baseurl=http://download.fedora.redhat.com/pub/fedora/linux/extras/$releasever/$basearch/
mirrorlist=http://fedora.redhat.com/download/mirrors/fedora-extras-$releasever
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-extras
gpgcheck=1
[updates]
name=Fedora Core $releasever - $basearch - Updates
baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/updates/$releasever/$basearch/
mirrorlist=http://fedora.redhat.com/download/mirrors/updates-released-fc$releasever
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora

Once yum is configured “yum update all” should get the server up-to date.

postgres installation – http://www.flmnh.ufl.edu/linux/install_postgresql.htm

PHP

Appears to be installed with error reporting in a quitet mode… time to fix that!

Found an interesting article on hardening… see

Padlock Plesk HTTPS root 27 February 2006

To customise the Plesk admin pages, add sections the httpd root is located here - /usr/local/psa/admin/htdocs Current additional mods include pgAdmin which is installed on - /usr/local/psa/admin/htdocs/__pgadmin

vhost.conf 31 October 2005

custom vhost notes - after creating place in conf/vhost.conf then run ->
<dos/>
/usr/local/psa/admin/sbin/websrvmng -u --vhost-name=maindomain.com
from bash to complete the update

September 2010
S M T W T F S
 1234
567891011
12131415161718
19202122232425
2627282930  
August 2010
S M T W T F S
1234567
891011121314
15161718192021
22232425262728
293031  
July 2010
S M T W T F S
 123
45678910
11121314151617
18192021222324
25262728293031
June 2010
S M T W T F S
 12345
6789101112
13141516171819
20212223242526
27282930  
powered by
wordpress
theme and icons by
web-engineer

©2008 web-engineer™
all rights reserved