On Feb 9, 5:02 pm, joseph.ko...@gmail.com (Joseph Koral) wrote: > However I came across this thread because I'm getting the same error > when I attempt to connect while running under mod_perl. The same code > (simple test connection) runs fine from a standalone perl script, but > I get "ORA-24327: need explicit attach before authenticating a user > (DBD ERROR: OCISessionBegin)" when attempting to connect while running > under mod_perl.
Replying to myself in case others run into this problem, I found the solution. That error message is really a simple "can not connect" error (same error if you shutdown the listener). If using tnsnames.ora (I was), under mod_perl I had to explicitly add the environment variables to the mod_perl startup.pl script where I preload the modules (even though they were already set in shell). Alternatively, I would also expect to be able to set them in the httpd.conf using PerlSetEnv, but I had tried that earlier to no avail.
