From: | Flip Mulder <fmulder(at)xs4all(dot)nl> |
---|---|
To: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | SSL Connection Issue |
Date: | 2004-07-28 12:50:17 |
Message-ID: | 6.1.2.0.0.20040728144938.01d2e418@pop.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
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:
---------------------------------------------------------------------------------------------------------
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 (with
log_error_verbosity=verbose):
------------------------------------------------------
C:\Documents and Settings\postgresql>postmaster
LOG: could not recognize system timezone, defaulting to "Etc/GMT-1"
HINT: You can specify the correct timezone in postgresql.conf.
LOG: could not load root certificate file
"C:/postgres/data/root.crt": No such
file or directory
DETAIL: Will not verify client certificates.
LOG: database system was shut down at 2004-07-28 12:21:47 W. Europe
Standard Ti
me
LOG: checkpoint record is at 0/C853918
LOG: redo record is at 0/C853918; undo record is at 0/0; shutdown
TRUE
LOG: next transaction ID: 1233553; next OID: 423208
LOG: database system is ready
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...
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-07-28 12:52:41 | Re: win32 pgsql not installable |
Previous Message | Andrew Dunstan | 2004-07-28 12:36:51 | Re: win32 pgsql not installable |