From: Mark Stosberg <mark@summersault.com>
To: Brett W. McCoy <bmccoy@chapelperilous.net>
Cc: pgsql-interfaces@postgresql.org
Cc: dbi-users@perl.org
Subject: Re: DBD::Pg 0.96 and DBI 1.15 ignoring username and password
Date: Sun, 15 Apr 2001 20:46:15 -0500
Message-ID: <3ADA4EE7.2324BE3B@summersault.com> (raw)
References: <Pine.LNX.4.30.0104142018080.12687-100000@chapelperilous.net>
Brett,
I believe this due to a bug in DBD::Pg .96. See the recent thread on
the dbi-users list entitled:
"bug in DBD::Pg .96-- connect user mishandled?"
A patch is in the works, and a workaround seems to be to use
$ENV{DBI_USER} and $ENV{DBI_PASS} to set the username and password,
which seem to be respected appropriately.
-mark
"Brett W. McCoy" wrote:
>
> I've just upgraded to DBD::Pg 0.96 and DBI 1.15, and now every script I
> have that uses DBI gives me this error:
>
> 1.15 at ./dbi-test line 6
> Use of uninitialized value in subroutine entry at
> /usr/local/lib/perl5/site_perl/5.6.0/i586-linux/DBD/Pg.pm line 94.
> Use of uninitialized value in subroutine entry at
> /usr/local/lib/perl5/site_perl/5.6.0/i586-linux/DBD/Pg.pm line 94.
> DBI->connect(dbname=cp) failed: fe_sendauth: no password supplied at
> ./dbi-test line 8
>
> The test.pl script used in the DBD 'make test' also failed with this
> error. I have not changed anything in my PostgreSQL (7.1beta3) setup or
> in my scripts.
>
> I have password authentication set for local users, and do have $PGHOST
> set accordingly. Logging into psql works fine, but all of my Perl DBI
> scripts are failing.
>
> Here is a test program that is causing this error (the real user name and
> password are changed):
>
> #!/usr/local/bin/perl -w
>
> use strict;
> use DBI;
>
> warn $DBI::VERSION;
>
> my $dbh = DBI->connect('DBI:Pg:dbname=cp', 'user', 'passwd') or DBI-errstr;
>
> $dbh->disconnect();
>
> This gives the error output above also.
>
> If I change pg_hba.conf to 'trust' on localhost, (and unset $PGHOST) and I
> run the same script, it tells me that 'bmccoy' (who I am logged in as)
> does not exist as a user (which is true). It looks like the user and
> password fields are being completely ignored by DBD::Pg.
>
> What happened?
>
> -- Brett
> http://www.chapelperilous.net/btfwk/
> ------------------------------------------------------------------------
> Adapt. Enjoy. Survive.
--
http://mark.stosberg.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mark@summersault.com, bmccoy@chapelperilous.net, dbi-users@perl.org
Subject: Re: DBD::Pg 0.96 and DBI 1.15 ignoring username and password
In-Reply-To: <3ADA4EE7.2324BE3B@summersault.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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