RoE | Wiki

User Tools

Site Tools

Trace:
servers:windows:nginx:piwigo

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:windows:nginx:piwigo [2025/01/26 18:18] – Sean Rhoneservers:windows:nginx:piwigo [2025/06/14 21:10] (current) – [Prerequisites] Sean Rhone
Line 8: Line 8:
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[windows:10|Windows 10]] +  * [[windows;11_ltsc_server|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)]]   * [[servers;windows;nginx;lets_encrypt|Certbot (Let's Encrypt)]]
 +  * [[programs;windows;git|Git]]
 +  * [[servers;windows;mariadb|MariaDB]]
 +
 +===== 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]])
  
 ====== Dependencies ====== ====== Dependencies ======
  
   * https://piwigo.org/guides/install/requirements   * https://piwigo.org/guides/install/requirements
- 
-===== Git ===== 
- 
-  * 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 ====== ====== Download Source ======
Line 37: Line 28:
  
   "%ProgramFiles%\Git\bin\git.exe" clone --branch "master" --depth "1" --recurse-submodules "https://github.com/Piwigo/Piwigo.git" "%SystemDrive%\www\media"   "%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 ===== ===== Bootstrap Darkroom =====
Line 48: Line 37:
 ====== Database ====== ====== Database ======
  
-  "%ProgramFiles%\MariaDB 11.6\bin\mariadb.exe" -u "root" -p+  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p
  
   CREATE DATABASE piwigo;   CREATE DATABASE piwigo;
Line 64: Line 53:
 ===== PHP ===== ===== PHP =====
  
-  notepad "%SystemDrive%\www\php\media.ini"+  "notepad.exe" "%SystemDrive%\www\php\media.ini"
  
 <code> <code>
Line 85: Line 74:
 ; End</code> ; 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 ===== ===== 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> <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;
Line 112: Line 98:
 ===== Server Block ===== ===== Server Block =====
  
-  notepad "%SystemDrive%\www\nginx\vhosts.d\media.conf"+  "notepad.exe" "%SystemDrive%\www\nginx\vhosts.d\media.conf"
  
 <code> <code>
Line 155: Line 141:
 # End</code> # End</code>
  
-  "%SystemDrive%\www\scripts\freenginx\Reload.bat"+  "%SystemDrive%\www\scripts\nginx\Reload.bat"
  
-====== Batch Files ======+====== Scripts ======
  
-  MKDIR "%SystemDrive%\www\scripts\media"+===== Folder =====
  
-  explorer "%SystemDrive%\www\scripts\media"+**** 
 + 
 +  MKDIR "%SystemDrive%\www\scripts\media"
  
 ===== PHP-CGI ===== ===== PHP-CGI =====
  
-  notepad "%SystemDrive%\www\scripts\media\PHP-CGI.bat"+  "notepad.exe" "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
  
 <code> <code>
Line 176: Line 164:
  
   "%SystemDrive%\www\scripts\media\PHP-CGI.bat"   "%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 ===== ===== Update =====
  
-  * https://github.com/Piwigo/Piwigo/commits/master/ +  "notepad.exe" "%SystemDrive%\www\scripts\media\Update.bat"
-  * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/ +
- +
-  notepad "%SystemDrive%\www\scripts\media\Update.bat"+
  
 <code> <code>
Line 198: Line 175:
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard "%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" 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 :: Bootstrap Darkroom
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" reset --hard
 "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media\themes\bootstrap_darkroom" pull origin "master" --rebase
 +
 +"%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
  
 :: End</code> :: End</code>
  
-===== Maintenance =====+  "%SystemDrive%\www\scripts\media\Update.bat"
  
-  notepad "%SystemDrive%\www\scripts\media\Maintenance.bat"+====== Shortcuts ======
  
-<code> +===== Desktop =====
-@echo off+
  
-:: Piwigo +==== Update ====
-"%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 +  "%SystemDrive%\www\scripts\media\Update.bat"
-"%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+
  
-:: End</code>+  Media Update
  
-===== Back-up =====+===== Autostart =====
  
-==== Database ====+==== CGI ====
  
-  notepad "%SystemDrive%\www\scripts\media\Database Back-up.bat"+  "explorer.exe" "%AppData%\Microsoft\Windows\Start Menu\Programs\StartUp"
  
-<code> +  "%SystemDrive%\www\scripts\media\PHP-CGI.bat"
-@echo off+
  
-:: User\Downloads +  Media PHP-CGI
-CD "%UserProfile%\Downloads"+
  
-:: NAS +====== Task Scheduler ======
-::CD /D "D:\Servers\Scheduled Backups"+
  
-echo Root MariaDB user password prompt: +****
-"%ProgramFiles%\MariaDB 11.6\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo-database-%RANDOM%.sql" "piwigo"+
  
-pause+  taskschd.msc
  
-:: End</code>+===== Update =====
  
-==== Files ====+  * ''01:00:00 AM'' daily
  
-  notepad "%SystemDrive%\www\scripts\media\Files Back-up.bat"+  Media Update
  
-<code> +  "%SystemDrive%\www\scripts\media\Update.bat"
-@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 ====== ====== Initial Setup ======
Line 280: Line 245:
   * [[https://github.com/Piwigo/Piwigo/blob/master/include/config_default.inc.php|More Settings]]   * [[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> <code>
Line 291: Line 256:
 // Minimal Logging // Minimal Logging
 $conf['log_level'] = 'EMERGENCY'; $conf['log_level'] = 'EMERGENCY';
 +
 +// Hide PHP Warnings
 +$conf['show_php_errors'] = E_ALL & ~E_DEPRECATED & ~E_NOTICE & ~E_WARNING;
  
 // Header Links // Header Links
Line 311: Line 279:
 ?></code> ?></code>
  
-====== Albums ======+====== Albums Formatting ======
  
-===== 2004Scape (localhost) =====+===== 4 Links =====
  
   * https://media.realmofespionage.xyz/index/category/2   * https://media.realmofespionage.xyz/index/category/2
Line 321: Line 289:
 </code> </code>
  
-===== 2009Scape (localhost) =====+===== Single Link =====
  
-  * https://media.realmofespionage.xyz/index/category/3+  * https://media.realmofespionage.xyz/picture/268/category/17
  
 <code> <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> </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>+
  
-==== Espionage ====+  "tar.exe" -czf "%UserProfile%\Downloads\piwigo-files-manual-%RANDOM%.tar.gz" -C "%SystemDrive%\www" "media"
  
-  * https://media.realmofespionage.xyz/index/category/10 +====== Database ======
-  * :?: Needed different sorting order: Numeric 1-9+
  
-<code>Amazon (Spear), SP, Classic (non-LoD), /players 1</code>+===== Backup =====
  
-===== Old School RuneScape =====+****
  
-  * https://media.realmofespionage.xyz/index/category/4+  CD "%UserProfile%\Downloads" && "%ProgramFiles%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "piwigo.sql" "piwigo"
  
-<code> +===== Restore =====
-<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 =====+  * [[#database|Initial set-up]]
  
-  * https://media.realmofespionage.xyz/index/category/5+  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE piwigo"
  
-<code> +  "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "piwigo" < "%UserProfile%\Downloads\piwigo.sql"
-<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 =====+====== Quick Commands ======
  
-  * https://media.realmofespionage.xyz/index/category/6+===== Scripts =====
  
-<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>+  "explorer.exe" "%SystemDrive%\www\scripts\media" 
 + 
 +===== Bookmarks ===== 
 + 
 +  * https://github.com/Piwigo/Piwigo/commits/master/ 
 +  * https://github.com/Piwigo/piwigo-bootstrap-darkroom/commits/master/
  
C:/www/wiki/data/attic/servers/windows/nginx/piwigo.1737933539.txt.gz · Last modified: by Sean Rhone