I have been using two local MySQL databases and I really like what Metabase is able to do with the data so I’m trying to connect to my production instances. They require connecting over SSH with keys, though, and I’m having trouble setting that up correctly in Metabase.
I’ve setup all the keys and user accounts and can verify that I’m able to SSH on the command line from the Metabase server to the production database server.
I’ve copied all the SSH user info info Metabase when trying to add the new database, but all I get is a message “Couldn’t connect to the database. Please check the connection details.” When I check the Metabase logs (through the UI), all I can find are these entries (some identifying data obscured):
[e2ebc18c-225b-4697-a5e4-87b318650243] 2020-10-01T12:31:14-04:00 ERROR metabase.driver.util Database connection error [e2ebc18c-225b-4697-a5e4-87b318650243] 2020-10-01T12:31:14-04:00 ERROR metabase.api.database Cannot connect to Database
[e2ebc18c-225b-4697-a5e4-87b318650243] 2020-10-01T12:31:14-04:00 DEBUG metabase.middleware.log POST /api/database/validate 200 49.4 ms (0 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (4 idle, 0 queued) (67 total active threads) Queries in flight: 0 (0 queued)
[e2ebc18c-225b-4697-a5e4-87b318650243] 2020-10-01T12:31:14-04:00 WARN org.apache.sshd.client.keyverifier.AcceptAllServerKeyVerifier Server at /XXX:22 presented unverified EC key: SHA256:XXX
Can anyone help me narrow down what to troubleshoot? I’ve also included Metabase’s debug info below.
Thanks for any assistance!
{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.1 Safari/605.1.15”,
“vendor”: “Apple Computer, Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10-post-Ubuntu-0ubuntu120.04”,
“java.vendor”: “Ubuntu”,
“java.vendor.url”: “https://ubuntu.com/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10-post-Ubuntu-0ubuntu120.04”,
“os.name”: “Linux”,
“os.version”: “5.4.0-48-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
},
“metabase-info”: {
“databases”: [
“mysql”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-09-15”,
“tag”: “v0.36.6”,
“branch”: “release-0.36.x”,
“hash”: “cb258fb”
},
“settings”: {
“report-timezone”: “US/Eastern”
}
}
}