jaybaker wrote:
> I'm having a very frustrating time trying to get a database connection from
> my mod_perl script using DBD::Informix.
>
> System:
> Redhat Enterprise Linux 4
> IBM Informix Dynamic Server Version 10.00.UC3
> Apache 2.0.52-28
> mod_perl-2.0.1
> DBI-1.40
> DBD-Informix-2005.2-1
>
>
> Stripped right down, my script now looks like this -
> use Data::Dumper;
> use DBD::Informix;
> my $dbh = DBI->connect("dbi:Informix:$database", "$username",
> "$password");
> print "Database connection = $dbh<br>";
> print "Error = $DBI::err, $DBI::errstr<br>";
>
> And the results I get from running it are -
> Database connection =
> Error = -25560, SQL: -25560: Environment variable INFORMIXSERVER must be
> set.
>
> If I run the same script from the command line (rather than through
> mod_perl) I get a database connection quite happily.
> I've tried setting all the environment variables in the httpd.conf file -
> SetEnv INFORMIXDIR /usr/informix
> SetEnv INFORMIXSERVER bktester
> SetEnv HOSTNAME bktester
> SetEnv ONCONFIG onconfig
> SetEnv INFORMIXC i386-glibc20-linux-gcc
> SetEnv DBCENTURY C
> which doesn't seem to change anything...PerlSetEnv or PerlPassEnv is probably what you are looking for. http://perl.apache.org/docs/2.0/user/config/config.html#C_PerlSetEnv_ http://perl.apache.org/docs/2.0/user/config/config.html#C_PerlPassEnv_ ------------------------------------------------------------------------ Philippe M. Chiasson GPG: F9BFE0C2480E7680 1AE53631CB32A107 88C3A5A5 http://gozer.ectoplasm.org/ m/gozer\@(apache|cpan|ectoplasm)\.org/
signature.asc
Description: OpenPGP digital signature
