Installation on Windows

Mapbender needs a database to store information. The Mapbender download package contains a SQLite databse that is ready to use. For production we recommend the use of a PostgreSQL database.

Requirements

As a web server, you can also use nginx, which is considered a beta version for Windows. If you still want to use it,

you can use the same configuration file as in the Linux installation guide.

Configuration PHP

  • Unzip the Zip archive, for example under c:\php.

  • Depending on the PHP version, PHP variables for a temp directory are not set correctly under Windows.

  • Therefore, it has to be checked if the following variables (php.ini) are set correctly:

sys_temp_dir
upload_tmp_dir
date.timezone

  • The path from PHP-bin directory to the PATH variable (Windows environment variable) needs to be set.

  • Activate the required PHP extensions in the php.ini configuration file:

# php.ini
extension=php_curl
extension=php_fileinfo
extension=php_gd
extension=php_intl
extension=php_pdo_pgsql
extension=php_pdo_sqlite
extension=php_pgsql
extension=php_openssl
extension=php_mbstring
extension=php_zip
extension=php_bz2

Extract Mapbender and register to web server

Download the current Mapbender version and unzip it into c:\mapbender\

Configuration Apache

A subfolder conf.d must be prepared in the directory <apache>/conf.

Add the following code at the end of file httpd.conf:

# Include directory conf.d
Include "conf/conf.d/*.conf"

Create file <apache>\conf\conf.d\mapbender.conf with:

Alias /mapbender c:/mapbender/public/
<Directory c:/mapbender/public/>
 Options MultiViews FollowSymLinks
 Require all granted

 # Activate SetEnvIf if you want to use the Mapbender API
 # SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1

 RewriteEngine On
 RewriteBase /mapbender/
 RewriteCond %{REQUEST_FILENAME} !-f
 RewriteRule ^(.*)$ index.php [QSA,L]
</Directory>

Restart Apache.

mod_fcgid

Create file <apache>\conf\conf.d\fcgi.conf with:

LoadModule fcgid_module modules/mod_fcgid.so

FcgidInitialEnv PHPRC "c:/php/"
FcgidInitialEnv PATH "c:/php;C:/WINDOWS/system32;C:/WINDOWS;C:/WINDOWS/System32/Wbem"
FcgidInitialEnv SystemRoot "C:/Windows"
FcgidInitialEnv TEMP "C:/WINDOWS/TEMP"
FcgidInitialEnv TMP "C:/WINDOWS/TEMP"
FcgidInitialEnv windir "C:/WINDOWS"

FcgidPassHeader Authorization
FcgidIOTimeout 1200
FcgidConnectTimeout 1200
FcgidBusyScanInterval 1200
FcgidBusyTimeout 1200
FcgidErrorScanInterval 1200
FcgidIdleScanInterval 1200
FcgidIdleTimeout 1200
FcgidZombieScanInterval 1200
FcgidMaxProcesses 1000
FcgidOutputBufferSize 64
FcgidProcessLifeTime 3600
FcgidMaxRequestsPerProcess 10000
FcgidMinProcessesPerClass 0
FcgidFixPathinfo 0
MaxRequestLen 200000

<Files ~ "\.php$">
    Options Indexes FollowSymLinks ExecCGI
    AddHandler fcgid-script .php
    FcgidWrapper "c:/php/php-cgi.exe" .php
</Files>

Configuration PostgreSQL

Configuration of PostgreSQL database for productive use:

Requirements:

  • Installation of PostgreSQL

  • database for the Mapbender configuration

  • PostgreSQl database user to access the database (optional)

Activate the PHP-PostgreSQL driver

# php.ini
extension=php_pgsql
extension=php_pdo_pgsql

Configuration of database connection is done by a variable that contains the entire connection string. Configure it by adding it in your .env.local file.

MAPBENDER_DATABASE_URL="postgresql://dbuser:dbpassword@localhost:5432/dbname?serverVersion=17&charset=utf8"

For more information on the database configuration, see YAML Configuration (Configuration and Application files).

Open the windows shell.

Create the Mapbender database if it does not exist already:

cd c:\mapbender
php.exe bin/console doctrine:database:create

Create the Mapbender table structure and the load example applications:

cd c:\mapbender
php.exe bin/console doctrine:schema:create
php.exe bin/console mapbender:database:init -v
php.exe bin/composer run reimport-example-apps

To administrate Mapbender you need a user. Create root user for access:

php.exe bin/console fom:user:resetroot

Find further information in Details of the configuration of Mapbender

First steps

The Mapbender installation can now be accessed under http://[hostname]/mapbender/.

Check if the alias is working

  • http://localhost/mapbender/

  • username: root

  • password: root

Troubleshooting is available via the following command (must be executed above the bin/ directory):

php.exe bin/console mapbender:config:check

Hint

Please note that config:check will use the php-cli version. The settings may be different from your webserver PHP settings. Please use php -r 'phpinfo();' to show your PHP webserver settings.

Further information can be found at bin/console mapbender:config:check.

Congratulations! Mapbender is now set up correctly and ready for further configuration. Find information about the first steps with Mapbender in the Mapbender Quickstart.

Optional

Configuration for Printing Vector Tiles on Windows

Node.js Installation

First, install Node.js using the Windows Installer from https://nodejs.org/en/download.

The Apache web server requires the path to the Node.js directory, so it must be added to the PATH environment variable.

Example in the fcgi.conf:

FcgidInitialEnv PATH "C:/srv/php;C:/WINDOWS/system32;C:/WINDOWS;C:/WINDOWS/System32/Wbem;C:/Program Files/nodejs"

Installing the Puppeteer Node Module

Installing the Puppeteer Node module on Windows is a bit more complex because it must be done in the context of the user under which the Apache web server is running.

Often, Apache runs as a service with the user ‘Local System’. If this is the case, you will need an additional tool to run a CMD or PowerShell command line as SYSTEM:

  1. Download the PsExec Tool: https://docs.microsoft.com/en-us/sysinternals/downloads/psexec

  2. Extract the ZIP file, e.g., to C:\Tools\PsExec\.

  3. Run CMD or PowerShell as Administrator.

  4. Run the console as SYSTEM:

    c:\Tools\PsExec\PsExec.exe -i -s cmd.exe

  5. In the SYSTEM console, install the Puppeteer module in the application directory of Mapbender (not globally!):

    c:\srv\htdocs\mapbender\application> npm install puppeteer

    c:\srv\htdocs\mapbender\application> npm puppeteer browsers install