Skip to content

Windows Server installation guide

Make sure that the requirements in the Pre-install checklist are met before continuing with the installation.

Installing MideyeServer consists of the following steps:

  • Install MideyeServer Package.
  • Install a database.
  • Configure MideyeServer application-prod.yml.
  • Open firewall ports.
  • Configure MideyeServer.

Install MideyeServer

Warning

If two Mideye Servers are connected to the same database or database cluster, SQL cleanup jobs will collide and lock the database. To mitigate this, configure application-prod.yml with cluster settings according to Shared Database instructions.

Execute the Mideye Server installation package as a local administrator and follow the instructions on the screen.

Accept the license agreement.

Specify a SSL port for the Web Gui.

Enter the configuration credentials for the Mideye Servers database in MS SQL Server, that was created before the installation if the instructions in Pre-install checklist were followed.

Note

If it's not possible to connect to the database or if MySQL or MariaDB is used, simply click next and ignore Test Database Connection error. The SQL connection configuration is located in application-prod.yml file and can be edited after the installation.

Create a selfsigned certificate with hostname localhost

Specify in which path to install Mideye Server 6.

Install the application.

Wait for files to be installed.

Finish the installation

It is possible to verify in the logs (default C:\Program Files (x86)\Mideye Server 6\log\mideyeserver.log) that the installation is complete by looking for the following lines, displaying that the Mideye Server is running and the IP-address to the Web GUI:

----------------------------------------------------------
    Application 'MideyeServer' is running! Access URLs:
    Local:      https://localhost:443/
    External:   https://10.20.30.11:443/
    Profile(s):     [prod]
----------------------------------------------------------

Uninstall MideyeServer

Navigate to "Add or remove programs" or "Apps & Features".

Press Uninstall on the Mideye Server 6 application.

Backup

Before proceeding with an upgrade, take a backup of the Mideye Server file system and the Mideye database. Some files containing customized settings may need to be replaced after the update.

Backup Mideye Server file system

To take a backup of the Mideye Server, copy or compress the whole Mideye Server installation directory. The default directory is:

C:\Program Files (x86)\Mideye Server 6

Backup the database

Backup MS SQL database:

To back up a database on Microsoft SQL Server, use SQL Server Management Studio. Right-click the database used by Mideye and choose “Tasks” followed by “Back up”.

Backup Mysql database:

mysqldump -u[username] -p[password] [database name] > mideye_backup.sql

Upgrade path

Mideye Server 4.x to 6.x

It is not possible to do a straight upgrade from Mideye Server 4.x to 6.x. Follow the instructions at Upgrade Mideye Server 4.x to 5.x for more information on upgrading to Mideye Server 5.x. Then follow the instructions to upgrade from Mideye Server 5.x to 6.x.

Mideye Server 5.x to 6.x

It is not possible to do a straight upgrade from Mideye Server 5.x to 6.x. Follow the instructions at Upgrade Mideye Server 5.x to 6.x for more information on upgrading to Mideye Server 6.

Mideye Server 6.x to 6.x

Before proceeding with an upgrade, take a backup of the Mideye Server file system and the Mideye database.

It is strongly suggested that a backup should be made of at least the following items considering the database encryption:

  • application-prod.yml
  • keystore.pfx

Read more: Database Encryption

Some files containing customized settings may need to be replaced after the update.

The installation package will automatically detect if a previous version of Mideye Server 6 is installed. Upgrade involves a service re-start with an approximate downtime of 40 seconds.

Note

To execute the installation/upgrade package, local administrator privileges are required.

Modify database configuration

Warning

If two Mideye Servers are connected to the same database or database cluster, SQL cleanup jobs will collide and lock the database. To mitigate this, configure application-prod.yml with cluster settings according to Shared Database instructions.

Open C:\Program Files (x86)\Mideye Server 6\config\application-prod.yml as an administrator. Navigate to the database section (see example below) and modify according to the new database settings.

MSSQL Database Configuration

Quick way to create database in admin cmd. 

sqlcmd -Q "CREATE DATABASE mideye"

Following is the default database configuration for Windows Servers.

spring:
    devtools:
        restart:
            enabled: false
        livereload:
            enabled: false
    datasource:
        type: com.zaxxer.hikari.HikariDataSource
        driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: jdbc:sqlserver://localhost:1433;databaseName=DATABASENAME_HERE;authenticationScheme=NTLM;useNTLMv2=true;user=PLACEHOLDER_DO_NOT_CHANGE_OR_REMOVE;password=PLACEHOLDER_DO_NOT_CHANGE_OR_REMOVE
        username: mideye
        password: password
        hikari:
            connection-test-query: SELECT 1
            initializationFailTimeout: 3600000
            data-source-properties:
                cachePrepStmts: true
                prepStmtCacheSize: 250
                prepStmtCacheSqlLimit: 2048
                useServerPrepStmts: true
    jpa:
        database-platform: org.hibernate.dialect.SQLServer2012Dialect
        database: SQL_SERVER
        show-sql: false
        properties:
            hibernate.id.new_generator_mappings: true
            hibernate.cache.use_second_level_cache: false
            hibernate.cache.use_query_cache: false
            hibernate.generate_statistics: false
    liquibase:
        contexts: prod
    mail:
        host: localhost
        port: 25

MySQL Database Configuration

To use MySQL or MariaDB in Windows Server change to the following database configuration. 

spring:
    devtools:
        restart:
            enabled: false
        livereload:
            enabled: false
    datasource:
        type: com.zaxxer.hikari.HikariDataSource
        url: jdbc:mariadb://localhost:3306/MideyeServer
        username: mideye
        password: password
        hikari:
            initializationFailTimeout: 3600000
            data-source-properties:
                cachePrepStmts: true
                prepStmtCacheSize: 250
                prepStmtCacheSqlLimit: 2048
                useServerPrepStmts: true
                max-lifetime: 600000
    jpa:
        database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
        database: MYSQL
        show-sql: false
        properties:
            hibernate.id.new_generator_mappings: true
            hibernate.cache.use_second_level_cache: true
            hibernate.cache.use_query_cache: false
            hibernate.generate_statistics: false
            hibernate.cache.region.factory_class: io.github.jhipster.config.jcache.BeanClassLoaderAwareJCacheRegionFactory
    liquibase:
        contexts: prod
    mail:
        host: localhost
        port: 25