Splan Setup

Splan Setup

Splan

Installation on Windows

Overview

The Splan Visitor Management System application can be installed on Windows and Linux. This section

describes the detailed installation procedure for Windows and also lists the hardware and software prerequisites.

Please download files from the link provided in the email from the Splan Team.

Note: When copying a command or script from this guide, it is recommended to first copy and

paste the commands or scripts to “Notepad++” file and then run them.

System Requirements

The Splan VMS application is delivered as a Web Application. Please check for the following prerequisites

before you start deployment:


Installation on Windows

Overview

The Splan Visitor Management System application can be installed on Windows and Linux. This section

describes the detailed installation procedure for Windows and also lists the hardware and software prerequisites.

Please download files from the link provided in the email from the Splan Team.

Note: When copying a command or script from this guide, it is recommended to first copy and

paste the commands or scripts to “Notepad++” file and then run them.

System Requirements

The Splan VMS application is delivered as a Web Application. Please check for the following prerequisites

before you start deployment:

Visitor Server Configuration Client Workstation Requirements

• 16 GB Servers, 64 Bit, Dual Core with

500GB storage

• Windows

• MySQL/MSSQL Database

• SMTP Service, SMS Gateway enabled

• Virtual Environment is supported

• Intranet connectivity to the server

• Browser: IE11, Chrome, Firefox

Self Service iPad Visitor Kiosk

• Internet access for Drivers License

Scanning

• Intranet Access for printer and visitor

server

• Brother Label printer configured on the

network

Assumptions:

• MSSQL 2016 server / MySQL is available

• Port 80 is available for the VMS application. In case this port is not available, please make a note

of which port the VMS application needs to be running on.

Installation Guide

4 support@splan.com

Download Software

Before deploying the Splan application, please verify the System Requirements. The necessary files for

installing the application servers are provided in three zip files. Splan services team provides links to

download following software package files.

Copy downloaded files to a folder drive “C://SplanBuilds”: (NOTE: C or D drive)

• Splan_Server_Tomcat.zip

• JRE Installer

• Splan Application ZIP

• Splan Database BAK files

Please follow the download instructions shared in the email from the Splan team. For additional support,

please reach out to us at dl-ps@splan.com or support@splan.com.

Step 1: Install JAVA

1. If Java 1.8 already installed, then you can skip these steps.

2. Navigate to the folder “C:/SplanBuilds/jre-8u251-windows-x64.exe”

3. Right click on the “JRE1.8” installer file.

4. Click on the ‘Run as administrator’ option

5. Configure JAVA_HOME path in Environment variable to “C:\Program Files\Java\jre1.8.0” . Please

refer to Appendix A to configure JAVA_HOME.

Step 2: Database Setup

Database Setup - MSSQL

Splan provides database BAK files which need to be restored in MSSQL server.

1. Download Splan database BAK files to database server.

a. Splan_vms : This is Splan Visitor database

b. Splan_reports : This is Splan Reports database

2. Restore these two databases.

3. Authentication – SQL Server User

a. Create one user for Splan (splanuser)

b. User should have FULL access to both database (splan_vms and splan_reports)

i. DDL and DML access to both databases.

4. Authentication – AD User (service account)

a. Splan supports connecting to database with AD authentication.

b. Create new service account or any existing service account can be used.

c. Service account should FULL access to both database (splan_vms and splan_reports)

i. DDL and DML access to both databases.

Installation Guide

5 support@splan.com

5. TCP Port

a. Splan server connects database using TCP/IP connection.

b. Default Port 1433

Database Setup - MYSQL

Creating the VMS and Reports Databases

1. Execute the command CREATE DATABASE splan_vms; OR Launch MySQL Workbench and click

‘Create a new schema’ in the connected server icon.

2. Provide the database name as ‘splan_vms’ and click OK

3. Repeat steps 1 and 2 to create ‘splan_report’ database

Importing the Reports Database

1. From the command prompt, run the command:

mysql splan_vms -u splanuser -p <

C:/SplanBuilds/SplanDB_<BUILD_NUMBER>/splan_report.db

2. Launch the MySQL workbench and click on ‘Database Import/Restore’

3. Select the ‘Import from Self-Contained File’ option and click on the ‘Browse’ button

4. Select ‘splan_report.sql’ file and click Open

Installation Guide

6 support@splan.com

5. Select ‘splan_report’ in the Default Target

Schema dropdown and click on ‘Start Import’

Creating a User and Assigning Privileges

• When the Splan application and DB are located

on same machine run the query: create user 'splanuser'@'localhost' IDENTIFIED BY 'Splan@1234';

• When the Splan application and DB are located on different machines run the query: create user

'splanuser'@'%' IDENTIFIED BY 'Splan@1234';

• To provide permissions to the user, use the command: GRANT ALL PRIVILEGES ON *.* TO

'splanuser'@'localhost' WITH GRANT OPTION;

Setting Auto commit to false

Execute the command

SET AUTOCOMMIT = 0;

Step 3: Splan Server Setup

1. Create a folder name with Splan in C or D drive

a. EX: C:\Splan

2. Extract Splan Server from downloaded SplanServer zip to C:\Splan folder.

3. Make sure to have following installation path.

a. C:\Splan\Tomcat

Installation Guide

7 support@splan.com

Database Connection

1. Configure database connectivity between Splan server and Database server.

2. Go to C:\Splan\Tomcat\conf folder

3. Open context.xml file

4. File already has sample database connection entries

5. Change database server IP and Port number

a. jdbcUrl="jdbc:sqlserver://localhost:1433;databaseName=SPLAN_VMS;"

6. Authentication – SQL Server User, provide user and passport in context file.

a. user="splanuser"

b. password="xxxx"

7. Authentication - AD / Windows User: Use the following jdbcUrl in context file and user / password

is not required in context.xml

jdbcUrl="jdbc:sqlserver://localhost:1433;databaseName=splan_vms3;integratedSecurity=true;"

Check Database Connection from Splan Server to Database Server

1. Open windows PowerShell

2. Use the following command to test connection.

a. Test-NetConnection {DatabaseServerIP / Name } -Port {PortNumber}

Copy Splan Visitor Software

1. Copy downloaded Splan application package to Tomcat server

2. Software package, C:\SplanBuilds\SplanVisitor_{version}.zip

a. Splan-web.war

b. Splan-reports.war

c. Splan-ui.zip

3. Copy all packages files to C:\Splan\Tomcat\webapps folder

4. Unzip splan-ui.zip folder to C:\Splan\Tomcat\webapps

Installation Guide

8 support@splan.com

Configure Splan Server as Service

1. Configure JAVA_HOME as Environment variable and point to installed JRE folder.

2. Configure Splan server as a service

3. Open command prompt as Administrator

4. Go to C:\Splan\Tomcat\bin folder and run “configureSplan.bat” command.

5. Splan Server is configured as service

Installation Guide

9 support@splan.com

Start Splan Server

1. Server will be started as Local Service / System account as default.

2. You can start server with different service account and same service account will be used to

authenticate to database server of SQL server if Windows authentication is enabled.

3. Start server

4. Splan server starts in default port 80

Logs

Server Logs: Server logs can be found from the path: C:\Splan\Tomcat\logs

Splan Logs: Splan logs can be found from the path: C:\Splan\Tomcat\logs\splan

Launch Splan Application

1. Open any browser and navigate to the URL:

http://<servernameOR_IP>/splan-ui

2. Splan login page will be displayed

Installation Guide

10 support@splan.com

License Activation

1. Login to Splan admin with user “admin” and password as “admin”

2. Error message will be displayed with license action.

3. Click on “Activate License” link.

4. Click on “Generate Hardware Key” and share the following details with Splan team.

a. Hdd manufacturer serial number

b. Ethernet address

c. Server Name / IP address

5. Splan Team will generate license with given values and send back the license.

6. Add license text to in License page and click on “Activate”.

Contact Splan Team for further configurations and training.