Differences

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

--- servers:windows:nginx:piwigo [2025/01/26 18:07] – [Diablo II] Sean Rhone
+++ servers:windows:nginx:piwigo [2025/11/29 00:43] (current) – [Back-up] Sean Rhone
@@ Line 8: / Line 8: @@
 ===== Prerequisites =====
-  * [[windows:10|Windows 10]]
+  * [[windows;10|Windows 10 (21H2)]]
-  * [[servers;windows;freenginx_php_php-cgi|freenginx + PHP + PHP-CGI]]
+  * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]]
   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
+  * [[programs;windows;git|Git]]
+  * [[servers;windows;mariadb|MariaDB]]
 ====== Dependencies ======
   * https://piwigo.org/guides/install/requirements
+  * https://github.com/Piwigo/piwigo-videojs/wiki/How-to-add-videos
-===== Git =====
+  * https://github.com/Piwigo/piwigo-videojs/wiki/Synchronize#requirement
-  * https://www.git-scm.com/download/win
-  * Last tested: ''Git-2.47.1.2-64-bit.exe''
-  * Git from the command line and also from 3rd-party software
-===== MariaDB Server =====
-  * https://mariadb.org/download/
-  * Last tested: ''mariadb-11.6.2-winx64.msi''
-  * No Development components or Third party tools
-  * Use UTF8 as default server's character set
-  * [x] Enable Networking
 ====== Download Source ======
@@ Line 37: / Line 25: @@
   "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/Piwigo/Piwigo.git" "%SystemDrive%\www\media"
-  explorer "%SystemDrive%\www\media"
 ===== Bootstrap Darkroom =====
@@ Line 48: / Line 34: @@
 ====== Database ======
-  "%ProgramFiles%\MariaDB 11.6\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p
   CREATE DATABASE piwigo;
@@ Line 56: / Line 42: @@
   GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ====== Environment ======
@@ Line 64: / Line 48: @@
 ===== PHP =====
-  notepad "%SystemDrive%\www\php\media.ini"
+  "notepad.exe" "%SystemDrive%\www\php\media.ini"
 <code>
 [PHP]
-; Modules
 extension_dir = ".\ext"
 extension = "exif"
@@ Line 74: / Line 57: @@
 extension = "mbstring"
 extension = "mysqli"
-zend_extension = "opcache"
-; Settings
+error_reporting = "~E_ALL"
+display_errors = "Off"
+log_errors = "Off"
 post_max_size = "100M"
 upload_max_filesize = "100M"
@@ Line 85: / Line 70: @@
 ; End</code>
-  CD "%SystemDrive%\" && "php.exe" -c "%SystemDrive%\www\php\media.ini" -m
+  "php.exe" -c "%SystemDrive%\www\php\media.ini" -m
-====== freenginx + PHP-CGI Configuration ======
+====== nginx + PHP-CGI Configuration ======
 ===== PHP-CGI =====
-  * :!: ''fastcgi_params'' include hard-coded to freenginx version path
+  "notepad.exe" "%SystemDrive%\www\nginx\default.d\media.conf"
-  notepad "%SystemDrive%\www\nginx\default.d\media.conf"
 <code>
-# PHP-CGI
+location "~" "\.(php)(/.*)?$" {
-location ~ \.(php)(/.*)?$ {
-    fastcgi_split_path_info ^(.+\.(?:php))(/.*)$;
+ fastcgi_split_path_info "^(.+\.(?:php))(/.*)$";
-    fastcgi_intercept_errors "on";
+ fastcgi_intercept_errors "on";
-    fastcgi_index "index.php";
+ fastcgi_index "index.php";
-    include "C:/freenginx-1.27.4/conf/fastcgi_params";
+ include "C:/www/nginx/conf/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 97: @@
 ===== Server Block =====
-  notepad "%SystemDrive%\www\nginx\vhosts.d\media.conf"
+  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
 <code>
 server {
-    listen "443" "ssl";
-    http2 "on";
-    server_name "media.realmofespionage.xyz";
-    root "C:/www/media";
-    index "index.php";
-    include C:/www/nginx/default.d/media.conf;
+ listen "443" "ssl";
-    include C:/www/nginx/default.d/headers.conf;
+ http2 "on";
+ server_name "media.realmofespionage.xyz";
+ root "C:/www/media";
+ index "index.php";
-    client_max_body_size "100M";
+ include "C:/www/nginx/default.d/media.conf";
+ include "C:/www/nginx/default.d/headers.conf";
-#    add_header Content-Security-Policy "default-src "self"; script-src "self" "unsafe-inline" "unsafe-eval"; style-src "self" "unsafe-inline"" always;
+ client_max_body_size "100M";
-#    access_log  logs/media-access.log;
+# access_log "logs/media-access.log";
-#    error_log  logs/media-error.log;
+# error_log "logs/media-error.log";
-# Install dir post-install block
+ location "/" {
-#
+  index "index.php";
-#    location "/install" {
+  try_files "$uri $uri/" "@rewrite";
-#        location ~* \.(php)$ {
+ }
-#            deny "all";
-#        }
-#    }
-    location / {
+ location "@rewrite" {
-        index index.php;
+  rewrite "^/picture((/|$).*)$" "/picture.php$1" "last";
-        try_files $uri $uri/ @rewrite;
+  rewrite "^/index((/|$).*)$" "/index.php$1" "last";
-    }
+  rewrite "^/i((/|$).*)$" "/i.php$1" "last";
+ }
-    location @rewrite {
-        rewrite ^/picture((/|$).*)$ /picture.php$1 last;
-        rewrite ^/index((/|$).*)$ /index.php$1 last;
-        rewrite ^/i((/|$).*)$ /i.php$1 last;
-    }
 }
@@ Line 155: / Line 131: @@
 # End</code>
-  "%SystemDrive%\www\scripts\freenginx\Reload.bat"
+  "%SystemDrive%\www\scripts\nginx\Reload.bat"
-====== Batch Files ======
+====== Scripts ======
+===== Folder =====
   MKDIR "%SystemDrive%\www\scripts\media"
-  explorer "%SystemDrive%\www\scripts\media"
+  "explorer.exe" "%SystemDrive%\www\scripts\media"
 ===== PHP-CGI =====
-  notepad "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
 <code>
+@echo off
 SET "PHP_FCGI_MAX_REQUESTS=0"
 SET "PHP_FCGI_CHILDREN=1"
-START "Media PHP-CGI" "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
+START "Media PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
 :: End</code>
@@ Line 177: / Line 157: @@
   "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-==== Autostart ====
+===== Update =====
-  explorer "%ProgramData%\Microsoft\Windows\Start Menu\Programs\StartUp"
+  "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
-  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
+<code>
+@echo off
-  Media PHP-CGI
+TITLE Media Updater
-===== Update =====
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard "origin/master"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull origin "master" --rebase
-  * https://github.com/Piwigo/Piwigo/commits/master/
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard "origin/master"
-  * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase
+:: End</code>
+  "%SystemDrive%\www\scripts\media\Update.bat"
+===== Back-up =====
+  * ''D:\Servers\Scheduled Backups''
-  notepad "%SystemDrive%\www\scripts\media\Update.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\media\Back-up.bat"
 <code>
 @echo off
-:: Piwigo
+TITLE Media Back-up
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull origin "master" --rebase
-:: Bootstrap Darkroom
+:: User\Downloads
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard
+::"tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase
+::"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
+:: NAS
+"tar.exe" -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
+"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "D:\Servers\Scheduled Backups\%RANDOM%-piwigo.sql" "piwigo"
 :: End</code>
+  "%SystemDrive%\www\scripts\media\Back-up.bat"
 ===== Maintenance =====
-  notepad "%SystemDrive%\www\scripts\media\Maintenance.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\media\Maintenance.bat"
 <code>
 @echo off
-:: Piwigo
+TITLE Media Maintenance
+CALL "%SystemDrive%\www\scripts\media\Git Fix.bat"
+:: End</code>
+  "%SystemDrive%\www\scripts\media\Maintenance.bat"
+===== Git Fix =====
+  * :!: Set email for both ''user.email''
+  "notepad.exe" "%SystemDrive%\www\scripts\media\Git Fix.bat"
+<code>
+@echo off
+TITLE Media Git Fix
+RMDIR /S /Q "%SystemDrive%\www\media\.git"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" init --initial-branch="master"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" add "."
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" config "user.email" "espionage724@x"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" commit --message="x"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" remote add "origin" "https://github.com/Piwigo/Piwigo.git"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull --depth "1" --recurse-submodules "origin" "master" --rebase
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard "origin/master"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" gc --aggressive --prune="all"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" fsck --full --strict
-:: Bootstrap Darkroom
+RMDIR /S /Q "%SystemDrive%\www\media\themes\bootstrap_darkroom\.git"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" init --initial-branch="master"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" add "."
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" config "user.email" "espionage724@x"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" commit --message="x"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" remote add "origin" "https://github.com/Piwigo/piwigo-bootstrap-darkroom.git"
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull --depth "1" --recurse-submodules "origin" "master" --rebase
+"%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard "origin/master"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" gc --aggressive --prune="all"
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" fsck --full --strict
@@ Line 222: / Line 255: @@
 :: End</code>
-===== Back-up =====
+  "%SystemDrive%\www\scripts\media\Git Fix.bat"
-==== Database ====
+====== Shortcuts ======
-  notepad "%SystemDrive%\www\scripts\media\Database Back-up.bat"
+===== Autostart =====
-<code>
+==== PHP-CGI ====
-@echo off
-:: User\Downloads
+  "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
-CD "%UserProfile%\Downloads"
-:: NAS
+  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-::CD /D "D:\Servers\Scheduled Backups"
-echo Root MariaDB user password prompt:
+  Media PHP-CGI
-"%ProgramFiles%\MariaDB 11.6\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo-database-%RANDOM%.sql" "piwigo"
-pause
+====== Task Scheduler ======
-:: End</code>
+****
-==== Files ====
+  taskschd.msc
-  notepad "%SystemDrive%\www\scripts\media\Files Back-up.bat"
+===== Update =====
-<code>
+  * ''1:00:00 AM'' daily
-@echo off
-:: User\Downloads
+  Media Update
-tar -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-:: NAS
+  "%SystemDrive%\www\scripts\media\Update.bat"
-::tar -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-:: End</code>
+===== Back-up =====
+  * Monthly -> All months -> Days: ''2''
+  * ''1:15:00 AM''
+  Media Back-up
+  "%SystemDrive%\www\scripts\media\Back-up.bat"
+===== Maintenance =====
+  * Monthly -> All months -> Days: ''2''
+  * ''1:30:00 AM''
+  Media Maintenance
+  "%SystemDrive%\www\scripts\media\Maintenance.bat"
 ====== Initial Setup ======
@@ Line 280: / Line 322: @@
   * [[https://github.com/Piwigo/Piwigo/blob/master/include/config_default.inc.php|More Settings]]
-  notepad "%SystemDrive%\www\media\local\config\config.inc.php"
+  "notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
 <code>
@@ Line 291: / Line 333: @@
 // Minimal Logging
 $conf['log_level'] = 'EMERGENCY';
+// Hide PHP Warnings
+$conf['show_php_errors'] = '0';
 // Header Links
@@ Line 311: / Line 356: @@
 ?></code>
-====== Albums ======
+====== Albums Formatting ======
-===== 2004Scape (localhost) =====
+===== 4 Links =====
   * https://media.realmofespionage.xyz/index/category/2
@@ Line 321: / Line 366: @@
 </code>
-===== 2009Scape (localhost) =====
+===== Single Link =====
-  * https://media.realmofespionage.xyz/index/category/3
+  * https://media.realmofespionage.xyz/picture/268/category/17
 <code>
-<a href="https://wiki.realmofespionage.xyz/servers;windows;games;2009scape_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/servers;linux;games;2009scape_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/servers;bsd;games;2009scape_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://forum.2009scape.org/viewtopic.php?t=1038-singleplayer-server-rt4-client-master-branches-scripts-and-desktop-start-launchers-on-windows-linux" target="_blank" rel="noopener">2009Scape Forums</a>
+<a href="https://wiki.realmofespionage.xyz/games;windows;dota_2_steamcmd" target="_blank" rel="noopener">Notes</a>
 </code>
-===== Diablo II =====
+====== Files ======
-  * https://media.realmofespionage.xyz/index/category/9
+===== Backup =====
-<code>
+****
-<a href="https://wiki.realmofespionage.xyz/games;windows;diablo_2" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/games;linux;wine;diablo_2" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/games;bsd;wine;diablo_2" target="_blank" rel="noopener">FreeBSD</a>
-</code>
-===== Old School RuneScape =====
+  "tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-  * https://media.realmofespionage.xyz/index/category/4
+====== Database ======
-<code>
+===== Backup =====
-<a href="https://secure.runescape.com/m=hiscore_oldschool_hardcore_ironman/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Hardcore</a> | <a href="https://secure.runescape.com/m=hiscore_oldschool_ironman/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Ironman</a> | <a href="https://secure.runescape.com/m=hiscore_oldschool/hiscorepersonal?user1=Espionage724" target="_blank" rel="noopener">Overall</a> | <a href="https://oldschool.runescape.wiki/w/Special:Contributions/Espionage724" target="_blank" rel="noopener">OSRS Wiki</a>
-</code>
-===== RuneScape =====
+****
-  * https://media.realmofespionage.xyz/index/category/5
+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo.sql" "piwigo"
-<code>
+===== Restore =====
-<a href="https://secure.runescape.com/m=hiscore_hardcore_ironman/compare?user1=Espionage724" target="_blank" rel="noopener">Hardcore</a> | <a href="https://secure.runescape.com/m=hiscore_ironman/compare?user1=Espionage724" target="_blank" rel="noopener">Ironman</a> | <a href="https://secure.runescape.com/m=hiscore/compare?user1=Espionage724" target="_blank" rel="noopener">Overall</a> | <a href="https://apps.runescape.com/runemetrics/app/overview/player/Espionage724" target="_blank" rel="noopener">RuneMetrics</a> | <a href="https://runescape.wiki/w/Special:Contributions/Espionage724" target="_blank" rel="noopener">RuneScape Wiki</a>
-</code>
-===== World of Warcraft 3.3.5 =====
+  * [[#database|Initial set-up]]
-  * https://media.realmofespionage.xyz/index/category/6
+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
-<code>
+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
-<a href="https://wiki.realmofespionage.xyz/servers;windows;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/servers;linux;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">Linux</a> | <a href="https://wiki.realmofespionage.xyz/servers;bsd;games;trinitycore_3.3.5_localhost" target="_blank" rel="noopener">FreeBSD</a> | <a href="https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293" target="_blank" rel="noopener">TrinityCore Forums</a>
-</code>
+====== 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]])