What happens if you try to connect to that same DB instance using SQL*plus? Does your CGI have use the same tnsnames.ora file as the command line user?
-- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Angus McIntyre [mailto:[EMAIL PROTECTED] Sent: Friday, August 18, 2006 10:39 AM To: [email protected] Subject: ORA-01017 ... but only when script is run as CGI I'm using current versions of DBI and DBD::Oracle in a CGI script, Oracle 10.2 client talking to an Oracle 9 database, RedHat Linux. The script previously ran successfully on a similar machine with the Oracle 9 client. I have a simple test script, in which the username, password and SID are hardcoded. If I run this script from the command line, it connects without problems. If I call the script as a CGI script, I get ORA-01017 in OCISessionBegin, which is the bad username or password error. As far as I can tell, environment variables are the same in both contexts, the same tnsnames.ora file is used, and so forth. I have identified and resolved permissions errors, so I think that isn't the problem. Has anyone encountered something similar, or does anyone have any suggestions for other things that I should check in order to resolve this? Thanks, Angus 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.
