====== Information ====== * WordPress ((https://wordpress.org)) * [[Information:Realm of Espionage]] * https://blog.realmofespionage.xyz ===== Prerequisites ===== * [[bsd:server:freebsd_15.0|FreeBSD 15.0]] * [[servers:bsd:freenginx_php_php-fpm|freenginx + PHP + PHP-FPM]] * [[servers:bsd:nginx:lets_encrypt|Let's Encrypt]] * [[servers:bsd:mariadb|MariaDB]] ====== Dependencies ====== * https://wordpress.org/about/requirements/ * https://make.wordpress.org/hosting/handbook/server-environment/#php-extensions su - pkg install git-lite php85-mysqli php85-intl php85-mbstring php85-xml ====== Download Source ====== * https://github.com/WordPress/WordPress/commits/master/ su - git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/WordPress/WordPress.git' '/usr/local/www/blog' && chown -R 'www':'www' '/usr/local/www/blog' ====== Database ====== su - mariadb CREATE DATABASE wordpress; CREATE USER wordpress@localhost IDENTIFIED BY 'x'; GRANT ALL PRIVILEGES ON wordpress.* to wordpress@localhost; FLUSH PRIVILEGES;EXIT; ====== nginx + PHP-FPM Configuration ====== ===== PHP-FPM Socket ===== su - ee '/usr/local/etc/php-fpm.d/blog.conf' && service 'php_fpm' reload [blog] ; User/Group user = www group = www ; Socket listen = 127.0.0.1:9004 listen.allowed_clients = 127.0.0.1 ; Process Management pm = ondemand pm.max_children = 4 pm.process_idle_timeout = 30 ; General php_value[date.timezone] = "America/New_York" ; Errors php_value[error_reporting] = "~E_ALL" php_value[display_errors] = "Off" ; End ===== FastCGI ===== su - ee '/usr/local/etc/freenginx/default.d/blog.conf' location ~ \.(php|phar)(/.*)?$ { fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$; fastcgi_intercept_errors on; fastcgi_index index.php; include fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_param PATH_INFO $fastcgi_path_info; fastcgi_param HTTPS on; fastcgi_pass 127.0.0.1:9004; } # End ===== Server Block ===== su - ee '/usr/local/etc/freenginx/vhosts.d/blog.conf' && service 'nginx' reload server { listen 443 ssl; http2 on; server_name 'blog.realmofespionage.xyz'; root '/usr/local/www/blog'; index 'index.php'; include '/usr/local/etc/freenginx/default.d/blog.conf'; include '/usr/local/etc/freenginx/default.d/headers.conf'; client_max_body_size '10M'; # access_log /var/log/nginx/blog-access.log; # error_log /var/log/nginx/blog-error.log; location / { try_files $uri $uri/ /index.php?$args; } rewrite /wp-admin$ $scheme://$host$uri/ permanent; location ~* ^.+\.(ogg|ogv|svg|svgz|eot|otf|woff|mp4|ttf|rss|atom|jpg|jpeg|gif|png|ico|zip|tgz|gz|rar|bz2|doc|xls|exe|ppt|tar|mid|midi|wav|bmp|rtf)$ { access_log off; log_not_found off; expires max; } } # End ====== Initial Setup ====== * https://blog.realmofespionage.xyz * Database Host: ''127.0.0.1'' ====== Settings ====== * Date Format: Y/m/d ===== wp-config.php ===== * :!: WordPress set-up needs to generate this file first ((put settings in the ''custom values'' section towards the bottom)) * Doesn't need ''^M'' su - su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" define( 'AUTOMATIC_UPDATER_DISABLED', true ); define( 'WP_DEBUG', false ); define( 'WP_DEBUG_DISPLAY', false ); /* End */ ====== Scripts ====== ===== Updater ===== mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/updater.sh' && chmod +x ~/'.local/scripts/www/blog/updater.sh' #!/bin/sh su -m 'www' -c "git -C '/usr/local/www/blog' reset --hard 'origin/master'" su -m 'www' -c "git -C '/usr/local/www/blog' pull 'origin' 'master' --rebase" # End ~/'.local/scripts/www/blog/updater.sh' su 'root' -c ~/'.local/scripts/www/blog/updater.sh' ===== Maintenance ===== mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/maintenance.sh' && chmod +x ~/'.local/scripts/www/blog/maintenance.sh' #!/bin/sh su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'" su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict" '/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'wordpress' # End ~/'.local/scripts/www/blog/maintenance.sh' su 'root' -c ~/'.local/scripts/www/blog/maintenance.sh' ===== Git Fix ===== * :!: Set email for ''user.email'' * :!: [[#initial_setup|Initial set-up]] needs re-completed for database connection ((re-use existing details)) mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/git-fix.sh' && chmod +x ~/'.local/scripts/www/blog/git-fix.sh' #!/bin/sh su -m 'www' -c "rm -Rf '/usr/local/www/blog/.git'" su -m 'www' -c "git -C '/usr/local/www/blog' init --initial-branch='master'" su -m 'www' -c "git -C '/usr/local/www/blog' add '.'" ################################################## su -m 'www' -c "git -C '/usr/local/www/blog' config 'user.email' 'espionage724@x'" ################################################## su -m 'www' -c "git -C '/usr/local/www/blog' commit --message='x'" su -m 'www' -c "git -C '/usr/local/www/blog' remote add 'origin' 'https://github.com/WordPress/WordPress.git'" su -m 'www' -c "git -C '/usr/local/www/blog' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase" su -m 'www' -c "git -C '/usr/local/www/blog' reset --hard 'origin/master'" su -m 'www' -c "git -C '/usr/local/www/blog' gc --aggressive --prune='all'" su -m 'www' -c "git -C '/usr/local/www/blog' fsck --full --strict" # End ~/'.local/scripts/www/blog/git-fix.sh' su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh' ====== cron ====== ===== Updater ===== * 02:00AM Every day su - ee '/etc/cron.d/blog-updater' # SHELL=/bin/sh 0 2 * * * root '/home/espionage724/.local/scripts/www/blog/updater.sh' # End ====== Backup ====== ===== Folder ===== su - tar -czf '/home/espionage724/wordpress-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'blog' ===== Database ===== **** mariadb-dump -u root -p --single-transaction --quick 'wordpress' -r '/home/espionage724/wordpress-database-manual-'$(date +%Y-%m-%d)'.sql' ===== scp ===== **** scp espionage724@192.168.1.152:~/'wordpress-files-'*'.tar.gz' espionage724@192.168.1.152:~/'wordpress-database-'*'.sql' ~/'Downloads' ====== Restore ====== ===== scp ===== **** scp ~/'Downloads/wordpress-files-'*'.tar.gz' ~/'Downloads/wordpress'*'.sql' espionage724@192.168.1.152:~ ===== Folder ===== su - rm -Rf '/usr/local/www/blog' tar -xzf '/home/espionage724/wordpress-files-'*'.tar.gz' -C '/usr/local/www' 'blog' && chown -R 'www':'www' '/usr/local/www/blog' && sync ===== Database ===== * [[#database|Initial set-up]] mariadb -u 'root' -p --execute='CREATE DATABASE wordpress;' cat ~/'wordpress'*'.sql' | mariadb -u 'root' -p 'wordpress' ===== Settings ===== su - su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" define( 'DB_HOST', 'localhost' );^M define( 'DB_HOST', '127.0.0.1' );^M