Re: jdbc pg_hba.conf error

On Wed, 2007-05-30 at 13:00 -0400, gonzales@linuxlouis.net wrote:
> Did you grant access to your user?

If you mean grant access by an SQL GRANT, he hasn't got far enough to
check that.  The error specifically says "no pg_hba.conf entry".  As far
as I can see, his pg_hba.conf is OK.

>
> On Wed, 30 May 2007, Oliver Elphick wrote:
>
> > On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote:
> >> On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
> >>> Oliver,
> >>>
> >>> When I do a :
> >>>                    psql -p 5000 testing123
> >>> I can make a connection.  However, when I do a
> >>>
> >>>     psql -U brakesh -h 127.0.0.1 -d testing123
> >>>
> >>> I get the followign error:
> >>>
> >>> psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "brakesh",
> >>> database "testing123", SSL off
> >>
> >> Ofcourse, the first connection is a local connection, which you
> >> obviously have configured. The latter connects to localhost, which you
> >> havn't configured.
> >
> > His original message (which I snipped) said he had:
> >
> > # IPv4-style local connections:
> > host    all         all         127.0.0.1         255.255.255.255   trust
> > host    testing123  brakesh     127.0.0.1         255.255.255.255   trust
> >
> > So it seems to me he did have it configured.
> >
> > In fact the first host line should be used and the second one for user
> > brakesh is redundant, since it comes later in the file.  The only thing
> > I can see is that it might be related to SSL.
> >
> >
> >
>
--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html