servers:nginx:zenphoto
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
servers:nginx:zenphoto [2019/01/18 16:19] – [Server Block] Sean Rhone | servers:nginx:zenphoto [2019/12/15 10:31] – [PHP-FPM Socket] Sean Rhone | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Information ====== | ||
+ | * Zenphoto ((https:// | ||
+ | * [[Information: | ||
+ | * https:// | ||
+ | |||
+ | ===== Prerequisites ===== | ||
+ | |||
+ | * [[distros: | ||
+ | * [[servers: | ||
+ | * [[servers: | ||
+ | * [[servers: | ||
+ | |||
+ | ====== Download Source ====== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo rm -Rf '/ | ||
+ | |||
+ | ====== Database ====== | ||
+ | |||
+ | sudo mysql | ||
+ | |||
+ | CREATE DATABASE zenphoto; | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON zenphoto.* to ' | ||
+ | |||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | EXIT | ||
+ | |||
+ | ====== nginx + PHP-FPM Configuration ====== | ||
+ | |||
+ | ===== PHP-FPM Socket ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [media] | ||
+ | user = www-data | ||
+ | group = www-data | ||
+ | |||
+ | listen = / | ||
+ | listen.owner = www-data | ||
+ | listen.group = www-data | ||
+ | listen.allowed_clients = 127.0.0.1 | ||
+ | |||
+ | pm = dynamic | ||
+ | pm.max_children = 8 | ||
+ | pm.start_servers = 3 | ||
+ | pm.min_spare_servers = 2 | ||
+ | pm.max_spare_servers = 4 | ||
+ | |||
+ | php_value[date.timezone] = " | ||
+ | php_value[upload_tmp_dir] = "/ | ||
+ | |||
+ | php_value[max_execution_time] = " | ||
+ | php_value[memory_limit] = " | ||
+ | php_value[post_max_size] = " | ||
+ | php_value[upload_max_filesize] = " | ||
+ | php_value[max_file_uploads] = " | ||
+ | |||
+ | php_value[session.save_handler] = " | ||
+ | php_value[session.save_path] = "/ | ||
+ | php_value[soap.wsdl_cache_dir] = "/ | ||
+ | php_value[opcache.file_cache] = "/ | ||
+ | |||
+ | ===== FastCGI ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | # PHP-FPM | ||
+ | location ~ \.(php|phar)(/ | ||
+ | fastcgi_split_path_info ^(.+\.(?: | ||
+ | |||
+ | fastcgi_intercept_errors on; | ||
+ | fastcgi_index index.php; | ||
+ | include fastcgi_params; | ||
+ | fastcgi_param SCRIPT_FILENAME | ||
+ | fastcgi_param PATH_INFO $fastcgi_path_info; | ||
+ | fastcgi_pass unix:/ | ||
+ | }</ | ||
+ | |||
+ | ===== Server Block ===== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | server { | ||
+ | listen ' | ||
+ | server_name ' | ||
+ | root '/ | ||
+ | index ' | ||
+ | |||
+ | include '/ | ||
+ | include '/ | ||
+ | |||
+ | client_max_body_size ' | ||
+ | |||
+ | add_header Content-Security-Policy " | ||
+ | |||
+ | # access_log | ||
+ | # error_log | ||
+ | |||
+ | location / { | ||
+ | try_files $uri $uri/ / | ||
+ | } | ||
+ | }</ | ||
+ | |||
+ | ==== Enable ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo rm -f '/ | ||
+ | |||
+ | ====== Initial Setup ====== | ||
+ | |||
+ | ===== UTF-8 Test ===== | ||
+ | |||
+ | * Zenphoto tests for a UTF8-compliant filesystem and expects the following file to exist | ||
+ | |||
+ | sudo -u ' | ||
+ | |||
+ | ===== Site ===== | ||
+ | |||
+ | * https:// | ||
+ | |||
+ | ====== Services ====== | ||
+ | |||
+ | ===== Updater ===== | ||
+ | |||
+ | ==== Service ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Service] | ||
+ | User=www-data | ||
+ | Group=www-data | ||
+ | Type=oneshot | ||
+ | WorkingDirectory=/ | ||
+ | ExecStart='/ | ||
+ | ExecStartPost='/ | ||
+ | |||
+ | ==== Timer ==== | ||
+ | |||
+ | * Every day at '' | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Unit] | ||
+ | Description=Zenphoto Updater | ||
+ | After=network-online.target | ||
+ | Wants=network-online.target | ||
+ | |||
+ | [Timer] | ||
+ | OnCalendar=*-*-* 05:00:00 | ||
+ | Persistent=true | ||
+ | |||
+ | [Install] | ||
+ | WantedBy=timers.target</ | ||
+ | |||
+ | ===== Maintenance ===== | ||
+ | |||
+ | ==== Service ==== | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Service] | ||
+ | User=www-data | ||
+ | Group=www-data | ||
+ | Type=oneshot | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | ExecStartPost='/ | ||
+ | |||
+ | ==== Timer ==== | ||
+ | |||
+ | * '' | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Unit] | ||
+ | Description=Zenphoto Maintenance | ||
+ | After=network-online.target | ||
+ | Wants=network-online.target | ||
+ | |||
+ | [Timer] | ||
+ | OnCalendar=*-*-01 05:20:00 | ||
+ | Persistent=true | ||
+ | |||
+ | [Install] | ||
+ | WantedBy=timers.target</ | ||
+ | |||
+ | ===== Backup ===== | ||
+ | |||
+ | ==== Files ==== | ||
+ | |||
+ | === Service === | ||
+ | |||
+ | mkdir -p ~/' | ||
+ | |||
+ | < | ||
+ | [Service] | ||
+ | Type=oneshot | ||
+ | WorkingDirectory=/ | ||
+ | ExecStart='/ | ||
+ | ExecStartPost='/ | ||
+ | |||
+ | === Timer === | ||
+ | |||
+ | * '' | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Unit] | ||
+ | Description=Zenphoto Files Backup | ||
+ | |||
+ | [Timer] | ||
+ | OnCalendar=*-*-01 05:50:00 | ||
+ | Persistent=true | ||
+ | |||
+ | [Install] | ||
+ | WantedBy=timers.target</ | ||
+ | |||
+ | ==== Database ==== | ||
+ | |||
+ | === Database Auth === | ||
+ | |||
+ | sudo -u ' | ||
+ | |||
+ | < | ||
+ | [mysqldump] | ||
+ | user=zenphoto | ||
+ | password=x</ | ||
+ | |||
+ | === Service === | ||
+ | |||
+ | mkdir -p ~/' | ||
+ | |||
+ | < | ||
+ | [Service] | ||
+ | Type=oneshot | ||
+ | WorkingDirectory=/ | ||
+ | ExecStartPre='/ | ||
+ | ExecStart='/ | ||
+ | ExecStart='/ | ||
+ | ExecStartPost='/ | ||
+ | |||
+ | === Timer === | ||
+ | |||
+ | * Every day at '' | ||
+ | |||
+ | sudo -e '/ | ||
+ | |||
+ | < | ||
+ | [Unit] | ||
+ | Description=Zenphoto Database Backup | ||
+ | After=mariadb.service | ||
+ | |||
+ | [Timer] | ||
+ | OnCalendar=*-*-* 05:15:00 | ||
+ | Persistent=true | ||
+ | |||
+ | [Install] | ||
+ | WantedBy=timers.target</ | ||
+ | |||
+ | ====== Backup ====== | ||
+ | |||
+ | * Create backup archive on server and transfer to client computer | ||
+ | |||
+ | ===== Server ===== | ||
+ | |||
+ | ==== Stop Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl stop nginx php7.2-fpm | ||
+ | |||
+ | ==== Backup Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | cd '/ | ||
+ | |||
+ | ==== Backup Database ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo mysqldump --defaults-extra-file='/ | ||
+ | |||
+ | ==== Start Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl start nginx php7.2-fpm | ||
+ | |||
+ | ===== Client ===== | ||
+ | |||
+ | ==== Transfer Files To Client ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | scp espionage724@192.168.1.153: | ||
+ | |||
+ | ====== Restore ====== | ||
+ | |||
+ | ===== Client ===== | ||
+ | |||
+ | ==== Uncompress Database ==== | ||
+ | |||
+ | * This is only needed if restoring an **automated** database backup ((manual doesn' | ||
+ | |||
+ | gunzip ~/' | ||
+ | |||
+ | ==== Transfer Files To Server ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | scp ~/' | ||
+ | |||
+ | ==== Remove Files ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | rm -f ~/' | ||
+ | |||
+ | ===== Server ===== | ||
+ | |||
+ | ==== Stop Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl stop nginx php7.2-fpm | ||
+ | |||
+ | ==== Remove Previous Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo rm -Rf '/ | ||
+ | |||
+ | ==== Restore Zenphoto Folder ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | cd '/ | ||
+ | |||
+ | ==== Drop Previous Database ==== | ||
+ | |||
+ | sudo mysql | ||
+ | |||
+ | DROP DATABASE zenphoto; | ||
+ | |||
+ | FLUSH TABLES; | ||
+ | |||
+ | EXIT | ||
+ | |||
+ | ==== Re-create Databases ==== | ||
+ | |||
+ | sudo mysql | ||
+ | |||
+ | CREATE DATABASE zenphoto; | ||
+ | |||
+ | EXIT | ||
+ | |||
+ | ==== Restore Database ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo mysql ' | ||
+ | |||
+ | ==== Reapply Permissions ==== | ||
+ | |||
+ | sudo mysql | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON zenphoto.* to ' | ||
+ | |||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | EXIT | ||
+ | |||
+ | ==== Start Services ==== | ||
+ | |||
+ | **** | ||
+ | |||
+ | sudo systemctl start nginx php7.2-fpm | ||
+ | |||
+ | ==== Remove Backups ==== | ||
+ | |||
+ | * Verify that Zenphoto works before running | ||
+ | |||
+ | rm ~/' |
/var/www/wiki/data/pages/servers/nginx/zenphoto.txt · Last modified: 2020/04/24 10:25 by Sean Rhone