Re: Login with blank password
| От | Tom Lane |
|---|---|
| Тема | Re: Login with blank password |
| Дата | |
| Msg-id | 16621.1102782761@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Login with blank password (rray@tcmail.mstc.state.ms.us) |
| Список | pgsql-admin |
rray@tcmail.mstc.state.ms.us writes:
> Is there a setting in postgresql.conf that will log the password that's used to login with?
No (deliberately so).
> If I add "host all user 172.17.32.0 255.255.255.0 password"
> to pg_hba.conf the user can login with a blank password.
> If I add "host all user 172.17.32.1 255.255.255.255 password"
> to pg_hba.conf the user must enter a correct password.
This sounds to me like you are failing to consider the effects of the
order of entries in pg_hba.conf --- ie, in the first case the connection
is being caught by a TRUST-mode entry (or at least, not a password-based
one ... could be IDENT as well). Don't forget to SIGHUP the postmaster
after editing pg_hba.conf, too.
regards, tom lane
В списке pgsql-admin по дате отправления: