Differences

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

--- servers:windows:nginx:piwigo [2025/01/26 18:18] – Sean Rhone
+++ servers:windows:nginx:piwigo [2025/04/18 11:23] (current) – [PHP-CGI] Sean Rhone
@@ Line 8: / Line 8: @@
 ===== Prerequisites =====
-  * [[windows:10|Windows 10]]
+  * [[windows;11_ltsc|Windows 11 (24H2)]]
-  * [[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)]]
@@ Line 19: / Line 19: @@
   * https://www.git-scm.com/download/win
-  * Last tested: ''Git-2.47.1.2-64-bit.exe''
+  * Last tested: ''Git-2.48.1-64-bit.exe''
   * Git from the command line and also from 3rd-party software
@@ Line 26: / Line 26: @@
   * https://mariadb.org/download/
-  * Last tested: ''mariadb-11.6.2-winx64.msi''
+  * Last tested: ''mariadb-11.7.2-winx64.msi''
   * No Development components or Third party tools
@@ Line 38: / Line 38: @@
   "%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"
+  "explorer.exe" "%SystemDrive%\www\media"
 ===== Bootstrap Darkroom =====
@@ Line 48: / Line 48: @@
 ====== Database ======
-  "%ProgramFiles%\MariaDB 11.6\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p
   CREATE DATABASE piwigo;
@@ Line 64: / Line 64: @@
 ===== PHP =====
-  notepad "%SystemDrive%\www\php\media.ini"
+  "notepad.exe" "%SystemDrive%\www\php\media.ini"
 <code>
@@ Line 85: / Line 85: @@
 ; 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>
@@ Line 101: / Line 99: @@
     fastcgi_intercept_errors "on";
     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 "PATH_INFO" $fastcgi_path_info;
@@ Line 112: / Line 110: @@
 ===== Server Block =====
-  notepad "%SystemDrive%\www\nginx\vhosts.d\media.conf"
+  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
 <code>
@@ Line 155: / Line 153: @@
 # End</code>
-  "%SystemDrive%\www\scripts\freenginx\Reload.bat"
+  "%SystemDrive%\www\scripts\nginx\Reload.bat"
-====== Batch Files ======
+====== Scripts ======
   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>
@@ Line 176: / Line 174: @@
   "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-==== Autostart ====
-  explorer "%ProgramData%\Microsoft\Windows\Start Menu\Programs\StartUp"
-  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-  Media PHP-CGI
 ===== Update =====
@@ Line 190: / Line 180: @@
   * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/
-  notepad "%SystemDrive%\www\scripts\media\Update.bat"
+  "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
 <code>
@@ Line 198: / Line 188: @@
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" pull origin "master" --rebase
+"%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
@@ Line 203: / Line 196: @@
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase
-:: End</code>
-===== Maintenance =====
-  notepad "%SystemDrive%\www\scripts\media\Maintenance.bat"
-<code>
-@echo off
-:: Piwigo
-"%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
 "%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 201: @@
 :: End</code>
-===== Back-up =====
+  "%SystemDrive%\www\scripts\media\Update.bat"
-==== Database ====
+====== Shortcuts ======
-  notepad "%SystemDrive%\www\scripts\media\Database Back-up.bat"
+===== Desktop =====
-<code>
+  "%SystemDrive%\www\scripts\media\Update.bat"
-@echo off
-:: User\Downloads
+  Media Update
-CD "%UserProfile%\Downloads"
-:: NAS
+===== Autostart =====
-::CD /D "D:\Servers\Scheduled Backups"
-echo Root MariaDB user password prompt:
+  "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
-"%ProgramFiles%\MariaDB 11.6\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo-database-%RANDOM%.sql" "piwigo"
-pause
+  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-:: End</code>
+  Media PHP-CGI
-==== Files ====
-  notepad "%SystemDrive%\www\scripts\media\Files Back-up.bat"
-<code>
-@echo off
-:: User\Downloads
-tar -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-:: NAS
-::tar -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-:: End</code>
 ====== Initial Setup ======
@@ Line 280: / Line 240: @@
   * [[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 251: @@
 // Minimal Logging
 $conf['log_level'] = 'EMERGENCY';
+// Hide PHP Warnings
+$conf['show_php_errors'] = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING;
 // Header Links
@@ Line 311: / Line 274: @@
 ?></code>
-====== Albums ======
+====== Albums Formatting ======
-===== 2004Scape (localhost) =====
+===== 4 Links =====
   * https://media.realmofespionage.xyz/index/category/2
@@ Line 321: / Line 284: @@
 </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 =====
+====== Database ======
-  * https://media.realmofespionage.xyz/index/category/9
+===== Backup =====
-<code>
+  CD "%UserProfile%\Downloads"
-<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>
-==== Espionage ====
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo.sql" "piwigo"
-  * https://media.realmofespionage.xyz/index/category/10
+===== Restore =====
-  * :?: Needed different sorting order: Numeric 1-9
-<code>Amazon (Spear), SP, Classic (non-LoD), /players 1</code>
+  * [[#database|Initial set-up]]
-===== Old School RuneScape =====
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
-  * https://media.realmofespionage.xyz/index/category/4
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';"
-<code>
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="DROP DATABASE piwigo"
-<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 =====
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
-  * https://media.realmofespionage.xyz/index/category/5
-<code>
-<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 =====
-  * https://media.realmofespionage.xyz/index/category/6
-<code>
-<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>