Re: Bug #1665: Can't logon and execute SQL statements on an identified database instance !

Hi Mark, I've tried this before sending my bug report. This answer is provided at the PHP site but it seems that only works when you execute it in a shell, not via a web browser (at least this is what is happening to me). Thanks anyway ! Regards, Wagner wsb@dc.ufscar.br Mark Britton wrote: > Try this: > <?php > putenv("ORACLE_SID=orcl"); > /* or whatever your ORACLE_SID is */ > putenv("ORACLE_HOME=/u01/app/oracle/product/8.0.5"); /* or whatever your > ORACLE_HOME is */ > > $conn = ocilogon("user","user_pass","ORACLE_SID"); > > $stmt = ociparse($conn, "delete from testeoci"); > ociexecute($stmt); > ocilogoff($conn); > > ?> > If this works, then you probably need to get the Oracle environment set up > correctly for the user that apache runs under...I set it up so that all > users get the Oracle environment variables set at login. > > Mark Britton > mbritton@verinet.com > > ----- Original Message ----- > From: <wsb@dc.ufscar.br> > To: <php-dev@lists.php.net> > Sent: Monday, July 05, 1999 2:20 PM > Subject: [PHP-DEV] Bug #1665: Can't logon and execute SQL statements on an > identified database instance ! > > > From: wsb@dc.ufscar.br > > Operating system: Linux RedHat 5.2 and 6.0 > > PHP version: 3.0.11 > > PHP Bug Type: Oracle related > > Bug description: Can't logon and execute SQL statements on an identified > database instance ! > > > > > > Hi Folks, > > > > I made two simple php3 files just to delete all data in a table called > "testeoci" in an Oracle 8.0.5 database instance. Both work fine when i call > them using the shell prompt but neither work when i call it via a Web > Browser ! My Web Server is an Apache 1.3.6 and my PHP version is 3.0.11. > Apache is running as "apache" user and i run the files on the same account > as apache user ). I can't figure out what could be wrong since all the > variables are correctly set. Maybe it is really a bug ! > > > > The files code are listed bellow : > > > > file://Test file #1 > > > > <?php > > > > $conn = ocilogon("user","user_pass","ORACLE_SID"); > > > > $stmt = ociparse($conn, "delete from testeoci"); > > ociexecute($stmt); > > ocilogoff($conn); > > > > ?> > > > > > > file://Test file #2 > > > > <?php > > > > $conn = ora_logon("user@ORACLE_SID", "user_pass"); > > $cursor = ora_open($conn); > > ora_parse($cursor, "delete from testeoci"); > > ora_exec($cursor); > > ora_logoff($conn); > > > > ?> > > > > Notes : 1 - Everything seems okay with oracle 'cause i can connect with > the related database using the sqlplus program. So, the files 'tnsnames.ora' > and 'listener.ora' are ok ! > > 2 - I have a web site running php3 scripts which connects > successfully with an Oracle database, but they use the regular logon > statement (which works fine !) : $conn = ora_logon("user@hostname", > "user_pass"); > > 3 - I've tested it over RedHat 5.2 and 6.0 producing the same > results ! > > > > > > > > -- > > PHP Development Mailing List <http://www.php.net/> > > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > > For additional commands, e-mail: php-dev-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net