Web Server for Windows

A simple web server for windows with Nginx, PHP, MariaDB/PostgreSQL and phpMyAdmin

Nginx 1.xx
PHP 7.x
- cURL
- OPCache
- APCu
- Sendmail
- Composer
MariaDB 10.x
- phpMyAdmin 5.x
  - With config for phpMyAdmin configuration storage
PostgreSQL 12.x
- pgAdmin 4.xx

Getting

cmd
cd C:\
git clone https://gitlab.com/breithbarbot/web-server-windows.git server

Download

Download the source files and extract to the each respective folder
- C:\server\nginx: Nginx
- C:\server\php: [Minimum recommended version 7.4.2] PHP (x64 Thread Safe)
  - The VC15 builds require to have the Visual C++ Redistributable for Visual Studio 2017 x64
- C:\server\mariadb: MariaDB (ZIP file - Windows x86_64)
- C:\server\phpmyadmin: [Minimum recommended version 5.0.1] phpMyAdmin
- C:\server\pgsql: PostgreSQL

Configuration

General

Update your PATH system variable
- C:\server\mariadb\bin
- C:\server\pgsql\bin
- C:\server\nginx
- C:\server\php
Restart your system (or just restart all open terminals).

Nginx

nginx-1.X.X.zip in: C:\server\nginx.

Execute: cp C:\server\nginx\conf\nginx.conf C:\server\nginx\conf\nginx.conf.bak

Configuration

Edit nginx files:

nginx documentation

Edit:

# C:\server\nginx\conf\nginx.conf

#user  nobody;
# Calcul: grep processor /proc/cpuinfo | wc -l
worker_processes  auto;

error_log  C:/server/var/log/nginx/error.log warn;
pid        C:/server/var/log/nginx/nginx.pid;

events {
    # Definition of the maximum number of simultaneous connections (Use the command to know the maximum value of your server: `ulimit -n`)
    worker_connections  1024;
    multi_accept        on;
}

http {
    ##
    # ngx_http_charset_module
    ##
    charset  utf-8;
    
    
    ##
    # ngx_http_core_module
    ##
    client_max_body_size  500M;
    include               mime.types;
    default_type          application/octet-stream;
    keepalive_timeout     65s;
    sendfile              on;
    #tcp_nopush           on;
    
    
    ##
    # ngx_http_gzip_module
    ##
    gzip             on;
    gzip_proxied     any;
    gzip_comp_level  6;
    gzip_types       text/plain text/css application/json application/x-javascript text/xml application/xml application/xml+rss text/javascript;
    
    
    ##
    # ngx_http_log_module
    ##
    #log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
    #                  '$status $body_bytes_sent "$http_referer" '
    #                  '"$http_user_agent" "$http_x_forwarded_for"';
    #access_log        C:/server/var/log/nginx/http_access.log  main;
    error_log          C:/server/var/log/nginx/http_error.log  warn;
    
    
    ##
    # Virtual Host Configs
    ##
    include  C:/server/nginx/conf/conf.d/*.conf;
}

Virtual Host

Place your configuration files in the conf.d directory.

Create:

# C:\server\nginx\conf\conf.d\default.conf

# HTTP Server
server {
    listen       80;
    server_name  localhost;
    
    
    root   c:/server/www;
    
    
    location / {
        index  index.html index.htm index.php;
    }
    
    
    # redirect server error pages to the static page /50x.html
    #
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   html;
    }
    
    
    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    location ~ \.php$ {
        fastcgi_pass   127.0.0.1:9000;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME  $realpath_root$fastcgi_script_name;
        include        fastcgi_params;
    }
    
    
    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    location ~ /\.ht {
        deny  all;
    }
    
    
    #access_log  C:/server/var/log//nginx/localhost.access.log;
    error_log   C:/server/var/log//nginx/localhost.error.log warn;
}

PHP

php-7.X.X-Win32-VC15-x64.zip in: C:\server\php.

Execute: cp C:\server\php\php.ini-development C:\server\php\php.ini

Configuration

List of Supported Timezones

Edit:

; C:\server\php\php.ini

[PHP]
realpath_cache_size = 10M
realpath_cache_ttl = 300
memory_limit = 512M
error_log = "C:\server\var\log\php_errors.log"
post_max_size = 50M
include_path = ".;C:\server\php\pear"
extension_dir = "ext"
sys_temp_dir = "C:\server\var\tmp"
upload_tmp_dir = "C:\server\var\tmp"
upload_max_filesize = 10M
extension=bz2
extension=curl
extension=fileinfo
extension=gd2
extension=intl
extension=mbstring

[Date]
date.timezone = Europe/Paris

[Session]
session.save_path = "C:\server\var\tmp"
session.gc_maxlifetime = 86400

[soap]
soap.wsdl_cache_dir="C:\server\var\tmp"

PEAR

Create folder: mkdir C:\server\php\pear
PEAR Packages

cURL / SSL

Download: https://curl.haxx.se/docs/caextract.html
Save file in: C:\server\php\extras\ssl\cacert.pem

Edit:

; C:\server\php\php.ini

[PHP]
extension=openssl

[curl]
curl.cainfo = "C:\server\php\extras\ssl\cacert.pem"

[openssl]
openssl.cafile="C:\server\php\extras\ssl\cacert.pem"

OPCache (Optional)

Edit:

; C:\server\php\php.ini

[opcache]
zend_extension=opcache
opcache.enable=1
opcache.enable_cli=1
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=30000
opcache.error_log="C:\server\var\log\php_opcache_errors.log"

APCu (Optional)

Download 7.4 Thread Safe (TS) x64
Save file in: C:\server\php\ext\php_apcu.dll

Edit at the end:

; C:\server\php\php.ini

[apcu]
extension=apcu
apc.enabled=1
apc.enable_cli=1
apc.shm_size=64M
apc.ttl=3600

Sendmail (Optional)

Download: https://www.glob.com.au/sendmail/
- Copy all files in: C:\server\sendmail

Edit:

; C:\server\php\php.ini

[mail function]
sendmail_path = "\"C:\server\sendmail\sendmail.exe\" -t"

Edit file: C:\server\sendmail\sendmail.ini

Composer

Download and install: https://getcomposer.org/download/
- The default installation folder/file is: C:\ProgramData\ComposerSetup\bin\composer.phar
- If you have this error during install: Signature mismatch, could not verify the phar file integrity
  - Comment temporarily: zend_extension=opcache in C:\server\php\php.ini, run Composer install and after, uncomment.

Xdebug (Optional)

Download PHP 7.4 VC15 TS (64 bit)
Save file in: C:\server\php\ext\php_xdebug.dll

Add at the end:

; C:\server\php\php.ini

[Xdebug]
zend_extension=xdebug
xdebug.profiler_enable_trigger = 1
xdebug.profiler_output_dir = "C:/server/var/tmp/profiler"
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9001

; Display all the tree
xdebug.var_display_max_depth = -1
xdebug.var_display_max_children = -1
xdebug.var_display_max_data = -1

MariaDB

mariadb-10.X.X-winx64.zip in: C:\server\mariadb.

Documentation

Installation (In admin)

# Create windows service
C:/server/mariadb/bin/mysql_install_db.exe --datadir=C:/server/mariadb/data --service=MariaDB

# Start and stop the new service
net start MariaDB
net stop MariaDB

Configuration

Edit:

; C:\server\mariadb\data\my.ini

[mysqld]
datadir=C:/server/mariadb/data

socket=C:/server/var/tmp/mariadb.sock

tmpdir=C:/server/var/tmp

long_query_time=10

key_buffer_size=256M
sort_buffer_size=4M
read_buffer_size=2M
table_open_cache=400

query_cache_limit=16M
query_cache_size=64M

collation-server=utf8mb4_general_ci
character-set-server=utf8mb4

[client]
socket=C:/server/var/tmp/mariadb.sock
plugin-dir=C:/server/mariadb/lib/plugin

Edit:

; C:\server\php\php.ini

[PHP]
extension=mysqli
extension=pdo_mysql

Various

Default login: root
Default password: EMPTY

For set or unset password?

Start mariadb server in admin in safe mode.
- C:/server/bin/start-mariadb-safe-mode.bat

Run commands:

For set password:

 mysql -u root -p

 USE mysql;
 UPDATE user SET `password` = PASSWORD('YOUR_PASSWORD') WHERE `User` = 'root';
 FLUSH PRIVILEGES;
 quit;

For unset password:

 UPDATE user SET password = '' WHERE User = 'root';

Restart MariaDB

Debug?

C:/server/mariadb/bin/mysqld.exe --defaults-file=C:/server/mariadb/data/my.ini --log-error=C:/server/var/log/mariadb/ --console

Remove service (In admin)

C:/server/mariadb/bin/mysqld.exe --remove

phpMyAdmin

phpMyAdmin-5.X.X-all-languages.zip in: C:\server\phpmyadmin.

Creation of a symbolic link
- Execute (In cmd in Administrator): mklink /D C:\server\www\phpmyadmin C:\server\phpmyadmin

Configuration (Automatique)

Using Setup script

Configuration (Manual)

Execute:
- cp C:/server/phpmyadmin/config.sample.inc.php C:/server/phpmyadmin/config.inc.php
phpMyAdmin Blowfish Secret Generator

Edit/create:

// C:\server\phpmyadmin\config.inc.php

/**
* This is needed for cookie based authentication to encrypt password in
* cookie. Needs to be 32 chars long.
*/
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/**
* Servers configuration
*/
$i = 0;

/**
* Server: localhost
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['hide_db'] = 'information_schema|mysql|performance_schema|phpmyadmin';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
// $cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/**
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

/**
* End of servers configuration
*/

/**
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = 'import';
$cfg['SaveDir'] = 'save';

$cfg['MaxRows'] = 50;

$cfg['DefaultLang'] = 'fr';

$cfg['ShowPhpInfo'] = true;
$cfg['ForceSSL'] = false;
$cfg['Import']['charset'] = 'utf-8';
$cfg['Export']['compression'] = 'gzip';
$cfg['Export']['charset'] = 'utf-8';
$cfg['NavigationTreeEnableGrouping'] = false;

Run:

mkdir C:\server\phpmyadmin\import
mkdir C:\server\phpmyadmin\save

Run: C:/server/mariadb/bin/mysql.exe -u root < C:/server/phpmyadmin/sql/create_tables.sql
Create a new user/password in phpMyAdmin for phpMyAdmin configuration storage with full privileges (without GRANT access) for the phpmyadmin database.
- Update $cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass'] variables in config.inc.php
Delete DB (optional): test

Optimisation
- http://localhost/phpmyadmin/server_status_advisor.php

PostgreSQL

postgresql-11.X-X-windows-x64-binaries.zip in: C:\server\pgsql.

Documentation

Installation (In admin)

# Create data DB folder
mkdir C:\server\pgsql\data

# Place the cuseur
cd C:\server\pgsql\bin
initdb.exe -U postgres -A password -E utf8 -W -D ../data

# Create Windows service
cd C:\server\pgsql\bin
pg_ctl register -D C:/server/pgsql/data -N PostgreSQL

# Start and stop PostgreSQL server
net start PostgreSQL
net stop PostgreSQL

Configuration

Edit:

; C:\server\php\php.ini

[PHP]
extension=pdo_pgsql
extension=pgsql

Debug?

# Place the cuseur
cd C:\server\pgsql\bin

# Start server
pg_ctl -D ../data -l trace_file start

# Stop server
pg_ctl -D ../data -l trace_file stop

Remove service (In admin)

pg_ctl unregister -N PostgreSQL

Start & Stop all servers

Start (In admin): C:/server/_start.bat
Stop (In admin): C:/server/_stop.bat

For future update ?

Execute:
```
cd C:\server
git pull
```
Comparison between your config and the README.md doc

Uninstall

Backup your DB(s) and project(s)
Kill all services
Remove entry your PATH system variable:
- C:\server\mariadb\bin
- C:\server\nginx
- C:\server\php
Remove MariaDB service (in admin): C:/server/mariadb/bin/mysqld.exe --remove
Restart your system.

Name		Name	Last commit message	Last commit date
Latest commit History 99 Commits
.others		.others
bin		bin
mariadb		mariadb
nginx		nginx
pgsql		pgsql
php		php
phpmyadmin		phpmyadmin
sendmail		sendmail
var		var
www		www
.gitignore		.gitignore
README.md		README.md
_restart.bat		_restart.bat
_start.bat		_start.bat
_stop.bat		_stop.bat

breithbarbot/web-server-windows

Folders and files

Latest commit

History

Repository files navigation

Web Server for Windows

Getting

Download

Configuration

General

Nginx

Configuration

Virtual Host

PHP

Configuration

PEAR

cURL / SSL

OPCache (Optional)

APCu (Optional)

Sendmail (Optional)

Composer

Xdebug (Optional)

MariaDB

Installation (In admin)

Configuration

Various

Debug?

Remove service (In admin)

phpMyAdmin

Configuration (Automatique)

Configuration (Manual)

PostgreSQL

Installation (In admin)

Configuration

Debug?

Remove service (In admin)

Start & Stop all servers

For future update ?

Uninstall

About

Topics

Resources

Stars

Watchers

Forks

Languages