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
<[EMAIL PROTECTED]>
-------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, June 30, 2001 12:39 PM
To: [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@shorthostname" 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]