====== Information ====== * MyBB * [[information:realm_of_espionage|Realm of Espionage]] * https://forums.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://docs.mybb.com/1.8/install/requirements/ * https://docs.mybb.com/1.8/install/anonymous-statistics/ * TODO: PHP modules su - pkg install git-lite ====== Download Source ====== * https://github.com/mybb/mybb/commits/feature/ 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' ====== Database ====== su - mariadb CREATE DATABASE mybb; CREATE USER mybb@localhost IDENTIFIED BY 'x'; GRANT ALL PRIVILEGES ON mybb.* to mybb@localhost; FLUSH PRIVILEGES;EXIT; ====== nginx + PHP-FPM Configuration ====== ===== PHP-FPM Socket ===== su - ee '/usr/local/etc/php-fpm.d/forum.conf' && service 'php_fpm' reload [forum] ; User/Group user = www group = www ; Socket listen = 127.0.0.1:9006 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/forum.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:9006; } # End ===== Server Block ===== su - ee '/usr/local/etc/freenginx/vhosts.d/forum.conf' && service 'nginx' reload server { listen 443 ssl; http2 on; server_name 'forums.realmofespionage.xyz'; root '/usr/local/www/forum'; index 'index.php'; include '/usr/local/etc/freenginx/default.d/forum.conf'; include '/usr/local/etc/freenginx/default.d/headers.conf'; client_max_body_size '10M'; # access_log /var/log/nginx/forum-access.log; # error_log /var/log/nginx/forum-error.log; } # End ====== Initial Setup ====== * https://forums.realmofespionage.xyz * Database Engine: ''MySQL Improved'' * Database Server Hostname: ''127.0.0.1'' * Table Encoding: ''4-Byte UTF-8 Unicode'' ====== Settings ====== * TODO ===== Offline Message ===== * Configuration -> Settings -> Board Online / Offline These forums are being built behind-the-scenes, check back later!
In the meantime, check out my wiki: RoE | Wiki ===== config.php ===== su - su -m 'www' -c "ee '/usr/local/www/forum/inc/config.php'" $config['hide_admin_links'] = 1; ====== Scripts ====== ===== Updater ===== mkdir -p ~/'.local/scripts/www/forum' && ee ~/'.local/scripts/www/forum/updater.sh' && chmod +x ~/'.local/scripts/www/forum/updater.sh' #!/bin/sh su -m 'www' -c "git -C '/usr/local/www/forum' reset --hard 'origin/feature'" su -m 'www' -c "git -C '/usr/local/www/forum' pull 'origin' 'feature' --rebase" # End ~/'.local/scripts/www/forum/updater.sh' su 'root' -c ~/'.local/scripts/www/forum/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/forum/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' # SHELL=/bin/sh 0 5 * * * root '/home/espionage724/.local/scripts/www/forum/updater.sh' # End ====== Backup ====== ===== Folder ===== su - tar -czf '/home/espionage724/mybb-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'forum' ===== Database ===== **** mariadb-dump -u root -p --single-transaction --quick 'mybb' -r '/home/espionage724/mybb-database-manual-'$(date +%Y-%m-%d)'.sql' ===== scp ===== **** scp espionage724@192.168.1.152:~/'mybb-files-'*'.tar.gz' espionage724@192.168.1.152:~/'mybb-database-'*'.sql' ~/'Downloads' ====== Restore ====== ===== scp ===== **** scp ~/'Downloads/mybb-files-'*'.tar.gz' ~/'Downloads/mybb'*'.sql' espionage724@192.168.1.152:~ ===== Folder ===== su - rm -Rf '/usr/local/www/forum' tar -xzf '/home/espionage724/mybb-files-'*'.tar.gz' -C '/usr/local/www' 'forum' && chown -R 'www':'www' '/usr/local/www/forum' && sync ===== Database ===== * [[#database|Initial set-up]] mariadb -u 'root' -p --execute='CREATE DATABASE mybb;' cat ~/'mybb'*'.sql' | mariadb -u 'root' -p 'mybb' ===== Settings ===== su - su -m 'www' -c "ee '/usr/local/www/forum/inc/config.php'" $config['database']['hostname'] = '127.0.0.1';