Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section lists the prerequisites and explains how to apply the patch on Windows-based and Linux-based operating systems.

...

  1. Go to .../<AdeptiaInstallFolder>/AdeptiaServer/ServerKernel/etc location.
  2. Take backup of server-configure.properties file from the above-mentioned location.
  3. Open server-configure.properties file.
  4. Go to Database Configuration section and do the following changes:
    1. Update the property 'abpm.jdo.driver' value as com.mysql.cj.jdbc.Driver.
    2. Update the property 'abpm.jdo.url' by appending the value ?useSSL=false&amp;serverTimezone=<time zone> at the end of the URL.


      Info
      • Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
      • Append the value &amp;serverTimezone=<time zone> at the end of the URL. For example, &amp;serverTimezone=UTC+3:00. This argument is required only when an error related to the time zone is displayed while starting the Connect Kernel.

        Here, <time zone> is the time zone of your MySQL server.



    3. Save the file.

  5. Go to Database Appender section and do the following changes:
    1. Update the property 'log4j.appender.jdbc.dbclass' value as com.mysql.cj.jdbc.Driver.
    2. Update the property 'abpm.jdo.url' by appending the value ?useSSL=false&amp;serverTimezone=<time zone> at the end of the URL.


      Info
      • Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
      • Append the value &amp;serverTimezone=<time zone> at the end of the URL. For example, &amp;serverTimezone=UTC+3:00. This argument is required only when an error related to the time zone is displayed while starting the Connect Kernel.

        Here, <time zone> is the time zone of your MySQL server.


    3. Save the file.

Changes in quartz.properties File

In case you are using MySQL as Backend and Log database then do these manual changes. 

Info
This is required as MySQL JDBC jars have been upgraded to the latest version. 
  1. Go to .../<AdeptiaInstallFolder>/AdeptiaServer/ServerKernel/etc location.
  2. Take backup of quartz.properties file from the above-mentioned location.
  3. Open quartz.properties file.
  4. Go to Configure Datasources section and do the following changes:
    1. Update the property 'org.quartz.dataSource.aBPM.driver' value as com.mysql.cj.jdbc.Driver.
    2. Update the property 'abpm.jdo.url' by appending the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.

      Info
      • Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
      • Append the value &serverTimezone=<time zone> at the end of the URL. For example, &serverTimezone=UTC+3:00. This argument is required only when an error related to time zone is displayed while starting the Connect Kernel.

        Here, <time zone> is the time zone of your MySQL server.


      Image Modified


  5. Save the file.

Restoring user-defined jars

...

Once the post patch deployment steps are done, start the services, i.e. Kernel and WebRunner.

Info

If you are using Database/Advanced Database Event, Source/Target activity with MySQL Database Server using an older version of MySQL JDBC jars then it is recommended to upgrade the jars to mitigate the vulnerability associated with the older jars.


Click here to download the recommended version of MySQL jars (mysql-connector-java-8.0.18.jar) and follow the steps to upgrade it.