RoE | Wiki

User Tools

Site Tools

Trace: • vsftpd • mariadb • mybb • joomla
servers:linux:nginx:mybb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
servers:linux:nginx:mybb [2024/08/13 22:18] – created Sean Rhoneservers:linux:nginx:mybb [2025/09/13 00:52] (current) – Sean Rhone
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * MyBB ((https://mybb.com/)) +  * MyBB 
-  * [[Information:Realm of Espionage]]+  * [[information:realm_of_espionage|Realm of Espionage]]
   * https://forums.realmofespionage.xyz   * https://forums.realmofespionage.xyz
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:fedora_server | Fedora Server]] +  * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]] 
-  * [[servers:mariadb | MariaDB]] +  * [[servers:linux:nginx_php_php-fpm|nginx + PHP + PHP-FPM]] 
-  * [[servers:nginx_php_php-fpm | nginx + PHP + PHP-FPM]] +  * [[servers:linux:nginx:lets_encrypt|Certbot (Let's Encrypt)]] 
-  * [[servers:nginx:lets_encrypt | Let's Encrypt]]+  * [[servers:linux:mariadb|MariaDB]] 
 + 
 +====== Dependencies ====== 
 + 
 +  * https://docs.mybb.com/1.8/install/requirements/ 
 +  * https://docs.mybb.com/1.8/install/anonymous-statistics/ 
 + 
 +  sudo zypper install php-composer2
  
 ====== Download Source ====== ====== Download Source ======
  
-****+  * https://github.com/mybb/mybb/commits/dev-1.9/
  
-  sudo git clone -b 'feature' 'https://github.com/mybb/mybb.git' '/var/www/forums' && sudo chcon -R -t 'httpd_sys_rw_content_t' '/var/www/forums' && sudo chown -R 'nginx':'nginx' '/var/www/forums' && sync+  sudo git clone --branch 'dev-1.9' --depth '1' --recurse-submodules 'https://github.com/mybb/mybb.git' '/srv/www/forum' && sudo chown -R 'wwwrun':'www' '/srv/www/forum' && sudo chmod -R '0755' '/srv/www/forum' 
 + 
 +====== Environment ====== 
 + 
 +  * https://github.com/mybb/mybb/wiki/Getting-started-with-MyBB-1.9-development---Composer 
 + 
 +===== Composer ===== 
 + 
 +  sudo su 'wwwrun' -s '/bin/bash' 
 + 
 +  cd '/tmp' && composer --working-dir='/srv/www/forum' --no-cache install --no-dev 
 + 
 +  exit
  
 ====== Database ====== ====== Database ======
  
-  mysql -u 'root' -p+  sudo mariadb
  
   CREATE DATABASE mybb;   CREATE DATABASE mybb;
  
-  GRANT ALL PRIVILEGES ON mybb.* to 'mybb'@'localhost' IDENTIFIED BY 'x';+  CREATE USER 'mybb'@'localhost' IDENTIFIED BY 'x'; 
 + 
 +  GRANT ALL PRIVILEGES ON mybb.* to 'mybb'@'localhost';
  
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
 +
 +  EXIT
  
 ====== nginx + PHP-FPM Configuration ====== ====== nginx + PHP-FPM Configuration ======
Line 32: Line 55:
 ===== PHP-FPM Socket ===== ===== PHP-FPM Socket =====
  
-  sudo -e '/etc/php-fpm.d/forums.conf' && sudo systemctl reload 'php-fpm'+  sudo -e '/etc/php8/fpm/php-fpm.d/forum.conf' && sudo systemctl restart 'php-fpm'
  
-  [forums] +<code> 
-  user = nginx +[forum] 
-  group = nginx + 
-   +; User/Group 
-  listen = /run/php-fpm/forums.sock +user = "wwwrun" 
-  listen.owner = nginx +group = "www" 
-  listen.group = nginx + 
-  listen.allowed_clients = 127.0.0.1 +; Socket 
-   +listen = "/run/php-fpm/forum.sock" 
-  pm = dynamic +listen.owner = "wwwrun" 
-  pm.max_children = 5 +listen.group = "www" 
-  pm.start_servers = 2 +listen.mode = "0662" 
-  pm.min_spare_servers = 1 + 
-  pm.max_spare_servers = 3 +; Process Management 
-   +pm = "ondemand" 
-  php_admin_value[error_log] = /var/log/php-fpm/www-error.log +pm.max_children = "4" 
-  php_admin_flag[log_errors] = on +pm.process_idle_timeout = "30" 
-   + 
-  php_value[session.save_handler] = files +; openSUSE php.ini Defaults 
-  php_value[session.save_path] = /var/lib/nginx/session+php_value[session.save_path] = "/var/lib/php8/sessions" 
 + 
 +; General 
 +php_value[log_errors] = "0" 
 +php_value[error_reporting] = "~E_ALL" 
 +php_value[date.timezone] = "America/New_York" 
 +php_value[max_execution_time] = "200" 
 +php_value[memory_limit] = "512M" 
 +php_value[post_max_size] = "10M" 
 +php_value[upload_max_filesize] = "10M" 
 +php_value[max_file_uploads] = "100" 
 + 
 +; End</code>
  
 ===== FastCGI ===== ===== FastCGI =====
  
-  sudo -e '/etc/nginx/default.d/forums.conf'+  * ''forum.sock''
  
-  location ~ \.php$ { +  sudo -e '/etc/nginx/default.d/forum.conf' 
-      fastcgi_split_path_info ^(.+\.php)(/.+)$; + 
-      try_files $fastcgi_script_name =404; +<code> 
-      set $path_info $fastcgi_path_info; +location ~ \.(php|phar)(/.*)?$ { 
-      fastcgi_param PATH_INFO $path_info; +    fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$; 
-      include fastcgi.conf; +    fastcgi_intercept_errors on; 
-      fastcgi_intercept_errors on; +    fastcgi_index index.php; 
-      fastcgi_index index.php; +    include fastcgi_params; 
-      fastcgi_param SCRIPT_FILENAME  $document_root$fastcgi_script_name; +    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; 
-      fastcgi_param HTTPS on; +    fastcgi_param PATH_INFO $fastcgi_path_info; 
-      fastcgi_pass unix:/run/php-fpm/forums.sock; +    fastcgi_pass unix:/run/php-fpm/forum.sock; 
-  }+} 
 + 
 +# End</code>
  
 ===== Server Block ===== ===== Server Block =====
  
-  sudo -e '/etc/nginx/conf.d/forums.conf' && sudo systemctl reload 'nginx'+  sudo -e '/etc/nginx/vhosts.d/forum.conf' && sudo systemctl reload 'nginx'
  
-  server { +<code> 
-      listen '443' 'ssl' 'http2'; +server { 
-      server_name 'forums.realmofespionage.xyz'; +    listen '443' 'ssl'; 
-      root '/var/www/forums'; +    http2 'on'; 
-      index 'index.php'; +    server_name 'forums.realmofespionage.xyz'; 
-   +    root '/srv/www/forum'; 
-      include '/etc/nginx/default.d/forums.conf'; +    index 'index.php'; 
-      include '/etc/nginx/default.d/restrictions.conf'; + 
-   +    include '/etc/nginx/default.d/forum.conf'; 
-      #access_log /var/log/nginx/forums-access.log; +    include '/etc/nginx/default.d/headers.conf'; 
-      #error_log /var/log/nginx/forums-error.log; + 
-   +    client_max_body_size '10M'; 
-      location / { + 
-          rewrite ^/forum-([0-9]+)\.html$ /forumdisplay.php?fid=$1; +#    access_log  /var/log/nginx/forum-access.log; 
-          rewrite ^/forum-([0-9]+)-page-([0-9]+)\.html$ /forumdisplay.php?fid=$1&page=$2; +#    error_log  /var/log/nginx/forum-error.log; 
-          rewrite ^/thread-([0-9]+)\.html$ /showthread.php?tid=$1; + 
-          rewrite ^/thread-([0-9]+)-page-([0-9]+)\.html$ /showthread.php?tid=$1&page=$2; +} 
-          rewrite ^/thread-([0-9]+)-lastpost\.html$ /showthread.php?tid=$1&action=lastpost; + 
-          rewrite ^/thread-([0-9]+)-nextnewest\.html$ /showthread.php?tid=$1&action=nextnewest; +# End</code>
-          rewrite ^/thread-([0-9]+)-nextoldest\.html$ /showthread.php?tid=$1&action=nextoldest; +
-          rewrite ^/thread-([0-9]+)-newpost\.html$ /showthread.php?tid=$1&action=newpost; +
-          rewrite ^/thread-([0-9]+)-post-([0-9]+)\.html$ /showthread.php?tid=$1&pid=$2; +
-          rewrite ^/post-([0-9]+)\.html$ /showthread.php?pid=$1; +
-          rewrite ^/announcement-([0-9]+)\.html$ /announcements.php?aid=$1; +
-          rewrite ^/user-([0-9]+)\.html$ /member.php?action=profile&uid=$1; +
-          rewrite ^/archive/index.php/forum-([0-9]+)\.html$ /archive/index.php?forum-$1.html; +
-          rewrite ^/archive/index.php/thread-([0-9]+)\.html$ /archive/index.php?thread-$1.html; +
-          rewrite ^/archive/index.php/forum-([0-9]+)-([0-9]+)\.html$ /archive/index.php?forum-$1-$2.html; +
-          rewrite ^/archive/index.php/thread-([0-9]+)-([0-9]+)\.html$ /archive/index.php?thread-$1-$2.html; +
-      } +
-  }+
  
 ====== Initial Setup ====== ====== Initial Setup ======
  
-  * Use 4-Byte UTF-8 Unicode Table Encoding+  * https://forums.realmofespionage.xyz 
 + 
 +====== Settings ====== 
 + 
 +  * TODO 
 + 
 +===== Offline Message ===== 
 + 
 +  * Configuration -> Settings -> Board Online / Offline 
 + 
 +<code> 
 +These forums are being built behind-the-scenes, check back later! 
 +<br /> 
 +In the meantime, check out my wiki: <a href="https://wiki.realmofespionage.xyz/">RoE | Wiki</a> 
 +</code> 
 + 
 +===== config.php ===== 
 + 
 +  * https://docs.mybb.com/1.8/administration/utf-8-setup/ 
 + 
 +  sudo su 'wwwrun' -s '/bin/bash' 
 + 
 +  nano '/srv/www/forum/inc/config.php' 
 + 
 +<code> 
 +$config['database']['encoding'] = 'utf8mb4';</code>
  
-  * https://forums.realmofespionage.xyz/install/index.php+  exit
  
 ====== Services ====== ====== Services ======
Line 120: Line 170:
 ==== Service ==== ==== Service ====
  
-  sudo -e '/etc/systemd/system/forums-up.service'+  sudo -e '/etc/systemd/system/forum-up.service'
  
-  [Service] +<code> 
-  User=nginx +[Service] 
-  Group=nginx +User=wwwrun 
-  Type=oneshot +Group=www 
-  ExecStart='/usr/bin/git' -C '/var/www/forums' pull origin 'feature' +Type=oneshot 
-  ExecStart='/usr/bin/sync'+ 
 +Environment="COMPOSER_CACHE_DIR=/dev/null" 
 + 
 +ExecStart='/usr/bin/git' -C '/srv/www/forum' pull origin 'dev-1.9' 
 + 
 +ExecStart='/usr/bin/composer' --working-dir='/srv/www/forum' --no-cache install 
 + 
 +ExecStartPost='/usr/bin/sync' 
 + 
 +# End</code>
  
 ==== Timer ==== ==== Timer ====
  
-  sudo -e '/etc/systemd/system/forums-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forums-up.timer' --now && sudo systemctl start 'forums-up' && sudo systemctl status 'forums-up' -l+  * Every day at ''05:00:00'' 
 + 
 +  sudo -e '/etc/systemd/system/forum-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forum-up.timer' --now && sudo systemctl start 'forum-up' && sudo systemctl status 'forum-up' -l 
 + 
 +<code> 
 +[Unit] 
 +Description=MyBB Git Updater 
 +After=network-online.target 
 +Wants=network-online.target 
 + 
 +[Timer] 
 +OnCalendar=*-*-* 05:00:00 
 +Persistent=true 
 + 
 +[Install] 
 +WantedBy=timers.target
  
-  [Unit] +# End</code>
-  Description=MyBB Git Updater +
-  After=network-online.target +
-  Wants=network-online.target +
-   +
-  [Timer] +
-  OnCalendar=*-*-* 01:55:00 +
-  Persistent=true +
-   +
-  [Install] +
-  WantedBy=timers.target+
  
 ===== Backup ===== ===== Backup =====
  
-==== Database Auth ====+==== Files ====
  
-  sudo -e '/var/lib/mysqlauth/mybb' && sudo chmod '600' '/var/lib/mysqlauth/mybb'+=== Service ===
  
-  [mysqldump] +  mkdir -p ~/'backups' && sudo -e '/etc/systemd/system/forum-fb.service' && sudo sed -i 's/CHANGEME/'$USER'/g' '/etc/systemd/system/forum-fb.service'
-  user=mybb +
-  password=x+
  
-==== Service ====+<code> 
 +[Service] 
 +Type=oneshot
  
-  mkdir -p ~/'backups' && sudo mkdir -p '/var/lib/mysqltmp' && sudo -e '/etc/systemd/system/forums-b.service' && sudo sed -i 's/CHANGEME/'$USER'/g' '/etc/systemd/system/forums-b.service'+ExecStart='/usr/bin/bash' -c '"/usr/bin/tar" -czf "/home/CHANGEME/backups/mybb-files-auto-"$$(date +%%Y-%%m-%%d)".tar.gz" -C "/srv/www" "forum"'
  
-  [Service] +ExecStartPost='/usr/bin/sync'
-  Type=oneshot +
-  WorkingDirectory=/var/lib/mysqltmp +
-  ExecStart='/usr/bin/mysqldump' --defaults-extra-file='/var/lib/mysqlauth/mybb' --single-transaction 'mybb' -r '/var/lib/mysqltmp/mybb.sql' +
-  ExecStart='/usr/bin/gzip' -f '/var/lib/mysqltmp/mybb.sql' +
-  ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysqltmp/mybb.sql.gz" "/home/CHANGEME/backups/mybb-"$$(date +%%Y-%%m-%%d)".sql.gz"' +
-  ExecStart='/usr/bin/sync'+
  
-==== Timer ====+# End</code>
  
-  sudo -e '/etc/systemd/system/forums-b.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forums-b.timer' --now && sudo systemctl start 'forums-b' && sudo systemctl status 'forums-b' -l+=== Timer ===
  
-  [Unit] +  * ''01'' day of every month at ''05:15:00''
-  Description=MyBB Database Backup +
-  After=mariadb.service +
-   +
-  [Timer] +
-  OnCalendar=*-*-* 02:00:00 +
-  Persistent=true +
-   +
-  [Install] +
-  WantedBy=timers.target+
  
-====== Backup ======+  sudo -e '/etc/systemd/system/forum-fb.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forum-fb.timer' --now
  
-  * Create backup archive on server and transfer to client computer+<code> 
 +[Unit] 
 +Description=MyBB Files Backup
  
-===== Server =====+[Timer] 
 +OnCalendar=*-*-01 05:15:00 
 +Persistent=true
  
-==== Stop Services ====+[Install] 
 +WantedBy=timers.target
  
-****+# End</code>
  
-  sudo systemctl stop nginx php-fpm+  sudo systemctl start 'forum-fb' && sudo systemctl status 'forum-fb' -l
  
-==== Backup Folder ====+==== Database ====
  
-****+=== Database Auth ===
  
-  cd '/var/www' && tar -cvzf ~/'forums-manual.tar.gz' 'forums' && cd ~ && sync+  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/mybb' && sudo chown 'mysql':'mysql' '/var/lib/mysql/auth/mybb' && sudo chmod '0600' '/var/lib/mysql/auth/mybb'
  
-==== Backup Database ====+<code> 
 +[mariadb-dump] 
 +user=mybb 
 +password=x
  
-****+# End</code>
  
-  mysqldump --defaults-extra-file='/var/lib/mysqlauth/mybb' --single-transaction 'mybb' -r '~/'mybb-manual.sql' && sync+=== Service ===
  
-==== Start Services ====+  mkdir -p ~/'backups' && sudo mkdir -p '/var/lib/mysql/tmp' && sudo -e '/etc/systemd/system/forum-db.service' && sudo sed -i 's/'CHANGEME'/'$USER'/g' '/etc/systemd/system/forum-db.service'
  
-****+<code> 
 +[Service] 
 +Group=mysql 
 +Type=oneshot
  
-  sudo systemctl start nginx php-fpm+ExecStart='/usr/bin/bash' -c '"/usr/bin/mariadb-dump" --defaults-extra-file="/var/lib/mysql/auth/mybb" --single-transaction --quick "mybb" -r "/home/CHANGEME/backups/mybb-database-auto-"$$(date +%%Y-%%m-%%d)".sql"'
  
-===== Client =====+ExecStartPost='/usr/bin/sync'
  
-==== Transfer Files To Client ====+# End</code>
  
-****+=== Timer ===
  
-  scp espionage724@192.168.1.153:~/'forums-manual.tar.gz' ~/'mybb-manual.sql' ~/'Downloads' && sync'+  * ''01'' day of every month at ''05:10:00''
  
-====== Restore ======+  sudo -e '/etc/systemd/system/forum-db.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forum-db.timer' --now && sudo systemctl start 'forum-db' && sudo systemctl status 'forum-db' -l
  
-===== Client =====+<code> 
 +[Unit] 
 +Description=mybb Database Backup 
 +After=mariadb.service
  
-==== Transfer Files To Server ====+[Timer] 
 +OnCalendar=*-*-01 05:10:00 
 +Persistent=true
  
-****+[Install] 
 +WantedBy=timers.target
  
-  scp ~/'Downloads/forums-manual.tar.gz' ~/'Downloads/mybb-manual.sql' espionage724@192.168.1.153:~+# End</code>
  
-==== Remove Files ====+===== Maintenance =====
  
-****+==== Service ====
  
-  rm ~/'Downloads/forums-manual.tar.gz' ~/'Downloads/mybb-manual.sql' && sync+  sudo -e '/etc/systemd/system/forum-m.service'
  
-===== Server =====+<code> 
 +[Service] 
 +User=wwwrun 
 +Group=www 
 +Type=oneshot
  
-==== Stop Services ====+ExecStart='/usr/bin/git' -C '/srv/www/forum' gc --aggressive --prune='all' 
 +ExecStart='/usr/bin/git' -C '/srv/www/forum' fsck --full --strict
  
-****+ExecStartPost='/usr/bin/sync'
  
-  sudo systemctl stop nginx php-fpm+# End</code>
  
-==== Remove Previous Folder ====+==== Timer ==== 
 + 
 +  * ''01'' day of every month at ''05:30:00'' 
 + 
 +  sudo -e '/etc/systemd/system/forum-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'forum-m.timer' --now 
 + 
 +<code> 
 +[Unit] 
 +Description=MyBB Maintenance 
 +After=network-online.target 
 +Wants=network-online.target 
 + 
 +[Timer] 
 +OnCalendar=*-*-01 05:30:00 
 +Persistent=true 
 + 
 +[Install] 
 +WantedBy=timers.target 
 + 
 +# End</code> 
 + 
 +  sudo systemctl start 'forum-m' && sudo systemctl status 'forum-m' -l 
 + 
 +====== Backup ====== 
 + 
 +===== Files =====
  
 **** ****
  
-  sudo rm -Rf '/var/www/forums'+  sudo tar -czf ~/'mybb-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/srv/www' 'forum'
  
-==== Restore MyBB Folder ====+===== Database =====
  
 **** ****
  
-  cd '/var/www' && sudo tar -xvzf ~/'forums-manual.tar.gz' 'forums' && sudo chcon -R -t 'httpd_sys_rw_content_t' '/var/www/forums' && sudo chown -R 'nginx':'nginx' '/var/www/forums' && cd ~ && sync+  sudo mariadb-dump --single-transaction --quick 'mybb' -r ~/'mybb-database-manual-'$(date +%Y-%m-%d)'.sql'
  
-==== Drop Previous Database ====+===== scp =====
  
-  mysql -u 'root' -p+  scp espionage724@192.168.1.152:~/'mybb-files-'*'.tar.gz' ~/'Downloads'
  
-  DROP DATABASE mybb;+  scp espionage724@192.168.1.152:~/'mybb-database-'*'.sql' ~/'Downloads'
  
-  FLUSH TABLES;+====== Restore ======
  
-==== Re-create Databases ====+===== scp =====
  
-  mysql -u 'root' -p+  scp ~/'Downloads/mybb-files-'*'.tar.gz' espionage724@192.168.1.152:~
  
-  CREATE DATABASE mybb;+  scp ~/'Downloads/mybb-database-'*'.sql' espionage724@192.168.1.152:~
  
-==== Restore Database ====+===== Stop nginx =====
  
 **** ****
  
-  mysql -u 'root' -p 'mybb' < ~/'mybb-manual.sql' && sync+  sudo systemctl stop 'nginx'
  
-==== Reapply Permissions ====+===== Remove Existing Files =====
  
-  mysql -u 'root' -p+****
  
-  GRANT ALL PRIVILEGES ON mybb.* to 'mybb'@'localhost' IDENTIFIED BY 'x';+  ls ~/'mybb-files-'*'.tar.gz' && sudo rm -Rf '/srv/www/forum'
  
-  FLUSH PRIVILEGES;+===== Restore Files =====
  
-==== Start Services ====+**** 
 + 
 +  sudo tar -xzf ~/'mybb-files-'*'.tar.gz' -C '/srv/www' 'forum' && sudo chown -R 'wwwrun':'www' '/srv/www/forum' && sudo chmod -R '0755' '/srv/www/forum' 
 + 
 +===== Restore Database ===== 
 + 
 +  * [[#database|Initial set-up]] 
 + 
 +  sudo mariadb --execute='DROP DATABASE mybb;' 
 + 
 +  sudo mariadb --execute='CREATE DATABASE mybb;' 
 + 
 +  sudo mariadb 'mybb' < ~/'mybb-database-'*'.sql' 
 + 
 +===== Start nginx =====
  
 **** ****
  
-  sudo systemctl start nginx php-fpm+  sudo systemctl start 'nginx'
  
-==== Remove Backups ====+===== Clean-up =====
  
-  * Verify that MyBB works before running+****
  
-  rm -R ~/'forums-manual.tar.gz' ~/'mybb-manual.sql' && sync+  rm -fv ~/'mybb-files-'*'.tar.gz' ~/'mybb-database-'*'.sql'
  
/srv/www/wiki/data/attic/servers/linux/nginx/mybb.1723601926.txt.gz · Last modified: by Sean Rhone