Thread: DBD::Pg installation difficulty during make test
I am attempting to install DBD::Pg version 1.13, and I'm using postgresql 7.2.2, Perl 5.8.0, on a Mandrake 9.0 release. The first two steps of the installation went smoothly (i.e. perl Makefile.PL, and make), but when I try to make test I get many failures of the DBI->connect(...) method, specifically: "DBI->connect(dbase=MYDBASE) failed: FATAL 1: IDENT authentication failed for user "MYUSER"." I have the configuration file set up NOT to use IDENT authentication: local all trust host all 127.0.0.1 255.255.255.255 trust and I know that MYDBASE and MYUSER are valid because I can access the database manually (i.e. psql MYDBASE MYUSER) without a problem (although, if while within MYDBASE, I try to use the \connect command to access another database as another user, this fails). Looking in the logfile, I just see the FATAL 1 error message, with little to no additional information. Could someone offer some suggestions to help me figure out why DBI->connect(...) isn't working? Oh, and I'm a super newbie, so please talk down to me. :-) Don
"Donald Tucker" <dtucker@arlut.utexas.edu> writes: > "DBI->connect(dbase=MYDBASE) failed: FATAL 1: IDENT authentication failed > for user "MYUSER"." > I have the configuration file set up NOT to use IDENT authentication: > local all trust > host all 127.0.0.1 255.255.255.255 trust Sure looks like it thinks it should be using IDENT. Perhaps you used to have IDENT lines in pg_hba.conf? If so, I'll bet you forgot to SIGHUP the postmaster after changing the config file. (See "pg_ctl reload" for a convenient way to do this.) The only other possibilities I can see are that DBD is trying to talk to some other postmaster, or that you're editing the wrong config file. regards, tom lane
You are 100% correct. The line forcing IDENT authentication was uncommented (and unseen) in the configuration file. I commented it out and everything worked well. Thanks! Don Tom Lane <tgl@sss.pgh.pa.us> To: "Donald Tucker" <dtucker@arlut.utexas.edu> Sent by: cc: pgsql-novice@postgresql.org pgsql-novice-owner@pos Subject: Re: [NOVICE] DBD::Pg installation difficulty during make tgresql.org test 03/21/2003 06:19 PM "Donald Tucker" <dtucker@arlut.utexas.edu> writes: > "DBI->connect(dbase=MYDBASE) failed: FATAL 1: IDENT authentication failed > for user "MYUSER"." > I have the configuration file set up NOT to use IDENT authentication: > local all trust > host all 127.0.0.1 255.255.255.255 trust Sure looks like it thinks it should be using IDENT. Perhaps you used to have IDENT lines in pg_hba.conf? If so, I'll bet you forgot to SIGHUP the postmaster after changing the config file. (See "pg_ctl reload" for a convenient way to do this.) The only other possibilities I can see are that DBD is trying to talk to some other postmaster, or that you're editing the wrong config file. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html