Simple web server windows

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

1. Update your PATH system variable

   • C:\server\mariadb\bin
   • C:\server\pgsql\bin
   • C:\server\nginx
   • C:\server\php

2. 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?
  1. Start mariadb server in admin in safe mode.
     • C:/server/bin/start-mariadb-safe-mode.bat
  2. Run commands:
     • For set password:

        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';

  3. 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 ?

1. Execute:
2. Comparison between your config and the README.md doc

Uninstall

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