Problems with authentication and some questions

From: Evelio Martinez <evelio(dot)martinez(at)testanet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems with authentication and some questions
Date: 2001-01-29 12:11:47
Message-ID: 3A755E02.4A5C4B1E@testanet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello!

I want to make a web interface to add users and modify password of
existing users.

If I use the authtype password with the file passwd it works ok.

host all x.w.y.z a.b.c.d
password passwd

where x.w.y.z and a.b.c.d are IP and NETMASK respectively.

1) BUT if I try authtype only with password it does not work
host all x.w.y.z a.b.c.d
password

As the manual says:

The client is asked for a password for the user. This is sent in clear
and compared against the password held in the pg_shadow table. If the
passwords match, the connection is allowed.
An optional password file may be specified after the password
keyword which is used to match the supplied password rather than the
pg_shadow table. See pg_passwd.

I have change the passwd with:

alter user usuario with password 'abcdefd';
I can see the changes in the pg_shadow table but if I try to psql -h
maquina -d basedatos -U evelio
I am not allowed to enter the database (psql: Password authentication
failed for user 'evelio')

2) This option does not work too.

host all x.w.y.z a.b.c.d
crypt

verify_password: couldn't open password file
'/var/lib/pgsql/data/passwd'
Password authentication failed for user 'evelio'

It is still looking for the passwd file. I have moved it.

Is this normal?

Thanks in advance

--
Evelio Martínez
Testanet. Dept. desarrollo software.
Av. Reino de Valencia, 15 - 5
46005 Valencia (Spain)
Tel: +34 96 395 90 00
Fax: +34 96 316 23 19

Browse pgsql-general by date

  From Date Subject
Next Message pblunat 2001-01-29 12:30:13 : Execute a string of command in sql'script
Previous Message Andy Corteen 2001-01-29 11:54:24 Fwd: Re: Timeouts on connections