DBD::Oracle causes core dumps

[Steve Steel]

Hi

look at

http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/2002-03/msg00087.html


Steve Steel

[Markus Bonet]

Hi, Steve!

Thanks for answering, but I don't see the point.
When I run perl under root, everything is fine.

When run under www-user, I get a 'permission denied'.
But permissions are given.


Markus

[Steve Steel · Accepted solution]

Hi


From

http://archive.develooper.com/dbi-users@perl.org/msg10427.html
I thought something was terrible hozed... because when I was logged in as
root, I had no problems running anything...

Turns out the DBAs just change permissions on their oracle directory...
problem solved.



Steve steel

[Markus Bonet]

Well,

thanks to everybody who helped me.
Now I am very, very close to solve all of those tricky issues.

'Oracle.sl' couldn't be loaded because user 'www' was permissioned to all needed libs. One was missing in Oracle->libs. 'ldd' gave me that advice.

Some other stuff needed permissions, now it works - even under user 'www' :-))

But one problem won't resolve so far.
It isn't directly a database-problem, but you might help me as well.

Wenn my test-script is run by Apache, the Oracle Environment Variables are missing.
So I set them in my script by:

BEGIN {
$ENV{ORACLE_HOME}='';
...
}

Use DBI;
...

But Apache's error-log keeps on telling me, the ORACLE_HOME var isn't set, OCI can't be initialized etc.

Any final idea by you?
I promise - if I find the solution - this will be my last question concerning this Perl/Oracle/Apache thing ;-))


Many thanks, Markus