Обсуждение: 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.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
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. >
> -----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.
> -----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.