Re: jdbc pg_hba.conf error - Mailing list pgsql-general

Did you ever "createuser brakesh" ???

Apologies about the he,she ;)... he + s = she, see you're greater of a
person than a 'he.'  Heehee.


On Wed, 30 May 2007, Bhavana.Rakesh wrote:

> Yes, I have been restarting the postgres every time I make changes to the
> pg_hba.conf file.
>
> -Bhavana
> On a lighter note, it's a 'she' not 'he'.  :)  No offense taken. :))
>
> gonzales@linuxlouis.net wrote:
>> As super-user (postgres) you have to create the user in Postgres, then
>> Grant access.  In other words, if the pg_hba.conf file specifies a user who
>> does not exist, "user brakesh does not exist" will cause a failure to
>> connect as well.
>>
>> Every connection to a database, has to have a user associated with the
>> session.
>>
>> So the fact that he has connected to at least one database, means he's
>> gotten far enough to connect and create the proper ID/Authentication.
>>
>> Actually, I wonder if 'after' he's changed the pg_hba.conf file if he's
>> been restarting the postgres process?  Which is 'session' associated.
>>
>> Everytime you change the pg_hba.conf file, you have to restart postgres,
>> don't you?
>>
>>
>>
>> On Wed, 30 May 2007, Oliver Elphick wrote:
>>
>>> 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.
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net