Differences

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

--- servers:bsd:nginx:wordpress [2025/10/30 21:29] – [Initial Setup] 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 140: / 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 223: / 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 ======