| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:bsd:nginx:friendica [2025/10/30 20:13] – 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 ===== |
| |
| * :!: 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 - |
| |
| su - | su - |
| |
| cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' -h" | |
| |
| cd '/usr/local/www/social' && su -m 'www' -c "'/usr/local/bin/php' '/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 '/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' 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 ====== |
| 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' reset --hard 'origin/develop'" |
| su -m 'www' -c "git -C '/usr/local/www/social/addon' pull 'origin' 'develop' --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' | 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' 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 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' dbstructure drop --execute" |
| su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' postupdate" | su -m 'www' -c "'/usr/local/bin/php' '/usr/local/www/social/bin/console.php' postupdate" |
| 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" | |
| |
| # 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' | |
| | |
| | |
| git clone --branch 'develop' --depth '1' --recurse-submodules 'https://github.com/friendica/friendica.git' '/usr/local/www/social' && chown -R 'www':'www' '/usr/local/www/social' | |
| git clone --branch 'develop' --depth '1' --recurse-submodules 'https://github.com/friendica/friendica-addons.git' '/usr/local/www/social/addon' && chown -R 'www':'www' '/usr/local/www/social/addon' | |
| |
| | 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" |
| | |
| | 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 '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 ===== |
| |
| 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', |
| |