Difference between revisions of "Installation Windows"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 64: Line 64:
## Restart Tomcat service
## Restart Tomcat service


=== If databases are missing ===
=== Not using default installer account ===
Grant acces to MySQL installer account (if not using default installer account)
Grant acces to MySQL installer account ad create databases
# Stop Tomcat service
# Stop Tomcat service
# Change credetials
# Change credetials

Revision as of 13:05, 24 May 2018

Install software stack

Java 8

Tomcat application server

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

Missingen dependencies ?

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

For version 5.7 the following are needed

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/
    1. Check that databases are created (tsbase,tslive,tstest)
    2. 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'" />