====== Information ======

  * WordPress ((https://wordpress.org))
  * [[information:realm_of_espionage|Realm of Espionage]]
  * https://blog.realmofespionage.xyz

===== Prerequisites =====

  * [[bsd:server:freebsd_16.0|FreeBSD 16.0]]
  * [[servers:bsd:freenginx_php_php-fpm|freenginx + PHP + PHP-FPM]]
  * [[servers:bsd:nginx:lets_encrypt|Certbot (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 php85-curl php85-dom php85-zlib php85-sodium php85-fileinfo php85-zip php85-iconv

====== 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

<code>
[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"

; Logging
php_value[log_errors] = "Off"
php_value[error_reporting] = "~E_ALL"
php_value[display_errors] = "Off"
php_value[display_startup_errors] = "Off"
php_value[html_errors] = "Off"

; General
php_value[date.timezone] = "America/New_York"

; WordPress
php_value[post_max_size] = "10M"
php_value[upload_max_filesize] = "10M"

; End</code>

===== FastCGI =====

  su -

  ee '/usr/local/etc/freenginx/default.d/blog.conf'

<code>
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</code>

===== Server Block =====

  su -

  ee '/usr/local/etc/freenginx/vhosts.d/blog.conf' && service 'nginx' reload

<code>
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';
}

# End</code>

====== Initial Setup ======

  * https://blog.realmofespionage.xyz
  * Database Host: ''127.0.0.1''

====== Settings ======

  * Date Format: Y/m/d

===== wp-config.php =====

  * https://github.com/WordPress/WordPress/blob/master/wp-config-sample.php
  * https://developer.wordpress.org/advanced-administration/wordpress/wp-config/
  * ''SCRIPT_DEBUG'' at ''true'' loads non-minified scripts/CSS ([[https://github.com/WordPress/WordPress/blob/master/wp-includes/script-loader.php#L6|source]]) ((2026/01/06: Fixed 2025 theme loading odd buttons in header))

  * :!: Change ''DB_PASSWORD''

  su -

  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" && clear

<code>
<?php

define( 'DB_NAME', 'wordpress' );
define( 'DB_USER', 'wordpress' );
define( 'DB_PASSWORD', 'x' );
define( 'DB_HOST', '127.0.0.1' );
define( 'DB_CHARSET', 'utf8mb4' );
$table_prefix = 'wp_';

define( 'AUTOMATIC_UPDATER_DISABLED', true );
define( 'WP_DEBUG', false );
define( 'WP_DEBUG_DISPLAY', false );

define( 'SCRIPT_DEBUG', true );

if ( ! defined( 'ABSPATH' ) ) {
        define( 'ABSPATH', __DIR__ . '/' );
}

require_once ABSPATH . 'wp-settings.php';

// End</code>

====== Scripts ======

===== Updater =====

  mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/updater.sh' && chmod +x ~/'.local/scripts/www/blog/updater.sh'

<code>
#!/bin/sh

cd '/tmp'

'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' reset --hard 'origin/master'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull 'origin' 'master' --rebase"

'/bin/sync'

# End</code>

  su 'root' -c ~/'.local/scripts/www/blog/updater.sh'

===== Backup =====

  mkdir -p ~/'backups' ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/backup.sh' && chmod +x ~/'.local/scripts/www/blog/backup.sh'

<code>
#!/bin/sh

cd '/tmp'

'/usr/bin/tar' -czf '/home/espionage724/backups/wordpress-files-auto-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'blog'

'/usr/local/bin/mariadb-dump' --single-transaction --quick 'wordpress' -r '/home/espionage724/backups/wordpress-database-auto-'$(date +%Y-%m-%d)'.sql'

'/bin/sync'

# End</code>

  su 'root' -c ~/'.local/scripts/www/blog/backup.sh'

===== Maintenance =====

  mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/maintenance.sh' && chmod +x ~/'.local/scripts/www/blog/maintenance.sh'

<code>
#!/bin/sh

cd '/tmp'

'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict"

# End</code>

  su 'root' -c ~/'.local/scripts/www/blog/maintenance.sh'

===== Git Fix =====

  * :!: Set email for ''user.email''

  mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/git-fix.sh' && chmod +x ~/'.local/scripts/www/blog/git-fix.sh'

<code>
#!/bin/sh

cd '/tmp'

####################
# Content Back-up
####################

'/usr/bin/su' -m 'www' -c "'/bin/rm' -Rf '/tmp/blog'"
'/usr/bin/su' -m 'www' -c "'/bin/mkdir' -p '/tmp/blog'"
'/usr/bin/su' -m 'www' -c "'/bin/cp' -Rf '/usr/local/www/blog/wp-content/uploads' '/usr/local/www/blog/wp-config.php' '/tmp/blog'"

####################
# WordPress
####################

'/usr/bin/su' -m 'www' -c "'/bin/rm' -Rf '/usr/local/www/blog/.git'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' init --initial-branch='master'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' add '.'"

##################################################
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' config 'user.email' 'espionage724@x'"
##################################################

'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' commit --message='x'"

'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' remote add 'origin' 'https://github.com/WordPress/WordPress.git'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"

'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' reset --hard 'origin/master'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'"
'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict"

####################
# Content Restore
####################

'/usr/bin/su' -m 'www' -c "'/bin/cp' -Rf '/tmp/blog/uploads' '/usr/local/www/blog/wp-content'"
'/usr/bin/su' -m 'www' -c "'/bin/cp' -f '/tmp/blog/wp-config.php' '/usr/local/www/blog/wp-config.php'"
'/usr/bin/su' -m 'www' -c "'/bin/rm' -Rf '/tmp/blog'"

'/bin/sync'

# End</code>

  su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh'

====== cron ======

===== Updater =====

  * Daily ''02:00:00 AM''

  su -

  ee '/etc/cron.d/blog-updater'

<code>
#
SHELL=/bin/sh

0 2 * * * root '/home/espionage724/.local/scripts/www/blog/updater.sh'

# End</code>

===== Backup =====

  * Monthly (3rd) ''02:10:00 AM''

  su -

  ee '/etc/cron.d/blog-backup'

<code>
#
SHELL=/bin/sh

10 2 3 * * root '/home/espionage724/.local/scripts/www/blog/backup.sh'

# End</code>

===== Maintenance =====

  * Monthly (3rd) ''02:30:00 AM''

  su -

  ee '/etc/cron.d/blog-maintenance'

<code>
#
SHELL=/bin/sh

30 2 3 * * root '/home/espionage724/.local/scripts/www/blog/maintenance.sh'

# End</code>

====== Backup ======

===== Folder =====

  su -

  tar -czf '/home/espionage724/wordpress-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'blog'

===== Database =====

  su -

  mariadb-dump --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

  ls '/home/'$USER'/wordpress-files-'*'.tar.gz' && rm -Rf '/usr/local/www/blog'

  tar -xzf '/home/'$USER'/wordpress-files-'*'.tar.gz' -C '/usr/local/www' 'blog' && chown -R 'www':'www' '/usr/local/www/blog' && sync

===== Database =====

  * [[#database|Initial set-up]]

  su

  mariadb --execute='CREATE DATABASE wordpress;'

  cat '/home/'$USER/'wordpress'*'.sql' | mariadb 'wordpress'

===== MySQL Connection =====

  su -

  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" && clear

  define( 'DB_HOST', '127.0.0.1' );