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