Skip site navigation (1) Skip section navigation (2)

SSL Connection Problems

From: dgr <me(at)home(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: SSL Connection Problems
Date: 2004-07-26 16:13:50
Message-ID: h2bag0t6njulk3ph5gddbrflnabnij40hs@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
A good day,

I am trying to connect to my postgresql database using SSL (I am using
the Win32 development build from postgresql).

I have followed the steps in:
http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php and all
seems to go fine. I edited the postgresql.conf and pg_hba.conf and
added ?ssl to the connection url but it doesn't work. I can't even
connect using pgAdmin.

This is what I get from the java debug: 

---------------------------------------------------------------------------------------------------------
PostgreSQL 7.5devel JDBC3 with SSL (build 304)
Trying to establish a protocol version 3 connection to localhost:5432
 FE=> SSLRequest
 <=BE SSLOk
converting regular socket connection to ssl
 FE=> StartupPacket(user=useronly, database=GIDS,
client_encoding=UNICODE, DateStyle=ISO)
SQLException: SQLState(08001) vendor code(451181827)
org.postgresql.util.PSQLException: The connection attempt failed
        at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:120)
        at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
        at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:106)
        at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:19)
        at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:15)
        at org.postgresql.Driver.connect(Driver.java:138)
        at
java.sql.DriverManager.getConnection(DriverManager.java:512)
        at
java.sql.DriverManager.getConnection(DriverManager.java:171)
        at GIDS.DB.DBPool.newConnection(DBPool.java:133)
        at GIDS.DB.DBPool.getConnection(DBPool.java:87)
        at GIDS.DB.DBaseManager.getConnection(DBaseManager.java:170)
        at GIDS.DB.Querier.<init>(Querier.java:57)
        at GIDS.LoginScreen.checkAdmin(LoginScreen.java:65)
        at GIDS.LoginScreen.<init>(LoginScreen.java:46)
        at GIDS.LoginScreen.main(LoginScreen.java:217)
Exception: org.postgresql.util.PSQLException: The connection attempt
failed
    trying
driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)1b3f8f6]
connect jdbc:postgresql://localhost:5432/GIDS?ssl&loglevel=2
PostgreSQL 7.5devel JDBC3 with SSL (build 304)
Trying to establish a protocol version 3 connection to localhost:5432
 FE=> SSLRequest
 <=BE SSLOk
converting regular socket connection to ssl
 FE=> StartupPacket(user=useronly, database=GIDS,
client_encoding=UNICODE, DateStyle=ISO)
SQLException: SQLState(08001) vendor code(451181827)
org.postgresql.util.PSQLException: The connection attempt failed
        at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:120)
        at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
        at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:106)
        at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:19)
        at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:15)
        at org.postgresql.Driver.connect(Driver.java:138)
        at
java.sql.DriverManager.getConnection(DriverManager.java:512)
        at
java.sql.DriverManager.getConnection(DriverManager.java:171)
        at GIDS.DB.DBPool.newConnection(DBPool.java:133)
        at GIDS.DB.DBPool.getConnection(DBPool.java:87)
        at GIDS.DB.DBaseManager.getConnection(DBaseManager.java:170)
        at GIDS.DB.Querier.<init>(Querier.java:57)
        at GIDS.LoginScreen.checkAdmin(LoginScreen.java:65)
        at GIDS.LoginScreen.<init>(LoginScreen.java:46)
        at GIDS.LoginScreen.main(LoginScreen.java:217)
Exception: org.postgresql.util.PSQLException: The connection attempt
failed
getConnection failed: org.postgresql.util.PSQLException: The
connection attempt failed

-----------------------------------------------------------------------------------------------------

I am connecting to the server from the same computer as where the
server is running. Just local... The log of the server gives this:

LOG:  could not initialize SSL connection: SSL error code 336306371

Any ideas on what I'm doing wrong? Or guides that can explain me what
exactly I have to do in order to get things working? 

Thanks in advance...

Responses

pgsql-jdbc by date

Next:From: Ian PilcherDate: 2004-07-26 16:42:23
Subject: Re: Problem w/ IDENT authentication
Previous:From: Ian PilcherDate: 2004-07-26 15:46:53
Subject: Re: Problem w/ IDENT authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group