RE: [PHP-GENERAL] PHP3+Apache+Oracle setup - FIXED

It looks like httpd just needed to be run with: User oracle Group dba However, does this cause any problems or pose any security risks? med vänlig hälsning /Dana -----Original Message----- From: thies@digicol.de [SMTP:thies@digicol.de] Sent: Friday, June 23, 2000 1:59 PM To: Reed, Dana Cc: php-general@lists.php.net Subject: Re: [PHP-GENERAL] PHP3+Apache+Oracle setup - almost working On Fri, Jun 23, 2000 at 01:54:33PM +0000, Dana.Reed@clinicaldatacare.com wrote: > It's finally time to move everything from the development environment to production > (php3+Xitami on W95 + Postgres on RH6.2 --> php3+Apache1.3 on RH6.2 + Oracle7.3) > > PHP and Apache on the webserver work fine, and using Oracle's SQLPlus we can access the > Oracle machine from the webserver > > However, using $conn = OCILogon("name","pass","SID") I'm > getting the error > Warning: oci8_open_server: Error while trying to retrieve text for error ORA-12154 > > And using $conn = ora_logon("name@SID","pass"); I'm getting the error > Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-12154) > > > My best guess is a priveleges/owner/group problem=2E My Oracle knowledge is quite limited, so > does anyone know of some very specific resources for getting info for a setup such as this? Any > help greatly appreciated! > > med vänlig hälsning thies@godzilla<85>oerr ORA 12154 12154, 00000, "TNS:could not resolve service name" // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. you should do: $c = ocilogon("u","p","dbname_as_found_in_tnsnames.ora"); > /Dana > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany