c4y · January 4, 2024 16:50 · Moongazer · Jan 4, 2024 · c4y · Jan 4, 2024
diff --git a/_README.md b/_README.md
diff --git a/backup.sh b/backup.sh
 #bin/backup.sh

 ```
 #!/bin/bash

 set -e

 # SSH_SERVER=
 WEB_FOLDER=/var/www/html
 DB_FOLDER=/var/www/database_backups
 MYSQL_USER=root
 MYSQL_PASSWORD=olli
 MYSQLDUMP=/usr/bin/mysqldump
 MYSQL=/usr/bin/mysql

 # Sichern der Datenbanken
 backup_db() {
  if [ -d "$DB_FOLDER" ]; then
    rm -R $DB_FOLDER
  fi  
  mkdir $DB_FOLDER
  databases=`$MYSQL --defaults-extra-file=/var/www/mysql/config.cnf -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema|mysql)"` 
  for db in $databases; do
    $MYSQLDUMP --defaults-extra-file=/var/www/mysql/config.cnf --force --opt --column-statistics=0 --databases $db | gzip > "$DB_FOLDER/$db.sql.gz"
  done
 }

 catch() {
   # echo -e "Subject: Backup-Fehler\nFehler in Zeile $1" #| msmtp [email protected]
   if [ "$1" != "0" ]; then
    echo "Error $1 occurred on $2"
  fi
 }

 echo `date +"%y%m%d-%H%M%S Datenbank Dumps werden erzeugt"` > /var/www/backup.log 2>&1
 backup_db
 echo `date +"%y%m%d-%H%M%S Die Webseiten werden gesichert"` >> /var/www/backup.log 2>&1
 rsync -avz -e 'ssh -p23' --delete --exclude-from=/var/www/rsync-excludes /var/www/html/ [email protected]:/home/backups/html 
 echo `date +"%y%m%d-%H%M%S Die Datenbanken werden gesichert"` >> /var/www/backup.log 2>&1
 rsync -avz -e 'ssh -p23' --delete /var/www/database_backups/ [email protected]:/home/backups/databases/ 
 echo `date +"%y%m%d-%H%M%S Sicherung erfolgreich beendet"` >> /var/www/backup.log 2>&1
 ```
diff --git a/docker-compose.yml b/docker-compose.yml
 ```yml
 version: '3.8'

 services:

    # Nginx Service
    nginx:
        image: nginx:latest
        ports:
            - 80:80
            - 8074:8074
        links:
            - 'php81'
            - 'php74'
        volumes:
            - ./html:/var/www/html
            - ./nginx/nginx-conf/nginx.conf:/etc/nginx/conf.d/nginx.conf
        depends_on:
            - php81
        restart: always
  
    # PHP Service
    php81:
        build:
            context: ./php
            dockerfile: php81-fpm-docker
        volumes:
            - './html:/var/www/html'
            - './php/81/php.ini:/usr/local/etc/php/php.ini'
            - './php/81/www.conf:/usr/local/etc/php-fpm.d/www.conf'
            - './php/81/xdebug.ini:/usr/local/etc/php/conf.d/xdebug.ini'
        depends_on:
            - mariadb
        restart: always
        
    # PHP Service
    php74:
        build:
            context: ./php
            dockerfile: php74-fpm-docker
        volumes:
            - './html:/var/www/html'
            - './php/74/php.ini:/usr/local/etc/php/php.ini'
            - './php/74/www.conf:/usr/local/etc/php-fpm.d/www.conf'
            - './php/74/xdebug.ini:/usr/local/etc/php/conf.d/xdebug.ini'
        #expose: 
            #- 9003
        depends_on:
            - mariadb
        restart: always
            
    # MariaDB Service
    mariadb:
        image: mariadb:10.9
        ports:
          - 3306:3306
        environment:
            MYSQL_ROOT_PASSWORD: olli
        volumes:
            - mysqldata:/var/lib/mysql
        restart: always

    # Mailhog
    mailhog:
        image: mailhog/mailhog
        ports:
            - 1025:1025
            - 8025:8025
        restart: always

 # Volumes
 volumes:
  mysqldata:
 ```
diff --git a/nginx.conf b/nginx.conf
 #nginx/nginx-conf/nginx.conf  

 ```
 #user olli olli

 server {
    listen 80;
    
    server_name ~^(?<projekt>.+)\..*\.contao4you.de$;
    root /var/www/html/$projekt/public;
    index index.php index.html;
    
    proxy_buffer_size 128k;
    proxy_buffers 4 256k;
    proxy_busy_buffers_size 256k;

    client_max_body_size 64M;

    location / {
        try_files $uri $uri/ /index.php$is_args$args;
    }

    location ~ ^/(preview|contao-manager\.phar)\.php(/|$) {
        fastcgi_pass php81:9000;
        fastcgi_split_path_info ^(.+\.php)(/.*)$;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param SCRIPT_NAME $fastcgi_script_name;
        fastcgi_buffer_size 128k;
        fastcgi_buffers 4 256k;
        fastcgi_busy_buffers_size 256k;
        include fastcgi_params;
    }
    
    location ~ \.php$ {
        fastcgi_pass php81:9000;
        fastcgi_split_path_info ^(.+\.php)(/.*)$;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        fastcgi_param DOCUMENT_ROOT $realpath_root;
        fastcgi_buffer_size 128k;
        fastcgi_buffers 4 256k;
        fastcgi_busy_buffers_size 256k;
        include fastcgi_params;
        #internal;
    }
    
    location = /favicon.ico {
        log_not_found off;
        access_log off;
        try_files $uri /index.php$is_args$args;
    }
    
    location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
        log_not_found off;
        try_files $uri /index.php$is_args$args;
    }
    
    #error_log /var/www/logs/nginx_error.log;
    #access_log /var/www/logs/nginx_access.log;
    
 }

 server {
    listen 8074;
    
    server_name ~^(?<projekt>.+)\..*\.contao4you.de$;
    root /var/www/html/$projekt/public;
    index index.php index.html;

    proxy_buffer_size 128k;
    proxy_buffers 4 256k;
    proxy_busy_buffers_size 256k;

    client_max_body_size 64M;

    location / {
        try_files $uri $uri/ /index.php$is_args$args;
    }

    location ~ ^/(preview|contao-manager\.phar)\.php(/|$) {
        fastcgi_pass php74:9000;
        fastcgi_split_path_info ^(.+\.php)(/.*)$;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param SCRIPT_NAME $fastcgi_script_name;
        fastcgi_buffer_size 128k;
        fastcgi_buffers 4 256k;
        fastcgi_busy_buffers_size 256k;
        include fastcgi_params;
    }
    
    location ~ \.php$ {
        fastcgi_pass php74:9000;
        fastcgi_split_path_info ^(.+\.php)(/.*)$;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        fastcgi_param DOCUMENT_ROOT $realpath_root;
        fastcgi_buffer_size 128k;
        fastcgi_buffers 4 256k;
        fastcgi_busy_buffers_size 256k;
        include fastcgi_params;
        #internal;
    }
    
    location = /favicon.ico {
        log_not_found off;
        access_log off;
        try_files $uri /index.php$is_args$args;
    }
    
    location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
        log_not_found off;
        try_files $uri /index.php$is_args$args;
    }
 }

 ```
diff --git a/php.ini b/php.ini
 #php/81/php.ini

 ```
 [www]
 user = olli
 listen .owner = olli
 ```
diff --git a/php81-fpm-docker b/php81-fpm-docker
 #php/php81-fpm-docker

 ```
 FROM php:8.1-fpm

 RUN groupadd -g 1000 olli
 RUN useradd -d /home/olli -s /bin/bash -u 1000 -g 1000 olli
 RUN mkdir /home/olli
 RUN chown -R olli /var/www/html

 # Installing dependencies for the PHP modules
 RUN apt-get update && \
    apt-get install -y zip gettext openssl libzip-dev libpng-dev libicu-dev libjpeg-dev libjpeg62-turbo-dev libxml2-dev libwebp-dev libfreetype6-dev libgd-dev

 # Installing additional PHP modules
 RUN docker-php-ext-configure gd --with-freetype --with-jpeg --with-webp
 RUN docker-php-ext-install gd
 RUN docker-php-ext-install mysqli pdo pdo_mysql zip
 RUN docker-php-ext-configure intl
 RUN docker-php-ext-install intl

 RUN pecl install xdebug-3.1.6 && docker-php-ext-enable xdebug
 ```
diff --git a/rsync-exclude b/rsync-exclude
 ```
 .git

 assets
 public
 system/cache
 system/themes
 system/logs
 system/tmp
 var
 vendor
 web

 node_modules
 ```
diff --git a/www.conf b/www.conf
 #php/81/www.conf

 ```
 [www]
 user = olli
 group = olli

 listen = 9000

 listen.owner = olli
 listen.group = olli
 ```
diff --git a/xdebug.ini b/xdebug.ini
 #php/81/xdebug.ini

 ```
 zend_extension=xdebug

 [xdebug]
 xdebug.mode = debug
 xdebug.start_with_request=yes
 xdebug.client_port=9003
 xdebug.remote_autostart = 0
 xdebug.client_host = 192.168.1.7

 ```
	#bin/backup.sh

	```
	#!/bin/bash

	set -e

	# SSH_SERVER=
	WEB_FOLDER=/var/www/html
	DB_FOLDER=/var/www/database_backups
	MYSQL_USER=root
	MYSQL_PASSWORD=olli
	MYSQLDUMP=/usr/bin/mysqldump
	MYSQL=/usr/bin/mysql

	# Sichern der Datenbanken
	backup_db() {
	if [ -d "$DB_FOLDER" ]; then
	rm -R $DB_FOLDER
	fi
	mkdir $DB_FOLDER
	databases=`$MYSQL --defaults-extra-file=/var/www/mysql/config.cnf -e "SHOW DATABASES;" \| grep -Ev "(Database\|information_schema\|performance_schema\|mysql)"`
	for db in $databases; do
	$MYSQLDUMP --defaults-extra-file=/var/www/mysql/config.cnf --force --opt --column-statistics=0 --databases $db \| gzip > "$DB_FOLDER/$db.sql.gz"
	done
	}

	catch() {
	# echo -e "Subject: Backup-Fehler\nFehler in Zeile $1" #\| msmtp [email protected]
	if [ "$1" != "0" ]; then
	echo "Error $1 occurred on $2"
	fi
	}

	echo `date +"%y%m%d-%H%M%S Datenbank Dumps werden erzeugt"` > /var/www/backup.log 2>&1
	backup_db
	echo `date +"%y%m%d-%H%M%S Die Webseiten werden gesichert"` >> /var/www/backup.log 2>&1
	rsync -avz -e 'ssh -p23' --delete --exclude-from=/var/www/rsync-excludes /var/www/html/ [email protected]:/home/backups/html
	echo `date +"%y%m%d-%H%M%S Die Datenbanken werden gesichert"` >> /var/www/backup.log 2>&1
	rsync -avz -e 'ssh -p23' --delete /var/www/database_backups/ [email protected]:/home/backups/databases/
	echo `date +"%y%m%d-%H%M%S Sicherung erfolgreich beendet"` >> /var/www/backup.log 2>&1
	```
	```yml
	version: '3.8'

	services:

	# Nginx Service
	nginx:
	image: nginx:latest
	ports:
	- 80:80
	- 8074:8074
	links:
	- 'php81'
	- 'php74'
	volumes:
	- ./html:/var/www/html
	- ./nginx/nginx-conf/nginx.conf:/etc/nginx/conf.d/nginx.conf
	depends_on:
	- php81
	restart: always

	# PHP Service
	php81:
	build:
	context: ./php
	dockerfile: php81-fpm-docker
	volumes:
	- './html:/var/www/html'
	- './php/81/php.ini:/usr/local/etc/php/php.ini'
	- './php/81/www.conf:/usr/local/etc/php-fpm.d/www.conf'
	- './php/81/xdebug.ini:/usr/local/etc/php/conf.d/xdebug.ini'
	depends_on:
	- mariadb
	restart: always

	# PHP Service
	php74:
	build:
	context: ./php
	dockerfile: php74-fpm-docker
	volumes:
	- './html:/var/www/html'
	- './php/74/php.ini:/usr/local/etc/php/php.ini'
	- './php/74/www.conf:/usr/local/etc/php-fpm.d/www.conf'
	- './php/74/xdebug.ini:/usr/local/etc/php/conf.d/xdebug.ini'
	#expose:
	#- 9003
	depends_on:
	- mariadb
	restart: always

	# MariaDB Service
	mariadb:
	image: mariadb:10.9
	ports:
	- 3306:3306
	environment:
	MYSQL_ROOT_PASSWORD: olli
	volumes:
	- mysqldata:/var/lib/mysql
	restart: always

	# Mailhog
	mailhog:
	image: mailhog/mailhog
	ports:
	- 1025:1025
	- 8025:8025
	restart: always

	# Volumes
	volumes:
	mysqldata:
	```
	#nginx/nginx-conf/nginx.conf

	```
	#user olli olli

	server {
	listen 80;

	server_name ~^(?<projekt>.+)\..*\.contao4you.de$;
	root /var/www/html/$projekt/public;
	index index.php index.html;

	proxy_buffer_size 128k;
	proxy_buffers 4 256k;
	proxy_busy_buffers_size 256k;

	client_max_body_size 64M;

	location / {
	try_files $uri $uri/ /index.php$is_args$args;
	}

	location ~ ^/(preview\|contao-manager\.phar)\.php(/\|$) {
	fastcgi_pass php81:9000;
	fastcgi_split_path_info ^(.+\.php)(/.*)$;
	fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
	fastcgi_param SCRIPT_NAME $fastcgi_script_name;
	fastcgi_buffer_size 128k;
	fastcgi_buffers 4 256k;
	fastcgi_busy_buffers_size 256k;
	include fastcgi_params;
	}

	location ~ \.php$ {
	fastcgi_pass php81:9000;
	fastcgi_split_path_info ^(.+\.php)(/.*)$;
	fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
	fastcgi_param DOCUMENT_ROOT $realpath_root;
	fastcgi_buffer_size 128k;
	fastcgi_buffers 4 256k;
	fastcgi_busy_buffers_size 256k;
	include fastcgi_params;
	#internal;
	}

	location = /favicon.ico {
	log_not_found off;
	access_log off;
	try_files $uri /index.php$is_args$args;
	}

	location ~* \.(js\|css\|png\|jpg\|jpeg\|gif\|ico)$ {
	log_not_found off;
	try_files $uri /index.php$is_args$args;
	}

	#error_log /var/www/logs/nginx_error.log;
	#access_log /var/www/logs/nginx_access.log;

	}

	server {
	listen 8074;

	server_name ~^(?<projekt>.+)\..*\.contao4you.de$;
	root /var/www/html/$projekt/public;
	index index.php index.html;

	proxy_buffer_size 128k;
	proxy_buffers 4 256k;
	proxy_busy_buffers_size 256k;

	client_max_body_size 64M;

	location / {
	try_files $uri $uri/ /index.php$is_args$args;
	}

	location ~ ^/(preview\|contao-manager\.phar)\.php(/\|$) {
	fastcgi_pass php74:9000;
	fastcgi_split_path_info ^(.+\.php)(/.*)$;
	fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
	fastcgi_param SCRIPT_NAME $fastcgi_script_name;
	fastcgi_buffer_size 128k;
	fastcgi_buffers 4 256k;
	fastcgi_busy_buffers_size 256k;
	include fastcgi_params;
	}

	location ~ \.php$ {
	fastcgi_pass php74:9000;
	fastcgi_split_path_info ^(.+\.php)(/.*)$;
	fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
	fastcgi_param DOCUMENT_ROOT $realpath_root;
	fastcgi_buffer_size 128k;
	fastcgi_buffers 4 256k;
	fastcgi_busy_buffers_size 256k;
	include fastcgi_params;
	#internal;
	}

	location = /favicon.ico {
	log_not_found off;
	access_log off;
	try_files $uri /index.php$is_args$args;
	}

	location ~* \.(js\|css\|png\|jpg\|jpeg\|gif\|ico)$ {
	log_not_found off;
	try_files $uri /index.php$is_args$args;
	}
	}

	```
	#php/php81-fpm-docker

	```
	FROM php:8.1-fpm

	RUN groupadd -g 1000 olli
	RUN useradd -d /home/olli -s /bin/bash -u 1000 -g 1000 olli
	RUN mkdir /home/olli
	RUN chown -R olli /var/www/html

	# Installing dependencies for the PHP modules
	RUN apt-get update && \
	apt-get install -y zip gettext openssl libzip-dev libpng-dev libicu-dev libjpeg-dev libjpeg62-turbo-dev libxml2-dev libwebp-dev libfreetype6-dev libgd-dev

	# Installing additional PHP modules
	RUN docker-php-ext-configure gd --with-freetype --with-jpeg --with-webp
	RUN docker-php-ext-install gd
	RUN docker-php-ext-install mysqli pdo pdo_mysql zip
	RUN docker-php-ext-configure intl
	RUN docker-php-ext-install intl

	RUN pecl install xdebug-3.1.6 && docker-php-ext-enable xdebug
	```
	```
	.git

	assets
	public
	system/cache
	system/themes
	system/logs
	system/tmp
	var
	vendor
	web

	node_modules
	```
	#php/81/www.conf

	```
	[www]
	user = olli
	group = olli

	listen = 9000

	listen.owner = olli
	listen.group = olli
	```
	#php/81/xdebug.ini

	```
	zend_extension=xdebug

	[xdebug]
	xdebug.mode = debug
	xdebug.start_with_request=yes
	xdebug.client_port=9003
	xdebug.remote_autostart = 0
	xdebug.client_host = 192.168.1.7

	```