Error Trying to Add Database

Get Help
1

Hi everyone, I’m running into an error and searching the forum and Google hasn’t turned up anything.

I’m trying to set up Metabase and have it running successfully in Docker.

During Step 3. Add your data, I’m getting this error:
Database name : No key-pair to add

I’m trying to add a MySQL 5.7.22 database via an SSH tunnel. I know all the credentials are good.

Could someone help me understand what’s happening and how to fix it?

Thank you!

2

Hi @alexshifrin
I don’t know what’s going wrong or what you input - skip adding the database during setup and add it after in Admin > Databases.
Then look in Admin > Troubleshooting > Logs for more details

3

Thanks for the quick reply, @flamber.

Here’s what the logs say:

2020-08-18T14:48:23-06:00 DEBUG metabase.middleware.log GET /api/database 200 2.1 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
2020-08-18T14:48:23-06:00 WARN org.apache.sshd.client.keyverifier.AcceptAllServerKeyVerifier Server at /_____ presented unverified EC key: SHA256:_____
2020-08-18T14:48:23-06:00 WARN org.apache.sshd.client.keyverifier.AcceptAllServerKeyVerifier Server at /_____ presented unverified EC key: SHA256:_____
2020-08-18T14:48:31-06:00 ERROR metabase.api.database Cannot connect to Database
2020-08-18T14:48:31-06:00 ERROR metabase.driver.util Database connection error
2020-08-18T14:48:31-06:00 ERROR metabase.driver.util Database connection error
2020-08-18T14:48:31-06:00 ERROR metabase.api.database Cannot connect to Database
2020-08-18T14:48:31-06:00 DEBUG metabase.middleware.log POST /api/database 400 201.0 ms (0 DB calls)
{:valid false, :dbname “No key-pair to add”, :message “No key-pair to add”}

4

@alexshifrin Haven’t seen that before. Guess it has something to do known_hosts not being available.
You can open an issue on it, but without details on how to reproduce it’s going to be difficult to fix:
https://github.com/metabase/metabase/issues/new/choose

5

Strange, the server is in my known_hosts file. I’ll do some more experimenting and let you know if I make any progress.

6

@alexshifrin I am running into a similar error with “… unverified EC key: …”. Were you able to find anything?

7

@Erik-ClickFlow I ended up re-entering all the database and SSH info and it just worked. I’m not clear on what I did differently. Sorry I don’t have a better answer for you.

1 Like
8

Swapping to the white-list IP addresses was a workaround to this issue.

1 Like