topic Apache users can't login in Operating System - HP-UX

Apache users can't login

Doug_85 — Thu, 29 Apr 2004 15:49:56 GMT

We're running Apache web server on a L class server with HP-UX 11.0. Our users receive ORA-12154 error when they try to log in. Using sqlplus you can log into the database but not from any browser. The tnsnames.ora file seems to be configured properly. This problem just occurred yesterday afternoon and we're trying to find a quick solution.

Thanks,
Doug

Re: Apache users can't login

Steven E. Protter — Thu, 29 Apr 2004 16:16:06 GMT

This is most likely due to an incorrect tnsnames.ora and/or sqlnet.ora file on the client desk top.

What are the results from a tnsping query?

What if any change has happened to client or server configuration?

Has there been a change to the DNS records on the network? do the clients and servers use the same dns server. If not were records changed on the one the client uses?

SEP

Re: Apache users can't login

Doug_85 — Thu, 29 Apr 2004 16:39:13 GMT

The configuration to the client and server has not changed. Our DBA performed a tnsping and verified that we're connecting to the database. I will check with our networking section to verify any DNS changes.

Thanks,
Doug

Re: Apache users can't login

Doug_85 — Thu, 29 Apr 2004 16:53:51 GMT

I just checked with our networking section and no DNS changes have been made.

Thanks,
Doug

Re: Apache users can't login

Doug_85 — Thu, 29 Apr 2004 17:02:11 GMT

Here's the complete error that's received when the user tries to log in.

Error - There was an error with the database.
Please inform your DBA. The Error was: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach)
The SQL statement that produced the error is: Problem during login! CHECK ALL YOUR ENV VARIABLES!!! called in(CTDBOBJ)
Click the Back arrow above to go to the previous page!

Thanks,
Doug

Re: Apache users can't login

James A. Donovan — Thu, 29 Apr 2004 18:47:44 GMT

What is your version of Oracle? There are known issues with version 8.1.6 (fixed in 8.1.6.3 and higher)

Otherwise, make sure that the application environment is being set correctly prior to Apache starting. TNS_ADMIN and such like need to be set appropriately.

Re: Apache users can't login

Doug_85 — Fri, 30 Apr 2004 10:48:55 GMT

Our oracle environment has recently changed to 8.1.7. I've found some information that states we need to change the following settings:

SetEnv ORACLE_HOME /v920
SetEnv LD_LIBRARY_PATH /v920/lib
PerlPassEnv ORACLE_HOME
PerlPassEnv LD_LIBRARY_PATH

Where do you set these variables in the httpd.conf file?

Thanks,
Doug