Differences

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

--- servers:bsd:nginx:wordpress [2025/10/30 21:25] – Sean Rhone
+++ servers:bsd:nginx:wordpress [2025/10/31 02:11] (current) – Sean Rhone
@@ Line 7: / Line 7: @@
 ===== Prerequisites =====
-  * [[bsd:server:freebsd_14.3|FreeBSD 14.3]]
+  * [[bsd:server:freebsd_15.0|FreeBSD 15.0]]
-  * [[servers:bsd:nginx_php_php-fpm|nginx + PHP + PHP-FPM]]
+  * [[servers:bsd:freenginx_php_php-fpm|freenginx + PHP + PHP-FPM]]
   * [[servers:bsd:nginx:lets_encrypt|Let's Encrypt]]
   * [[servers:bsd:mariadb|MariaDB]]
@@ Line 31: / Line 31: @@
 ====== Database ======
-  mariadb -u 'root' -p
+  su -
+  mariadb
   CREATE DATABASE wordpress;
@@ Line 112: / Line 114: @@
     client_max_body_size '10M';
-#    add_header Content-Security-Policy "default-src 'self'; script-src 'self' 'unsafe-inline' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; font-src 'self' data:; img-src 'self' data: s.w.org" always;
 #    access_log  /var/log/nginx/blog-access.log;
@@ Line 134: / Line 134: @@
   * https://blog.realmofespionage.xyz
+  * Database Host: ''127.0.0.1''
 ====== Settings ======
@@ Line 139: / Line 140: @@
   * Date Format: Y/m/d
-===== DB Connection Fix =====
+===== wp-config.php =====
-  * https://forums.freebsd.org/threads/wordpress-cant-connect-to-mysql-database.71914/#post-436461
+  * :!: WordPress set-up needs to generate this file first ((put settings in the ''custom values'' section towards the bottom))
-  * ''DB_HOST'' to ''127.0.0.1''
+  * Doesn't need ''^M''
-  * :?: May need or be fixed with ''dos2unix''
   su -
-  ee '/usr/local/www/blog/wp-config.php'
+  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'"
-<code>define( 'DB_HOST', 'localhost' );^M</code>
+<code>
+define( 'AUTOMATIC_UPDATER_DISABLED', true );
+define( 'WP_DEBUG', false );
+define( 'WP_DEBUG_DISPLAY', false );
-<code>define( 'DB_HOST', '127.0.0.1' );^M</code>
+/* End */</code>
 ====== Scripts ======
@@ Line 192: / Line 196: @@
   * :!: 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'
@@ Line 198: / Line 203: @@
 #!/bin/sh
-su -m 'www' -c "rm -Rf '/usr/local/www/wiki/.git'"
+su -m 'www' -c "rm -Rf '/usr/local/www/blog/.git'"
-su -m 'www' -c "git -C '/usr/local/www/wiki' init --initial-branch='master'"
+su -m 'www' -c "git -C '/usr/local/www/blog' init --initial-branch='master'"
-su -m 'www' -c "git -C '/usr/local/www/wiki' add '.'"
+su -m 'www' -c "git -C '/usr/local/www/blog' add '.'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/wiki' config 'user.email' 'espionage724@x'"
+su -m 'www' -c "git -C '/usr/local/www/blog' config 'user.email' 'espionage724@x'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/wiki' commit --message='x'"
+su -m 'www' -c "git -C '/usr/local/www/blog' commit --message='x'"
-su -m 'www' -c "git -C '/usr/local/www/wiki' remote add 'origin' 'https://github.com/dokuwiki/dokuwiki.git'"
+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/wiki' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+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/wiki' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/blog' reset --hard 'origin/master'"
-su -m 'www' -c "git -C '/usr/local/www/wiki' gc --aggressive --prune='all'"
+su -m 'www' -c "git -C '/usr/local/www/blog' gc --aggressive --prune='all'"
-su -m 'www' -c "git -C '/usr/local/www/wiki' fsck --full --strict"
+su -m 'www' -c "git -C '/usr/local/www/blog' fsck --full --strict"
 # End</code>
@@ Line 221: / Line 226: @@
   su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh'
-====== Temp Commands ======
+====== cron ======
-===== Update =====
+===== Updater =====
-  * https://github.com/WordPress/WordPress/commits/master/
+  * 02:00AM Every day
   su -
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull origin 'master'"
+  ee '/etc/cron.d/blog-updater'
-===== Maintenance =====
+<code>
+#
+SHELL=/bin/sh
-  su -
+2 * * * root '/home/espionage724/.local/scripts/www/blog/updater.sh'
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' reset --hard"
+# End</code>
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull origin 'master' --rebase"
-  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"
-  mariadb-check -u 'root' -p -o -f -e --auto-repair 'wordpress'
 ====== Backup ======