Differences

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

--- servers:linux:nginx:wordpress [2025/12/20 23:01] – [Back-up] Sean Rhone
+++ servers:linux:nginx:wordpress [2025/12/21 00:43] (current) – [Git Fix] Sean Rhone
@@ Line 90: / Line 90: @@
 # End</code>
-===== Server Block =====
-    location / {
-        try_files $uri $uri/ /index.php?$args;
-    }
-    rewrite /wp-admin$ $scheme://$host$uri/ permanent;
-}
 ===== Server Block ======
@@ Line 147: / Line 134: @@
 ===== wp-config.php =====
-  * :!: WordPress set-up needs to generate this file first ((put settings in the ''custom values'' section towards the bottom))
+  * https://github.com/WordPress/WordPress/blob/master/wp-config-sample.php
+  * https://developer.wordpress.org/advanced-administration/wordpress/wp-config/
+  * :!: Change ''DB_PASSWORD''
   sudo -u 'www-data' -e '/var/www/blog/wp-config.php'
 <code>
-define( 'AUTOMATIC_UPDATER_DISABLED', true );
+<?php
+define( 'DB_NAME', 'wordpress' );
+define( 'DB_USER', 'wordpress' );
+define( 'DB_PASSWORD', 'x' );
+define( 'DB_HOST', 'localhost' );
+define( 'DB_CHARSET', 'utf8mb4' );
+$table_prefix = 'wp_';
+define( 'AUTOMATIC_UPDATER_DISABLED', true );
 define( 'WP_DEBUG', false );
 define( 'WP_DEBUG_DISPLAY', false );
-/* End */</code>
+if ( ! defined( 'ABSPATH' ) ) {
+        define( 'ABSPATH', __DIR__ . '/' );
+}
+require_once ABSPATH . 'wp-settings.php';
+// End</code>
+====== Scripts ======
+===== Git Fix =====
+  * :!: Set email for ''user.email''
+  sudo mkdir -p '/etc/nginx/scripts/blog' && sudo -e '/etc/nginx/scripts/blog/git-fix.sh' && sudo chmod '0500' '/etc/nginx/scripts/blog/git-fix.sh' && sudo chown 'www-data':'www-data' '/etc/nginx/scripts/blog/git-fix.sh'
+<code>
+#!/bin/bash
+'/usr/bin/rm' -Rf '/tmp/blog'
+'/usr/bin/mkdir' -p '/tmp/blog'
+'/usr/bin/cp' -Rf '/var/www/blog/wp-content/uploads' '/var/www/blog/wp-config.php' '/tmp/blog'
+'/usr/bin/rm' -Rf '/var/www/blog/.git'
+'/usr/bin/git' -C '/var/www/blog' init --initial-branch='master'
+'/usr/bin/git' -C '/var/www/blog' add '.'
+########################################
+'/usr/bin/git' -C '/var/www/blog' config 'user.email' 'espionage724@x'
+########################################
+'/usr/bin/git' -C '/var/www/blog' commit --message='x'
+'/usr/bin/git' -C '/var/www/blog' remote add 'origin' 'https://github.com/WordPress/WordPress.git'
+'/usr/bin/git' -C '/var/www/blog' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase
+'/usr/bin/git' -C '/var/www/blog' reset --hard 'origin/master'
+'/usr/bin/git' -C '/var/www/blog' gc --aggressive --prune='all'
+'/usr/bin/git' -C '/var/www/blog' fsck --full --strict
+'/usr/bin/cp' -Rf '/tmp/blog/uploads' '/var/www/blog/wp-content'
+'/usr/bin/cp' -f '/tmp/blog/wp-config.php' '/var/www/blog/wp-config.php'
+'/usr/bin/rm' -Rf '/tmp/blog'
+# End</code>
+  sudo -u 'www-data' '/etc/nginx/scripts/blog/git-fix.sh'
 ====== Services ======
@@ Line 173: / Line 217: @@
 Type=oneshot
-ExecStart='/usr/bin/git' -C '/var/www/blog' pull origin 'master'
+WorkingDirectory=/var/www/blog
+ExecStart='/usr/bin/git' -C '/var/www/blog' reset --hard
+ExecStart='/usr/bin/git' -C '/var/www/blog' pull origin 'master' --rebase
 ExecStartPost='/usr/bin/sync'
@@ Line 181: / Line 228: @@
 ==== Timer ====
-  * Every day at ''02:00:00''
+  * Daily ''02:00:00 AM''
   sudo -e '/etc/systemd/system/blog-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'blog-up.timer' --now && sudo systemctl start 'blog-up' && sudo systemctl status 'blog-up' -l
@@ Line 211: / Line 258: @@
 [Service]
 Type=oneshot
+WorkingDirectory=/var/www/blog
 ExecStart='/usr/bin/bash' -c '"/usr/bin/tar" -czf "/home/CHANGEME/backups/wordpress-files-auto-"$$(date +%%Y-%%m-%%d)".tar.gz" -C "/var/www" "blog"'
@@ Line 220: / Line 269: @@
 === Timer ===
-  * ''01'' day of every month at ''02:15:00''
+  * Monthly (3rd) ''02:15:00 AM''
   sudo -e '/etc/systemd/system/blog-fb.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'blog-fb.timer' --now
@@ Line 229: / Line 278: @@
 [Timer]
-OnCalendar=*-*-01 02:15:00
+OnCalendar=*-*-03 02:15:00
 Persistent=true
@@ Line 260: / Line 309: @@
 Group=mysql
 Type=oneshot
+WorkingDirectory=/var/lib/mysql
 ExecStart='/usr/bin/bash' -c '"/usr/bin/mariadb-dump" --defaults-extra-file="/var/lib/mysql/auth/wordpress" --single-transaction --quick "wordpress" -r "/home/CHANGEME/backups/wordpress-database-auto-"$$(date +%%Y-%%m-%%d)".sql"'
@@ Line 269: / Line 320: @@
 === Timer ===
-  * ''01'' day of every month at ''02:10:00''
+  * Monthly (3rd) ''02:10:00 AM''
   sudo -e '/etc/systemd/system/blog-db.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'blog-db.timer' --now && sudo systemctl start 'blog-db' && sudo systemctl status 'blog-db' -l
@@ Line 279: / Line 330: @@
 [Timer]
-OnCalendar=*-*-01 02:10:00
+OnCalendar=*-*-03 02:10:00
 Persistent=true
@@ Line 299: / Line 350: @@
 Type=oneshot
-ExecStart='/usr/bin/git' -C '/var/www/blog' reset --hard
+WorkingDirectory=/var/www/blog
 ExecStart='/usr/bin/git' -C '/var/www/blog' gc --aggressive --prune='all'
 ExecStart='/usr/bin/git' -C '/var/www/blog' fsck --full --strict
@@ Line 309: / Line 361: @@
 ==== Timer ====
-  * ''01'' day of every month at ''02:30:00''
+  * Monthly (3rd) ''02:30:00 AM''
   sudo -e '/etc/systemd/system/blog-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'blog-m.timer' --now
@@ Line 320: / Line 372: @@
 [Timer]
-OnCalendar=*-*-01 02:30:00
+OnCalendar=*-*-03 02:30:00
 Persistent=true
@@ Line 394: / Line 446: @@
 ===== Git Fix =====
-==== Back-up ====
+==== Back-up Files ====
 ****
@@ Line 403: / Line 455: @@
   * :!: Set email for ''user.email''
-  * :!: [[#initial_setup|Initial set-up]] needs re-completed for database connection ((re-use existing details))
   sudo su 'www-data' -s '/bin/bash'
@@ Line 429: / Line 480: @@
   exit
-==== Restore ====
+==== Restore Files ====
-  * TODO
+****
+  sudo -u 'www-data' cp -Rf '/tmp/www/blog/uploads' '/var/www/blog/wp-content' && sudo -u 'www-data' cp -f '/tmp/www/blog/wp-config.php' '/var/www/blog/wp-config.php' && sudo rm -Rf '/tmp/www/blog' && sync
 ===== MySQL Connection =====