SSL Connection error

[mkmetko]

Hi, I am trying to connect to MariaDB with SSL.

With SSL turned on, connection fails (Failed to connect to database: Error: Access denied for user). When I lifted SSL, connection goes without any problem (this was however acceptable only for testing purposes)

I am using RMySQL 0.10.8 Tried to install latest github version, but got this error: Error in get(".packageName", where) : /R/win-library/3.2/DBI/R/DBI.rdb' is corrupt In addition: Warning message: In get(".packageName", where) : internal error -3 in R_decompress1

any suggestion how to proceed? Thanks!

[jchrom]

Yep,

Failed to connect to database: Error: Access denied for user 'xxx'@'123.456.78.910' (using password: YES)

On Windows 7. I'm providing all the neccessities (host, user, dbname, port, password and path to certificate) in the

default.file="path/to/.my.cnf"

Also, I have the exact same setup on Ubuntu 14.04 where it works just fine.

R version 3.3.0 (2016-05-03)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=Czech_Czech Republic.1250 
[2] LC_CTYPE=Czech_Czech Republic.1250   
[3] LC_MONETARY=Czech_Czech Republic.1250
[4] LC_NUMERIC=C                         
[5] LC_TIME=Czech_Czech Republic.1250    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods  
[7] base     

other attached packages:
[1] dplyr_0.5.0 DBI_0.5    

loaded via a namespace (and not attached):
[1] magrittr_1.5   R6_2.1.1       assertthat_0.1 tools_3.3.0   
[5] tibble_1.1     Rcpp_0.12.6    RMySQL_0.10.9

[jchrom]

Also, on Mac, I get:

Error in .local(drv, ...) : 
  Failed to connect to database: Error: Unknown SSL error

I provide path to the certificate as well. Session:

R version 3.3.1 (2016-06-21)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: OS X 10.11.2 (El Capitan)

locale:
[1] cs_CZ.UTF-8/cs_CZ.UTF-8/cs_CZ.UTF-8/C/cs_CZ.UTF-8/cs_CZ.UTF-8

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] DBI_0.4-1   moodler_0.1

loaded via a namespace (and not attached):
[1] magrittr_1.5   R6_2.1.2       assertthat_0.1 tools_3.3.1    dplyr_0.5.0   
[6] tibble_1.1     Rcpp_0.12.6    RMySQL_0.10.9  tidyr_0.5.1