Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ili2pg: SSL-connection to DB Server possible? #176

Closed
schmandr opened this issue Jun 1, 2018 · 6 comments
Closed

ili2pg: SSL-connection to DB Server possible? #176

schmandr opened this issue Jun 1, 2018 · 6 comments
Milestone

Comments

@schmandr
Copy link

schmandr commented Jun 1, 2018

Question: Is it possible to call ili2pg in a way that it establishes an SSL connection to the DB server? Maybe by using some -D...-Option?

@claeis
Copy link
Owner

claeis commented Jun 4, 2018

with (clientcert=1) or without (clientcert=0) client certificate authentication?

https://www.postgresql.org/docs/current/static/ssl-tcp.html#SSL-CLIENT-CERTIFICATES

https://jdbc.postgresql.org/documentation/head/connect.html

@schmandr
Copy link
Author

schmandr commented Jun 4, 2018

Without client certificate authentication. For my current use case.

@claeis
Copy link
Owner

claeis commented Jun 4, 2018

should work

@schmandr
Copy link
Author

schmandr commented Jun 5, 2018

Nice.
So my guess was to try with
java -Dorg.postgresql.PGProperty.SSL=true -Dorg.postgresql.PGProperty.SSL_FACTORY=org.postgresql.ssl.NonValidatingFactory -jar ili2pg.jar ...
But I had no success (ili2pg 3.11.2). Do you have any hint how to pass those properties correctly?

@schmandr
Copy link
Author

should work

Does this actually mean "it doesn't work right now, but the software should support it some day" or "it should actually work if the user passes the right options"? If it's the latter, how would one do it the right way? So far, I just figured out a hack...:
java -jar ili2pg.jar --dbhost localhost --dbport 5432 --dbdatabase "dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" ...

@claeis
Copy link
Owner

claeis commented Jan 23, 2019

see #252

@claeis claeis closed this as completed Jan 23, 2019
@claeis claeis added this to the 4.0.0 milestone Jan 23, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants