Problems with new DBD

On Thu, 19 Apr 2001, Glen Eustace wrote:

I have just upgraded to the new DBD, but am still using postgresql 7.0.3

I am now getting access errors. I have had to go back into the db and
GRANT ALL on <ALL> to PUBLIC as a work around.

Even though I have specified a userid and password on the DBI->connect,
Pg seems to be using the actual user.

NB: I didn't change any of my code, just upgraded to DBD 0.96, I have
since upgraded to DBI 1.15 but that hasn't helped.

There's a bug in Pg::DBD 0.96. Here's the patch:

*** DBD-Pg-0.96/Pg.pm-orig	Tue Apr 10 03:44:18 2001
--- DBD-Pg-0.96/Pg.pm	Sun Apr 15 10:26:16 2001
***************
*** 79,89 ****
          $Name =~ s/^.*dbname\s*=\s*//;
          $Name =~ s/\s*;.*$//;

! $user = "" unless defined($user);
! $auth = "" unless defined($auth);
!
! $user = $ENV{DBI_USER} unless $user eq "";
! $auth = $ENV{DBI_PASS} unless $auth eq "";

          my($dbh) = DBI::_new_dbh($drh, {
              'Name' => $Name,
--- 79,88 ----
          $Name =~ s/^.*dbname\s*=\s*//;
          $Name =~ s/\s*;.*$//;

! $user ||= $ENV{DBI_USER};
! $auth ||= $ENV{DBI_PASS};
! $user ||= "";
! $auth ||= "";

my($dbh) = DBI::_new_dbh($drh, {
'Name' => $Name,

http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
It's amazing how many people you could be friends with if only they'd
make the first approach.

Hi guys,

Which of these patch is "better"? I'd like to include this this on the
techdocs.postgresql.org website with a patch for it.

Just have to know which one to include.

Regards and best wishes,

Justin Clift

"Brett W. McCoy" wrote:

On Thu, 19 Apr 2001, Glen Eustace wrote:

I have just upgraded to the new DBD, but am still using postgresql 7.0.3

I am now getting access errors. I have had to go back into the db and
GRANT ALL on <ALL> to PUBLIC as a work around.

Even though I have specified a userid and password on the DBI->connect,
Pg seems to be using the actual user.

NB: I didn't change any of my code, just upgraded to DBD 0.96, I have
since upgraded to DBI 1.15 but that hasn't helped.

There's a bug in Pg::DBD 0.96. Here's the patch:

*** DBD-Pg-0.96/Pg.pm-orig      Tue Apr 10 03:44:18 2001
--- DBD-Pg-0.96/Pg.pm   Sun Apr 15 10:26:16 2001
***************
*** 79,89 ****
$Name =~ s/^.*dbname\s*=\s*//;
$Name =~ s/\s*;.*$//;

! $user = "" unless defined($user);
! $auth = "" unless defined($auth);
!
! $user = $ENV{DBI_USER} unless $user eq "";
! $auth = $ENV{DBI_PASS} unless $auth eq "";

my($dbh) = DBI::_new_dbh($drh, {
'Name' => $Name,
--- 79,88 ----
$Name =~ s/^.*dbname\s*=\s*//;
$Name =~ s/\s*;.*$//;

! $user ||= $ENV{DBI_USER};
! $auth ||= $ENV{DBI_PASS};
! $user ||= "";
! $auth ||= "";

my($dbh) = DBI::_new_dbh($drh, {
'Name' => $Name,

http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
It's amazing how many people you could be friends with if only they'd
make the first approach.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

On Thu, 19 Apr 2001, Justin Clift wrote:

Which of these patch is "better"? I'd like to include this this on the
techdocs.postgresql.org website with a patch for it.

Just have to know which one to include.

Actually, I think Jeff's has a minor fix to it, so use the one he posted.

-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
Sacred cows make great hamburgers.