servers:nginx:mybb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
servers:nginx:mybb [2016/10/30 23:17] – [PHP-FPM Socket] Sean Rhone | servers:nginx:mybb [2016/11/22 16:03] (current) – Sean Rhone | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Information ====== | ||
+ | * MyBB ((https:// | ||
+ | * [[Information: | ||
+ | * https:// | ||
+ | |||
+ | ===== Prerequisites ===== | ||
+ | |||
+ | * [[distros: | ||
+ | * [[servers: | ||
+ | * [[servers: | ||
+ | * [[servers: | ||
+ | |||
+ | ====== Download Source ====== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo git clone -b ' | ||
+ | |||
+ | ====== Database ====== | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | CREATE DATABASE mybb; | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON mybb.* to ' | ||
+ | |||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | ====== nginx + PHP-FPM Configuration ====== | ||
+ | |||
+ | ===== PHP-FPM Socket ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [forums] | ||
+ | user = nginx | ||
+ | group = nginx | ||
+ | | ||
+ | listen = / | ||
+ | listen.owner = nginx | ||
+ | listen.group = nginx | ||
+ | listen.allowed_clients = 127.0.0.1 | ||
+ | | ||
+ | pm = dynamic | ||
+ | pm.max_children = 5 | ||
+ | pm.start_servers = 2 | ||
+ | pm.min_spare_servers = 1 | ||
+ | pm.max_spare_servers = 3 | ||
+ | | ||
+ | php_admin_value[error_log] = / | ||
+ | php_admin_flag[log_errors] = on | ||
+ | | ||
+ | php_value[session.save_handler] = files | ||
+ | php_value[session.save_path] = / | ||
+ | |||
+ | ===== FastCGI ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | location ~ \.php$ { | ||
+ | fastcgi_split_path_info ^(.+\.php)(/ | ||
+ | try_files $fastcgi_script_name =404; | ||
+ | set $path_info $fastcgi_path_info; | ||
+ | fastcgi_param PATH_INFO $path_info; | ||
+ | include fastcgi.conf; | ||
+ | fastcgi_intercept_errors on; | ||
+ | fastcgi_index index.php; | ||
+ | fastcgi_param SCRIPT_FILENAME | ||
+ | fastcgi_param HTTPS on; | ||
+ | fastcgi_pass unix:/ | ||
+ | } | ||
+ | |||
+ | ===== Server Block ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | server { | ||
+ | listen ' | ||
+ | server_name ' | ||
+ | root '/ | ||
+ | index ' | ||
+ | | ||
+ | include '/ | ||
+ | include '/ | ||
+ | | ||
+ | #access_log / | ||
+ | #error_log / | ||
+ | | ||
+ | location / { | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | rewrite ^/ | ||
+ | } | ||
+ | } | ||
+ | |||
+ | ====== Initial Setup ====== | ||
+ | |||
+ | * Use 4-Byte UTF-8 Unicode Table Encoding | ||
+ | |||
+ | * https:// | ||
+ | |||
+ | ====== Services ====== | ||
+ | |||
+ | ===== Updater ===== | ||
+ | |||
+ | ==== Service ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [Service] | ||
+ | User=nginx | ||
+ | Group=nginx | ||
+ | Type=oneshot | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | |||
+ | ==== Timer ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [Unit] | ||
+ | Description=MyBB Git Updater | ||
+ | After=network-online.target | ||
+ | Wants=network-online.target | ||
+ | | ||
+ | [Timer] | ||
+ | OnCalendar=*-*-* 01:55:00 | ||
+ | Persistent=true | ||
+ | | ||
+ | [Install] | ||
+ | WantedBy=timers.target | ||
+ | |||
+ | ===== Backup ===== | ||
+ | |||
+ | ==== Database Auth ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [mysqldump] | ||
+ | user=mybb | ||
+ | password=x | ||
+ | |||
+ | ==== Service ==== | ||
+ | |||
+ | mkdir -p ~/' | ||
+ | |||
+ | [Service] | ||
+ | Type=oneshot | ||
+ | WorkingDirectory=/ | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | |||
+ | ==== Timer ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | [Unit] | ||
+ | Description=MyBB Database Backup | ||
+ | After=mariadb.service | ||
+ | | ||
+ | [Timer] | ||
+ | OnCalendar=*-*-* 02:00:00 | ||
+ | Persistent=true | ||
+ | | ||
+ | [Install] | ||
+ | WantedBy=timers.target | ||
+ | |||
+ | ====== Backup ====== | ||
+ | |||
+ | * Create backup archive on server and transfer to client computer | ||
+ | |||
+ | ===== Server ===== | ||
+ | |||
+ | ==== Stop Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl stop nginx php-fpm | ||
+ | |||
+ | ==== Backup Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | cd '/ | ||
+ | |||
+ | ==== Backup Database ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | mysqldump --defaults-extra-file='/ | ||
+ | |||
+ | ==== Start Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl start nginx php-fpm | ||
+ | |||
+ | ===== Client ===== | ||
+ | |||
+ | ==== Transfer Files To Client ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | scp espionage724@192.168.1.153: | ||
+ | |||
+ | ====== Restore ====== | ||
+ | |||
+ | ===== Client ===== | ||
+ | |||
+ | ==== Transfer Files To Server ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | scp ~/' | ||
+ | |||
+ | ==== Remove Files ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | rm ~/' | ||
+ | |||
+ | ===== Server ===== | ||
+ | |||
+ | ==== Stop Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl stop nginx php-fpm | ||
+ | |||
+ | ==== Remove Previous Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo rm -Rf '/ | ||
+ | |||
+ | ==== Restore MyBB Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | cd '/ | ||
+ | |||
+ | ==== Drop Previous Database ==== | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | DROP DATABASE mybb; | ||
+ | |||
+ | FLUSH TABLES; | ||
+ | |||
+ | ==== Re-create Databases ==== | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | CREATE DATABASE mybb; | ||
+ | |||
+ | ==== Restore Database ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | ==== Reapply Permissions ==== | ||
+ | |||
+ | mysql -u ' | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON mybb.* to ' | ||
+ | |||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | ==== Start Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl start nginx php-fpm | ||
+ | |||
+ | ==== Remove Backups ==== | ||
+ | |||
+ | * Verify that MyBB works before running | ||
+ | |||
+ | rm -R ~/' |
/var/www/wiki/data/pages/servers/nginx/mybb.txt · Last modified: 2016/11/22 16:03 by Sean Rhone