Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This is the trace when connecting throug Apache:
8750 Apache::DBI PerlChildInitHandler
-> DBI->connect(dbi:DB2:DATABASE,USER, ****, HASH(0x20283528))
-> DBI->install_driver(DB2) for aix perl=5.008 pid=65638 ruid=211
euid=211
-> DBI->connect(DBI:DB2:DATABASE,USER, ****, HASH(0x20a1415c))
-> DBI->install_driver(DB2) for aix perl=5.008 pid=65638 ruid=211
euid=211
install_driver: DBD::DB2 version undef loaded from
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBD/DB2.pm
-> $DBI::errstr (&) FETCH from lasth=none
And this is the trace when i run it as a stand alone program:
8750 Apache::DBI PerlChildInitHandler
DBI 1.42-ithread default trace level set to Ox2/0 (in pid 58518)
-> DBI->connect(DBI:DB2:DATABASE, USER, ****)
-> DBI->install_driver(DB2) for aix perl=5.008 pid=58518 ruid=0 euid=0
install_driver: DBD::DB2 version 0.76 loaded from
/usr/opt/perl5/lib/site_perl/5.8.0/aix-thread-multi/DBD/DB2.pm
<- install_driver= DBI::dr=HASH(0x2016b5e8)
-> connect for DBD::DB2::dr (DBI::dr=HASH(0x2016b5e8)~0x20551850
'INFORMES' 'sige' **** HASH(0x20552af8)) thr#20019348
connect 'DATABASE', 'USER', 'pass' <- connect= DBI::db=HASH(0x205518d4)
at DBI.pm line 587
-> STORE for DBD::DB2::db (DBI::db=HASH(0x20552b28)~INNER 'PrintError'
1) thr#20019348
does someone has any idea on what's happening??
thanks.
Ricardo Guerra