From: | Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] User authentication blues |
Date: | 1998-07-30 19:13:01 |
Message-ID: | Pine.SUN.3.91.980730211124.7383A-100000@dutepp2.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 30 Jul 1998, Maarten Boekhold wrote:
> 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.
I've figured out that if I use authtype 'crypt' in pg_hba.conf I can
connect to a database. I don't have to specify 'authtype=crypt' in my
perl-script, 'authtype=passwd' works just fine. Only, I cannot use this
to connect from older clients (ie. a 6.2 system). Too bad.....
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 | Maria Eugenia Ruiz Milln | 1998-07-31 07:54:26 | new-member |
Previous Message | Maarten Boekhold | 1998-07-30 18:28:13 | Re: [GENERAL] User authentication blues |