Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql complains about timezone #65

Open
msalle opened this issue Apr 11, 2021 · 0 comments
Open

mysql complains about timezone #65

msalle opened this issue Apr 11, 2021 · 0 comments
Assignees

Comments

@msalle
Copy link

msalle commented Apr 11, 2021

I just updated my voms packages to the latest from
https://repo.cloud.cnaf.infn.it/repository/voms-rpm-stable/centos7/
and ran into a problem with the mysql connector:
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.
(from the /var/log/voms-admin/voms-admin-<MYVO>.log file).

From e.g. https://stackoverflow.com/q/37719818, in particular https://stackoverflow.com/a/54256150 I just added ?serverTimezone=Europe/Amsterdam to the
hibernate.connection.url=jdbc:mysql://localhost:3306/voms_<MYVO>
line in /etc/voms-admin/<MYVO>/database.properties
which solves the issue.

This is an up-to-date CentOS7.9 with mariadb-server-5.5.68-1.el7 and voms-admin-server-3.8.1-1.el7

I'm not sure if this is a misconfiguration from our side but don't fully understand why we didn't see this before.

@andreaceccanti andreaceccanti self-assigned this Apr 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants