Thank you for your help. However, the options given "useSSL=false&requireSSL=false" didnt' work.
Below are the logs that we have...
java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server
Apr 05 14:19:28 xxx metabase[64253]: :dbname "java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server",
Apr 05 14:19:28 xxx metabase[64253]: :message "java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server"}
@cehau37
Did you try upgrading to 0.32.2? Which version of MySQL?
I’ve just tried to add skip_ssl to my MariaDB 10.3 configuration and restarted, and Metabase connects without problems.
Okay, I cannot reproduce your issue. Try looking at the logs to see if you see something. Otherwise I can only recommend that you downgrade to 0.31.2
Out of curiosity, why is MariaDB configured with skip_ssl ?
I had an issue after upgrading, where none of my questions could load - traced it back to the details column of metabase_database containing a parameter about SSL, which was not enabled previously for this DB.
Removing that restored access to my questions, but I really didn’t expect a normal upgrade to change settings like this.
I initially tried to disable SSL from the admin dashboard, but it was grayed out and “disabled”, although clicking the save button (and triggering a DB conn check), returned the error that the DB did not support SSL.
My original details column (after upgrade) was: {"host":"XXXX","port":3306,"dbname":"XXXX","user":"XXXX","password":"XXXX","tunnel-port":22,"ssl":"true"}
I removed "ssl":"true", and my queries could work again. The error I was seeing in the metabase logs was:
SQLException:
Message: Connections could not be acquired from the underlying database!
SQLState: null
Error Code: 0
SQLException:
Message: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
SQLState: null
Error Code: 0
Interestingly, the other MySQL database I had in the table was not affected with the problem, and questions using that database was fine.
It’s not in the admin panel, I was directly editing the metabase database, metabase_database table, and the details column of the database row.
You can have a look and see if the "ssl": "true" parameter is enabled there, and perhaps trying removing it (temporarily), and see if that solves your problem.
@bakavic
That is so strange. I have not been able to reproduce it, but I remember someone else reporting similar problem (I cannot find it right now).
Have you checked if the details column in the database before the upgrade? I’m wondering if "ssl":"true" gets added or if it was already there.