Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

RE: [PHP-DB] problems connecting to remote oracle database From: Brian S. Dunworth (brian <email protected>)
Date: 07/02/01

Hi Phil,

   Make sure that the web user (usually 'nobody' on an Apache installation)
has access to the $ORA_HOME/bin directory and permissions to execute the
binaries within. Also, be sure that ORA_HOME and ORACLE_SID are set in the
'nobody' user environment...

 - Brian

 -------------------------------------
   Brian S. Dunworth
   Sr. Software Development Engineer
   Oracle Database Administrator
   The Printing House, Ltd.

   (850) 875-1500 x225
   <brian <email protected>>
 -------------------------------------

-----Original Message-----
From: phil <email protected> [SMTP:phil <email protected>]
Sent: Saturday, June 30, 2001 12:39 PM
To: php-db <email protected>
Subject: [PHP-DB] problems connecting to remote oracle database

Hi folks,

I'm having difficulties getting php4 to connect to a remote oracle
database.

I have an entry in tnsnames.ora, along the lines of

shorthostname = (etc, etc)

and I can use "sqlplus user/name <email protected>" to connect just fine, as
a regular user. Even without ORACLE_SID set, since I have it set in
tnsnames.ora for that entry

But when I try
 ocilogin("user","name","shorthostname");

on a php page, I get a printout of oracle error 01017: authentication
failed.
The listener log on that oracle machine confirms that I am actually
attempting to connect. But no details on what's going wrong.

Any suggestions? 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>