<work in progress>

<Short description- Device Manager>

This document provides the deployment steps for setting up Device Manager server and all its dependencies.

For setting up this server the below applications or tools should be available in the server machine:

1. JDK – 1.8
2. TOMCAT – v8
3. MAVEN – v3
4. MySQL DB – v5.6

The below software should be installed and available for running Device Manager server.

MySQL DB

Check whether My SQL DB is already installed and up and running.  For installation of MySQL in the below OS refer the below links

• Linux: https://dev.mysql.com/doc/refman/8.0/en/linux-installation.html
• Microsoft Windows: https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Jdk – 1.8

JDK should be available in the build machine where the .war file for Device Manager server is build and it should be available in the server machine.

• Linux: https://docs.oracle.com/javase/8/docs/technotes/guides/install/linux_jdk.html
• Microsoft Windows: https://docs.oracle.com/javase/8/docs/technotes/guides/install/windows_jdk_install.html#CHDEBCCJ

Tomcat – 8

Tomcast 8 is required to deploy Device Manager server. Tomcat server installation file and setup documents can be found in the below links:

• Download: https://tomcat.apache.org/download-80.cgi
• Setup: https://tomcat.apache.org/tomcat-8.5-doc/setup.html

Maven – 3

Maven is the tool used for building and managing Device Manager project. Please follow the below links to download and install Maven:

• Download: https://maven.apache.org/download.cgi
• Installation: https://maven.apache.org/install.html

Following are the steps to be followed to setup Device Manager Server and its dependent softwares in a Machine:

My SQL DB Setup and Configuration

After installation of My SQL DB, connect to DB using MySQL command line tool.

1. Create a database with name 'device_manager'.

                                DB creation command :

1. For creating all the tables required for Device Manager server, excecute the script 'sql' available with Device Manager source code inside 'device-manager\src\main\resources'.

                                Excecute Table creation script:

                                If already connected to 'device_manager' DB

                                                mysql> source <<path to 'Device_Manager_DB.sql' file>>

                                To connect to 'device_manager' DB and run table creation scripts

                                                mysql -u root -p device_manager < Device_Manager_DB.sql

1. Check whetether all the tables are created successfully in DB, run the below command after connecting to 'device_manager' DB.

                                mysql> show tables;