Timezone error when starting Bonita Platform

Submitted by ssilva_bizpro on Sat, 06/19/2021 - 00:09
1
0
-1

Hello!

I have Bonita Platform on a Linux server, I was able to:

  • Installed it
  • Connect to a MySQL database
  • Access the portal from outside the server
  • Deploy a process and BDM
  • Run the process successfully on the portal

Some weeks passed and when I tried to access the portal again I got a screen with a 500 error. On the server I stopped the tomcat and when trying to start it again with the start-bonita.sh script I get the following error:

[root-bizpro@bizpof-front BonitaCommunity-2021.1]$ sudo ./start-bonita.sh
JAVA_HOME is not set. Use java in path.
Java command path is java
Check that Java version is compatible with Bonita
Java full version: 11.0.9
Java version: 11
Java version is compatible
------------------------------------------------------
Initializing and configuring Bonita Tomcat bundle
------------------------------------------------------
____ _ _
| _ \ (_) |
| |_) | ___ _ __ _| |_ __ _
| _ < / _ \| '_ \| | __/ _` |
| |_) | (_) | | | | | || (_| |
|____/ \___/|_| |_|_|\__\__,_|

(Platform Setup 7.12.1)

[INFO] configuration for Database vendor: mysql
[ERROR] HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSetup.java:455)
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(PlatformSetup.java:485)
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:100)
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand.java:44)
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105)
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79)
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
... 17 common frames omitted
[ERROR] java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
[ERROR] You might get more detailed information about the error by adding '--debug' to the command line, and run again

I already checked the time zones and in both servers (Bonita Platform and MySQL) the time zone is 'CDT'. Can you help me solve this issue?

Thanks in advanced,

Solange Silva

1 answer

Submitted by romain.bioteau on Mon, 06/21/2021 - 11:27
1
0
-1

Hi,

I suggest having a look at the following ticket on the MySQL bugtracker.

It appears that CDT is not a valid MySql timezone identifier, and they recommend using serverTimezone=America/Chicago in the connection URL instead.

HTH
Romain

Notifications