ident authentication over tcp
От | Peter Koczan |
---|---|
Тема | ident authentication over tcp |
Дата | |
Msg-id | 4544e0330912090925h2cd7d182h7604244948b582c5@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ident authentication over tcp
|
Список | pgsql-admin |
Hi all, I'm having some trouble configuring ident authentication for TCP connections. I can get it to work fine for local connections, but I can't Local connection: $ psql postgres ... postgres=> Server Log: Dec 9 11:06:59 mitchell postgres[27482]: [4-1] LOG: connection received: host=[local] Dec 9 11:06:59 mitchell postgres[27482]: [5-1] LOG: connection authorized: user=koczan database=postgres Dec 9 11:07:03 mitchell postgres[27482]: [6-1] LOG: disconnection: session time: 0:00:04.370 user=koczan database=postgres host=[local] Remote connection to localhost: $ psql -h localhost postgres psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "koczan", database "postgres", SSL off Server log: Dec 9 11:07:06 mitchell postgres[27494]: [4-1] LOG: connection received: host=localhost port=41434 Dec 9 11:07:06 mitchell postgres[27494]: [5-1] LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused Dec 9 11:07:06 mitchell postgres[27494]: [6-1] FATAL: Ident authentication failed for user "koczan" Dec 9 11:07:06 mitchell postgres[27495]: [4-1] LOG: connection received: host=localhost port=41435 Dec 9 11:07:06 mitchell postgres[27495]: [5-1] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "koczan", database "postgres", SSL off My pg_hba.conf file looks like this: # TYPE DATABASE USER CIDR-ADDRESS METHOD local all koczan ident sameuser hostssl all koczan 127.0.0.1/32 ident sameuser I'm running Red Hat Enterprise 5.4, and I can't find any place where an ident server is actually running on this host. How is it working for local connections, and what might I be able to do to get it to work for localhost TCP connections. Thanks, Peter
В списке pgsql-admin по дате отправления: