powered by Jive Software

Problems with connection to DB

I’m currently migrating my openfire server server to new server, I’m making the connection to DB again, but I always have the same notification:

2019.10.16 10:04:29 org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool (attempt 1 out of 10).
java.sql.SQLException: The server time zone value ‘Hora est?ndar de Venezuela’ 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.

How I fix that?


If you search the forums for time zone you will find a few solutions. Either adding UTC to db string or editing a config Openfire doesn't start in linux. May be a timezone problem?