*** URGENT *** SSL Documentation?!
Posted: Fri 28 Aug 2009 20:11
I have an urgent requirement to implement SSL in my application.
However, the documentation you have provided is out of date and incorrect. The documentation gives this example :-
This is completely incorrect and won't even compile. According to IntelliSense, the actual members of 'SslOptions' are :-
CACert = location of authority certificate
Cert = location of client certificate
CipherList = list of ciphers the client agrees to use
Key = location of users private key
SslMode =
Please will you provide an in-depth guide on how to set this up? Also, according to the PostgreSQL documentation here :-
http://www.postgresql.org/docs/8.1/static/ssl-tcp.html
Thanks, Hedley
However, the documentation you have provided is out of date and incorrect. The documentation gives this example :-
Code: Select all
PgSqlConnection conn = new PgSqlConnection("user id=postgres;password=postgres;host=localhost;");
conn.SslOptions.Cert = "E:\Test\client.p12";
conn.SslOptions.Password = "";
conn.SslOptions.TargetHost = "pg_server";
conn.SslOptions.SslMode = SslMode.Require;
conn.Open();
CACert = location of authority certificate
Cert = location of client certificate
CipherList = list of ciphers the client agrees to use
Key = location of users private key
SslMode =
Please will you provide an in-depth guide on how to set this up? Also, according to the PostgreSQL documentation here :-
http://www.postgresql.org/docs/8.1/static/ssl-tcp.html
...client authentication is optional and we should be able to omit it and only encrypt the communication without any client authentication. I have already implemented this with my client's PostgreSQL installation - please can you let me know how to implement this with your provider?When the root.crt file is not present, client certificates will not be requested or checked. In this mode, SSL provides communication security but not authentication.
Thanks, Hedley