| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:windows:nginx:wordpress [2025/06/05 15:49] – Sean Rhone | servers:windows:nginx:wordpress [2025/10/10 07:33] (current) – Sean Rhone |
|---|
| * [[servers;windows;nginx_php_php-cgi|nginx + 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)]] |
| * [[servers;windows;git|Git]] | * [[programs;windows;git|Git]] |
| * [[servers;windows;mariadb|MariaDB]] | * [[servers;windows;mariadb|MariaDB]] |
| |
| ====== Database ====== | ====== Database ====== |
| |
| "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p | "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p |
| |
| CREATE DATABASE wordpress; | CREATE DATABASE wordpress; |
| extension = "openssl" | extension = "openssl" |
| extension = "sodium" | extension = "sodium" |
| zend_extension = "opcache" | |
| |
| ; Settings | ; Settings |
| fastcgi_param "HTTPS" "on"; | fastcgi_param "HTTPS" "on"; |
| fastcgi_pass "127.0.0.1:9004"; | fastcgi_pass "127.0.0.1:9004"; |
| | } |
| | |
| | # End</code> |
| | |
| | ===== Themes Deny ===== |
| | |
| | * https://github.com/WordPress/WordPress/tree/master/wp-content/themes |
| | * Deny all except ''twentytwentyfive'' |
| | |
| | "notepad.exe" "%SystemDrive%\www\nginx\default.d\wp-themes-deny.conf" |
| | |
| | <code> |
| | location ~ /wp-content/themes/(twentyeleven|twentyfifteen|twentyfourteen|twentynineteen|twentyseventeen|twentysixteen|twentyten|twentythirteen|twentytwelve|twentytwentyfour|twentytwentyone|twentytwentythree|twentytwentytwo|twentytwenty)/ { |
| | deny all; |
| } | } |
| |
| include C:/www/nginx/default.d/blog.conf; | include C:/www/nginx/default.d/blog.conf; |
| include C:/www/nginx/default.d/headers.conf; | include C:/www/nginx/default.d/headers.conf; |
| | include C:/www/nginx/default.d/wp-themes-deny.conf; |
| |
| client_max_body_size "10M"; | client_max_body_size "10M"; |
| rewrite /wp-admin$ $scheme://$host$uri/ permanent; | rewrite /wp-admin$ $scheme://$host$uri/ permanent; |
| |
| location ~* ^.+\.(ogg|ogv|svg|svgz|eot|otf|woff|mp4|ttf|rss|atom|jpg|jpeg|gif|png|ico|zip|tgz|gz|rar|bz2|doc|xls|exe|ppt|tar|mid|midi|wav|bmp|rtf)$ { | |
| access_log off; log_not_found off; expires max; | |
| } | |
| } | } |
| |
| |
| "%SystemDrive%\www\scripts\blog\Update.bat" | "%SystemDrive%\www\scripts\blog\Update.bat" |
| | |
| | ===== Back-up ===== |
| | |
| | * TODO |
| | |
| | "notepad.exe" "%SystemDrive%\www\scripts\media\Back-up.bat" |
| | |
| | <code> |
| | @echo off |
| | |
| | :: User\Downloads |
| | "tar.exe" -czf "%UserProfile%\Downloads\dokuwiki-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www\wiki" "data/pages" "data/meta" "data/media" "data/media_meta" "data/attic" "data/media_attic" "conf" |
| | |
| | :: NAS |
| | ::"tar.exe" -czf "D:\Servers\Scheduled Backups\dokuwiki-files-auto-%RANDOM%.tar.gz" -C "%SystemDrive%\www\wiki" "data/pages" "data/meta" "data/media" "data/media_meta" "data/attic" "data/media_attic" "conf" |
| | |
| | :: End</code> |
| | |
| | "%SystemDrive%\www\scripts\media\Back-up.bat" |
| | |
| | ===== Maintenance ===== |
| | |
| | "notepad.exe" "%SystemDrive%\www\scripts\media\Maintenance.bat" |
| | |
| | <code> |
| | @echo off |
| | |
| | :: Piwigo |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\media" reset --hard |
| | |
| | "%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" reset --hard |
| | |
| | "%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> |
| | |
| | "%SystemDrive%\www\scripts\media\Maintenance.bat" |
| | |
| | ===== Git Fix ===== |
| | |
| | * :!: Set email for ''user.email'' |
| | |
| | "notepad.exe" "%SystemDrive%\www\scripts\blog\Git Fix.bat" |
| | |
| | <code> |
| | @echo off |
| | |
| | RMDIR /S /Q "%SystemDrive%\www\blog\.git" |
| | |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" init --initial-branch="master" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" add "." |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" config "user.email" "espionage724@x" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" commit --message="x" |
| | |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" remote add "origin" "https://github.com/WordPress/WordPress.git" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" pull --depth "1" --recurse-submodules "origin" "master" --rebase |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" reset --hard "origin/master" |
| | |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" gc --aggressive --prune="all" |
| | "%ProgramFiles%\Git\bin\git.exe" -C "%SystemDrive%\www\blog" fsck --full --strict |
| | |
| | PAUSE |
| | |
| | :: End</code> |
| | |
| | "%SystemDrive%\www\scripts\blog\Git Fix.bat" |
| |
| ====== Shortcuts ====== | ====== Shortcuts ====== |
| **** | **** |
| |
| CD "%USERPROFILE%\Downloads" && "%PROGRAMFILES%\MariaDB 12.0\bin\mariadb-dump.exe" -u "root" -p --opt -r "wordpress.sql" "wordpress" | CD "%USERPROFILE%\Downloads" && "%PROGRAMFILES%\MariaDB 12.1\bin\mariadb-dump.exe" -u "root" -p --opt -r "wordpress.sql" "wordpress" |
| |
| ===== Restore ===== | ===== Restore ===== |
| * [[#database|Initial set-up]] | * [[#database|Initial set-up]] |
| |
| "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE wordpress" | "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p --execute="CREATE DATABASE wordpress" |
| |
| "%ProgramFiles%\MariaDB 12.0\bin\mariadb.exe" -u "root" -p "wordpress" < "%UserProfile%\Downloads\wordpress.sql" | "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p "wordpress" < "%UserProfile%\Downloads\wordpress.sql" |
| |
| ====== Quick Commands ====== | ====== Quick Commands ====== |