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?
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