DBD::DB2 connect cgi problem(maybe slightly OT)

shemp has asked for the wisdom of the Perl Monks concerning the following question:

UPDATE: Thanks Joost, it was actually a typo in the
$ENV{'DB2INSTANCE'} = '...';
Problem solved.

I am able to establish a DBD::DB2 (version 0.78) connection to a remote DB2 server through a command line script running as a normal user, but when i try to connect thru a CGI script (apache2, RedHat enterprise 3ES) running as nobody, i get the following error in the apache log.

DBI connect(...) failed: Total Environment allocation failure! Did you set up your DB2 client environment? at <scriptname line X>...

No clue whats happening. Anybody see anything like this?

note: I dont ever use DB2, i just need to get some data out of a vendor system, and then its back to MySQL land (where things make sense to me)

Comment on DBD::DB2 connect cgi problem(maybe slightly OT)

Replies are listed 'Best First'.
Re: DBD::DB2 connect cgi problem(maybe slightly OT) by Joost (Canon) on Apr 07, 2005 at 22:16 UTC
It looks like DBD::DB2 needs some environment variables that are set up for your normal user but not for user nobody. Look at the documentation. Alternatively print out %ENV for both users and try to spot the difference. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]