RE: [PHP-DB] problems connecting to remote oracle database

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@theprintinghouse.com> ------------------------------------- -----Original Message----- From: phil@bolthole.com [SMTP:phil@bolthole.com] Sent: Saturday, June 30, 2001 12:39 PM To: php-db@lists.php.net 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net