Verification Check of Remote Certificate Failed
Posted: Thu 14 Jul 2016 14:12
Hi,
I have an instance on Amazon and I'm trying to connect to their MySQL RDS using SSL.
I have a database user that requires SSL and is granted permission to use all databases.
My database connection string looks something like this:
"User Id=UserName;Password=Password;Host=HostName;Protocol=SSL;Database=DatabaseName;SSL CA Cert=C:\\rds-combined-ca-bundle.pem;Ping Interval=10;Pooling=True;Port=3306"
I get "SSL connection error (2026): Verification check of remote certificate failed."
However, it works when I connect directly to MySQL:
mysql -h hostname --ssl-ca=C:\\rds-combined-ca-bundle.pem --ssl-verify-server-cert -u UserName -p
Amazon's documentation tells me to connect by downloading and specifying the ssl-ca public key.
http://docs.aws.amazon.com/AmazonRDS/la ... SSLSupport (under Using SSL with a MySQL DB Instance)
I'm using dotConnect for MySQL version 8.6.667.0
Please let me know if you need more information.
Thanks in advance,
Jared
I have an instance on Amazon and I'm trying to connect to their MySQL RDS using SSL.
I have a database user that requires SSL and is granted permission to use all databases.
My database connection string looks something like this:
"User Id=UserName;Password=Password;Host=HostName;Protocol=SSL;Database=DatabaseName;SSL CA Cert=C:\\rds-combined-ca-bundle.pem;Ping Interval=10;Pooling=True;Port=3306"
I get "SSL connection error (2026): Verification check of remote certificate failed."
However, it works when I connect directly to MySQL:
mysql -h hostname --ssl-ca=C:\\rds-combined-ca-bundle.pem --ssl-verify-server-cert -u UserName -p
Amazon's documentation tells me to connect by downloading and specifying the ssl-ca public key.
http://docs.aws.amazon.com/AmazonRDS/la ... SSLSupport (under Using SSL with a MySQL DB Instance)
I'm using dotConnect for MySQL version 8.6.667.0
Please let me know if you need more information.
Thanks in advance,
Jared