Differences

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

--- servers:bsd:nginx:wordpress [2025/10/30 21:15] – [Dependencies] 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 39: / Line 41: @@
   GRANT ALL PRIVILEGES ON wordpress.* to wordpress@localhost;
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ====== nginx + PHP-FPM Configuration ======
@@ Line 69: / Line 69: @@
 ; General
 php_value[date.timezone] = "America/New_York"
+; Errors
+php_value[error_reporting] = "~E_ALL"
+php_value[display_errors] = "Off"
 ; End</code>
@@ Line 76: / Line 80: @@
   su -
-  ee '/usr/local/etc/nginx/default.d/blog.conf'
+  ee '/usr/local/etc/freenginx/default.d/blog.conf'
 <code>
@@ Line 96: / Line 100: @@
   su -
-  ee '/usr/local/etc/nginx/vhosts.d/blog.conf' && service 'nginx' reload
+  ee '/usr/local/etc/freenginx/vhosts.d/blog.conf' && service 'nginx' reload
 <code>
@@ Line 106: / Line 110: @@
     index 'index.php';
-    include '/usr/local/etc/nginx/default.d/blog.conf';
+    include '/usr/local/etc/freenginx/default.d/blog.conf';
-    include '/usr/local/etc/nginx/default.d/headers.conf';
+    include '/usr/local/etc/freenginx/default.d/headers.conf';
     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 132: / Line 134: @@
   * https://blog.realmofespionage.xyz
+  * Database Host: ''127.0.0.1''
 ====== Settings ======
@@ Line 137: / 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 );
-<code>define( 'DB_HOST', '127.0.0.1' );^M</code>
+define( 'WP_DEBUG', false );
+define( 'WP_DEBUG_DISPLAY', false );
-====== Temp Commands ======
+/* End */</code>
-===== Update =====
+====== Scripts ======
-  * https://github.com/WordPress/WordPress/commits/master/
+===== Updater =====
-  su -
+  mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/updater.sh' && chmod +x ~/'.local/scripts/www/blog/updater.sh'
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' pull origin 'master'"
+<code>
+#!/bin/sh
+su -m 'www' -c "git -C '/usr/local/www/blog' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/blog' pull 'origin' 'master' --rebase"
+# End</code>
+  ~/'.local/scripts/www/blog/updater.sh'
+  su 'root' -c ~/'.local/scripts/www/blog/updater.sh'
 ===== Maintenance =====
-  su -
+  mkdir -p ~/'.local/scripts/www/blog' && ee ~/'.local/scripts/www/blog/maintenance.sh' && chmod +x ~/'.local/scripts/www/blog/maintenance.sh'
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' reset --hard"
+<code>
+#!/bin/sh
-  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"
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' gc --aggressive --prune='all'"
+'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'wordpress'
-  su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/blog' fsck --full --strict"
+# End</code>
-  mariadb-check -u 'root' -p -o -f -e --auto-repair 'wordpress'
+  ~/'.local/scripts/www/blog/maintenance.sh'
+  su 'root' -c ~/'.local/scripts/www/blog/maintenance.sh'
+===== Git Fix =====
+  * :!: 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'
+<code>
+#!/bin/sh
+su -m 'www' -c "rm -Rf '/usr/local/www/blog/.git'"
+su -m 'www' -c "git -C '/usr/local/www/blog' init --initial-branch='master'"
+su -m 'www' -c "git -C '/usr/local/www/blog' add '.'"
+##################################################
+su -m 'www' -c "git -C '/usr/local/www/blog' config 'user.email' 'espionage724@x'"
+##################################################
+su -m 'www' -c "git -C '/usr/local/www/blog' commit --message='x'"
+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/blog' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+su -m 'www' -c "git -C '/usr/local/www/blog' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/blog' gc --aggressive --prune='all'"
+su -m 'www' -c "git -C '/usr/local/www/blog' fsck --full --strict"
+# End</code>
+  ~/'.local/scripts/www/blog/git-fix.sh'
+  su 'root' -c ~/'.local/scripts/www/blog/git-fix.sh'
+====== cron ======
+===== Updater =====
+  * 02:00AM Every day
+  su -
+  ee '/etc/cron.d/blog-updater'
+<code>
+#
+SHELL=/bin/sh
+2 * * * root '/home/espionage724/.local/scripts/www/blog/updater.sh'
+# End</code>
 ====== Backup ======
@@ Line 218: / Line 287: @@
   cat ~/'wordpress'*'.sql' | mariadb -u 'root' -p 'wordpress'
+===== Settings =====
+  su -
+  su -m 'www' -c "ee '/usr/local/www/blog/wp-config.php'"
+  define( 'DB_HOST', 'localhost' );^M
+  define( 'DB_HOST', '127.0.0.1' );^M