Issue 71 in rpostgresql: Allow service and sslmode parameters.

[rpost...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 71 by da...@farmersbusinessnetwork.com: Allow service and sslmode
parameters.
https://code.google.com/p/rpostgresql/issues/detail?id=71

What steps will reproduce the problem?
1. Supply either of those parameters
2. Errors out.

What is the expected output? What do you see instead?

Login. Error.


What version of the product are you using? On what operating system?

Doesn't matter. The source code contains no provisions for this.


Please provide any additional information below.


Please fix :)

--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[rpost...@googlecode.com]

Comment #1 on issue 71 by tagr...@gmail.com: Allow service and sslmode
parameters.
https://code.google.com/p/rpostgresql/issues/detail?id=71

According to the discussion on the mailing-list:

https://groups.google.com/forum/#!topic/rpostgresql-dev/ELnVUJqjDbk

RPostgreSQL doesn't support SSL by design.

You'll need to run something like pgbouncer to proxy your connections or
switch to the JDBC driver
http://ryepup.unwashedmeme.com/blog/2010/11/17/working-with-r-postgresql-ssl-and-mssql/

[rpost...@googlecode.com]

Comment #2 on issue 71 by da...@farmersbusinessnetwork.com: Allow service

and sslmode parameters.
https://code.google.com/p/rpostgresql/issues/detail?id=71

I'm happy to remove the SSL part if that's a requirement. It was an
afterthought to the feature I was actually interested in, namely the
ability to use service parameters. Would that help?

[rpost...@googlecode.com]

Comment #3 on issue 71 by tagr...@gmail.com: Allow service and sslmode
parameters.
https://code.google.com/p/rpostgresql/issues/detail?id=71

I require SSL/TLS support

[rpost...@googlecode.com]

Comment #4 on issue 71 by tagr...@gmail.com: Allow service and sslmode
parameters.
https://code.google.com/p/rpostgresql/issues/detail?id=71

This is resolved see http://stackoverflow.com/a/28582949/833093

simply do:

pg_dsn = paste0(
'dbname=', dbname, ' ',
'sslrootcert=', cacert, ' ',
'sslmode=verify-full'
)
dbConnect(RPostgreSQL::PostgreSQL(), dbname=pg_dsn, host=host,
port=port, password=password, user='datasciencemachine')