Installation Windows

Install software stack

Java 8

• https://java.com/en/download/

Tomcat application server

• https://tomcat.apache.org/download-80.cgi#8.5.28

Notes

• Do NOT use default manager password
• Change default http port from 8080 to 80
• Change default https port from 8443 to 443

Option: Extra header security

For Tomcat 7 and higher you can add the security filter to <tomcat>/conf/web.xml inside the web-app tag

  <filter>
   <filter-name>HttpHeaderFilter</filter-name>
   <filter-class>org.apache.catalina.filters.HttpHeaderSecurityFilter</filter-class>
   <init-param>
     <param-name>antiClickJackingEnabled</param-name>
     <param-value>true</param-value>
   </init-param>
   <init-param>
     <param-name>antiClickJackingOption</param-name>
     <param-value>SAMEORIGIN</param-value>
   </init-param>
  </filter>
  <filter-mapping>
    <filter-name>HttpHeaderFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

After writing the file reboot Tomcat for changes to take effect.

MySQL database

http://dev.mysql.com/downloads/mysql/

Notes

• Pick version 5.4 or higher
• Do NOT use default administraion password
• Consider moving data folder relevant location

Create automation accounts

For automated database creation in Tempus Serva (later) create the following user credentials

• username: tsinstall
• password: TempusServa
• host: localhost
• role: Administrator

Missingen dependencies ?

Depending on your Windows installation you might need Visual C++ redistributable

For version 5.7 the following are needed

• Visual C++ Redistributable Packages for Visual Studio 2013 (Server)
• Visual C++ Redistributable for Visual Studio 2015 (Client tools)

Important change for MySQL 5.7+ on windows

Before importing please add the following to the my.ini fil

    innodb_strict_mode=0

Install Tempus Serva

Complete the following steps

1. Copy TempusServa.war to Tomcat webapps
2. A new folder should be created: If not start Tomcat and wait 30 seconds
3. Copy database drivers to application server
   • source: <tomcat>/webapps/TempusServa/WEB-INF/lib/mysql-connector-java-X.X.X-bin.jar
   • target: <tomcat>/lib/
4. Restart Tomcat service
5. Check that databases are created (tsbase,tslive,tstest)
   • No databases: Proceed to "NOT USING DEFAULT INSTALLER ACCOUNT" below
6. Restart Tomcat service

Not using default installer account

Grant acces to MySQL installer account ad create databases

1. Stop Tomcat service
2. Change credetials
   • edit <tomcat>/webapps/TempusServa/META-INF/context.xml
   • set Install.DatabaseUsername
   • set Install.DatabasePassword
3. Start Tomcat service
4. Check that databases are created (tsbase,tslive,tstest)
5. Restart Tomcat service

Optional

• Change root site page to redirect to login page
  1. edit <tomcat>/webapps/ROOT/index.jsp
  2. replace file content with

 <meta http-equiv="refresh" content="0; URL='/TempusServa/login'" />

Optionally you may need to create the folder and edit the file

 sudo mkdir /usr/share/tomcat7/webapps/ROOT/
 sudo nano /usr/share/tomcat7/webapps/ROOT/index.jsp

Service functions

Backup

All data is stored in the MySQL database, so just follow the recommended standard:

https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html

Note: Best practice dumping every night using mysqldump tool

Surveillance

The service page will contain the word HEALTHY if everything is ok on the server

 <server>/TempusServa/service?<password>

Upgrades

Updating the platform is easy because the underlying database is self upgrading

1. Download new war file
2. Stop Tomcat server
3. Replace the war file
4. Start Tomcat server

Note: After some major changes the service daemon is sometimes disabled