Drupal + Apache + PostgreSQL

Drupal + Apache + PostgreSQL

출처: Drupal + Apache + PostgreSQL — wdocs 1.0 documentation

• https://www.howtoforge.com/tutorial/how-to-install-drupal_8-with-apache-and-ssl-on-ubuntu-15-10/

Tested on Ubuntu Xenial (16.04)

Install prerequirements:

sudo apt update
sudo apt install postgresql apache2 php libapache2-mod-php7.0 php7.0-gd php7.0-xml php7.0-pgsql

a2enmod rewrite ssl
systemctl restart apache2

# check ssl, rewrite
apache2ctl -M | egrep 'ssl|rewrite'

Download end extract drupal:

cd /var/www/
wget https://ftp.drupal.org/files/projects/drupal-8.2.2.tar.gz
tar -xvzf drupal-8.2.2.tar.gz
mv drupal-8.2.2 drupal
chown www-data:www-data -R drupal/

Apache configuration

SSL:

mkdir /etc/apache2/ssl

# generate a self-signed SSL certificate
sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/apache2/ssl/drupalssl.key -out /etc/apache2/ssl/drupalssl.crt
sudo chmod 600 /etc/apache2/ssl/*

Create virtual host config /etc/apache2/sites-available/drupal.conf:

        ServerName www.mydrupal.co
        DocumentRoot /var/www/drupal

        # Redirect http to https
        RedirectMatch 301 (.*) https://www.mydrupal.co$1




        # Server Info
        ServerName www.mydrupal.co
        ServerAlias mydrupal.co
        ServerAdmin webmaster@localhost

        # Web root
        DocumentRoot /var/www/drupal

        # Log configuration
        ErrorLog ${APACHE_LOG_DIR}/drupal-error.log
        CustomLog ${APACHE_LOG_DIR}/drupal-access.log combined

        #   Enable/Disable SSL for this virtual host.
        SSLEngine on

        # Self signed SSL Certificate file
        SSLCertificateFile      /etc/apache2/ssl/drupalssl.crt
        SSLCertificateKeyFile /etc/apache2/ssl/drupalssl.key

        <directory "="" var="" www="" drupal"="">
                Options FollowSymLinks
                AllowOverride All
                Require all granted
        

        <filesmatch "\.(cgi|shtml|phtml|php)$"="">
                        SSLOptions +StdEnvVars
        
        
                        SSLOptions +StdEnvVars
        

        BrowserMatch "MSIE [2-6]" \
                        nokeepalive ssl-unclean-shutdown \
                        downgrade-1.0 force-response-1.0
        # MSIE 7 and newer should be able to use keepalive
        BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown

Enable new virtual host:

# check config
apachectl configtest

# enable new host
a2ensite drupal

# disable default host config
a2dissite 000-default

systemctl restart apache2

DB Postgres for drupal

Create DB and User for Drupal:

su - postgres

psql
    CREATE USER drupal WITH password 'PASSWORD';
    CREATE DATABASE drupal OWNER drupal;
    GRANT ALL privileges ON DATABASE drupal TO drupal;

exit

psql -h localhost drupal drupal
    ALTER DATABASE "drupal" SET bytea_output = 'escape';