Not able to view new tables added to MySQL database
-
I am able to see all the tables created before and create new questions at metabase.atapio.com. But I am not able to view any new tables added to MySQL database now(hosted with DigitalOcean). I believe this change occured after the upgrade to v0.48.4 on 1/29/2024.
The same thing is happening on another Cloudron supported site. (dashboard.twrl.app)
Using a local installation of Metabase v0.48.4, and connecting to a local MySQL database, I was not able to reproduce the problem. It allows me to see new tables.
Is it possible for you to try adding a new table in MySQL on DigitalOcean and see if you can see the new tables added in Metabase?
Thank you,
Jeff
-
I keep seeing
driver.mysql :: You may need to add trustServerCertificate=true to the additional connection options to connect with SSL.when trying to sync tables. Do you see similar in your logs ?It works when the database is not using encryption like localhost.
-
Thanks for looking into this. I've also logged in a bug with Metabase GitHub. I think the Metabase team is actively working on a resolution. Something did change after the upgrade from v0.48.3 that caused this issue with multiple customers using MySQL 8. Here is the link to the issue: https://github.com/metabase/metabase/issues/38499
