回复: ident auth does not works as usual

[pan snowave <windxp@xxxxxxx>]

Hi

"Show your psql command that is failing."

[root@~ pg]# /usr/local/pgsql/bin/psql   -p5432 -d db1     -h127.0.0.1

psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL:  Ident authentication failed for user "root"

If the error is  Ident authentication failed for user "cce", i think the ident config file taked effect.

Reference information:

PG version 15.3

Thanks.

---

发件人: David G. Johnston <david.g.johnston@xxxxxxxxx>
发送时间: 2023年8月26日 14:43
收件人: pan snowave <windxp@xxxxxxx>
抄送: pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
主题: Re: ident auth does not works as usual

 

On Saturday, August 26, 2023, pan snowave <windxp@xxxxxxx> wrote:

Well  , describe as follows:

pg_pba.conf

host    all             root             127.0.0.1/32           ident    map=test

host    all             all             127.0.0.1/32            trust

pg_indent.conf

test   root    cce

and  login pg  via  root  user , it doesnt work

You are saying root os user can login as pg role cce but that line of the pg_hba.conf doesn’t permit cce to login.  In short, the mapping is useless.

David J.