The file command is not listing permissions, nor size. What is the output of 'ls -l /opt/perl5_64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBD/Oracle'?
What happens if you run the test script from the command line as the user who starts Apache? ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Wales, Stephen (RTSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 10:37 AM To: dbi-users@perl.org Subject: DBD::Oracle 1.46 can't find library I had been happily plodding along on oracletool 2.0 for that last 2 years (a perl cgi script that interrogates Oracle databases), when I discovered that there was a new version. So I downloaded and installed that and found that it didn't work, that something that had been added, ora_session_modes in DBD::Oracle required version 1.13 or greater of DBD::Oracle (I had 1.12). After spending a day and a half working out how to get DBD::Oracle 1.16, DBI 1.46 and Perl 5.8.5 compiled up for HP-UX 11.11 and Oracle 9.2.0.5, I was ready to give it a try. When I try to invoke oracletool now (either 2.2 or the saved version 2.0), I'm getting the following perl error: Can't load '/opt/perl5_64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBD/Oracle/Oracl e.sl' for module DBD::Oracle: No such file or directory at /opt/perl5_64/lib/5.8.5/PA-RISC2.0-LP64/DynaLoader.pm line 230. at oracletool.pl line 24 Compilation failed in require at oracletool.pl line 24. BEGIN failed--compilation aborted at oracletool.pl line 24. [Tue Feb 01 16:35:21 2005] [error] [client 148.175.62.147] Premature end of script headers: oracletool.pl Now, I've checked the permissions on /opt/perl5_64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBD/Oracle/Oracle .sl and it appears to be globally readable: root[2929] rtsihp7 /opt/hpapache2/logs# su - www [snip HP Copyright info at login] $ file /opt/perl5_64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBD/Oracle/Oracle .sl /opt/perl5_64/lib/site_perl/5.8.5/PA-RISC2.0-LP64/auto/DBD/Oracle/Oracle .sl: ELF-64 shared object file - PA-RISC 2.0 (LP64) $ Oracletool also comes with a basic test script that connects to the database and runs "select sysdate from dual" and reports it. This is giving me the same error. Unfortunately I don't know a whole lot about perl or Apache. As another test, I tried to run the example.cgi script mentioned in the above paragraph from the command line, and it's reporting the same message, so I guess that rules out apache. Anyone have ideas as to why this can't load? Thanks Steve Stephen Wales Senior Database Administrator Rio Tinto Services Inc. Phone: 801-252-3623 Fax: 801-252-3522 Mobile: 801-699-1774 E-mail: [EMAIL PROTECTED] "Delivering Superior Service" This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
