servers:nginx:wordpress
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
servers:nginx:wordpress [2020/04/24 12:19] – Ubuntu 20.04 Sean Rhone | servers:nginx:wordpress [2024/02/01 10:03] (current) – Sean Rhone | ||
---|---|---|---|
Line 7: | Line 7: | ||
===== Prerequisites ===== | ===== Prerequisites ===== | ||
- | * [[distros:ubuntu_server|Ubuntu | + | * [[distros:fedora_server|Fedora |
* [[servers: | * [[servers: | ||
* [[servers: | * [[servers: | ||
Line 14: | Line 14: | ||
===== Notes ===== | ===== Notes ===== | ||
- | * :!: Do not initiate any updates from the Admin/ | + | * :!: Do not initiate any updates from the Admin/ |
+ | |||
+ | ====== Dependencies ====== | ||
+ | |||
+ | * https:// | ||
+ | * https:// | ||
+ | |||
+ | sudo dnf install php-mysqlnd php-xml php-pecl-igbinary php-imagick php-intl php-mbstring php-pecl-zip php-sodium php-bcmath php-gd php-process | ||
====== Download Source ====== | ====== Download Source ====== | ||
Line 20: | Line 27: | ||
**** | **** | ||
- | sudo git clone --branch ' | + | sudo git clone --branch ' |
====== Database ====== | ====== Database ====== | ||
- | sudo mysql | + | sudo mariadb |
CREATE DATABASE wordpress; | CREATE DATABASE wordpress; | ||
Line 38: | Line 45: | ||
===== PHP-FPM Socket ===== | ===== PHP-FPM Socket ===== | ||
- | sudo -e '/ | + | sudo -e '/ |
< | < | ||
[blog] | [blog] | ||
- | user = www-data | ||
- | group = www-data | ||
- | listen = / | + | ; User/ |
- | listen.owner = www-data | + | user = nginx |
- | listen.group = www-data | + | group = nginx |
+ | |||
+ | ; Socket | ||
+ | listen = /run/php-fpm/ | ||
+ | listen.acl_users | ||
listen.allowed_clients = 127.0.0.1 | listen.allowed_clients = 127.0.0.1 | ||
- | pm = dynamic | + | ; Process Management |
- | pm.max_children = 8 | + | pm = ondemand |
- | pm.start_servers | + | pm.max_children = 4 |
- | pm.min_spare_servers = 2 | + | pm.process_idle_timeout |
- | pm.max_spare_servers = 4 | + | |
- | php_value[date.timezone] = "America/ | + | ; Fedora php.ini Defaults |
- | php_value[upload_tmp_dir] = "/tmp" | + | php_value[session.save_handler] = "files" |
+ | php_value[session.save_path] = "/var/ | ||
+ | ; General | ||
+ | php_value[date.timezone] = " | ||
php_value[max_execution_time] = " | php_value[max_execution_time] = " | ||
php_value[memory_limit] = " | php_value[memory_limit] = " | ||
Line 65: | Line 76: | ||
php_value[max_file_uploads] = " | php_value[max_file_uploads] = " | ||
- | php_value[session.save_handler] = " | + | ; End</code> |
- | php_value[session.save_path] = "/var/ | + | |
- | php_value[soap.wsdl_cache_dir] = "/ | + | < |
- | php_value[opcache.file_cache] = "/var/ | + | php_value[upload_tmp_dir] = "/tmp"</ |
===== FastCGI ===== | ===== FastCGI ===== | ||
- | sudo -e '/ | + | sudo -e '/ |
< | < | ||
Line 78: | Line 89: | ||
location ~ \.(php|phar)(/ | location ~ \.(php|phar)(/ | ||
fastcgi_split_path_info ^(.+\.(?: | fastcgi_split_path_info ^(.+\.(?: | ||
- | |||
fastcgi_intercept_errors on; | fastcgi_intercept_errors on; | ||
fastcgi_index index.php; | fastcgi_index index.php; | ||
include fastcgi_params; | include fastcgi_params; | ||
- | fastcgi_param SCRIPT_FILENAME | + | fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; |
fastcgi_param PATH_INFO $fastcgi_path_info; | fastcgi_param PATH_INFO $fastcgi_path_info; | ||
- | fastcgi_pass unix:/ | + | fastcgi_pass unix:/ |
}</ | }</ | ||
===== Server Block ===== | ===== Server Block ===== | ||
- | * :!: '' | + | * 2023/09/12: CSPs disabled; TODO: Re-figure out CSPs |
- | sudo -e '/ | + | sudo -e '/ |
< | < | ||
Line 100: | Line 110: | ||
index ' | index ' | ||
- | include '/ | + | include '/ |
- | include '/ | + | include '/ |
client_max_body_size ' | client_max_body_size ' | ||
- | | + | # |
- | # access_log | + | # access_log |
- | # error_log | + | # error_log |
location / { | location / { | ||
Line 120: | Line 130: | ||
} | } | ||
}</ | }</ | ||
- | |||
- | ==== Enable ==== | ||
- | |||
- | **** | ||
- | |||
- | sudo rm -f '/ | ||
====== Initial Setup ====== | ====== Initial Setup ====== | ||
Line 145: | Line 149: | ||
< | < | ||
[Service] | [Service] | ||
- | User=www-data | + | User=nginx |
- | Group=www-data | + | Group=nginx |
Type=oneshot | Type=oneshot | ||
ExecStart='/ | ExecStart='/ | ||
- | ExecStartPost='/ | + | ExecStartPost=' |
==== Timer ==== | ==== Timer ==== | ||
Line 178: | Line 182: | ||
< | < | ||
[Service] | [Service] | ||
- | User=www-data | + | User=nginx |
- | Group=www-data | + | Group=nginx |
Type=oneshot | Type=oneshot | ||
ExecStart='/ | ExecStart='/ | ||
ExecStart='/ | ExecStart='/ | ||
- | ExecStartPost='/ | + | ExecStartPost=' |
==== Timer ==== | ==== Timer ==== | ||
- | * '' | + | * '' |
- | sudo -e '/ | + | sudo -e '/ |
< | < | ||
Line 216: | Line 220: | ||
Type=oneshot | Type=oneshot | ||
WorkingDirectory=/ | WorkingDirectory=/ | ||
- | ExecStart='/ | + | ExecStart=' |
- | ExecStartPost='/ | + | ExecStartPost=' |
=== Timer === | === Timer === | ||
- | * '' | + | * '' |
sudo -e '/ | sudo -e '/ | ||
Line 230: | Line 234: | ||
[Timer] | [Timer] | ||
- | OnCalendar=*-*-01 04:50:00 | + | OnCalendar=*-*-01 04:35:00 |
Persistent=true | Persistent=true | ||
Line 240: | Line 244: | ||
=== Database Auth === | === Database Auth === | ||
- | sudo -u ' | + | sudo mkdir -p '/var/lib/mysql/auth' |
< | < | ||
- | [mysqldump] | + | [mariadb-dump] |
user=wordpress | user=wordpress | ||
password=x</ | password=x</ | ||
Line 249: | Line 253: | ||
=== Service === | === Service === | ||
- | mkdir -p ~/' | + | mkdir -p ~/' |
< | < | ||
Line 255: | Line 259: | ||
Type=oneshot | Type=oneshot | ||
WorkingDirectory=/ | WorkingDirectory=/ | ||
- | ExecStartPre='/ | + | ExecStartPre='/ |
- | ExecStart='/ | + | ExecStart=' |
- | ExecStart='/ | + | ExecStart=' |
- | ExecStartPost='/ | + | ExecStartPost=' |
=== Timer === | === Timer === | ||
- | * Every day at '' | + | * Every day at '' |
sudo -e '/ | sudo -e '/ | ||
Line 272: | Line 276: | ||
[Timer] | [Timer] | ||
- | OnCalendar=*-*-* 04:15:00 | + | OnCalendar=*-*-* 04:45:00 |
Persistent=true | Persistent=true | ||
Line 288: | Line 292: | ||
**** | **** | ||
- | sudo systemctl stop nginx php7.4-fpm | + | sudo systemctl stop nginx php-fpm |
==== Backup Folder ==== | ==== Backup Folder ==== | ||
Line 300: | Line 304: | ||
**** | **** | ||
- | sudo mysqldump | + | sudo mariadb-dump |
==== Start Services ==== | ==== Start Services ==== | ||
Line 306: | Line 310: | ||
**** | **** | ||
- | sudo systemctl start nginx php7.4-fpm | + | sudo systemctl start nginx php-fpm |
===== Client ===== | ===== Client ===== | ||
Line 314: | Line 318: | ||
**** | **** | ||
- | scp espionage724@192.168.1.153: | + | scp espionage724@192.168.1.152: |
====== Restore ====== | ====== Restore ====== | ||
Line 330: | Line 334: | ||
**** | **** | ||
- | scp ~/' | + | scp ~/' |
==== Remove Files ==== | ==== Remove Files ==== | ||
Line 344: | Line 348: | ||
**** | **** | ||
- | sudo systemctl stop nginx php7.4-fpm | + | sudo systemctl stop nginx php-fpm |
==== Remove Previous Folder ==== | ==== Remove Previous Folder ==== | ||
Line 356: | Line 360: | ||
**** | **** | ||
- | cd '/ | + | cd '/ |
==== Drop Previous Database ==== | ==== Drop Previous Database ==== | ||
- | sudo mysql | + | sudo mariadb |
DROP DATABASE wordpress; | DROP DATABASE wordpress; | ||
Line 370: | Line 374: | ||
==== Re-create Databases ==== | ==== Re-create Databases ==== | ||
- | sudo mysql | + | sudo mariadb |
CREATE DATABASE wordpress; | CREATE DATABASE wordpress; | ||
Line 380: | Line 384: | ||
**** | **** | ||
- | sudo mysql ' | + | sudo mariadb |
==== Reapply Permissions ==== | ==== Reapply Permissions ==== | ||
- | sudo mysql | + | sudo mariadb |
GRANT ALL PRIVILEGES ON wordpress.* to ' | GRANT ALL PRIVILEGES ON wordpress.* to ' | ||
Line 396: | Line 400: | ||
**** | **** | ||
- | sudo systemctl start nginx php7.4-fpm | + | sudo systemctl start nginx php-fpm |
==== Remove Backups ==== | ==== Remove Backups ==== | ||
Line 403: | Line 407: | ||
rm ~/' | rm ~/' | ||
+ |
/var/www/wiki/data/attic/servers/nginx/wordpress.1587745149.txt.gz · Last modified: 2020/04/24 12:19 by Sean Rhone