0

Following up on a previous answer to this question, I'm using RMySQL to connect to my Amazon RDS instance. I can connect without SSL, but would prefer to connect over SSL using the provided certificate for my EC2 instance. This method seems to work fine using Sequel Pro.

However, when attempting the same connection in R using the RMySQL package, I get the following error:

library(RMySQL)
con <- dbConnect(MySQL(), default.file='~/Desktop/mysql.cfg')
Error in mysqlNewConnection(drv, ...) : 
  RS-DBI driver: (Failed to connect to database: Error: SSL connection error: SSL_CTX_set_default_verify_paths failed
)

In addition to my regular authentication parameters, the mysql.cfg file contains the path to my .pem file provided by Amazon, (e.g., ssl-ca='~/.ssh/file.pem'). Am I missing an additional parameter?

Community
  • 1
  • 1
Jason French
  • 394
  • 2
  • 15
  • It appears that my EC2 file is actually a key. I then tried changing `ssl-ca` to `ssl-key` but still received this error: `SSL error: Unable to get certificate from '/Users/me/.ssh/MacbookAir.pem' Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (Failed to connect to database: Error: SSL connection error: Unable to get certificate )` – Jason French Jun 24 '14 at 23:47
  • 1
    Can you try again with the new version of RMySQL? – Jeroen Ooms Jan 16 '15 at 20:32
  • Try using absolute paths as described here: http://stackoverflow.com/questions/20709581/ssl-connection-error-when-connecting-to-rds-mysql-from-django – Gobi Dasu Jun 22 '16 at 06:27

0 Answers0