Unix: Upgrade TIM & Wildfly

Unix: Upgrade TIM & Wildfly

from TIM Version 7.11.0 upwards

Database

  1. Check required database version (release notes)

  2. Backup database

  3. If needed update database

 

Java

  1. Check required Java version (release notes)

  2. If needed download required version from Adoptium

  3. Install and set JAVA_HOME for the system

 

TIM

  1. Check release notes for required wildfly version

  2. Download wildfly.zip, wildfly-delta.zip, dashboard.war & timVERSION

  3. Create backup folders e.g. usr/local/tim/backup/date/old & usr/local/tim/backup/date/new

  4. Stop TIM Service

  5. Move existing folder usr/local/tim/wildflyVERSION-ENVIRONMENT/ to usr/local/tim/backup/date/old

  6. Extract wildfly.zip to usr/local/tim/backup/date/new/wf-ver-env

  7. Extract wildfly-delta.zip and copy folder content into usr/local/tim/backup/date/new/wf-ver-env replace existing files

  8. Copy usr/local/tim/backup/date/new/wf-ver-env/docs/contrib/scripts/systemd/launch.sh to usr/local/tim/backup/date/new/wf-ver-env/bin/

  9. Copy usr/local/tim/backup/date/new/wf-ver-env/docs/contrib/scripts/systemd/wildfly.conf to etc/default/

  10. Copy usr/local/tim/backup/date/new/wf-ver-env/docs/contrib/scripts/systemd/wildfly.service to etc/systemd/system/

  1. Replace following files from usr/local/tim/backup/date/old to usr/local/tim/backup/date/new

\wf-ver-env\standalone\configuration\jwt.keystore \wf-ver-env\ssl\keystore.jks \wf-ver-env\ssl\truststore.jks \wf-ver-env\standalone\configuration\tim_store_secret.cs \wf-ver-env\standalone\configuration\tim-ldap.properties \wf-ver-env\standalone\configuration\dashboard.properties \wf-ver-env\standalone\configuration\tim.properties
  1. Unzip downloaded timVERSION folder and move timVERSION.ear file to
    usr/local/tim/backup/date/new/wf-ver-env/standalone/deployments

  2. If timVERSION.ear was a directory custom handler may be in use

    1. In this case follow custom handler instruction

  3. Move dashboard.war file to usr/local/tim/backup/date/new/wf-ver-env/standalone/deployments

  4. Open usr/local/tim/backup/date/new/wf-ver-env/standalone/deployments/standalone-tim.xml to configure the data source.

Replace env-data only, xml syntax does change

<datasources> <datasource jta="true" jndi-name="java:/doorisPortalDB" pool-name="doorisPortalDB" enabled="true" use-java-context="true" use-ccm="false"> <connection-url>${env.JDBC_CONNECTION,jboss.JDBC_CONNECTION:jdbc:sqlserver://localhost:1433;databaseName=tim;}</connection-url> <driver>${env.JDBC_DRIVER,jboss.JDBC_DRIVER:sqlserver}</driver> <pool> <min-pool-size>20</min-pool-size> <max-pool-size>150</max-pool-size> </pool> <security> <user-name>${env.DBUSER,jboss.DBUSER:sa}</user-name> <password>${env.DBPASSWORD,jboss.DBPASSWORD:t1m}</password> </security> <validation> <check-valid-connection-sql>${env.CHECK_ALIVE_QUERY,jboss.CHECK_ALIVE_QUERY:SELECT 1 FROM TIM_DUAL}</check-valid-connection-sql> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> <use-fast-fail>false</use-fast-fail> </validation> </datasource> ... </datasources>
  1. Set port offset at the end of usr/local/tim/backup/date/new/wf-ver-env/standalone/deployments/standalone-tim.xml file

<socket-binding-group name="standard-sockets" default-interface="public" port-offset="${env.socket.binding.port-offset,jboss.socket.binding.port-offset:0}"> <socket-binding name="ajp" port="${jboss.ajp.port:8009}"/> <socket-binding name="http" port="${jboss.http.port:8080}"/> <socket-binding name="https" port="${jboss.https.port:8443}"/> <socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/> <socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9993}"/> <socket-binding name="txn-recovery-environment" port="4712"/> <socket-binding name="txn-status-manager" port="4713"/> <outbound-socket-binding name="mail-smtp"> <remote-destination host="${jboss.mail.server.host:localhost}" port="${jboss.mail.server.port:25}"/> </outbound-socket-binding> </socket-binding-group>
  1. Open usr/local/tim/backup/date/new/wf-ver-env/bin/standalone.conf & configure lines 96 - 104 to be disabled:

# TIM Solutions GmbH Configuration part # Feel free to edit this configuration below! #JAVA_OPTS="$JAVA_OPTS -Djboss.socket.binding.port-offset=0" #JAVA_OPTS="$JAVA_OPTS -Djboss.http.port=8080" #JAVA_OPTS="$JAVA_OPTS -Djboss.JDBC_CONNECTION=jdbc:sqlserver://database.fqdn:1433\;database=tim\;encrypt=true\;loginTimeout=30\;" #JAVA_OPTS="$JAVA_OPTS -Djboss.JDBC_DRIVER=sqlserver" #JAVA_OPTS="$JAVA_OPTS -Djboss.CHECK_ALIVE_QUERY='SELECT 1 FROM TIM_DUAL'" #JAVA_OPTS="$JAVA_OPTS -Djboss.DBUSER=tim" #JAVA_OPTS="$JAVA_OPTS -Djboss.DBPASSWORD=t1m"
  1. Move usr/local/tim/backup/date/new/wf-ver-env/ folder to usr/local/tim/

  2. Open etc/systemd/system/wildfly.service and set following parameters:

    [Service] Environment=LAUNCH_JBOSS_IN_BACKGROUND=1 EnvironmentFile=-/etc/default/wildfly.conf User=tim LimitNOFILE=102642 PIDFile=/run/wildfly/wildfly.pid ExecStart=/usr/local/tim/wildfly-[VERSION].Final/bin/launch.sh $WILDFLY_MODE $WILDFLY_CONFIG $WILDFLY_BIND StandardOutput=null
  3. Open etc/default/wildfly.conf and set WILDFLY_CONFIG=standalone-tim.xml

  4. Enable service with systemctl enable wildfly.service & systemctl daemon-reload

  5. Start wildfly.service

  6. Check usr/local/tim/wf-ver-env/standalone/log/server.log for any issues to resolve.

  7. Issues may be closed ports, connection to the database, missing permissions or antivirus intervention

  8. Open http://hostname:port/loom-portal/license.htm & check validity of TIM license

  9. Database changes require license renewal

  10. Request license according to shown token id (single or multi node)

  11. License can be ordered at License Request

  12. For license activation please use https://hostname:port/loom-portal/license.htm

  13. Open https://hostname:port/tim/client/ to log in

  14. Replace unencrypted passwords with encrypted ones in
    usr/local/tim/wf-ver-env/standalone/configuration/tim.properties &
    usr/local/tim/wf-ver-env/standalone/configuration/standalone-tim.xml

to decrypt already encrypted files after an update copy wfOLD/standalone/configuration/tim_store_secret.cs to wfNEW/standalone/configuration/

For further configuration check TIM BPM DOCUMENTATION e.g SMTP, LDAP Auth & Sync or SSO with SAML

Feel free to contact TIM Servicedesk for assistance