Both sides previous revisionPrevious revisionNext revision | Previous revision |
servers:nginx:friendica [2023/09/12 14:43] – openSUSE TW -> Fedora Server (partial) Sean Rhone | servers:nginx:friendica [2024/02/01 08:29] (current) – Sean Rhone |
---|
====== Dependencies ====== | ====== Dependencies ====== |
| |
===== Old openSUSE ===== | * https://friendi.ca/resources/requirements/ |
| |
**** | sudo dnf install php-gd php-pdo php-mbstring php-mysqlnd php-xml php-pecl-zip php-process php-gmp php-pecl-xdebug3 |
| |
sudo zypper install php8-posix php8-gmp openssl php8-pcntl php8-xdebug | |
| |
====== Download Source ====== | ====== Download Source ====== |
sudo su 'nginx' -s '/bin/bash' | sudo su 'nginx' -s '/bin/bash' |
| |
cd '/var/www/social' && COMPOSER_CACHE_DIR='/dev/null' '/var/www/social/bin/composer.phar' install && sync | cd '/var/www/social' && COMPOSER_CACHE_DIR='/dev/null' php '/var/www/social/bin/composer.phar' install && sync |
| |
====== Database ====== | ====== Database ====== |
| |
sudo mysql | sudo mariadb |
| |
CREATE DATABASE friendica; | CREATE DATABASE friendica; |
* Every 5 minutes | * Every 5 minutes |
| |
sudo -e '/etc/systemd/system/social-d.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-d.timer' --now | sudo -e '/etc/systemd/system/social-d.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-d.timer' --now && sudo systemctl start 'social-d' && sudo systemctl status 'social-d' -l |
| |
<code> | <code> |
[Install] | [Install] |
WantedBy=timers.target</code> | WantedBy=timers.target</code> |
| |
==== SELinux Test ==== | |
| |
**** | |
| |
sudo semanage fcontext --add --type 'bin_t' '/var/www/social/bin/worker.php' | |
| |
===== Updater ===== | ===== Updater ===== |
ExecStart='/usr/bin/git' -C '/var/www/social' pull origin 'develop' | ExecStart='/usr/bin/git' -C '/var/www/social' pull origin 'develop' |
ExecStart='/usr/bin/git' -C '/var/www/social/addon' pull origin 'develop' | ExecStart='/usr/bin/git' -C '/var/www/social/addon' pull origin 'develop' |
ExecStart='/var/www/social/bin/composer.phar' install | ExecStart='/usr/bin/php' '/var/www/social/bin/composer.phar' install |
ExecStartPost='/usr/bin/sync'</code> | ExecStartPost='/usr/bin/sync'</code> |
| |
==== Timer ==== | ==== Timer ==== |
| |
* Every day at ''02:00:00'' | * Every day at ''03:00:00'' |
| |
sudo -e '/etc/systemd/system/social-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-up.timer' --now && sudo systemctl start 'social-up' && sudo systemctl status 'social-up' -l | sudo -e '/etc/systemd/system/social-up.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-up.timer' --now && sudo systemctl start 'social-up' && sudo systemctl status 'social-up' -l |
| |
[Timer] | [Timer] |
OnCalendar=*-*-* 02:00:00 | OnCalendar=*-*-* 03:00:00 |
Persistent=true | Persistent=true |
| |
==== Timer ==== | ==== Timer ==== |
| |
* ''01'' day of every month at ''02:20:00'' | * ''01'' day of every month at ''03:20:00'' |
| |
sudo -e '/etc/systemd/system/social-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-m.timer' --now | sudo -e '/etc/systemd/system/social-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-m.timer' --now && sudo systemctl start 'social-m' && sudo systemctl status 'social-up' -l |
| |
<code> | <code> |
| |
[Timer] | [Timer] |
OnCalendar=*-*-01 02:20:00 | OnCalendar=*-*-01 03:20:00 |
Persistent=true | Persistent=true |
| |
=== Timer === | === Timer === |
| |
* ''01'' day of every month at ''02:50:00'' | * ''01'' day of every month at ''03:35:00'' |
| |
sudo -e '/etc/systemd/system/social-fb.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-fb.timer' --now && sudo systemctl start 'social-fb' && sudo systemctl status 'social-fb' -l | sudo -e '/etc/systemd/system/social-fb.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-fb.timer' --now && sudo systemctl start 'social-fb' && sudo systemctl status 'social-fb' -l |
| |
[Timer] | [Timer] |
OnCalendar=*-*-01 02:50:00 | OnCalendar=*-*-01 03:35:00 |
Persistent=true | Persistent=true |
| |
| |
<code> | <code> |
[mysqldump] | [mariadb-dump] |
user=friendica | user=friendica |
password=x</code> | password=x</code> |
Type=oneshot | Type=oneshot |
WorkingDirectory=/var/lib/mysql/tmp | WorkingDirectory=/var/lib/mysql/tmp |
ExecStartPre='/usr/bin/mysqldump' --defaults-extra-file='/var/lib/mysql/auth/friendica' --single-transaction 'friendica' -r '/var/lib/mysql/tmp/friendica.sql' | ExecStartPre='/usr/bin/mariadb-dump' --defaults-extra-file='/var/lib/mysql/auth/friendica' --single-transaction 'friendica' -r '/var/lib/mysql/tmp/friendica.sql' |
ExecStart='/usr/bin/gzip' -f '/var/lib/mysql/tmp/friendica.sql' | ExecStart='/usr/bin/gzip' -f '/var/lib/mysql/tmp/friendica.sql' |
ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysql/tmp/friendica.sql.gz" "/home/CHANGEME/backups/friendica-database-auto-"$$(date +%%Y-%%m-%%d)".sql.gz"' | ExecStart='/usr/bin/bash' -c '"/usr/bin/mv" "/var/lib/mysql/tmp/friendica.sql.gz" "/home/CHANGEME/backups/friendica-database-auto-"$$(date +%%Y-%%m-%%d)".sql.gz"' |
=== Timer === | === Timer === |
| |
* Every day at ''02:15:00'' | * Every day at ''03:45:00'' |
| |
sudo -e '/etc/systemd/system/social-db.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-db.timer' --now && sudo systemctl start 'social-db' && sudo systemctl status 'social-db' -l | sudo -e '/etc/systemd/system/social-db.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'social-db.timer' --now && sudo systemctl start 'social-db' && sudo systemctl status 'social-db' -l |
| |
[Timer] | [Timer] |
OnCalendar=*-*-* 02:15:00 | OnCalendar=*-*-* 03:45:00 |
Persistent=true | Persistent=true |
| |
**** | **** |
| |
sudo mysqldump --defaults-extra-file='/var/lib/mysql/auth/friendica' --single-transaction 'friendica' -r ~/'friendica-database-manual-'$(date +%Y-%m-%d)'.sql' && sync | sudo mariadb-dump --defaults-extra-file='/var/lib/mysql/auth/friendica' --single-transaction 'friendica' -r ~/'friendica-database-manual-'$(date +%Y-%m-%d)'.sql' && sync |
| |
==== Start Services ==== | ==== Start Services ==== |
==== Drop Previous Database ==== | ==== Drop Previous Database ==== |
| |
sudo mysql | sudo mariadb |
| |
DROP DATABASE friendica; | DROP DATABASE friendica; |
==== Re-create Databases ==== | ==== Re-create Databases ==== |
| |
sudo mysql | sudo mariadb |
| |
CREATE DATABASE friendica; | CREATE DATABASE friendica; |
**** | **** |
| |
sudo mysql 'friendica' < ~/'friendica-database-'*'.sql' && sync | sudo mariadb 'friendica' < ~/'friendica-database-'*'.sql' && sync |
| |
==== Reapply Permissions ==== | ==== Reapply Permissions ==== |
| |
sudo mysql | sudo mariadb |
| |
GRANT ALL PRIVILEGES ON friendica.* to 'friendica'@'localhost' IDENTIFIED BY 'x'; | GRANT ALL PRIVILEGES ON friendica.* to 'friendica'@'localhost' IDENTIFIED BY 'x'; |