| Both sides previous revisionPrevious revisionNext revision | Previous revision | 
| servers:bsd:nginx:friendica [2025/10/30 18:41]  – [User]  Sean Rhone | servers:bsd:nginx:friendica [2025/10/31 02:12] (current)  –  Sean Rhone | 
|---|
| * [[information:realm_of_espionage|Realm of Espionage]] | * [[information:realm_of_espionage|Realm of Espionage]] | 
| * https://social.realmofespionage.xyz | * https://social.realmofespionage.xyz | 
|  |  | 
| * :!: WIP |  | 
|  |  | 
| ===== Resources ===== | ===== Resources ===== | 
| su - | 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 ====== | ====== Download Source ====== | 
| php_value[upload_max_filesize] = "20M" | php_value[upload_max_filesize] = "20M" | 
| php_value[max_file_uploads] = "100" | 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> | ; End</code> | 
|  |  | 
| * :!: Change ''--dbpass'', and ''--admin'' to email | * :!: 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 - | su - | 
| ===== Etc ===== | ===== 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 ====== | ====== Scripts ====== | 
| ===== Updater ===== | ===== 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> | <code> | 
| #!/bin/sh | #!/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/social/addon' reset --hard 'origin/develop'" | 
|  | 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 "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'" | su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' dbstructure update --force" | 
| su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull 'origin' 'master' --rebase" | 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> | # 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 ===== | ===== 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> | <code> | 
| #!/bin/sh | #!/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/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'" | 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/media/themes/bootstrap_darkroom' fsck --full --strict" | su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/social/addon' fsck --full --strict" | 
|  |  | 
| '/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'piwigo' | su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' cache clear" | 
|  | 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 'friendica' | 
|  |  | 
| # End</code> | # 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 ===== | ===== 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> | <code> | 
| #!/bin/sh | #!/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> | # 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 | 
|  |  | 
|  | 0 4 * * * root '/home/espionage724/.local/scripts/www/social/updater.sh' | 
|  |  | 
|  | # End</code> | 
|  |  | 
| ====== Backup ====== | ====== Backup ====== | 
| su - | 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 ===== | ===== Database ===== | 
| **** | **** | 
|  |  | 
| 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 ===== | ===== scp ===== | 
| **** | **** | 
|  |  | 
| 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 ====== | ====== Restore ====== | 
| **** | **** | 
|  |  | 
| scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~ | scp ~/'Downloads/friendica-files-'*'.tar.gz' ~/'Downloads/friendica'*'.sql' espionage724@192.168.1.152:~ | 
|  |  | 
| ===== Folder ===== | ===== Folder ===== | 
| su - | su - | 
|  |  | 
| rm -Rf '/usr/local/www/media' | rm -Rf '/usr/local/www/social' | 
|  |  | 
| tar -xzf '/home/espionage724/piwigo-files-'*'.tar.gz' -C '/usr/local/www' 'media' && chown -R 'www':'www' '/usr/local/www/media' && sync | tar -xzf '/home/espionage724/friendica-files-'*'.tar.gz' -C '/usr/local/www' 'social' && chown -R 'www':'www' '/usr/local/www/social' && sync | 
|  |  | 
| ===== Database ===== | ===== Database ===== | 
| * [[#database|Initial set-up]] | * [[#database|Initial set-up]] | 
|  |  | 
| mariadb -u 'root' -p --execute='CREATE DATABASE piwigo;' | mariadb -u 'root' -p --execute='CREATE DATABASE friendica;' | 
|  |  | 
| cat ~/'piwigo'*'.sql' | mariadb -u 'root' -p 'piwigo' | cat ~/'friendica'*'.sql' | mariadb -u 'root' -p 'friendica' | 
|  |  | 
| ===== MySQL Connection ===== | ===== Settings ===== | 
|  |  | 
| su - | su - | 
|  |  | 
| su -m 'www' -c "ee '/usr/local/www/media/local/config/database.inc.php'" | su -m 'www' -c "ee '/usr/local/www/social/config/local.config.php'" | 
|  |  | 
|  | 'hostname' => '127.0.0.1', | 
|  |  | 
|  | 'php_path' => '/usr/local/bin/php', | 
|  |  | 
| <code>$conf['db_host'] = '127.0.0.1';</code> | 'basepath' => '/usr/local/www/social', | 
|  |  |