Differences

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

--- servers:bsd:nginx:friendica [2025/10/30 18:50] – [MySQL Connection] Sean Rhone
+++ servers:bsd:nginx:friendica [2025/10/31 02:12] (current) – Sean Rhone
@@ Line 4: / Line 4: @@
   * [[information:realm_of_espionage|Realm of Espionage]]
   * https://social.realmofespionage.xyz
-  * :!: WIP
 ===== Resources =====
@@ Line 25: / Line 23: @@
   su -
-  pkg install git-lite php85-composer php85-curl php85-gd php85-gmp php85-pdo php85-mbstring php85-intl php85-mysqli php85-zip php85-fileinfo php85-posix php85-dom php85-iconv php85-simplexml
+  pkg install git-lite php85-composer php85-curl php85-gd php85-gmp php85-pdo php85-mbstring php85-intl php85-mysqli php85-zip php85-fileinfo php85-posix php85-dom php85-iconv php85-simplexml php85-pdo_mysql
 ====== Download Source ======
@@ Line 95: / Line 93: @@
 php_value[upload_max_filesize] = "20M"
 php_value[max_file_uploads] = "100"
-php_value[register_argc_argv] = "On"
+php_value[register_argc_argv] = "Off"
+; Errors
+php_value[error_reporting] = "~E_ALL"
+php_value[display_errors] = "Off"
 ; End</code>
@@ Line 164: / Line 166: @@
   * :!: Change ''--dbpass'', and ''--admin'' to email
+  * :!: 2025/10/30: This failed to find a file and didn't seem to work ((restoring a previous-install works fine bypassing this initial set-up))
   su -
@@ Line 184: / Line 187: @@
 ===== Etc =====
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' -h
+  su -
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' worker
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' worker"
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' dbstructure update --force
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' dbstructure update --force"
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' dbstructure drop --execute
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' dbstructure drop --execute"
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' postupdate
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' postupdate"
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' cache clear
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' cache clear"
-  cd '/srv/www/social' && '/usr/bin/php' '/srv/www/social/bin/console.php' clearavatarcache
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' clearavatarcache"
-  nano '/srv/www/social/config/local.config.php'
+  cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' -h"
-  exit
 ====== Scripts ======
@@ Line 206: / Line 207: @@
 ===== Updater =====
-  mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/updater.sh' && chmod +x ~/'.local/scripts/www/media/updater.sh'
+  mkdir -p ~/'.local/scripts/www/social' && ee ~/'.local/scripts/www/social/updater.sh' && chmod +x ~/'.local/scripts/www/social/updater.sh'
 <code>
 #!/bin/sh
-su -m 'www' -c "git -C '/usr/local/www/media' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/social' reset --hard 'origin/develop'"
-su -m 'www' -c "git -C '/usr/local/www/media' pull 'origin' 'master' --rebase"
+su -m 'www' -c "git -C '/usr/local/www/social' pull 'origin' 'develop' --rebase"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' reset --hard 'origin/develop'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull 'origin' 'master' --rebase"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' pull 'origin' 'develop' --rebase"
+su -m 'www' -c "'/usr/local/bin/composer.phar' --working-dir='/usr/local/www/social' --no-cache install --no-dev"
+cd '/usr/local/www/social'
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' worker"
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' dbstructure update --force"
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' dbstructure drop --execute"
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' postupdate"
 # End</code>
-  ~/'.local/scripts/www/media/updater.sh'
+  ~/'.local/scripts/www/social/updater.sh'
-  su 'root' -c ~/'.local/scripts/www/media/updater.sh'
+  su 'root' -c ~/'.local/scripts/www/social/updater.sh'
 ===== Maintenance =====
-  mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/maintenance.sh' && chmod +x ~/'.local/scripts/www/media/maintenance.sh'
+  mkdir -p ~/'.local/scripts/www/social' && ee ~/'.local/scripts/www/social/maintenance.sh' && chmod +x ~/'.local/scripts/www/social/maintenance.sh'
 <code>
 #!/bin/sh
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' gc --aggressive --prune='all'"
+su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/social' gc --aggressive --prune='all'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' fsck --full --strict"
+su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/social' fsck --full --strict"
+su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/social/addon' gc --aggressive --prune='all'"
+su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/social/addon' fsck --full --strict"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' cache clear"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"
+su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' clearavatarcache"
-'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'piwigo'
+'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'friendica'
 # End</code>
-  ~/'.local/scripts/www/media/maintenance.sh'
+  ~/'.local/scripts/www/social/maintenance.sh'
-  su 'root' -c ~/'.local/scripts/www/media/maintenance.sh'
+  su 'root' -c ~/'.local/scripts/www/social/maintenance.sh'
 ===== Git Fix =====
-  * :!: Set email for ''user.email''
+  * :!: Set email for both ''user.email''
+  * :!: Requires [[#etc|Etc]] commands afterwards
-  mkdir -p ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/git-fix.sh' && chmod +x ~/'.local/scripts/www/media/git-fix.sh'
+  mkdir -p ~/'.local/scripts/www/social' && ee ~/'.local/scripts/www/social/git-fix.sh' && chmod +x ~/'.local/scripts/www/social/git-fix.sh'
 <code>
 #!/bin/sh
-su -m 'www' -c "rm -Rf '/usr/local/www/media/.git'"
+su -m 'www' -c "rm -Rf '/usr/local/www/social/.git'"
-su -m 'www' -c "git -C '/usr/local/www/media' init --initial-branch='master'"
+su -m 'www' -c "git -C '/usr/local/www/social' init --initial-branch='develop'"
-su -m 'www' -c "git -C '/usr/local/www/media' add '.'"
+su -m 'www' -c "git -C '/usr/local/www/social' add '.'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/media' config 'user.email' 'espionage724@x'"
+su -m 'www' -c "git -C '/usr/local/www/social' config 'user.email' 'espionage724@x'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/media' commit --message='x'"
+su -m 'www' -c "git -C '/usr/local/www/social' commit --message='x'"
-su -m 'www' -c "git -C '/usr/local/www/media' remote add 'origin' 'https://github.com/Piwigo/Piwigo.git'"
+su -m 'www' -c "git -C '/usr/local/www/social' remote add 'origin' 'https://github.com/friendica/friendica.git'"
-su -m 'www' -c "git -C '/usr/local/www/media' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+su -m 'www' -c "git -C '/usr/local/www/social' pull --depth '1' --recurse-submodules 'origin' 'develop' --rebase"
-su -m 'www' -c "git -C '/usr/local/www/media' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/social' reset --hard 'origin/develop'"
-su -m 'www' -c "git -C '/usr/local/www/media' gc --aggressive --prune='all'"
+su -m 'www' -c "git -C '/usr/local/www/social' gc --aggressive --prune='all'"
-su -m 'www' -c "git -C '/usr/local/www/media' fsck --full --strict"
+su -m 'www' -c "git -C '/usr/local/www/social' fsck --full --strict"
-su -m 'www' -c "rm -Rf '/usr/local/www/media/themes/bootstrap_darkroom/.git'"
+su -m 'www' -c "rm -Rf '/usr/local/www/social/addon/.git'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' init --initial-branch='master'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' init --initial-branch='develop'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' add '.'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' add '.'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' config 'user.email' 'espionage724@x'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' config 'user.email' 'espionage724@x'"
 ##################################################
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' commit --message='x'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' commit --message='x'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' remote add 'origin' 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' remote add 'origin' 'https://github.com/friendica/friendica-addons.git'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' pull --depth '1' --recurse-submodules 'origin' 'develop' --rebase"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' reset --hard 'origin/develop'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' gc --aggressive --prune='all'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"
+su -m 'www' -c "git -C '/usr/local/www/social/addon' fsck --full --strict"
 # End</code>
-  ~/'.local/scripts/www/media/git-fix.sh'
+  ~/'.local/scripts/www/social/git-fix.sh'
-  su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'
+  su 'root' -c ~/'.local/scripts/www/social/git-fix.sh'
+====== cron ======
+===== Updater =====
+  * 04:00AM Every day
+  su -
+  ee '/etc/cron.d/social-updater'
+<code>
+#
+SHELL=/bin/sh
+4 * * * root '/home/espionage724/.local/scripts/www/social/updater.sh'
+# End</code>
 ====== Backup ======
@@ Line 299: / Line 332: @@
   su -
-  tar -czf '/home/espionage724/piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'media'
+  tar -czf '/home/espionage724/friendica-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'social'
 ===== Database =====
@@ Line 305: / Line 338: @@
 ****
-  mariadb-dump -u root -p --single-transaction --quick 'piwigo' -r '/home/espionage724/piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
+  mariadb-dump -u root -p --single-transaction --quick 'friendica' -r '/home/espionage724/friendica-database-manual-'$(date +%Y-%m-%d)'.sql'
 ===== scp =====
@@ Line 311: / Line 344: @@
 ****
-  scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync
+  scp espionage724@192.168.1.152:~/'friendica-files-'*'.tar.gz' espionage724@192.168.1.152:~/'friendica-database-'*'.sql' ~/'Downloads' && sync
 ====== Restore ======
@@ Line 337: / Line 370: @@
   cat ~/'friendica'*'.sql' | mariadb -u 'root' -p 'friendica'
-===== MySQL Connection =====
+===== Settings =====
   su -
@@ Line 343: / Line 376: @@
   su -m 'www' -c "ee '/usr/local/www/social/config/local.config.php'"
-<code>$conf['db_host'] = '127.0.0.1';</code>
+  'hostname' => '127.0.0.1',
+  'php_path' => '/usr/local/bin/php',
+  'basepath' => '/usr/local/www/social',