----- Original Message -----
From: "Stephen M. Ford" <[EMAIL PROTECTED]>
To: "Sterin, Ilya" <[EMAIL PROTECTED]>
Subject: RE: :Pg again
> I changed the $dbh line to
>
> my $dbh =
DBI->connect("dbi:Pg:dbname=tracker;host=bullwinkle.eng.auburn.edu;port=5432
;","","");
>
> and added a dbh->trace(4) and got the following output. It appears to
fail around the connect with DBI.pm.
Sorry for my original reply...I realize your original message was just a
cut-and-paste error.
There is 1 obvious problem with the above usage: the blank username. Even
though you added the following line:
host all xxx.xxx.xxx.xxx 255.255.255.255 trust
the username the user connects as must still be in pg_shadow. (the above
line means all users in pg_shadow are trusted, not any user at all is
trusted) Now, because the username is blank, it will just connect with
whatever username you ran the script as. If that username isn't set up as a
valid postgres username, then it won't connect. Username postgres is always
set up, so you may as well use that.
However, that's not your problem (at least, not your only problem) because
if that were the case, it would give you a straightfoward error message
like, "username xxx not in pg_shadow."
What I want you to do is, from the same machine you are trying to use the
DBI from, type the following:
psql -h bullwinkle.eng.auburn.edu -p 5432 -U postgres tracker
and tell us what the result is.
-Mike
