...

Phase 4 - Configure Other Components

JBOSS Server

EITHER: Install new Version of JBOSS Server

You can simply install the new version of the JBOSS Server, at least jboss-as-7.1.1.FINAL.13.tar.gz from cdn.jtel.de.

This contains the required components, but will require that the hazelcast.xml and standalone-full.xml files are updated as described in the installation of the webserver, see here: Rolle WEB

OR: Update the JBOSS Server

The JBOSS server requires a new connector to attach to MySQL 8.x.

...

./update_jboss.sh

Change stanalone-full.xml

The standalone-full.xml configuration file requires some modifications.

A new connection property must be added to the datasource configurations for MySQL. This must be added to the datasource configurations for JTELWeb, JTELWebSlave, JTELStats, JTELLog and JTELReports.

See the following example:

...
<datasource jndi-name="java:jboss/datasources/JTELLog" pool-name="JTELLog" enabled="true">
    <connection-url>jdbc:mysql://testdb2:3306/JTELLog</connection-url>
        #
        # THIS SECTION NEEDS TO BE ADDED
        #
        <connection-property name="useSSL">
            false
        </connection-property>
...

In the drivers section, make sure that the driver class line is included for the mysql driver.

This will only be missing on very old jboss installations, if this is the case, it might be better to update the jboss server to a new release completely.

...
<drivers>
    <driver name="com.mysql" module="com.mysql">
        #
        # MAKE SURE THIS NEXT LINE IS PRESENT.
        #
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        ...               

Reconfigure 8-Server ODBC Connections

The Rollback string for MySQL Versions 8.x (in fact MySQL 5.7) and higher has changed, and will need to be reconfigured in 8-Server. 

...