RoE | Wiki

User Tools

Site Tools

Trace: • joomla • status_page • opensuse_tumbleweed_server • clone_hero • mybb • piwigo • wordpress • dokuwiki • mariadb • piwigo
servers:bsd:nginx:piwigo

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:bsd:nginx:piwigo [2026/01/09 04:58] – Sean Rhoneservers:bsd:nginx:piwigo [2026/01/09 17:34] (current) – [MySQL Connection] Sean Rhone
Line 73: Line 73:
  
 ; Logging ; Logging
-php_value[log_errors] = "0"+php_value[log_errors] = "Off"
 php_value[error_reporting] = "~E_ALL" php_value[error_reporting] = "~E_ALL"
 +php_value[display_errors] = "Off"
 +php_value[display_startup_errors] = "Off"
 +php_value[html_errors] = "Off"
  
 ; General ; General
Line 83: Line 86:
 php_value[memory_limit] = "512M" php_value[memory_limit] = "512M"
 php_value[post_max_size] = "100M" php_value[post_max_size] = "100M"
-php_value[upload_max_filesize] = "20M"+php_value[upload_max_filesize] = "100M"
 php_value[max_file_uploads] = "100" php_value[max_file_uploads] = "100"
  
Line 257: Line 260:
 #!/bin/sh #!/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> # End</code>
- 
-  ~/'.local/scripts/www/media/maintenance.sh' 
  
   su 'root' -c ~/'.local/scripts/www/media/maintenance.sh'   su 'root' -c ~/'.local/scripts/www/media/maintenance.sh'
Line 282: Line 283:
 cd '/tmp' 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' '/bin/sync'
Line 321: Line 330:
  
   su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'   su 'root' -c ~/'.local/scripts/www/media/git-fix.sh'
- 
-  ~/'.local/scripts/www/media/git-fix.sh' 
  
 ====== cron ====== ====== cron ======
Line 328: Line 335:
 ===== Updater ===== ===== Updater =====
  
-  * 01:00AM Every day+  * Daily ''01:00:00 AM''
  
   su -   su -
Line 339: Line 346:
  
 0 1 * * * root '/home/espionage724/.local/scripts/www/media/updater.sh' 0 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
 +
 +10 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
 +
 +30 1 2 * * root '/home/espionage724/.local/scripts/www/media/maintenance.sh'
  
 # End</code> # End</code>
Line 352: Line 391:
 ===== Database ===== ===== 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 ===== ===== scp =====
Line 372: Line 411:
 ===== Folder ===== ===== 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 ===== ===== Database =====
Line 382: Line 421:
   * [[#database|Initial set-up]]   * [[#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 ===== ===== MySQL Connection =====
Line 390: Line 431:
   su -   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> <code>$conf['db_host'] = '127.0.0.1';</code>
  
/usr/local/www/wiki/data/attic/servers/bsd/nginx/piwigo.1767952716.txt.gz · Last modified: by Sean Rhone