pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
can not connect to pg on linux FC4 2+ messages / 2 participants [nested] [flat]
* can not connect to pg on linux FC4 @ 2005-11-05 05:12 Tai Huynh Phuoc <fucai1116@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: Tai Huynh Phuoc @ 2005-11-05 05:12 UTC (permalink / raw) To: pgsql-sql Hi, I use pg 8.03 (come with FC4). I can not connect to pg because of Ident authentication failed for user "root" error. pg_hba.conf host all all 127.0.0.1/32 ident sameuser Then I try another way by add adding a row to pg_indet so that I can use root account to connection to db. mymap root root and chage "sameuser" to "mymap" in the pg_hba.conf. But I can not connect too as the above error. Thank in advande someone help me. Onother question. Is there a way that I can create a user using password authetication at the situation I have no pg account like this sitation?. Thanks. Fucai __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: can not connect to pg on linux FC4 @ 2005-11-08 21:26 Oliver Elphick <olly@lfix.co.uk> parent: Tai Huynh Phuoc <fucai1116@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Oliver Elphick @ 2005-11-08 21:26 UTC (permalink / raw) To: Tai Huynh Phuoc <fucai1116@yahoo.com>; +Cc: pgsql-sql On Fri, 2005-11-04 at 21:12 -0800, Tai Huynh Phuoc wrote: > Hi, > I use pg 8.03 (come with FC4). I can not connect to pg > because of Ident authentication failed for user "root" > error. pg_hba.conf > host all all 127.0.0.1/32 ident sameuser > > Then I try another way by add adding a row to pg_indet > so that I can use root account to connection to db. > mymap root root > and chage "sameuser" to "mymap" in the pg_hba.conf. > But I can not connect too as the above error. > > Thank in advande someone help me. If you are going to use ident authentication on a TCP/IP connection (even localhost) you need an ident server running on the client machine. That is what supplies the authentication. You need to trust the administrator of the client machine, otherwise this can be very insecure. Since you are connecting to the local machine, you could just as easily use a Unix socket connection (do not supply any hostname) in which case ident authentication will use the ownership credentials associated with the socket. In pg_hba.conf, this is a "local" connection and is secure on Linux. > Onother question. Is there a way that I can create a > user using password authetication at the situation I > have no pg account like this sitation?. Assign a password for the user with ALTER USER. Then add a suitable line to pg_hba.conf. Oliver Elphick ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-08 21:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-11-05 05:12 can not connect to pg on linux FC4 Tai Huynh Phuoc <fucai1116@yahoo.com> 2005-11-08 21:26 ` Oliver Elphick <olly@lfix.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox