Re: [GENERAL] JDBC connection test with SSL on PG 9.2.1 server

On 02/01/2013 06:06 AM, Hari Babu wrote:
>
>

>
> We tried the approach as suggested by you but still it is not working as shown in the below log (I had enabled
logLevelas 1) 
> keystore passowrd is qwerty
> 19:26:22.666 (1) PostgreSQL 9.2 JDBC4 (build 1002)
> 19:26:23.451 (1) Receive Buffer Size is 43808
> 19:26:23.452 (1) Send Buffer Size is 25386
> getConnection returning driver[className=org.postgresql.Driver,org.postgresql.Driver@3f7fa65e]
> Connection1 successful! Conn1:org.postgresql.jdbc4.Jdbc4Connection@6baa9f99
> null
> wrongqwerty
> DriverManager.getConnection("jdbc:postgresql://127.0.0.1:15432/postgres")
>      trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@3597a37c]
> *Driver.connect (jdbc:postgresql://127.0.0.1:15432/postgres)
>      trying driver[className=org.postgresql.Driver,org.postgresql.Driver@3f7fa65e]
> 19:26:23.835 (2) PostgreSQL 9.2 JDBC4 (build 1002)
> 19:26:23.847 (2) Receive Buffer Size is 43808
> 19:26:23.848 (2) Send Buffer Size is 25386
> getConnection returning driver[className=org.postgresql.Driver,org.postgresql.Driver@3f7fa65e]
> Connection2 successful! Conn2:org.postgresql.jdbc4.Jdbc4Connection@2e958bb8
>
> Connect OK
>
> There is function as SSL_CTX_SETSESSIONCACHEMODE(ctxt, mode) in C library of SSL.
> Can you please let us  know if there is some similar function in JSSE also.


Per a previous post, have you verified that pg_hba.conf is set up to
properly handle SSL password connections?

>
> Regards,
> Hari Babu.



--
Adrian Klaver
adrian.klaver@gmail.com