Differences

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

--- servers:windows:nginx:piwigo [2025/02/16 17:35] – [Backup] Sean Rhone
+++ servers:windows:nginx:piwigo [2025/05/09 20:46] (current) – Sean Rhone
@@ Line 8: / Line 8: @@
 ===== Prerequisites =====
-  * [[windows:11_ltsc|Windows 11]]
+  * [[windows;10|Windows 10 (21H2)]]
   * [[servers;windows;nginx_php_php-cgi|nginx + PHP + PHP-CGI]]
   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
+===== TODOs =====
+  * Show title on pictures (long titles get cut-off in navbar)
 ====== Dependencies ======
@@ Line 18: / Line 22: @@
 ===== Git =====
-  * https://www.git-scm.com/download/win
+  * https://gitforwindows.org/
-  * Last tested: ''Git-2.48.1-64-bit.exe''
+  * Last tested: ''Git-2.49.0-64-bit.exe''
   * Git from the command line and also from 3rd-party software
@@ Line 90: / Line 94: @@
 ===== PHP-CGI =====
-  * :!: ''fastcgi_params'' include hard-coded to nginx version path
   "notepad.exe" "%SystemDrive%\www\nginx\default.d\media.conf"
@@ Line 101: / Line 103: @@
     fastcgi_intercept_errors "on";
     fastcgi_index "index.php";
-    include "C:/nginx-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 208: / Line 210: @@
 ===== Desktop =====
+==== Update ====
   "%SystemDrive%\www\scripts\media\Update.bat"
@@ Line 214: / Line 218: @@
 ===== Autostart =====
+==== CGI ====
   "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
@@ Line 220: / Line 226: @@
   Media PHP-CGI
+====== Task Scheduler ======
+****
+  taskschd.msc
+===== Update =====
+  * ''01:00:00 AM'' daily
+  Media Update
+  "%SystemDrive%\www\scripts\media\Update.bat"
 ====== Initial Setup ======
@@ Line 276: / Line 296: @@
 ?></code>
-====== Albums ======
+====== Albums Formatting ======
-===== 2004Scape (localhost) =====
+===== 4 Links =====
   * https://media.realmofespionage.xyz/index/category/2
@@ Line 286: / Line 306: @@
 </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://wiki.realmofespionage.xyz/games;windows;dota_2_steamcmd" target="_blank" rel="noopener">Notes</a>
-</code>
-===== Diablo II Classic =====
-  * https://media.realmofespionage.xyz/index/category/12
-<code>
-<a href="https://wiki.realmofespionage.xyz/games;windows;diablo_2_classic_1.06b" target="_blank" rel="noopener">Windows</a> | <a href="https://wiki.realmofespionage.xyz/games;linux;wine;diablo_2_classic_1.06b" target="_blank" rel="noopener">Linux</a> | Patch 1.06b (non-LoD)
-</code>
-==== Espionage (Bow) ====
-  * https://media.realmofespionage.xyz/index/category/13
-<code>Amazon (Bow, Magic Arrow)</code>
-===== Old School RuneScape =====
-  * https://media.realmofespionage.xyz/index/category/4
-<code>
-<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
-<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>
@@ Line 343: / Line 325: @@
   * [[#database|Initial set-up]]
+  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
   "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
-  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="GRANT ALL PRIVILEGES ON piwigo.* to 'piwigo'@'localhost';"
-  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="DROP DATABASE piwigo"
-  "%ProgramFiles%\MariaDB 11.7\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"