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

• ORA-01017 ... but only when script is run as CGI by Angus McIntyre
• RE: ORA-01017 ... but only when script is run as CGI by Reidy, Ron
• RE: ORA-01017 ... but only when script is run as CGI by Angus McIntyre
• RE: ORA-01017 ... but only when script is run as CGI by Reidy, Ron
• RE: ORA-01017 ... but only when script is run as CGI by Angus McIntyre
• Re: ORA-01017 ... but only when script is run as CGI by Jeffrey Seger
• RE: ORA-01017 ... but only when script is run as CGI by Garrett, Philip
• RE: ORA-01017 ... but only when script is run as CGI by Angus McIntyre