RoE | Wiki

User Tools

Site Tools

Trace:
servers:linux:nginx:piwigo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
servers:linux:nginx:piwigo [2024/08/13 22:17] – created Sean Rhoneservers:linux:nginx:piwigo [2025/08/27 20:15] (current) – Sean Rhone
Line 3: Line 3:
   * Piwigo ((https://piwigo.org/))   * Piwigo ((https://piwigo.org/))
   * Bootstrap Darkroom Theme ((https://github.com/Piwigo/piwigo-bootstrap-darkroom))   * Bootstrap Darkroom Theme ((https://github.com/Piwigo/piwigo-bootstrap-darkroom))
-  * ''master'' Branches ((https://github.com/Piwigo/Piwigo/tree/master)) ((https://github.com/Piwigo/piwigo-bootstrap-darkroom/tree/master)) 
   * [[Information:Realm of Espionage]]   * [[Information:Realm of Espionage]]
   * https://media.realmofespionage.xyz   * https://media.realmofespionage.xyz
 +
 +===== TODOs =====
 +
 +  * Show title on pictures (long titles get cut-off in navbar)
 +  * AI ([[https://piwigo.org/forum/viewtopic.php?pid=192438#p192438|post]], [[https://github.com/Piwigo/Piwigo/commits/master/include/config_default.inc.php|config.inc.php]])
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:fedora_server|Fedora Server]] +  * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]] 
-  * [[servers:mariadb|MariaDB]] +  * [[servers:linux:nginx_php_php-fpm|nginx + PHP + PHP-FPM]] 
-  * [[servers:nginx_php_php-fpm|nginx + PHP + PHP-FPM]] +  * [[servers;linux;nginx;lets_encrypt|Certbot (Let's Encrypt)]] 
-  * [[servers:nginx:lets_encrypt|Let's Encrypt]]+  * [[servers:linux:mariadb|MariaDB]]
  
 ====== Dependencies ====== ====== Dependencies ======
Line 19: Line 23:
   * https://github.com/Piwigo/piwigo-videojs/wiki/How-to-add-videos   * https://github.com/Piwigo/piwigo-videojs/wiki/How-to-add-videos
   * https://github.com/Piwigo/piwigo-videojs/wiki/Synchronize#requirement   * https://github.com/Piwigo/piwigo-videojs/wiki/Synchronize#requirement
 +
 +  sudo zypper install php8-gd php8-exif php8-mbstring php8-mysql php8-opcache
 +
 +===== Old TODO =====
  
   sudo dnf install php-mysqlnd php-imagick php-gd perl-Image-ExifTool mediainfo ffmpeg-free libvorbis poppler-utils   sudo dnf install php-mysqlnd php-imagick php-gd perl-Image-ExifTool mediainfo ffmpeg-free libvorbis poppler-utils
 +
 +  sudo zypper install php8-bz2 php8-intl php8-sodium php8-zlib
  
 ====== Download Source ====== ====== Download Source ======
Line 26: Line 36:
   * Also includes the [[https://github.com/Piwigo/piwigo-bootstrap-darkroom|Bootstrap Darkroom]] theme   * Also includes the [[https://github.com/Piwigo/piwigo-bootstrap-darkroom|Bootstrap Darkroom]] theme
  
-  sudo git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/Piwigo.git' '/var/www/media' && sudo git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git' '/var/www/media/themes/bootstrap_darkroom' && sudo semanage fcontext --add --type 'httpd_sys_rw_content_t' '/var/www/media(/.*)?' && sudo restorecon -F -I -R '/var/www/media' && sudo chown -R 'nginx':'nginx' '/var/www/media' && sync+  sudo git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/Piwigo.git' '/srv/www/media' && sudo git clone --branch 'master' --depth '1' --recurse-submodules 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git' '/srv/www/media/themes/bootstrap_darkroom' && sudo chown -R 'wwwrun' '/srv/www/media'
  
 ====== Database ====== ====== Database ======
Line 34: Line 44:
   CREATE DATABASE piwigo;   CREATE DATABASE piwigo;
  
-  GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost' IDENTIFIED BY 'x';+  CREATE USER 'piwigo'@'localhost' IDENTIFIED BY 'x'; 
 + 
 +  GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';
  
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
Line 44: Line 56:
 ===== PHP-FPM Socket ===== ===== PHP-FPM Socket =====
  
-  sudo -e '/etc/php-fpm.d/media.conf' && sudo systemctl restart 'php-fpm'+  sudo -e '/etc/php8/fpm/php-fpm.d/media.conf' && sudo systemctl restart 'php-fpm'
  
 <code> <code>
Line 78: Line 90:
  
 ===== FastCGI ===== ===== FastCGI =====
 +
 +  * ''media.sock''
  
   sudo -e '/etc/nginx/default.d/media.conf'   sudo -e '/etc/nginx/default.d/media.conf'
  
 <code> <code>
-# PHP-FPM 
 location ~ \.(php|phar)(/.*)?$ { location ~ \.(php|phar)(/.*)?$ {
     fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$;     fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$;
Line 91: Line 104:
     fastcgi_param PATH_INFO $fastcgi_path_info;     fastcgi_param PATH_INFO $fastcgi_path_info;
     fastcgi_pass unix:/run/php-fpm/media.sock;     fastcgi_pass unix:/run/php-fpm/media.sock;
-}</code>+} 
 + 
 +# End</code>
  
 ===== Server Block ===== ===== Server Block =====
Line 331: Line 346:
 WantedBy=timers.target</code> WantedBy=timers.target</code>
  
-====== Backup ======+====== Old Restore ======
  
-  * Create backup archive on server and transfer to client computer+===== Client =====
  
-===== Server =====+==== Uncompress Database ====
  
-==== Stop Services ====+  * This is only needed if restoring an **automated** database backup ((manual doesn't gzip))
  
-****+  gunzip ~/'Downloads/piwigo-database-'*'.sql.gz'
  
-  sudo systemctl stop nginx php-fpm+====== Files ======
  
-==== Backup Folder ====+===== Backup =====
  
 **** ****
  
-  cd '/var/www' && sudo tar -cvzf ~/'piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' 'media' && cd ~ && sync+  sudo tar -czf ~/'piwigo-files-manual-'$(date +%Y-%m-%d)'.tar.gz' -C '/srv/www' 'media'
  
-==== Backup Database ====+===== scp =====
  
-****+==== To Client Backup ====
  
-  sudo mariadb-dump --defaults-extra-file='/var/lib/mysql/auth/piwigo' --single-transaction 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql' && sync+  * Server back-up -> Client 
 +  * Run on server
  
-==== Start Services ====+  scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' ~/'Downloads'
  
-****+==== To Server Restore ====
  
-  sudo systemctl start nginx php-fpm+  * Client -> (files) -> Server 
 +  * Run on client
  
-===== Client =====+  scp ~/'Downloads/piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~
  
-==== Transfer Files To Client ====+===== Restore =====
  
 **** ****
  
-  scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync+  sudo rm -Rf '/srv/www/media' && sudo tar -xzf ~/'piwigo-files-'*'.tar.gz' -C '/srv/www' 'media' && sudo chown -R 'wwwrun':'www' '/srv/www/media' && sync
  
-====== Restore ====== +===== Clean-up =====
- +
-===== Client ===== +
- +
-==== Uncompress Database ==== +
- +
-  * This is only needed if restoring an **automated** database backup ((manual doesn't gzip)) +
- +
-  gunzip ~/'Downloads/piwigo-database-'*'.sql.gz' +
- +
-==== Transfer Files To Server ====+
  
 **** ****
  
-  scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo-database-'*'.sql' espionage724@192.168.1.152:~+  rm -fv ~/'piwigo-files-'*'.tar.gz'
  
-==== Remove Files ====+====== Database ======
  
-**** +===== Backup =====
- +
-  rm -f ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo-database-'*'.sql' && sync +
- +
-===== Server ===== +
- +
-==== Stop Services ====+
  
 **** ****
  
-  sudo systemctl stop nginx php-fpm+  sudo mariadb-dump --single-transaction --quick 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
  
-==== Remove Previous Folder ====+===== scp =====
  
-****+==== To Client Backup ====
  
-  sudo rm -Rf '/var/www/media'+  * Server back-up -> Client 
 +  * Run on server
  
-==== Restore Piwigo Folder ====+  scp espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads'
  
-****+==== To Server Restore ====
  
-  cd '/var/www' && sudo tar -xvzf ~/'piwigo-files-'*'.tar.gz' 'media' && sudo semanage fcontext --add --type 'httpd_sys_rw_content_t' '/var/www/media(/.*)?' && sudo restorecon -F -I -R '/var/www/media' && sudo chown -R 'nginx':'nginx' '/var/www/media' && cd ~ && sync+  * Client -> (files) -> Server 
 +  * Run on client
  
-==== Drop Previous Database ====+  scp ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~
  
-  sudo mariadb+===== Restore =====
  
-  DROP DATABASE piwigo;+  sudo mariadb --execute='CREATE DATABASE piwigo'
  
-  FLUSH TABLES;+  sudo mariadb 'piwigo' < ~/'piwigo'*'.sql'
  
-  EXIT +==== Permissions ====
- +
-==== Re-create Databases ====+
  
   sudo mariadb   sudo mariadb
  
-  CREATE DATABASE piwigo; +  CREATE USER 'piwigo'@'localhost' IDENTIFIED BY 'x';
- +
-  EXIT +
- +
-==== Restore Database ==== +
- +
-**** +
- +
-  sudo mariadb 'piwigo' < ~/'piwigo-database-'*'.sql' && sync +
- +
-==== Reapply Permissions ==== +
- +
-  sudo mariadb+
  
-  GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost' IDENTIFIED BY 'x';+  GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';
  
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
Line 445: Line 434:
   EXIT   EXIT
  
-==== Start Services ====+===== Clean-up =====
  
 **** ****
  
-  sudo systemctl start nginx php-fpm +  rm -fv ~/'piwigo'*'.sql'
- +
-==== Remove Backups ==== +
- +
-  * Verify that Piwigo works before running +
- +
-  rm ~/'piwigo-files-'*'.tar.gz' ~/'piwigo-database-'*'.sql' && sync+
  
/usr/local/www/wiki/data/attic/servers/linux/nginx/piwigo.1723601865.txt.gz · Last modified: (external edit)