I'm trying to use DBD::Pg module to connect to a PostgreSQL database, but it keeps giving me an Ident error.
DBI connect('database=Repairs;host=localhost;port=5432','',...) failed: FATAL: Ident authentication failed for user "vendion" at TickItAdmin.pl line 73This is what I am passing to the module as my connect statement.
From my understanding from the documentation of the module passing '' as the username and password it will use the active user's username. I do have a ROLE setup for the username I am using and I know it works,my $dsn = "DBI:Pg:database=Repairs;host=localhost;port=5432"; my $dbh = DBI->connect( $dsn, '', '', { AutoCommit => 0, RaiseError +=> 1 } ) || croak "Couldn't authenticate to the Database: $OS_ERROR";
Has anyone here run into this before or have an idea of where to look?vendion@linux-9rf6:~> psql Repairs psql (8.4.5) Type "help" for help. Repairs=>
In reply to Trouble Connecting to PostgreSQL with DBD::Pg by vendion
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |