Thread: connection problems due to authentication

connection problems due to authentication

From
"Leonardo Junquera"
Date:
Now I am getting this error:

An error has occured in pgAdmin II: frmConnect.cmdConnect_Click:

Number: -2147217843
Description: Password authentication failed for user 'leoj'




I am a user in the database and have set the password to the one I am using when trying to connect.  I looked in the
pg_hba.conffile and saw a reference to the pg_password(1) utility.  I'm not sure what it is but I'm guessing I need to
addthe password someplace else. 

Sorry for the novice questions.  Thanks for your help.

Leo

Re: connection problems due to authentication

From
"Leonardo Junquera"
Date:
Sorry.

host  sbm   192.168.0.2  255.255.255.255   password   leoj

---------- Original Message ----------------------------------
From: Dave Page <dpage@vale-housing.co.uk>
Date: Wed, 30 Jan 2002 15:30:54 -0000

>
>
>> -----Original Message-----
>> From: Leonardo Junquera [mailto:leo@junquera.com]
>> Sent: 30 January 2002 14:12
>> To: pgadmin-support@postgresql.org
>> Subject: [pgadmin-support] connection problems due to authentication
>>
>>
>> Now I am getting this error:
>>
>> An error has occured in pgAdmin II: frmConnect.cmdConnect_Click:
>>
>> Number: -2147217843
>> Description: Password authentication failed for user 'leoj'
>>
>>
>>
>>
>> I am a user in the database and have set the password to the
>> one I am using when trying to connect.  I looked in the
>> pg_hba.conf file and saw a reference to the pg_password(1)
>> utility.  I'm not sure what it is but I'm guessing I need to
>> add the password someplace else.
>>
>> Sorry for the novice questions.  Thanks for your help.
>
>Can you post the relevant lines of your pg_hba.conf to the list please?
>
>Regards, Dave.
>

Re: connection problems due to authentication

From
Dave Page
Date:

> -----Original Message-----
> From: Leonardo Junquera [mailto:leo@junquera.com]
> Sent: 30 January 2002 14:12
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] connection problems due to authentication
>
>
> Now I am getting this error:
>
> An error has occured in pgAdmin II: frmConnect.cmdConnect_Click:
>
> Number: -2147217843
> Description: Password authentication failed for user 'leoj'
>
>
>
>
> I am a user in the database and have set the password to the
> one I am using when trying to connect.  I looked in the
> pg_hba.conf file and saw a reference to the pg_password(1)
> utility.  I'm not sure what it is but I'm guessing I need to
> add the password someplace else.
>
> Sorry for the novice questions.  Thanks for your help.

Can you post the relevant lines of your pg_hba.conf to the list please?

Regards, Dave.

Re: connection problems due to authentication

From
Dave Page
Date:

> -----Original Message-----
> From: Leonardo Junquera [mailto:leo@junquera.com]
> Sent: 30 January 2002 15:30
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] connection problems due to
> authentication
>
>
> Sorry.
>
> host  sbm   192.168.0.2  255.255.255.255   password   leoj

Try losing the 'leoj' from the end of the line. If I remember correctly,
anything after 'password' is taken to be an external password file. Without
it, PostgreSQL should use it's internal pg_shadow table.

Regards, Dave.