Differences

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

--- servers:bsd:nginx:piwigo [2026/01/09 04:37] – Sean Rhone
+++ servers:bsd:nginx:piwigo [2026/01/09 17:34] (current) – [MySQL Connection] Sean Rhone
@@ Line 73: / Line 73: @@
 ; Logging
-php_value[log_errors] = "0"
+php_value[log_errors] = "Off"
 php_value[error_reporting] = "~E_ALL"
+php_value[display_errors] = "Off"
+php_value[display_startup_errors] = "Off"
+php_value[html_errors] = "Off"
 ; General
@@ Line 83: / Line 86: @@
 php_value[memory_limit] = "512M"
 php_value[post_max_size] = "100M"
-php_value[upload_max_filesize] = "20M"
+php_value[upload_max_filesize] = "100M"
 php_value[max_file_uploads] = "100"
@@ Line 95: / Line 98: @@
 <code>
-location ~ \.(php|phar)(/.*)?$ {
+location '~' '\.(php|phar)(/.*)?$' {
-    fastcgi_split_path_info ^(.+\.(?:php|phar))(/.*)$;
+ fastcgi_split_path_info '^(.+\.(?:php|phar))(/.*)$';
-    fastcgi_intercept_errors on;
+ fastcgi_intercept_errors 'on';
-    fastcgi_index index.php;
+ fastcgi_index 'index.php';
-    include fastcgi_params;
+ include 'fastcgi_params';
-    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
+ fastcgi_param 'SCRIPT_FILENAME' '$document_root$fastcgi_script_name';
-    fastcgi_param PATH_INFO $fastcgi_path_info;
+ fastcgi_param 'PATH_INFO' '$fastcgi_path_info';
-    fastcgi_param HTTPS on;
+ fastcgi_param 'HTTPS' 'on';
-    fastcgi_pass 127.0.0.1:9003;
+ fastcgi_pass '127.0.0.1:9003';
 }
@@ Line 112: / Line 116: @@
   su -
-  ee '/usr/local/etc/freenginx/vhosts.d/media.conf' && service 'nginx' reload && sync
+  ee '/usr/local/etc/freenginx/vhosts.d/media.conf' && service 'nginx' reload
 <code>
 server {
-    listen '443' 'ssl';
+ listen '443' 'ssl';
-    http2 'on';
+ http2 'on';
-    server_name 'media.realmofespionage.xyz';
+ server_name 'media.realmofespionage.xyz';
-    root '/usr/local/www/media';
+ root '/usr/local/www/media';
-    index 'index.php';
+ index 'index.php';
+ include '/usr/local/etc/freenginx/default.d/media.conf';
+ include '/usr/local/etc/freenginx/default.d/headers.conf';
-    include '/usr/local/etc/freenginx/default.d/media.conf';
+ client_max_body_size '100M';
-    include '/usr/local/etc/freenginx/default.d/headers.conf';
-#    access_log  /var/log/nginx/media-access.log;
+# access_log '/var/log/nginx/media-access.log';
-#    error_log  /var/log/nginx/media-error.log;
+# error_log '/var/log/nginx/media-error.log';
-    location / {
+ location '/' {
-        index index.php;
+  index 'index.php';
-        try_files $uri $uri/ @rewrite;
+  try_files '$uri $uri/' '@rewrite';
-    }
+ }
-    location @rewrite {
+ location '@rewrite' {
-        rewrite ^/picture((/|$).*)$ /picture.php$1 last;
+  rewrite '^/picture((/|$).*)$' '/picture.php$1' 'last';
-        rewrite ^/index((/|$).*)$ /index.php$1 last;
+  rewrite '^/index((/|$).*)$' '/index.php$1' 'last';
-        rewrite ^/i((/|$).*)$ /i.php$1 last;
+  rewrite '^/i((/|$).*)$' '/i.php$1' 'last';
-    }
+ }
 }
@@ Line 214: / Line 220: @@
 #!/bin/sh
-su -m 'www' -c "git -C '/usr/local/www/media' reset --hard 'origin/master'"
+cd '/tmp'
-su -m 'www' -c "git -C '/usr/local/www/media' pull 'origin' 'master' --rebase"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' reset --hard 'origin/master'"
-su -m 'www' -c "git -C '/usr/local/www/media/themes/bootstrap_darkroom' pull 'origin' 'master' --rebase"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' pull 'origin' 'master' --rebase"
-# End</code>
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' pull 'origin' 'master' --rebase"
-  ~/'.local/scripts/www/media/updater.sh'
+'/bin/sync'
+# End</code>
   su 'root' -c ~/'.local/scripts/www/media/updater.sh'
+===== Backup =====
+  mkdir -p ~/'backups' ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/backup.sh' && chmod +x ~/'.local/scripts/www/media/backup.sh'
+<code>
+#!/bin/sh
+cd '/tmp'
+'/usr/bin/tar' -czf '/home/espionage724/backups/piwigo-files-auto-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'media'
+'/usr/local/bin/mariadb-dump' --single-transaction --quick 'piwigo' -r '/home/espionage724/backups/piwigo-database-auto-'$(date +%Y-%m-%d)'.sql'
+'/bin/sync'
+# End</code>
+  su 'root' -c ~/'.local/scripts/www/media/backup.sh'
 ===== Maintenance =====
@@ Line 233: / Line 260: @@
 #!/bin/sh
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' gc --aggressive --prune='all'"
+cd '/tmp'
-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/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
+'/usr/bin/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/media/themes/bootstrap_darkroom' fsck --full --strict"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' fsck --full --strict"
-'/usr/local/bin/mariadb-check' -o -f -e --auto-repair 'piwigo'
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"
 # End</code>
-  ~/'.local/scripts/www/media/maintenance.sh'
   su 'root' -c ~/'.local/scripts/www/media/maintenance.sh'
@@ Line 258: / Line 283: @@
 cd '/tmp'
-su -m 'www' -c "'/bin/rm' -Rf '/usr/local/www/media/.git'"
+####################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' init --initial-branch='master'"
+# Piwigo
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' add '.'"
+####################
+'/usr/bin/su' -m 'www' -c "'/bin/rm' -Rf '/usr/local/www/media/.git'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' init --initial-branch='master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' add '.'"
 ########################################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' config 'user.email' 'espionage724@x'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' config 'user.email' 'espionage724@x'"
 ########################################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' commit --message='x'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' commit --message='x'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' remote add 'origin' 'https://github.com/Piwigo/Piwigo.git'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' remote add 'origin' 'https://github.com/Piwigo/Piwigo.git'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' reset --hard 'origin/master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' reset --hard 'origin/master'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' gc --aggressive --prune='all'"
+'/usr/bin/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/media' fsck --full --strict"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media' fsck --full --strict"
-su -m 'www' -c "'/bin/rm' -Rf '/usr/local/www/media/themes/bootstrap_darkroom/.git'"
+####################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' init --initial-branch='master'"
+# Bootstrap Darkroom
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' add '.'"
+####################
+'/usr/bin/su' -m 'www' -c "'/bin/rm' -Rf '/usr/local/www/media/themes/bootstrap_darkroom/.git'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' init --initial-branch='master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' add '.'"
 ########################################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' config 'user.email' 'espionage724@x'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' config 'user.email' 'espionage724@x'"
 ########################################
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' commit --message='x'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' commit --message='x'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' remote add 'origin' 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' remote add 'origin' 'https://github.com/Piwigo/piwigo-bootstrap-darkroom.git'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' pull --depth '1' --recurse-submodules 'origin' 'master' --rebase"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' reset --hard 'origin/master'"
-su -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' gc --aggressive --prune='all'"
+'/usr/bin/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/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"
+'/usr/bin/su' -m 'www' -c "'/usr/local/bin/git' -C '/usr/local/www/media/themes/bootstrap_darkroom' fsck --full --strict"
 '/bin/sync'
@@ Line 297: / Line 330: @@
   su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'
-  ~/'.local/scripts/www/media/git-fix.sh'
 ====== cron ======
@@ Line 304: / Line 335: @@
 ===== Updater =====
-  * 01:00AM Every day
+  * Daily ''01:00:00 AM''
   su -
@@ Line 315: / Line 346: @@
 1 * * * root '/home/espionage724/.local/scripts/www/media/updater.sh'
+# End</code>
+===== Backup =====
+  * Monthly (2nd) ''01:10:00 AM''
+  su -
+  ee '/etc/cron.d/media-backup'
+<code>
+#
+SHELL=/bin/sh
+1 2 * * root '/home/espionage724/.local/scripts/www/media/backup.sh'
+# End</code>
+===== Maintenance =====
+  * Monthly (2nd) ''01:30:00 AM''
+  su -
+  ee '/etc/cron.d/media-maintenance'
+<code>
+#
+SHELL=/bin/sh
+1 2 * * root '/home/espionage724/.local/scripts/www/media/maintenance.sh'
 # End</code>
@@ Line 328: / Line 391: @@
 ===== Database =====
-****
+  su -
-  mariadb-dump -u root -p --single-transaction --quick 'piwigo' -r '/home/espionage724/piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
+  mariadb-dump --single-transaction --quick 'piwigo' -r '/home/espionage724/piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
 ===== scp =====
@@ Line 348: / Line 411: @@
 ===== Folder =====
-  su -
+  su
-  rm -Rf '/usr/local/www/media'
+  ls '/home/'$USER'/piwigo-files-'*'.tar.gz' && rm -Rf '/usr/local/www/media'
-  tar -xzf '/home/espionage724/piwigo-files-'*'.tar.gz' -C '/usr/local/www' 'media' && chown -R 'www':'www' '/usr/local/www/media' && sync
+  tar -xzf '/home/'$USER'/piwigo-files-'*'.tar.gz' -C '/usr/local/www' 'media' && chown -R 'www':'www' '/usr/local/www/media' && sync
 ===== Database =====
@@ Line 358: / Line 421: @@
   * [[#database|Initial set-up]]
-  mariadb -u 'root' -p --execute='CREATE DATABASE piwigo;'
+  su
+  mariadb --execute='CREATE DATABASE piwigo;'
-  cat ~/'piwigo'*'.sql' | mariadb -u 'root' -p 'piwigo'
+  cat '/home/'$USER/'piwigo'*'.sql' | mariadb 'piwigo'
 ===== MySQL Connection =====
@@ Line 366: / Line 431: @@
   su -
-  su -m 'www' -c "ee '/usr/local/www/media/local/config/database.inc.php'"
+  su -m 'www' -c "ee '/usr/local/www/media/local/config/database.inc.php'" && clear
 <code>$conf['db_host'] = '127.0.0.1';</code>