Problem

-- B2Bi is using a MySQL database

-- getting this error in CN log when starting B2Bi

2020-04-08 15:14:26,490 - INFO [Startup] (AcceptorThread) - Listening for node connections on port 47001
2020-04-08 15:14:27,026 - FATAL [Startup] (ConnectionManagerImpl) - Error while getting a database connection
java.sql.SQLException: The server time zone value 'CEST' 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) ~[mysql-connector-java-8.0.14.jar:8.0.14]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.14.jar:8.0.14]

Resolution

* alter the mysql connect string in Interchange/conf/datastoreconfig.xml (add the string : &serverTimezone=CET) :

<ConnectionURL>jdbc:mysql://{Host}:{Port}/{DatabaseName}?zeroDateTimeBehavior=convertToNull&connectTimeout=300000&socketTimeout=300000&useSSL=false</ConnectionURL>

to

<ConnectionURL>jdbc:mysql://{Host}:{Port}/{DatabaseName}?zeroDateTimeBehavior=convertToNull&connectTimeout=300000&socketTimeout=300000&useSSL=false&serverTimezone=CET</ConnectionURL>

* add the string "amp" after each "&" in the URL (it is automatically removed when saving the article)