Differences

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

--- servers:bsd:nginx:piwigo [2026/01/09 05:02] – [Git Fix] 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 257: / 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 329: / Line 330: @@
   su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'
-  ~/'.local/scripts/www/media/git-fix.sh'
 ====== cron ======
@@ Line 336: / Line 335: @@
 ===== Updater =====
-  * 01:00AM Every day
+  * Daily ''01:00:00 AM''
   su -
@@ Line 347: / 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 360: / 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 380: / 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 390: / 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 398: / 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>