Hi there,
I recently migrated our metabase instance, using docker running in kubernetes, from a local MySQL database to an RDS instance. Since that migration we're seeing user's logins as future dates. I would guess this has to do with a timezone setting somewhere. One major difference in the configuration of the container is that I replaced the various separate MB_DB_
environment variables with the single MB_DB_CONNECTION_URI
variable to facilitate a TLS connection. See the screenshots for a couple of examples. Is there something implicit that got changed when I started using MB_DB_CONNECTION_URI
? I also noticed that JAVA_TIMEZONE
isn't set, but I don't believe it was before either. I can also confirm that the RDS instance has its timezone set at UTC
, which I understand to be the correct setting.
mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| UTC | UTC |
+--------------------+---------------------+