| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:bsd:nginx:friendica [2025/10/30 20:16] – 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 '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', |
| |