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

* forcing SSL
@ 2004-02-14 19:13  Eric <hehe88hk@yahoo.com.hk>
  0 siblings, 1 reply; 2+ messages in thread

From: hehe88hk@yahoo.com.hk @ 2004-02-14 19:13 UTC (permalink / raw)
  To: pgsql-admin

In order to ensure all user are making SSL connection to the database,
in the file pg_hba.conf, I change all the first columns into "hostssl"
such that there is neither "host" nor "local" left.

However, when I try to use a program written in Tcl to access the
database, even without the option "requiressl=1" for "pg_connect", the
program can still make connection to the database.

(With the option "requiressl=1" present for "pg_connect", my program
can also connect the database successfully)

May I know what the problem is and how to ensure incoming SSL
connection?

Thank you



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

* Re: forcing SSL
@ 2004-02-15 05:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Eric <hehe88hk@yahoo.com.hk>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-02-15 05:26 UTC (permalink / raw)
  To: hehe88hk@yahoo.com.hk; +Cc: pgsql-admin

hehe88hk@yahoo.com.hk (Eric) writes:
> In order to ensure all user are making SSL connection to the database,
> in the file pg_hba.conf, I change all the first columns into "hostssl"
> such that there is neither "host" nor "local" left.

> However, when I try to use a program written in Tcl to access the
> database, even without the option "requiressl=1" for "pg_connect", the
> program can still make connection to the database.

Is this a local-Unix-socket connection?  We don't bother with SSL on
such connections.  There's no point --- the only way to eavesdrop on
a local connection is to have broken into your kernel, at which point
it's game over anyway.

			regards, tom lane

PS: it also occurs to me you might have forgotten to SIGHUP the
postmaster after editing pg_hba.conf...



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


end of thread, other threads:[~2004-02-15 05:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-14 19:13 forcing SSL Eric <hehe88hk@yahoo.com.hk>
2004-02-15 05:26 ` 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