pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Initial request packet for SSL
2+ messages / 2 participants
[nested] [flat]

* Initial request packet for SSL
@ 2006-03-26 15:58  Donald Fraser <postgres@kiwi-fraser.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Donald Fraser @ 2006-03-26 15:58 UTC (permalink / raw)
  To: pgsql-admin

Hello,
I'm not sure whether this is the correct place to post this question, but I will try here first.

According to the documentation, to connect to the back-end using SSL a special start-up packet (SSLRequest) is required before the front-end can begin with the SSL hand-shake.

My question is, can this initial request be avoided in any way - is it possible to start with the SSL handshake without the request?

The reason I'm asking is that I've been asked to write some software that will establish a secure connection through a HTTPS proxy server to a PostgreSQL database. My research shows that to tunnel through a proxy requires first the connection to the proxy server and then the SSL hand-shake. Many HTTPS proxy servers will not allow any data to be transmitted before the SSL hand-shake, which in the case for PostgreSQL is going to cause problems if I'm required to send the SSLRequest packet first.

Any thoughts would be appreciated,
regards
Donald Fraser. 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Initial request packet for SSL
@ 2006-03-26 16:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Donald Fraser <postgres@kiwi-fraser.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-03-26 16:25 UTC (permalink / raw)
  To: Donald Fraser <postgres@kiwi-fraser.net>; +Cc: pgsql-admin

"Donald Fraser" <postgres@kiwi-fraser.net> writes:
> My question is, can this initial request be avoided in any way - is it =
> possible to start with the SSL handshake without the request?

No, sorry.  You might consider tunneling to an ssh proxy port that is
redirected to 5432 locally on the database server.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-03-26 16:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-26 15:58 Initial request packet for SSL Donald Fraser <postgres@kiwi-fraser.net>
2006-03-26 16:25 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox