Differences

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

--- servers:windows:nginx:piwigo [2026/01/29 21:41] – [config.inc.php] Sean Rhone
+++ servers:windows:nginx:piwigo [2026/04/15 10:05] (current) – [PHP-CGI] Sean Rhone
@@ Line 34: / Line 34: @@
 ====== Database ======
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
   CREATE DATABASE piwigo;
@@ Line 48: / Line 48: @@
 ===== PHP =====
-  "notepad.exe" "%SystemDrive%\www\php\media.ini"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\php\media.ini"
 <code>
@@ Line 79: / Line 79: @@
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\nginx\default.d\media.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\default.d\media.conf"
 <code>
@@ Line 98: / Line 98: @@
 ===== Server Block =====
-  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
 <code>
@@ Line 136: / Line 136: @@
   MKDIR "%SystemDrive%\www\scripts\media"
-  "explorer.exe" "%SystemDrive%\www\scripts\media"
+  "%SystemRoot%\explorer.exe" "%SystemDrive%\www\scripts\media"
 ===== PHP-CGI =====
-  "notepad.exe" "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
 <code>
@@ Line 150: / Line 150: @@
 SET "PHP_FCGI_CHILDREN=1"
-START "Media PHP-CGI" /MIN "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
+START "Media PHP-CGI" /MIN /D "%Temp%" "php-cgi.exe" -b "127.0.0.1:9003" -c "%SystemDrive%\www\php\media.ini" -q
 SET "PHP_FCGI_MAX_REQUESTS="
@@ Line 161: / Line 161: @@
 ===== Update =====
-  "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
 <code>
@@ Line 181: / Line 181: @@
 ===== Back-up =====
-  "notepad.exe" "%SystemDrive%\www\scripts\media\Back-up.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\media\Back-up.bat"
 <code>
@@ Line 189: / Line 189: @@
 CD "%Temp%"
-"tar.exe" -czf "D:\Servers\Scheduled Backups\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
+"%SystemRoot%\System32\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"
+"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "D:\Servers\Scheduled Backups\%RANDOM%-piwigo.sql" "piwigo"
-::"tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
+::"%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
-::"%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
+::"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-piwigo.sql" "piwigo"
 :: End</code>
@@ Line 201: / Line 201: @@
 ===== Maintenance =====
-  "notepad.exe" "%SystemDrive%\www\scripts\media\Maintenance.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\media\Maintenance.bat"
 <code>
@@ Line 223: / Line 223: @@
   * :!: Set **both** ''user.email''
-  "notepad.exe" "%SystemDrive%\www\scripts\media\Git Fix.bat"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\media\Git Fix.bat"
 <code>
@@ Line 283: / Line 283: @@
   * Auto-start
-  SCHTASKS /Create /SC "ONLOGON" /TN "Media PHP-CGI" /TR "%SystemDrive%\www\scripts\media\PHP-CGI.bat" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "ONLOGON" /TN "Media PHP-CGI" /TR "%SystemDrive%\www\scripts\media\PHP-CGI.bat" /F
 ===== Update =====
@@ Line 289: / Line 289: @@
   * Daily ''01:00:00 AM''
-  SCHTASKS /Create /SC "DAILY" /TN "Media Update" /TR "%SystemDrive%\www\scripts\media\Update.bat" /ST "01:00" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "DAILY" /TN "Media Update" /TR "%SystemDrive%\www\scripts\media\Update.bat" /ST "01:00" /F
 ===== Back-up =====
@@ Line 295: / Line 295: @@
   * Monthly (2nd) ''01:10:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Back-up" /TR "%SystemDrive%\www\scripts\media\Back-up.bat" /ST "01:10" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Back-up" /TR "%SystemDrive%\www\scripts\media\Back-up.bat" /ST "01:10" /F
 ===== Maintenance =====
@@ Line 301: / Line 301: @@
   * Monthly (2nd) ''01:30:00 AM''
-  SCHTASKS /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Maintenance" /TR "%SystemDrive%\www\scripts\media\Maintenance.bat" /ST "01:30" /F
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "MONTHLY" /D "2" /M "*" /TN "Media Maintenance" /TR "%SystemDrive%\www\scripts\media\Maintenance.bat" /ST "01:30" /F
 ====== Initial Setup ======
@@ Line 326: / Line 326: @@
   * [[https://github.com/Piwigo/Piwigo/blob/master/include/config_default.inc.php|More Settings]]
-  "notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
 <code>
@@ Line 344: / Line 344: @@
 $conf['links'] = array(
   '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://forums.realmofespionage.xyz/' => 'RoE | Forums',
+  'https://forums.realmofespionage.xyz' => 'RoE | Forums',
-  'https://status.realmofespionage.xyz/' => 'RoE | Status',
+  'https://status.realmofespionage.xyz' => 'RoE | Status',
   'https://wiki.realmofespionage.xyz/user;espionage724' => 'Webmaster Info',
   'https://wiki.realmofespionage.xyz/servers;windows;nginx;piwigo' => 'Instance Configuration Notes',
@@ Line 368: / Line 368: @@
   * :!: Change ''db_password''
-  "notepad.exe" "%SystemDrive%\www\media\local\config\config.inc.php"
+  "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\media\local\config\database.inc.php"
 <code>
@@ Line 393: / Line 393: @@
 ****
-  "tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
+  "%SystemRoot%\System32\tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
 ===== Database =====
@@ Line 399: / Line 399: @@
 ****
-  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.2\bin\mariadb-dump.exe" -u "root" --opt -r "piwigo.sql" "piwigo"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --opt --single-transaction -r "%UserProfile%\Downloads\piwigo.sql" "piwigo"
 ====== Restore ======
@@ Line 407: / Line 407: @@
   * [[#database|Initial set-up]]
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE piwigo"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --execute="CREATE DATABASE piwigo"
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
 ====== Resources ======
 ===== Albums Formatting =====
+  * :!: Using Emojis (like 8-) from [[https://emojipedia.org/smiling-face-with-sunglasses|Emojipedia]]) in comments caused a MySQL exception
 ==== 4 Links ====
@@ Line 430: / Line 432: @@
 <a href="https://wiki.realmofespionage.xyz/games;windows;dota_2_steamcmd" target="_blank" rel="noopener">Notes</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]])