Обсуждение: Problems with authentication and some questions

Поиск
Список
Период
Сортировка

Problems with authentication and some questions

От
Evelio Martinez
Дата:
 
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