| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:bsd:nginx:friendica [2025/10/30 19:22] – Sean Rhone | servers:bsd:nginx:friendica [2025/11/01 22:29] (current) – [Etc] 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 ===== |
| 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/local/bin/php' '/srv/www/social/bin/console.php' -h | su - |
| |
| cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/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/local/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/local/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/local/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/local/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/local/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" |
| |
| | cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' -h" |
| |
| | ssh '192.168.1.152' -t "su 'root' -c ~/'.local/scripts/www/social/updater.sh'" |
| |
| ====== 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/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> | # 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/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> | # 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/social' && ee ~/'.local/scripts/www/social/git-fix.sh' && chmod +x ~/'.local/scripts/www/social/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' |
| |
| su 'root' -c ~/'.local/scripts/www/social/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 ====== |
| cat ~/'friendica'*'.sql' | mariadb -u 'root' -p 'friendica' | cat ~/'friendica'*'.sql' | mariadb -u 'root' -p 'friendica' |
| |
| ===== MySQL Connection ===== | ===== Settings ===== |
| |
| su - | su - |
| su -m 'www' -c "ee '/usr/local/www/social/config/local.config.php'" | 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', |
| |