################################################################################
#
# FreeBSD Apache configuration db.example.com.
#
# /usr/local/etc/apache24/virtual-hosts/005-db.conf
#
# More info: https://www.librobert.net/book/internet
#
################################################################################
#
# Copyright (c) 2019 Robert LA LAU < https://www.librobert.net/ >
#
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are met:
#
# 1. Redistributions of source code must retain the above copyright notice,
#    this list of conditions and the following disclaimer.
#
# 2. Redistributions in binary form must reproduce the above copyright notice,
#    this list of conditions and the following disclaimer in the documentation
#    and/or other materials provided with the distribution.
#
# 3. Neither the name of the copyright holder nor the names of its contributors
#    may be used to endorse or promote products derived from this software
#    without specific prior written permission.
#
# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
# DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
# FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
# DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
# SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
# CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
# OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
# OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
################################################################################

<VirtualHost *:80>
	ServerName db.example.com
	Redirect permanent "/" "https://db.example.com/"
</VirtualHost>

<VirtualHost *:443>
	ServerName db.example.com

	SSLEngine On
	SSLCertificateFile "/usr/local/etc/letsencrypt/live/db.example.com/fullchain.pem"
	SSLCertificateKeyFile "/usr/local/etc/letsencrypt/live/db.example.com/privkey.pem"

	DocumentRoot /srv/www/db.example.com/htdocs
	<Directory /srv/www/db.example.com/htdocs>
		Require all granted
	</Directory>

	Alias "/mariadb" "/usr/local/www/phpMyAdmin"
	<Directory "/usr/local/www/phpMyAdmin">
		Options none
		AllowOverride Limit
		Require all granted
	</Directory>

	Alias "/postgres" "/usr/local/www/phpPgAdmin"
	<Directory "/usr/local/www/phpPgAdmin">
		Options none
		AllowOverride Limit
		Require all granted
	</Directory>

	Alias "/ldap" "/usr/local/www/phpldapadmin/htdocs"
	<Directory "/usr/local/www/phpldapadmin">
		Options none
		AllowOverride Limit
		Require all granted
	</Directory>

	# ProxyPassMatch "^/mariadb/(.*\.php(/.*)?)$" "fcgi://127.0.0.1:9001/usr/local/www/phpMyAdmin/$1"
	# ProxyPassMatch "^/postgres/(.*\.php(/.*)?)$" "fcgi://127.0.0.1:9001/usr/local/www/phpPgAdmin/$1"
	# ProxyPassMatch "^/ldap/(.*\.php(/.*)?)$" "fcgi://127.0.0.1:9001/usr/local/www/phpldapadmin/htdocs/$1"
	# ProxyPassMatch "^/(.*\.php(/.*)?)$" "fcgi://127.0.0.1:9001/srv/www/db.example.com/htdocs/$1"

	# The lines above can be replaced with the lines below.
	# Clearly, these present less risk of typos.
	# Also, this way there is no need to consider the order of the lines, and no need to add a line
	# for each Alias separately: Apache automatically sends the correct path to the PHP-FPM.
	<Files "*.php">
		SetHandler "proxy:fcgi://127.0.0.1:9001/"
	</Files>
</VirtualHost>