| Both sides previous revisionPrevious revisionNext revision | Previous revision | 
| servers:bsd:nginx:mybb [2025/10/30 22:27]  –  Sean Rhone | servers:bsd:nginx:mybb [2025/10/31 02:24] (current)  – [Updater]  Sean Rhone | 
|---|
| * [[information:realm_of_espionage|Realm of Espionage]] | * [[information:realm_of_espionage|Realm of Espionage]] | 
| * https://forums.realmofespionage.xyz | * https://forums.realmofespionage.xyz | 
|  |  | 
| * :!: WIP |  | 
|  |  | 
| ===== Prerequisites ===== | ===== Prerequisites ===== | 
| * https://docs.mybb.com/1.8/install/requirements/ | * https://docs.mybb.com/1.8/install/requirements/ | 
| * https://docs.mybb.com/1.8/install/anonymous-statistics/ | * https://docs.mybb.com/1.8/install/anonymous-statistics/ | 
|  | * TODO: PHP modules | 
|  |  | 
| su - | su - | 
|  |  | 
| pkg install git-lite php85-composer | pkg install git-lite | 
|  |  | 
| ====== Download Source ====== | ====== Download Source ====== | 
|  |  | 
| * https://github.com/WordPress/WordPress/commits/master/ | * https://github.com/mybb/mybb/commits/feature/ | 
|  |  | 
| su - | su - | 
|  |  | 
| git clone --branch 'feature' --depth '1' --recurse-submodules 'https://github.com/mybb/mybb.git' '/usr/local/www/forum' && chown -R 'www':'www' '/usr/local/www/forum' | git clone --branch 'feature' --depth '1' --recurse-submodules 'https://github.com/mybb/mybb.git' '/usr/local/www/forum' && chown -R 'www':'www' '/usr/local/www/forum' | 
|  |  | 
| ====== Environment ====== |  | 
|  |  | 
| ===== Composer ===== |  | 
|  |  | 
| * https://github.com/mybb/mybb/wiki/Getting-started-with-MyBB-1.9-development---Composer |  | 
|  |  | 
| su - |  | 
|  |  | 
| cd '/tmp' && su -m 'www' -c "cd '/tmp' && '/usr/local/bin/composer.phar' --working-dir='/usr/local/www/forum' --no-cache install --no-dev" |  | 
|  |  | 
| ====== Database ====== | ====== Database ====== | 
|  |  | 
| * https://forums.realmofespionage.xyz | * https://forums.realmofespionage.xyz | 
|  |  | 
|  | * Database Engine: ''MySQL Improved'' | 
|  | * Database Server Hostname: ''127.0.0.1'' | 
|  | * Table Encoding: ''4-Byte UTF-8 Unicode'' | 
|  |  | 
| ====== Settings ====== | ====== Settings ====== | 
|  |  | 
| ===== config.php ===== | ===== config.php ===== | 
|  |  | 
| * https://docs.mybb.com/1.8/administration/utf-8-setup/ |  | 
|  |  | 
| su - | su - | 
| su -m 'www' -c "ee '/usr/local/www/forum/inc/config.php'" | su -m 'www' -c "ee '/usr/local/www/forum/inc/config.php'" | 
|  |  | 
| <code> | <code>$config['hide_admin_links'] = 1;</code> | 
| $config['database']['encoding'] = 'utf8mb4';</code> |  | 
|  |  | 
| ====== Scripts ====== | ====== Scripts ====== | 
| ===== Updater ===== | ===== Updater ===== | 
|  |  | 
| mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/updater.sh' && chmod +x ~/'.local/scripts/www/blog/updater.sh' | mkdir -p ~/'.local/scripts/www/forum' && ee ~/'.local/scripts/www/forum/updater.sh' && chmod +x ~/'.local/scripts/www/forum/updater.sh' | 
|  |  | 
| <code> | <code> | 
| #!/bin/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/forum' reset --hard 'origin/feature'" | 
| su -m 'www' -c "git -C '/usr/local/www/blog' pull 'origin' 'master' --rebase" | su -m 'www' -c "git -C '/usr/local/www/forum' pull 'origin' 'feature' --rebase" | 
|  |  | 
| # End</code> | # End</code> | 
|  |  | 
| ~/'.local/scripts/www/blog/updater.sh' | ~/'.local/scripts/www/forum/updater.sh' | 
|  |  | 
| su 'root' -c ~/'.local/scripts/www/blog/updater.sh' | su 'root' -c ~/'.local/scripts/www/forum/updater.sh' | 
|  |  | 
| ===== Maintenance ===== | ===== Maintenance ===== | 
| # End</code> | # End</code> | 
|  |  | 
| ~/'.local/scripts/www/blog/git-fix.sh' | ~/'.local/scripts/www/forum/git-fix.sh' | 
|  |  | 
| su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh' | su 'root' -c ~/'.local/scripts/www/forum/git-fix.sh' | 
|  |  | 
|  | ====== cron ====== | 
|  |  | 
|  | ===== Updater ===== | 
|  |  | 
|  | * 05:00AM Every day | 
|  |  | 
|  | su - | 
|  |  | 
|  | ee '/etc/cron.d/forum-updater' | 
|  |  | 
|  | <code> | 
|  | # | 
|  | SHELL=/bin/sh | 
|  |  | 
|  | 0 5 * * * root '/home/espionage724/.local/scripts/www/forum/updater.sh' | 
|  |  | 
|  | # End</code> | 
|  |  | 
| ====== Backup ====== | ====== Backup ====== | 
| su - | su - | 
|  |  | 
| tar -czf '/home/espionage724/wordpress-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'blog' | tar -czf '/home/espionage724/mybb-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'forum' | 
|  |  | 
| ===== Database ===== | ===== Database ===== | 
| **** | **** | 
|  |  | 
| mariadb-dump -u root -p --single-transaction --quick 'wordpress' -r '/home/espionage724/wordpress-database-manual-'$(date +%Y-%m-%d)'.sql' | mariadb-dump -u root -p --single-transaction --quick 'mybb' -r '/home/espionage724/mybb-database-manual-'$(date +%Y-%m-%d)'.sql' | 
|  |  | 
| ===== scp ===== | ===== scp ===== | 
| **** | **** | 
|  |  | 
| scp espionage724@192.168.1.152:~/'wordpress-files-'*'.tar.gz' espionage724@192.168.1.152:~/'wordpress-database-'*'.sql' ~/'Downloads' | scp espionage724@192.168.1.152:~/'mybb-files-'*'.tar.gz' espionage724@192.168.1.152:~/'mybb-database-'*'.sql' ~/'Downloads' | 
|  |  | 
| ====== Restore ====== | ====== Restore ====== | 
| **** | **** | 
|  |  | 
| scp ~/'Downloads/wordpress-files-'*'.tar.gz' ~/'Downloads/wordpress'*'.sql' espionage724@192.168.1.152:~ | scp ~/'Downloads/mybb-files-'*'.tar.gz' ~/'Downloads/mybb'*'.sql' espionage724@192.168.1.152:~ | 
|  |  | 
| ===== Folder ===== | ===== Folder ===== | 
| su - | su - | 
|  |  | 
| rm -Rf '/usr/local/www/blog' | rm -Rf '/usr/local/www/forum' | 
|  |  | 
| tar -xzf '/home/espionage724/wordpress-files-'*'.tar.gz' -C '/usr/local/www' 'blog' && chown -R 'www':'www' '/usr/local/www/blog' && sync | tar -xzf '/home/espionage724/mybb-files-'*'.tar.gz' -C '/usr/local/www' 'forum' && chown -R 'www':'www' '/usr/local/www/forum' && sync | 
|  |  | 
| ===== Database ===== | ===== Database ===== | 
| * [[#database|Initial set-up]] | * [[#database|Initial set-up]] | 
|  |  | 
| mariadb -u 'root' -p --execute='CREATE DATABASE wordpress;' | mariadb -u 'root' -p --execute='CREATE DATABASE mybb;' | 
|  |  | 
| cat ~/'wordpress'*'.sql' | mariadb -u 'root' -p 'wordpress' | cat ~/'mybb'*'.sql' | mariadb -u 'root' -p 'mybb' | 
|  |  | 
| ===== Settings ===== | ===== Settings ===== | 
| su - | su - | 
|  |  | 
| su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'" | su -m 'www' -c "ee '/usr/local/www/forum/inc/config.php'" | 
|  |  | 
| define( 'DB_HOST', 'localhost' );^M |  | 
|  |  | 
| define( 'DB_HOST', '127.0.0.1' );^M | <code>$config['database']['hostname'] = '127.0.0.1';</code> | 
|  |  |