Deployment Guide - moritzmars/ScienceDataManagement GitHub Wiki

System requirements

  • Apache Tomcat/8.0.17
  • Java 8.0 (jre1.8.0_31/ jdk1.8.0_31)
  • My SQL 5.6.21

Installation guide

1. Preparation

Get the file "Installationspaket_sciencepapermanager_Release_1.0.zip" from the repository. Extract the file on your target system.

The extractes file contains the following files:

(0) CreateStructure.sql: Creates the sql structure. (1) CreateData.sql: Creates the data. ScientificPaperManager.war: Creates the web application.

2. Database

  • Execute the script „(0) CreateStructure.sql“ on your database server. The script creates a schema with the name „sciencedatamanagement“ and all required tables.

  • Please check after the execution, whether there is a error message in your sql console and whether the „sciencedatamanagement“ database is successfully created.

  • Execute the script (1) CreateData.sql“ on your database server. The script creates the required data.

  • Please check after the execution, whether there is a error message in your sql console and whether the „sciencedatamanagement“ database is successfully created.

3. Web application

  • Open the App Management of your web application server (Tomcat Root-> Manager App).
  • Select in the section „War file to deploy“ the file „ScientificPaperManager.war“ from the extracted installation package and click afterwards on deploy.
  • Check whether the application „SciencePaperManager“ is listed.
  • Open the application with a double click on the name.

4. Application configuration

  • Open the application and navigate to Settings.
  • Enter a connection string to your "My SQL Server" and click afterwards on save. Example connection string:

jdbc:mysql://[MY SQL SERVER NAME]:[MY SQL SERVER PORT]/ sciencedatamanagement?user=scndatamgr&password=password

MY SQL SERVER: DNS or IP address of your „My SQL Server“ MY SQL SERVER PORT: Port of the „My SQL Server“ sciencepapermagement: Name of the database user=scndatamgr&password=password: Username and password of a user with accesss rights to the sciencepapermagement database.

5. Basic function test

  • Open the application and navigate to the search section. You should see two entries.

  • If you do not see the entries, please restart you Browser and check the SQL connection string.

  • Select „Test query 1“ and click on „Start search“. The application will start crawling. Please monitor the progress an the progress bar.

  • After the crawel has finished, please reselect the „Test query 1“. The application will display the search results.

The application is now succesfully installed and can be used.