pg_hba.conf not right

From: Phillip Smith <phillips(at)fukawi2(dot)homelinux(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_hba.conf not right
Date: 2007-09-25 12:39:22
Message-ID: Pine.LNX.4.64.0709252233520.22889@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)fukawi2(dot)homelinux(dot)net

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rajaram J 2007-09-25 13:09:00 Re: Messages on my console.
Previous Message Phillip Smith 2007-09-25 11:54:50 Re: Messages on my console.