| From: | Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | User authentication blues |
| Date: | 1998-07-30 09:46:34 |
| Message-ID: | Pine.SUN.3.91.980730114208.26535C-100000@dutepp0.et.tudelft.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a 6.3.2 server, and I want to use password authentication.
So, I gave the user 'postgres' and some other user a password, and I put this
in my pg_hba.conf:
host all 127.0.0.1 255.255.255.255 password
host all 206.31.72.11 255.255.255.255 password
But I cannot connect this way using a password (psql -u). I can connect
if I set everything to 'trust', but in that case I can even fool
posttresql in thinking I'm user postgres while I'm logged on as the other
user by using password authentication and using 'postgres' as username
while supplying a fake password.
Am I doing something wrong here?
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Orlandi | 1998-07-30 15:46:53 | Strange behaviour ? |
| Previous Message | Vadim Mikheev | 1998-07-30 06:03:36 | btree bug found & fixed |