pg_hba.conf not right
От | Phillip Smith |
---|---|
Тема | pg_hba.conf not right |
Дата | |
Msg-id | Pine.LNX.4.64.0709252233520.22889@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: pg_hba.conf not right
|
Список | pgsql-novice |
Hi all, Not sure what I've done (an automatic yum update I suspect!) but my Drupal site recently died. Traced the problem back to this error in PostgreSQL: ESTLOG: connection received: host=::1 port=37822 ESTFATAL: no pg_hba.conf entry for host "::1", user "drupal", database "drupal", SSL off This PostgreSQL server purely exists these days to run Drupal, and I haven't touched the config since I set it up - I suspect a yum update changed something to do with the way Apache or PHP talks to PG. I compiled PG from source so yum hasn't touched PG. Here's my pg_hba.conf: [root@poweredge2400 data]# cat pg_hba.conf # PostgreSQL Client Authentication Configuration File # =================================================== # # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust host all all 127.0.0.1/32 trust host all all 192.168.1.0/24 md5 host all all 172.20.0.0/18 md5 I've managed to get my site running again by telling it to connect to PG via the 192.168.0.0/24 interface instead of 'localhost' If I su to 'apache' and run 'psql drupal drupal' it connects fine. What's been buggered up? Cheers, ~p -- Phillip Smith phillips@fukawi2.homelinux.net
В списке pgsql-novice по дате отправления: