I'm using DBI and DBD::Pg. When I try and connect to the database, I get
DBI->connect(dbname=tracker) failed: 1 at ./tracker2.pl line 15. Can someone tell me
where the 1 is defined so I can see what it means?
On the postgres database, I've add the following line to the pg_hba.conf
host all xxx.xxx.xxx.xxx 255.255.255.255 trust
where the x's are the actual ip address of the server I am trying to connect from.
That should allow anyone one from that ip to connect to any database, right?
And I am using $dbh = DBI->connect("dbi:Pg:dbname=tracker",
"dbi:Pg:host=host.our.domain.name"); in my perl script.
I can telnet to port 5432 and communicate with postgres with errors going to standard
out but nothing showing up in the logs so I know the database is taking connections at
least.
Thanks for the help and sorry for such a basic question.
Stephen