Error #2026 Ssl Connection Error: Certificate Verify Failed

[HanGmanXXL]

Hi!

 

I’m not able to connect to my AWS RDS instance with using the AWS 2015 certificate authority.

Heidi SQL works properly.

 

Any suggestions about the problem?

 

I’m using SQLYog v12.03

 

Thank you very much!

[Abhishek Kumar Pandey]

Are you using latest certificate bundle in SQLyog?

[HanGmanXXL]

Correct.

 

This one:

 

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html

[Abhishek Kumar Pandey]

We just changed our SSL certificates and Certificate authority and it is working perfectly for us. Have you rebooted your instance after changing the CA?   Also please confirm once that you are using rds-ca-2015 as CA in your RDS instance and http://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem as CA cetificate in SQLyog.

[HanGmanXXL]

Yes, rebooted my instance twice an using the neweset ca-bundle in SQLYog.

 

Certificate Authority Certificate authority for this DB Instance

rds-ca-2015 (3/5/20)

 

 

 

Which SQLYog version are you running?

[HanGmanXXL]

Tried mysql user with and without require ssl settings.

[Abhishek Kumar Pandey]

Please download root certificates for all region from-https://s3.amazonaws.com/rds-downloads/rds-ca-2015-root.pem

Please refer-http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html

SQLyog works fine for root certificate for all regions.

[Author]

Posts