RoE | Wiki

User Tools

Site Tools

Trace: • friendica • netgear_r6260_openwrt • mybb • landing_page • freebsd • wordpress
servers:bsd:nginx:wordpress

This is an old revision of the document!

Table of Contents

Information

Prerequisites

Dependencies

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

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"

; 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

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

# End

Initial Setup

Settings

  • Date Format: Y/m/d

wp-config.php

  • :!: Change DB_PASSWORD
su -
su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" && clear
<?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

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

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
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'
#!/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
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'
#!/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
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'
#!/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
su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh'

cron

Updater

  • Daily 02:00:00 AM
su -
ee '/etc/cron.d/blog-updater'
#
SHELL=/bin/sh

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

# End

Backup

  • Monthly (3rd) 02:10:00 AM
su -
ee '/etc/cron.d/blog-backup'
#
SHELL=/bin/sh

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

# End

Maintenance

  • Monthly (3rd) 02:30:00 AM
su -
ee '/etc/cron.d/blog-maintenance'
#
SHELL=/bin/sh

30 2 3 * * root '/home/espionage724/.local/scripts/www/blog/maintenance.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
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

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', 'localhost' );
define( 'DB_HOST', '127.0.0.1' );
1)
https://wordpress.org
2)
2026/01/06: Fixed 2025 theme loading odd buttons in header
/usr/local/www/wiki/data/attic/servers/bsd/nginx/wordpress.1767998307.txt.gz · Last modified: by Sean Rhone
Except where otherwise noted, content on this wiki is licensed under the following license: CC0 1.0 Universal
CC0 1.0 Universal Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki