Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"unknown error number" when attempting to connect via SSL with CA cert #3520

Open
jwhazel opened this issue Aug 22, 2019 · 9 comments

Comments

@jwhazel
Copy link

commented Aug 22, 2019

  • Sequel Pro Version: Nightly build 5446
  • macOS Version: 10.14.6
  • MySQL Version: 8.0.17 via Brew

Description
When attempting to connect via SSL with a CA cert issued, it results in a Connection failed! dialog that states MySQL said: SSL connection error: unknown error number

Steps To Reproduce

  1. Populate connection info for an SSL instance
  2. Make sure to include the CA cert in the corresponding field

Expected Behaviour
The program should connect to the instance or at least provide a more verbose error.

Additional Context
This was discovered while testing Digital Oceans new managed MySQL service that was just released: https://www.digitalocean.com/docs/databases/mysql/. The connection params aren't anything exotic other than maybe the port number.

password = ***
host = db-mysql-nyc1-71474-do-user-****-0.db.ondigitalocean.com
port = 25060
database = defaultdb
sslmode = REQUIRED

I've managed to successfully connect to it using MySQL cli, TablePlus, and Querious.

@Gys

This comment has been minimized.

Copy link

commented Aug 24, 2019

Came here for exactly the same issue. I can confirm connect is also successful in MySQLWorkBench (latest) and through some standard Golang code.

@shornuk

This comment has been minimized.

Copy link

commented Aug 28, 2019

Same here

@katimari

This comment has been minimized.

Copy link

commented Sep 2, 2019

same issue here

@StanBarrows

This comment has been minimized.

Copy link

commented Sep 2, 2019

same here

@code91

This comment has been minimized.

Copy link

commented Sep 9, 2019

same here

@craigpearson

This comment has been minimized.

Copy link

commented Sep 10, 2019

Same here

1 similar comment
@goldwaterenterprises

This comment has been minimized.

Copy link

commented Sep 11, 2019

Same here

@spham

This comment has been minimized.

Copy link

commented Sep 15, 2019

same here

@npalmqvist

This comment has been minimized.

Copy link

commented Sep 16, 2019

+1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
10 participants
You can’t perform that action at this time.