Installing a new webserver: Difference between revisions

From Edgar BV Wiki
Jump to navigation Jump to search
 
(30 intermediate revisions by the same user not shown)
Line 1: Line 1:
= Basic Debian and network setup =
= Basic Debian and network setup =
<pre>
[[Debian Network Setup]]
apt-get install mysql-server openssh-server proftpd apache2 libapache2-mod-perl2 libapache2-mod-php5 php5 php5-cli php5-ffmpeg php5-gd php5-imagick php5-mcrypt php5-mhash php5-mysql php5-xmlrpc php5-xsl php5-curl php-apc snmp snmpd iotop mtop apachetop iptstate atsar postfix popa3d shorewall vim awstats bmon nscd sshfs mc zip unzip bzip2 arj spamassassin pyzor razor ncftp rsync phpmyadmin quota ntpdate ntp vacation pdnsd


pdnsd - use resolvconf configuration
[[Debian Standard Packages to install afterwards]]


Set up networking in /etc/network/interfaces
<pre>
<pre>
# The loopback network interface
apt-get install apache2 bc libapache2-mod-perl2 libapache2-mod-php php php-cli php-gd php-imagick php-mcrypt php-mysql php-ssh2 php-xmlrpc php-curl php-apcu snmp snmpd iotop mtop apachetop iptstate awstats bmon
auto lo
</pre>
iface lo inet loopback
Possible packages
  apt-get install mysql-server sshfs phpmyadmin mysql-client


# The primary network interface
== depreciated ==
allow-hotplug eth0
Also ensure backports are enabled by adding
#auto eth0
<pre>
iface eth0 inet static
deb http://ftp.debian.org/debian jessie-backports main
        address 192.168.0.112
</pre>
        netmask 255.255.255.0
to /etc/apt/sources.list
        network 192.168.0.0
        broadcast 192.168.0.255
#      gateway 192.168.0.1
        dns-nameservers 213.75.63.36 213.75.63.70 192.168.0.1
#      dns-nameservers 192.168.0.1 192.168.0.2
#      dns-search tripnet.int internal.tripnet.int ops.tripnet.int


auto eth1
Then
iface eth1 inet static
<pre>
        address 188.204.140.195
sudo apt-get install python-certbot-apache -t jessie-backports
        netmask 255.255.255.224
        network 188.204.140.192
        broadcast 188.204.140.223
        gateway 188.204.140.193
        dns-nameservers 213.75.63.36 213.75.63.70 192.168.0.1
</pre>
</pre>
For Letsencrypt.


= SNMP =
= SNMP =
run snmpconf
[[SNMP]]


/etc/default/snmpd get rid of 127.0.0.1
= sshd chroot for sftp =
 
vi /etc/ssh/sshd_config
/etc/snmp/snmpd.conf should have at least the following:
<pre>
<pre>
rocommunity public  default   -V systemonly
#Subsystem      sftp   /usr/libexec/openssh/sftp-server
rocommunity  euhostro
Subsystem      sftp    internal-sftp
</pre>
</pre>
to define the community and
at the end
<pre>
<pre>
agentAddress
Match Group sftp
agentaddress
        ChrootDirectory /var/www/www.sitename.ext/
        ForceCommand internal-sftp
        AllowTcpForwarding no
</pre>
</pre>
in order to allow the daemon to listen to all IP adresses instead of only localhost
or per user
 
test with
<pre>
<pre>
snmpwalk -v1 -c euhostro localhost
Match User myguy
        ChrootDirectory /var/www/www.sitename.ext/
        ForceCommand internal-sftp
        AllowTcpForwarding no
</pre>
</pre>
systemctl restart sshd


then from another server:
Note: make sure that the ChrootDirectory itself is owned by root!
<pre>
snmpwalk -v1 -c euhostro IPADRESS
</pre>


= Proftpd =  
= Proftpd (depreciated) =  
/etc/proftpd/proftpd.conf add
/etc/proftpd/proftpd.conf add
<pre>
<pre>
Line 83: Line 73:
<pre>
<pre>
mkdir /home/adm_usr/webserveradmin/ -p
mkdir /home/adm_usr/webserveradmin/ -p
mkdir /opt/triphost/ -p
mkdir /opt/myhost/ -p
mkdir /opt/weblog/etc -p
mkdir /opt/weblog/etc -p
mkdir /opt/weblog/src -p
mkdir /opt/weblog/src -p
Line 90: Line 80:


<pre>
<pre>
mkdir /home/sites/servername.tripany.com/site/sitestats/ -p
mkdir /home/sites/servername.xxx.com/site/sitestats/ -p
mkdir /home/sites/servername.tripany.com/site/sitestats/servername.tripany.com/
mkdir /home/sites/servername.xxx.com/site/sitestats/servername.xxx.com/
mkdir /home/sites/USGP.tripany.com/logs/
mkdir /home/sites/USGP.xxx.com/logs/
mkdir /home/sites/USGP.tripany.com/sites/ftpstats
mkdir /home/sites/USGP.xxx.com/sites/ftpstats
chown razor /home/sites/servername.tripany.com/site -R
chown razor /home/sites/servername.xxx.com/site -R
</pre>
</pre>
[[addsite.sh]]
[[adduser.sh]]
[[delsite.sh]]
[[/etc/apache2/listvirts]]


= APC =
= APC =
Line 107: Line 102:


== log rotation ==
== log rotation ==
/etc/logrotate.d/apache2
<pre>
/var/log/apache2/*.log {
        daily
        missingok
        rotate 14
        compress
        delaycompress
        notifempty
        create 644 root adm
        sharedscripts
        postrotate
                if invoke-rc.d apache2 status > /dev/null 2>&1; then \
                    invoke-rc.d apache2 reload > /dev/null 2>&1; \
                fi;
        endscript
        prerotate
                if [ -d /etc/logrotate.d/httpd-prerotate ]; then \
                        run-parts /etc/logrotate.d/httpd-prerotate; \
                fi; \
        endscript
}
</pre>
=== deprecated ===
Because of the way awstats works nowadays
/etc/logrotate.d/apache2
/etc/logrotate.d/apache2
<pre>
<pre>
Line 119: Line 141:
         prerotate
         prerotate
               # Run the central statistics before rotating the logs
               # Run the central statistics before rotating the logs
                 /opt/triphost/statisticsSERVERNAMEweb.sh
                 /opt/myhost/statisticsSERVERNAMEweb.sh
                 # Then we split the logs for the virtual hosts
                 # Then we split the logs for the virtual hosts
                 /opt/triphost/apachelogsplit.sh
                 /opt/myhost/apachelogsplit.sh
                 # Run the individual site stats
                 # Run the individual site stats
                 /opt/triphost/sitestatistics.sh
                 /opt/myhost/sitestatistics.sh
                 echo "All done for the day" >> /var/log/statistics
                 echo "All done for the day" >> /var/log/statistics
                 date >> /var/log/statistics
                 date >> /var/log/statistics
Line 191: Line 213:
/etc/apache2/apache2.conf or /etc/apache2/mods-enabled/proxy.conf
/etc/apache2/apache2.conf or /etc/apache2/mods-enabled/proxy.conf
<pre>
<pre>
# Tripany change: This forces it to proxy to the monitor server
# XXX change: This forces it to proxy to the monitor server
# Requires libapache2-mod-proxy-html and a2enmod proxy
# Requires libapache2-mod-proxy-html and a2enmod proxy
ProxyRequests Off
ProxyRequests Off
#ProxyPass / http://monitor.tripnet.int/
#ProxyPass / http://monitor.mynet.int/
#ProxyPassReverse / http://monitor.tripnet.int/
#ProxyPassReverse / http://monitor.mynet.int/


ProxyPass / http://192.168.0.210/
ProxyPass / http://192.168.0.210/
Line 211: Line 233:


== /etc/apache2/sites-available/default ==
== /etc/apache2/sites-available/default ==
move this file to 000-default.conf to ensure it gets loaded first by apache


change
change
<pre>
<pre>
ServerName IPADDRESS
ServerName IPADDRESS
DocumentRoot /home/sites/servername.tripany.com/site
DocumentRoot /home/sites/servername.xxx.com/site
</pre>
</pre>
and add
and add
<pre>
<pre>
  Redirect /stats http://servername.tripany.com/sitestats/tripwraith.tripany.com/index.php
  Redirect /stats http://servername.xxx.com/sitestats/mywraith.xxx.com/index.php
         Redirect /livestats http://servername.tripany.com/cgi-bin/awstats.pl?config=tripwraith
         Redirect /livestats http://servername.xxx.com/cgi-bin/awstats.pl?config=mywraith
#      AliasMatch ^/mailstats(.*) /home/sites/servername.tripany.com/mailstats/awstats.servername.mail.html
#      AliasMatch ^/mailstats(.*) /home/sites/servername.xxx.com/mailstats/awstats.servername.mail.html
         AliasMatch ^/ftpstats(.*)  /home/sites/servername.tripany.com/ftpstats/awstats.servername.ftp.html
         AliasMatch ^/ftpstats(.*)  /home/sites/servername.xxx.com/ftpstats/awstats.servername.ftp.html
         <Directory /home/sites/servername.tripany.com/>
         <Directory /home/sites/servername.xxx.com/>
                 Options Indexes FollowSymLinks MultiViews
                 Options Indexes FollowSymLinks MultiViews
                 AllowOverride Options Authconfig
                 AllowOverride Options Authconfig
Line 239: Line 262:
         ServerAdmin webmaster@localhost
         ServerAdmin webmaster@localhost


         DocumentRoot /home/sites/USGP.tripany.com/site
         DocumentRoot /home/sites/USGP.xxx.com/site
         <Directory />
         <Directory />
                 Options FollowSymLinks
                 Options FollowSymLinks
Line 280: Line 303:
make sure this links from /etc/apache2/sites-enabled/000-default as this becomes the fallback site for any IP or domain name not otherwise used.
make sure this links from /etc/apache2/sites-enabled/000-default as this becomes the fallback site for any IP or domain name not otherwise used.


== /etc/apache2/sites-available/default-ssl==
== Lets Encrypt ==
 
Because the Debian backport version is buggy, don't just run certbot --apache but you have to run the certbot for each domain (and serveraliases) you want it to work with as such:
Note - nowadays you will need to do it this way!
<pre>
certbot --authenticator webroot --installer apache -d www.domain.ext -w /var/www/www.domain.ext/site/
certbot -a webroot -i apache -d www.domain.ext -w /var/www/www.domain.ext/site/
 
certbot -a webroot -i apache -d www.domain.ext,domain.ext,other.domain.ext -w /var/www/www.domain.ext/site/
</pre>
 
After adding / changing certificates make sure you reload the apache2 server.
 
If you see a warning with a lock and a yellow triangle from Firefox it means the page is serving mixed content (http + https). When inspecting the certificate itself it will look like there is no verifing agency for the certificate. This has nothing to do with the validity or verification of the certificate, it's purely there because of mixed content.
 
You can inspect the history of a certificate with the following URL
<pre>
https://crt.sh/?q=%25linkielist.com
</pre>
 
To renew certificates (put this in a cronjob)
<pre>
certbot renew
</pre>
 
To test
<pre>
certbot renew --dry-run
</pre>
 
Also, ensure that Dovecot is looking at the latest version of the certificate files under /etc/dovecot/conf.d/10-ssl.conf<blockquote>ssl_cert = </etc/letsencrypt/live/mail.edgarbv.com-0001/fullchain.pem
 
ssl_key = </etc/letsencrypt/live/mail.edgarbv.com-0001/privkey.pem</blockquote>[[Dovecot]]
 
 
[https://certbot.eff.org/#debianjessie-apache Certbot documentation for apache + jessie]
 
OLD
----
<pre>
certbot -d www.domain.ext -d domain.ext -d www.alias.ext -d alias.ext --apache
</pre>
 
== /etc/apache2/sites-available/default-ssl ==
generate a certificate using certbot for the servername
<pre>
certbot certonly edgarinet.edgarbv.com
</pre>
 
them move the file to 000-default-ssl.conf to ensure it gets loaded first
<pre>
<IfModule mod_ssl.c>
<VirtualHost *:443>
Alias /roundcube /var/lib/roundcube
        ServerAdmin webmaster@localhost
 
        DocumentRoot /var/www
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>
 
        ErrorLog ${APACHE_LOG_DIR}/error.log
        LogLevel warn
 
        CustomLog ${APACHE_LOG_DIR}/ssl_access.log combined
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>
        BrowserMatch "MSIE [2-6]" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0
 
SSLCertificateFile /etc/letsencrypt/live/edgarinet.edgarbv.com/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/edgarinet.edgarbv.com/privkey.pem
Include /etc/letsencrypt/options-ssl-apache.conf
</VirtualHost>
</IfModule>
</pre>
 
== depreciated /etc/apache2/sites-available/default-ssl ==
 
'''Don't do this because LetsEncrypt!'''


Because we edited ports conf, we need to change:
Because we edited ports conf, we need to change:
Line 340: Line 454:
</pre>
</pre>
make sure that this links from /etc/apache2/sites-enabled/000-default-ssl as we need this to be the first SNI site.
make sure that this links from /etc/apache2/sites-enabled/000-default-ssl as we need this to be the first SNI site.
== modules to enable==
  s2enmod ssl rewrite


== Public Key Pinning Extension for HTTP (HPKP) ==
== Public Key Pinning Extension for HTTP (HPKP) ==
Line 355: Line 472:
<pre>
<pre>
<VirtualHost *:80>
<VirtualHost *:80>
         ServerName robin.tripany.com
         ServerName robin.xxx.com
         DocumentRoot /home/sites/robin.tripany.com/site
         DocumentRoot /home/sites/robin.xxx.com/site
         ServerAdmin red@tripany.com
         ServerAdmin red@email.com
         ServerAlias tripany.com
         ServerAlias xxx.com
         Redirect /stats http://USGP.tripany.com/sitestats/robin.tripany.com/index.php
         Redirect /stats http://USGP.xxx.com/sitestats/robin.xxx.com/index.php
         Redirect /livestats http://robin.tripany.com/cgi-bin/awstats.pl?config=robin.tripany.com
         Redirect /livestats http://robin.xxx.com/cgi-bin/awstats.pl?config=robin.xxx.com
         <Directory /home/sites/robin.tripany.com/site/>
         <Directory /home/sites/robin.xxx.com/site/>
                 Options FollowSymLinks
                 Options FollowSymLinks
                 AllowOverride All
                 AllowOverride All
Line 377: Line 494:
<pre>
<pre>
cp /var/www/index.html /home/sites
cp /var/www/index.html /home/sites
cp /var/www/index.html /home/sites/servername.tripany.com/site/
cp /var/www/index.html /home/sites/servername.xxx.com/site/
</pre>
</pre>


Line 384: Line 501:
<pre>
<pre>
# nb make sure first site after the original starts at 100!
# nb make sure first site after the original starts at 100!
tripwraith.tripany.com - site0
mywraith.xxx.com - site0
some.site.com - site100
some.site.com - site100
</pre>
</pre>
Line 394: Line 511:
'''/OLD'''
'''/OLD'''


create /etc/apache2/sites-available/servername.tripany.com
create /etc/apache2/sites-available/servername.xxx.com


link it in in sites-enabled
link it in in sites-enabled
Line 406: Line 523:
<pre>
<pre>
Alias /awstatsicon/ /usr/share/awstats/icon/
Alias /awstatsicon/ /usr/share/awstats/icon/
</pre>
== rewrite stuff / redirect ==
Get rid of the www in the domain name (make sure you do this in the 443 section of the virtualhost after you redirect from http -> https)
<pre>
RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.yourdomain.com [NC]
RewriteRule ^(.*)$ http://yourdomain.com/$1 [L,R=301]
</pre>
Or to add the www
<pre>
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{HTTP_HOST} ^domain\.com [NC]
RewriteRule ^(.*)$ http://www.domain.com/$1 [L,R=301]
</IfModule>
</pre>
</pre>


Line 443: Line 577:


<pre>
<pre>
cp /etc/awstats/model.conf /etc/awstats/awstats.servername.tripany.com.conf
cp /etc/awstats/model.conf /etc/awstats/awstats.servername.xxx.com.conf
</pre>
</pre>
Edit the following directives:
Edit the following directives:
<pre>
<pre>
LogFile="/var/log/apache2/access.log"
LogFile="/var/log/apache2/access.log"
SiteDomain="servername.tripany.com"
SiteDomain="servername.xxx.com"
HostAliases="localhost 127.0.0.1 REGEX[servername.tripany\.(com|nl)$]"
HostAliases="localhost 127.0.0.1 REGEX[servername.xxx\.(com|nl)$]"
</pre>
</pre>


Create the index.php file in /home/sites/servername.tripany.com/site/sitestats/servername.tripany.com/
Create the index.php file in /home/sites/servername.xxx.com/site/sitestats/servername.xxx.com/
<pre>
<pre>
<?
<?
Header('Location: http://servername.tripany.com/sitestats/servername.tripany.com/awstats.zpress.tripany.com.html')
Header('Location: http://servername.xxx.com/sitestats/servername.xxx.com/awstats.zpress.xxx.com.html')
?>
?>
</pre>
</pre>
Line 465: Line 599:
ie.
ie.
<pre>
<pre>
cat /opt/triphost/statisticsSERVERNAME.sh
cat /opt/myhost/statisticsSERVERNAME.sh
</pre>
</pre>
and run this line by line.
and run this line by line.


<pre>
<pre>
cp /opt/weblog/src/weblog_files/graphs/ /home/sites/USGP.tripany.com/site/webloggraphs/ -R
cp /opt/weblog/src/weblog_files/graphs/ /home/sites/USGP.xxx.com/site/webloggraphs/ -R
</pre>
</pre>


Line 510: Line 644:
backup scripts in /etc/crontab
backup scripts in /etc/crontab
<pre>
<pre>
00 2 * * *      root    /opt/triphost/mysqldatasnapdaily.sh
00 2 * * *      root    /opt/myhost/mysqldatasnapdaily.sh
00 3 * * 7      root    /opt/triphost/mysqldatasnapweekly.sh
00 3 * * 7      root    /opt/myhost/mysqldatasnapweekly.sh
00 4 1 * *      root    /opt/triphost/mysqldatasnapmonthly.sh
00 4 1 * *      root    /opt/myhost/mysqldatasnapmonthly.sh
</pre>
</pre>
and
and

Latest revision as of 12:31, 21 October 2024

Basic Debian and network setup

Debian Network Setup

Debian Standard Packages to install afterwards

apt-get install apache2 bc libapache2-mod-perl2 libapache2-mod-php php php-cli php-gd php-imagick php-mcrypt php-mysql php-ssh2 php-xmlrpc php-curl php-apcu snmp snmpd iotop mtop apachetop iptstate awstats bmon 

Possible packages

  apt-get install mysql-server sshfs phpmyadmin mysql-client

depreciated

Also ensure backports are enabled by adding

deb http://ftp.debian.org/debian jessie-backports main

to /etc/apt/sources.list

Then

sudo apt-get install python-certbot-apache -t jessie-backports

For Letsencrypt.

SNMP

SNMP

sshd chroot for sftp

vi /etc/ssh/sshd_config

#Subsystem      sftp    /usr/libexec/openssh/sftp-server
Subsystem       sftp    internal-sftp

at the end

Match Group sftp
        ChrootDirectory /var/www/www.sitename.ext/
        ForceCommand internal-sftp
        AllowTcpForwarding no

or per user

Match User myguy
        ChrootDirectory /var/www/www.sitename.ext/
        ForceCommand internal-sftp
        AllowTcpForwarding no

systemctl restart sshd

Note: make sure that the ChrootDirectory itself is owned by root!

Proftpd (depreciated)

/etc/proftpd/proftpd.conf add

DefaultRoot                     ~/../../

Also add /bin/false to /etc/shells

This allows users to log in with ftp, but not with ssh

For AWStats

LogFormat awstats "%t   %h      %u      %m      %f      %s      %b"
ExtendedLog /var/log/xferlog read,write awstats
TransferLog none
RequireValidShell off

Hosting scripts and directories

mkdir /home/adm_usr/webserveradmin/ -p
mkdir /opt/myhost/ -p
mkdir /opt/weblog/etc -p
mkdir /opt/weblog/src -p

copy the stuff from another webserver into these dirs and find and replace the servername in these directories.

mkdir /home/sites/servername.xxx.com/site/sitestats/ -p
mkdir /home/sites/servername.xxx.com/site/sitestats/servername.xxx.com/
mkdir /home/sites/USGP.xxx.com/logs/
mkdir /home/sites/USGP.xxx.com/sites/ftpstats
chown razor /home/sites/servername.xxx.com/site -R

addsite.sh adduser.sh delsite.sh /etc/apache2/listvirts

APC

add

apc.shm_size=512M

to /etc/php5/apache2/conf.d/20-apc.ini

Apache2

log rotation

/etc/logrotate.d/apache2

/var/log/apache2/*.log {
        daily
        missingok
        rotate 14
        compress
        delaycompress
        notifempty
        create 644 root adm
        sharedscripts
        postrotate
                if invoke-rc.d apache2 status > /dev/null 2>&1; then \
                    invoke-rc.d apache2 reload > /dev/null 2>&1; \
                fi;
        endscript
        prerotate
                if [ -d /etc/logrotate.d/httpd-prerotate ]; then \
                        run-parts /etc/logrotate.d/httpd-prerotate; \
                fi; \
        endscript
}

deprecated

Because of the way awstats works nowadays

/etc/logrotate.d/apache2

/var/log/statistics {
        daily
        missingok
        rotate 8
        compress
}

/var/log/apache2/*.log {
        prerotate
               # Run the central statistics before rotating the logs
                /opt/myhost/statisticsSERVERNAMEweb.sh
                # Then we split the logs for the virtual hosts
                /opt/myhost/apachelogsplit.sh
                # Run the individual site stats
                /opt/myhost/sitestatistics.sh
                echo "All done for the day" >> /var/log/statistics
                date >> /var/log/statistics
        endscript
        daily
        missingok
        rotate 7
        compress
        delaycompress
        notifempty
        create 640 root adm
        sharedscripts
        postrotate
                if [ -f "`. /etc/apache2/envvars ; echo ${APACHE_PID_FILE:-/var/run/apache2.pid}`" ]; then
                        /etc/init.d/apache2 reload > /dev/null
                fi
        endscript
}
touch /var/log/statistics
mkdir /var/log/apache2/virts
mkdir /var/log/apache2/awstats

apache2 conf

/etc/apache2/apache2.conf change LogFormat and add %v to the beginning of the the combined format

LogFormat "%v %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined

And also check the values of

<IfModule mpm_prefork_module>
    StartServers          100
    MinSpareServers       80
    MaxSpareServers      150
    MaxClients          250
    MaxRequestsPerChild   0
</IfModule>

and make sure

Options -Indexes

is in there!

/etc/apache2/ports.conf

NameVirtualHost *:80
Listen 80

<IfModule mod_ssl.c>
    NameVirtualHost *:443
    Listen 443
</IfModule>

<IfModule mod_gnutls.c>
    Listen 443
</IfModule>

Creating a proxy passthrough

/etc/apache2/apache2.conf or /etc/apache2/mods-enabled/proxy.conf

# XXX change: This forces it to proxy to the monitor server
# Requires libapache2-mod-proxy-html and a2enmod proxy
ProxyRequests Off
#ProxyPass / http://monitor.mynet.int/
#ProxyPassReverse / http://monitor.mynet.int/

ProxyPass / http://192.168.0.210/
ProxyPassReverse / http://192.168.0.210/

NB you can also do

ProxyPass /internal http://192.168.0.210/
ProxyPassReverse /internal http://192.168.0.210/

Which will make requests to http://external.domain/internal/foo go to http://192.168.0.210/foo. Note no trailing slashes!

Make sure all the proxy modules are enabled and restart the server after changes, don't reload.

/etc/apache2/sites-available/default

move this file to 000-default.conf to ensure it gets loaded first by apache

change

ServerName IPADDRESS
DocumentRoot /home/sites/servername.xxx.com/site

and add

 Redirect /stats http://servername.xxx.com/sitestats/mywraith.xxx.com/index.php
        Redirect /livestats http://servername.xxx.com/cgi-bin/awstats.pl?config=mywraith
#       AliasMatch ^/mailstats(.*) /home/sites/servername.xxx.com/mailstats/awstats.servername.mail.html
        AliasMatch ^/ftpstats(.*)  /home/sites/servername.xxx.com/ftpstats/awstats.servername.ftp.html
        <Directory /home/sites/servername.xxx.com/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride Options Authconfig
                Order allow,deny
                allow from all
                # This directive allows us to have apache2's default start page
                # in /apache2-default/, but still have / go to the right place
        </Directory>

to the bottom

So it should look something like:

<VirtualHost *:80>
        ServerAdmin webmaster@localhost

        DocumentRoot /home/sites/USGP.xxx.com/site
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
        <Directory "/usr/lib/cgi-bin">
                AllowOverride None
                Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </Directory>

        ErrorLog /var/log/apache2/error.log

        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn

        CustomLog /var/log/apache2/access.log combined

    Alias /doc/ "/usr/share/doc/"
    <Directory "/usr/share/doc/">
        Options Indexes MultiViews FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
        Allow from 127.0.0.0/255.0.0.0 ::1/128
    </Directory>

</VirtualHost>

make sure this links from /etc/apache2/sites-enabled/000-default as this becomes the fallback site for any IP or domain name not otherwise used.

Lets Encrypt

Because the Debian backport version is buggy, don't just run certbot --apache but you have to run the certbot for each domain (and serveraliases) you want it to work with as such: Note - nowadays you will need to do it this way!

certbot --authenticator webroot --installer apache -d www.domain.ext -w /var/www/www.domain.ext/site/
certbot -a webroot -i apache -d www.domain.ext -w /var/www/www.domain.ext/site/

certbot -a webroot -i apache -d www.domain.ext,domain.ext,other.domain.ext -w /var/www/www.domain.ext/site/

After adding / changing certificates make sure you reload the apache2 server.

If you see a warning with a lock and a yellow triangle from Firefox it means the page is serving mixed content (http + https). When inspecting the certificate itself it will look like there is no verifing agency for the certificate. This has nothing to do with the validity or verification of the certificate, it's purely there because of mixed content.

You can inspect the history of a certificate with the following URL

https://crt.sh/?q=%25linkielist.com

To renew certificates (put this in a cronjob)

certbot renew

To test

certbot renew --dry-run

Also, ensure that Dovecot is looking at the latest version of the certificate files under /etc/dovecot/conf.d/10-ssl.conf

ssl_cert = </etc/letsencrypt/live/mail.edgarbv.com-0001/fullchain.pem ssl_key = </etc/letsencrypt/live/mail.edgarbv.com-0001/privkey.pem

Dovecot


Certbot documentation for apache + jessie

OLD


certbot -d www.domain.ext -d domain.ext -d www.alias.ext -d alias.ext --apache

/etc/apache2/sites-available/default-ssl

generate a certificate using certbot for the servername

certbot certonly edgarinet.edgarbv.com

them move the file to 000-default-ssl.conf to ensure it gets loaded first

<IfModule mod_ssl.c>
<VirtualHost *:443>
Alias /roundcube /var/lib/roundcube
        ServerAdmin webmaster@localhost

        DocumentRoot /var/www
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

        ErrorLog ${APACHE_LOG_DIR}/error.log
        LogLevel warn

        CustomLog ${APACHE_LOG_DIR}/ssl_access.log combined
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>
        BrowserMatch "MSIE [2-6]" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0

SSLCertificateFile /etc/letsencrypt/live/edgarinet.edgarbv.com/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/edgarinet.edgarbv.com/privkey.pem
Include /etc/letsencrypt/options-ssl-apache.conf
</VirtualHost>
</IfModule>

depreciated /etc/apache2/sites-available/default-ssl

Don't do this because LetsEncrypt!

Because we edited ports conf, we need to change:

<VirtualHost *:443>

and of course very important are

       SSLEngine on
       SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem
       SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key
       SSLCACertificatePath /etc/ssl/certs/

default-ssl should look something like

<IfModule mod_ssl.c>
<VirtualHost *:443>
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>
        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
        <Directory "/usr/lib/cgi-bin">
                AllowOverride None
                Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </Directory>
        ErrorLog ${APACHE_LOG_DIR}/error.log
        LogLevel warn
        CustomLog ${APACHE_LOG_DIR}/ssl_access.log combined
        SSLEngine on
        SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem
        SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key
        SSLCACertificatePath /etc/ssl/certs/
        <FilesMatch "\.(cgi|shtml|phtml|php)$">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>
        BrowserMatch "MSIE [2-6]" \
                nokeepalive ssl-unclean-shutdown \
                downgrade-1.0 force-response-1.0
        BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown
</VirtualHost>
</IfModule>

make sure that this links from /etc/apache2/sites-enabled/000-default-ssl as we need this to be the first SNI site.

modules to enable

 s2enmod ssl rewrite

Public Key Pinning Extension for HTTP (HPKP)

[1]

Disable SSLv3

/etc/apache2/mods-available/ssl.conf Make sure it has SSLv3 disabled, check the line:

SSLProtocol All -SSLv2 -SSLv3

Standard site

Should look something like:

<VirtualHost *:80>
        ServerName robin.xxx.com
        DocumentRoot /home/sites/robin.xxx.com/site
        ServerAdmin red@email.com
        ServerAlias xxx.com
        Redirect /stats http://USGP.xxx.com/sitestats/robin.xxx.com/index.php
        Redirect /livestats http://robin.xxx.com/cgi-bin/awstats.pl?config=robin.xxx.com
        <Directory /home/sites/robin.xxx.com/site/>
                Options FollowSymLinks
                AllowOverride All
                Order allow,deny
                allow from all
        </Directory>
        ErrorLog /var/log/apache2/error.log
        LogLevel warn
        CustomLog /var/log/apache2/access.log combined
        ServerSignature On
</VirtualHost>

ensure sites have indexes

cp /var/www/index.html /home/sites
cp /var/www/index.html /home/sites/servername.xxx.com/site/

listvirts

/etc/apache2/listvirts (NB has to start at group 100!)

# nb make sure first site after the original starts at 100!
mywraith.xxx.com - site0
some.site.com - site100

OLD

create /etc/apache2/sites-available/82.95.91.75 with DocumentRoot /home/sites by hand!

/OLD

create /etc/apache2/sites-available/servername.xxx.com

link it in in sites-enabled

check both sites to see if they go to different indexes.

a2enmod rewrite (or a2enmod for options list)

vi /etc/apache2/conf.d/awstats

Alias /awstatsicon/ /usr/share/awstats/icon/

rewrite stuff / redirect

Get rid of the www in the domain name (make sure you do this in the 443 section of the virtualhost after you redirect from http -> https)

RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.yourdomain.com [NC]
RewriteRule ^(.*)$ http://yourdomain.com/$1 [L,R=301]

Or to add the www

<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{HTTP_HOST} ^domain\.com [NC]
RewriteRule ^(.*)$ http://www.domain.com/$1 [L,R=301]
</IfModule>

Post configuration

AWStats

cp /usr/share/doc/awstats/examples/apache.conf /etc/apache2/conf.d/awstats


Make sure that /var/log/apache2 is readable by www-data

chgrp /var/log/apache2/ www-data -R
touch /var/log/statistics

/etc/awstats/model.conf

tar xzvf /usr/share/doc/awstats/examples/awstats.model.conf.gz
cp /usr/share/doc/awstats/examples/awstats.model.conf /etc/awstats/model.conf

Changes in the model.conf for our scripts:

LogFile="thislogfile"
LogFormat="%virtualname %host %other %logname %time1 %methodurl %code %bytesd %refererquot %uaquot"
SiteDomain="thissitedomain"
HostAliases="localhost 127.0.0.1 REGEX[thisdomname\.(thisdomext)$]"
DNSLookup=1
DirData="/var/log/apache2/awstats"
DirIcons="/awstatsicon"
AllowFullYearView=3
SaveDatabaseFilesWithPermissionsForEveryone=1
KeepBackupOfHistoricFiles=1
DebugMessages=1
cp /etc/awstats/model.conf /etc/awstats/awstats.servername.xxx.com.conf

Edit the following directives:

LogFile="/var/log/apache2/access.log"
SiteDomain="servername.xxx.com"
HostAliases="localhost 127.0.0.1 REGEX[servername.xxx\.(com|nl)$]"

Create the index.php file in /home/sites/servername.xxx.com/site/sitestats/servername.xxx.com/

<?
Header('Location: http://servername.xxx.com/sitestats/servername.xxx.com/awstats.zpress.xxx.com.html')
?>

Also do this for the serverIP

copy /etc/awstats/awstats.servername* (ftp / mail / web)

run the statisticsrun in /etc/logrotate.d/apache2 by hand to see how it all goes! ie.

cat /opt/myhost/statisticsSERVERNAME.sh

and run this line by line.

cp /opt/weblog/src/weblog_files/graphs/ /home/sites/USGP.xxx.com/site/webloggraphs/ -R

testing

When testing, it's sometimes useful to delete the following:

/var/cache/awstats/* -R <- generated static files dir

/var/lib/awstats/* <- database directory

in /etc/cron.d/awstats are the run commands to generate the files.

Firewall

Shorewall

Mail

See Installing a new mailserver

For instructions on

Postfix and Procmail, as well as Dovecot (for mail pickup), Amavis-new and ClamAV for antivirus and Roundcube webmail

NB don't forget to

postmap virtual
postmap transport

spamassassin (knowledgebase page)

other stuff

change the mysql password

set up disk quotas (Quota Howto)

backup scripts in /etc/crontab

00 2 * * *      root    /opt/myhost/mysqldatasnapdaily.sh
00 3 * * 7      root    /opt/myhost/mysqldatasnapweekly.sh
00 4 1 * *      root    /opt/myhost/mysqldatasnapmonthly.sh

and

mkdir /home/store
mkdir /home/store/daily
mkdir /home/store/weekly
mkdir /home/store/monthly

OCSInventory

Add to Cacti