| Both sides previous revisionPrevious revisionNext revision | Previous revision | 
| servers:bsd:nginx:friendica [2025/10/30 19:59]  – [Git Fix]  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 ===== | 
|  |  | 
| * :!: 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 '/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' worker" | 
|  |  | 
| 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 update --force" | 
|  |  | 
| 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' dbstructure drop --execute" | 
|  |  | 
| 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' postupdate" | 
|  |  | 
| 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' cache clear" | 
|  |  | 
|  | 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" | 
|  |  | 
| ====== 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 ===== | 
|  |  | 
| 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', | 
|  |  |