pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Dynamic IP authentication
3+ messages / 3 participants
[nested] [flat]

* Dynamic IP authentication
@ 2004-03-19 18:37 Richard Dockery <Richard.Dockery@unh.edu>
  2004-03-19 19:04 ` Re: Dynamic IP authentication Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
  0 siblings, 1 reply; 3+ messages in thread

From: Richard Dockery @ 2004-03-19 18:37 UTC (permalink / raw)
  To: pgsql-admin

Does anyone know a way of authenticating client applications with dynamic IP
addresses?  All our client machines are receiving dynamic IP addresses.  Is
there a way to set up the pg_hba file to allow for this, or is there another
way to configure connections so as not to use this file?
Any thoughts would be appreciated.
Thank you!

Richard Dockery
Facilities Information Technology Group
University Of New Hampshire
richard.dockery@unh.edu
603.862.1803




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

* Re: Dynamic IP authentication
  2004-03-19 18:37 Dynamic IP authentication Richard Dockery <Richard.Dockery@unh.edu>
@ 2004-03-19 19:04 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
  2004-03-19 20:14   ` Re: Dynamic IP authentication Mitch Pirtle <mitchy@spacemonkeylabs.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Sam Barnett-Cormack @ 2004-03-19 19:04 UTC (permalink / raw)
  To: Richard Dockery <Richard.Dockery@unh.edu>; +Cc: pgsql-admin

On Fri, 19 Mar 2004, Richard Dockery wrote:

> Does anyone know a way of authenticating client applications with dynamic IP
> addresses?  All our client machines are receiving dynamic IP addresses.  Is
> there a way to set up the pg_hba file to allow for this, or is there another
> way to configure connections so as not to use this file?
> Any thoughts would be appreciated.
> Thank you!

Open access to the whole IP range, but require passwords. I think you
can wrap in SSL as well.

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University



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

* Re: Dynamic IP authentication
  2004-03-19 18:37 Dynamic IP authentication Richard Dockery <Richard.Dockery@unh.edu>
  2004-03-19 19:04 ` Re: Dynamic IP authentication Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
@ 2004-03-19 20:14   ` Mitch Pirtle <mitchy@spacemonkeylabs.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Mitch Pirtle @ 2004-03-19 20:14 UTC (permalink / raw)
  To: pgsql-admin

Sam Barnett-Cormack wrote:

 > On Fri, 19 Mar 2004, Richard Dockery wrote:
 >
 >
 >> Does anyone know a way of authenticating client applications with 
dynamic IP
 >> addresses?  All our client machines are receiving dynamic IP 
addresses.  Is
 >> there a way to set up the pg_hba file to allow for this, or is there 
another
 >> way to configure connections so as not to use this file?
 >> Any thoughts would be appreciated.
 >> Thank you!
 >
 >
 >
 > Open access to the whole IP range, but require passwords. I think you
 > can wrap in SSL as well.
 >

This is what I do, and now I won't let non-SSL connections through.  The 
pg_hba.conf entry that lets me connect over SSL from anywhere looks like 
this:

     hostssl  all  mitchy  0.0.0.0   0.0.0.0   password

Of course you need to configure your database box with an SSL key, which 
is well documented.

-- Mitch



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


end of thread, other threads:[~2004-03-19 20:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-19 18:37 Dynamic IP authentication Richard Dockery <Richard.Dockery@unh.edu>
2004-03-19 19:04 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-03-19 20:14   ` Mitch Pirtle <mitchy@spacemonkeylabs.com>

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