Connecting Metabase Jar based local installation with remote database

Get Help
1

I have a metabase local installation with jar file ,
I am able add local databases but while trying to connect a adminer managed database,
It is saying
You may need to add trustServerCertificate=true to the additional connection options to connect with SSL.
Any Idea

2

Hi @coffeebotsrepo
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type and version you're trying to connect to.

4

@coffeebotsrepo
Since you are not including which version of MySQL, then have a look here:
https://www.metabase.com/docs/latest/databases/connections/mysql
https://www.metabase.com/docs/latest/troubleshooting-guide/db-connection

If you are still having problems connecting to the database, then you need to include the full errors from Admin > Troubleshooting > Logs

You should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2

6

@coffeebotsrepo The error is Timed out after 10.0 s, which means either host/port is incorrect, or the database is firewalled.

8

@coffeebotsrepo That's not an error, that's an INFO, but you are not inputting the correct host or port, or your database is firewalled, or you have other networking problems.
Read this:
https://www.metabase.com/docs/latest/troubleshooting-guide/db-connection

1 Like
9

Thank You so much