Hi Folks
OS: Debian.
I just used aptitude to install Postgres V 8.3.3, and recompiled DBD::Pg
V 2.10.3.
>From the command line I can connect to Postgres, but via a CGI script or
mod_perl handler I'm getting:
<==><8==>
[Tue Sep 16 10:23:24 2008] [notice] Apache/2.2.9 (Unix) mod_ssl/2.2.9
OpenSSL/0.9.8g mod_apreq2-20051231/2.6.0 mod_perl/2.0.4 Perl/v5.10.0
configured -- resuming normal operations
DBI connect('dbname=contacts','ron',...) failed: FATAL: Ident
authentication failed for user "ron"
at /home/ron/perl.modules/Local-Contacts/lib/Local/Contacts/App/Database.pm
line 184
[Dispatch] ERROR: Can't connect to data source '' because I can't work
out what driver to use (it doesn't seem to contain a 'dbi:driver:'
prefix and the DBI_DRIVER env var is not set)
at /usr/local/share/perl/5.10.0/Log/Dispatch/DBI.pm line 31
<==><8==>
Note the DSN has lost the prefix 'dbi:Pg:', so the error msg is correct.
If the mod_perl code uses warn "<$dsn>" I get:
<dbi:Pg:dbname=contacts, ron, ...>
as expected.
If I deliberately corrupt the command line script to use:
my($dbh) = DBI -> connect('dbname=contacts', 'ron', '...');
I get the same error msg:
[EMAIL PROTECTED]:~$ perl -I/home/ron/perl.modules/Local-Contacts/lib
~/scripts/Postgres/test.pg.pl
Can't connect to data source 'dbname=contacts' because I can't work out
what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix
and the DBI_DRIVER env var is not set)
at /home/ron/scripts/Postgres/test.pg.pl line 17
Help!?
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
