| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:bsd:nginx:piwigo [2026/01/09 06:07] – [Database] Sean Rhone | servers:bsd:nginx:piwigo [2026/07/24 03:03] (current) – [config.inc.php] Sean Rhone |
|---|
| ===== Prerequisites ===== | ===== Prerequisites ===== |
| |
| * [[bsd:server:freebsd_16.0|FreeBSD 16.0]] | * [[bsd:server:arm:freebsd_15.1|FreeBSD 15.1]] |
| * [[servers:bsd:freenginx_php_php-fpm|freenginx + PHP + PHP-FPM]] | * [[servers:bsd:freenginx_php_php-fpm|freenginx + PHP + PHP-FPM]] |
| * [[servers:bsd:nginx:lets_encrypt|Certbot (Let's Encrypt)]] | * [[servers:bsd:nginx:lets_encrypt|Certbot (Let's Encrypt)]] |
| su - | su - |
| |
| pkg install git-lite php85-exif php85-gd php85-mysqli php85-mbstring | pkg install git-lite php85-dom php85-exif php85-fileinfo php85-gd php85-mysqli php85-mbstring |
| |
| ====== Download Source ====== | ====== Download Source ====== |
| php_value[log_errors] = "0" | php_value[log_errors] = "0" |
| php_value[error_reporting] = "~E_ALL" | php_value[error_reporting] = "~E_ALL" |
| | php_value[display_errors] = "0" |
| | php_value[display_startup_errors] = "0" |
| | php_value[html_errors] = "0" |
| |
| ; General | ; General |
| 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" |
| |
| |
| ===== Page Banner ===== | ===== Page Banner ===== |
| |
| **** | |
| |
| <code> | <code> |
| // Hide PHP Warnings | // Hide PHP Warnings |
| $conf['show_php_errors'] = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING; | $conf['show_php_errors'] = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING; |
| | |
| | $conf['graphics_library'] = 'gd'; |
| |
| // Header Links | // Header Links |
| $conf['links'] = array( | $conf['links'] = array( |
| 'https://realmofespionage.xyz' => 'Realm of Espionage', | 'https://realmofespionage.xyz' => 'Realm of Espionage', |
| 'https://wiki.realmofespionage.xyz/start' => 'RoE | Wiki', | 'https://wiki.realmofespionage.xyz' => 'RoE | Wiki', |
| 'https://blog.realmofespionage.xyz' => 'RoE | Blog', | 'https://blog.realmofespionage.xyz' => 'RoE | Blog', |
| 'https://social.realmofespionage.xyz/profile/espionage724' => 'RoE | Social', | 'https://social.realmofespionage.xyz/profile/espionage724' => 'RoE | Social', |
| 'https://forums.realmofespionage.xyz' => 'RoE | Forums', | 'https://forums.realmofespionage.xyz' => 'RoE | Forums', |
| | 'https://status.realmofespionage.xyz' => 'RoE | Status', |
| 'https://wiki.realmofespionage.xyz/user:espionage724' => 'Webmaster Info', | 'https://wiki.realmofespionage.xyz/user:espionage724' => 'Webmaster Info', |
| 'https://wiki.realmofespionage.xyz/servers:bsd:nginx:piwigo' => 'Instance Configuration Notes', | 'https://wiki.realmofespionage.xyz/servers:bsd:nginx:piwigo' => 'Instance Configuration Notes', |
| $conf['file_ext'] = array_merge( | $conf['file_ext'] = array_merge( |
| $conf['picture_ext'], | $conf['picture_ext'], |
| array('mp4','webmv','m4v','webm','mov') | array('mp4') |
| ); | ); |
| |
| |
| ===== Backup ===== | ===== Backup ===== |
| | |
| | * [[bsd:notes:ufs_format|UFS NAS]] |
| |
| mkdir -p ~/'backups' ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/backup.sh' && chmod +x ~/'.local/scripts/www/media/backup.sh' | mkdir -p ~/'backups' ~/'.local/scripts/www/media' && ee ~/'.local/scripts/www/media/backup.sh' && chmod +x ~/'.local/scripts/www/media/backup.sh' |
| cd '/tmp' | cd '/tmp' |
| |
| '/usr/bin/tar' -czf '/home/espionage724/backups/piwigo-files-auto-'$(date +%Y-%m-%d)'.tar.gz' -C '/usr/local/www' 'media' | '/usr/bin/tar' -czf '/mnt/NAS1/Servers/Scheduled 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 '/mnt/NAS1/Servers/Scheduled Backups/piwigo-database-auto-'$(date +%Y-%m-%d)'.sql' |
| |
| '/usr/local/bin/mariadb-dump' --single-transaction --quick 'piwigo' -r '/home/espionage724/backups/piwigo-database-auto-'$(date +%Y-%m-%d)'.sql' | #'/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' | '/bin/sync' |
| |
| 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 ====== |
| |
| ===== scp ===== | ===== scp ===== |
| |
| **** | |
| |
| scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync | scp espionage724@192.168.1.152:~/'piwigo-files-'*'.tar.gz' espionage724@192.168.1.152:~/'piwigo-database-'*'.sql' ~/'Downloads' && sync |
| |
| ===== scp ===== | ===== scp ===== |
| |
| **** | |
| |
| scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~ | scp ~/'Downloads/piwigo-files-'*'.tar.gz' ~/'Downloads/piwigo'*'.sql' espionage724@192.168.1.152:~ |
| ===== 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 ===== |
| 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> |
| |