http://www.perlmonks.org?node_id=467771


in reply to Issues with DBD::Oracle and an apache environment

Compare the environment when ran from the web to the environment when ran from the command line. Have your perl script print out the entire environment and look for differences.

You might find something like TNS_ADMIN is set in one, but not the other.

It sounds like you are already setting LD_LIBRARY_PATH, ORACLE_HOME, and ORACLE_SIDE -- but also make sure that your library files in the LD_LIBRARY_PATH have adequate permissions for the user who runs your Apache to access them.

Matt
  • Comment on Re: Issues with DBD::Oracle and an apache environment

Replies are listed 'Best First'.
Re^2: Issues with DBD::Oracle and an apache environment
by l2kashe (Deacon) on Jun 17, 2005 at 15:51 UTC

    It is amazing how humbling system administration can be.

    Matt, Thank You.
    I forgot under Linux the default permissions on home directories is 600 and long story short oracle is installed in a users dir.

    Problem solved

    use perl;
    Everyone should spend some time pounding nails with their forehead for a while before they graduate to complicated stuff like hammers. - Dominus

[reply]

In Section Seekers of Perl Wisdom