[PHP-DB] Oracle/PHP Instant-Client ( remote connection )
Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using phpmySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next to me but separate ) Oracle server... I found on otn.oracle.com a thing called 'instantclient' - a couple of .rpm's to install what is supposed to be a kinda plug-and-play Linux Oracle client.. However, I can't seem to be able to compile PHP with Oracle support, because I don't think instantclient has the required header files to compile PHP/OCI8 .. Is that right? The other solution I thought might be to use instantclient itself.. .. It comes with a couple of .so's, so I've tried DynamicallyLoading them at the top of a php page.. It seems to be loading the one I give it (libociei.so) but then complains that it can't find libclntsh.so.10.1 which I have, and is sitting right next to libociei.so .. ( The error is : Warning: dl(): Unable to load dynamic library '/usr/local/lib/php/extensions/libociei.so' - libclntsh.so.10.1: cannot open shared object file: No such file or directory in /path/to/info.php on line 2 .. And /usr/local/lib/php/extensions/libclntsh.so.10.1 does exist ) Thought that maybe I've just got a path problem..?? Anyway - is the 'ONLY' solution to getting PHP to connect remotely to an Oracle server to download 1.5Gb's of Oracle CD's? Has anyone had any experience getting instantclient/php to work? Is there any way I can get the headers I need to compile --with-oci8 without the 1.5Gb download?? Am I missing something blatantly obvious? Any advice/points-in-the-right-direction would be much appreciated, Thanks, Jimbo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP Instant-Client ( remote connection )
Comments below. Jim Morrison wrote: Hello all, Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc - not sure I can find the answer.. I've been using phpmySql for a while now and getting on great - however I'm now tasked with getting my php to talk to a _remote_ ( right next to me but separate ) Oracle server... I found on otn.oracle.com a thing called 'instantclient' - a couple of .rpm's to install what is supposed to be a kinda plug-and-play Linux Oracle client.. However, I can't seem to be able to compile PHP with Oracle support, because I don't think instantclient has the required header files to compile PHP/OCI8 .. Is that right? The other solution I thought might be to use instantclient itself.. .. It comes with a couple of .so's, so I've tried DynamicallyLoading them at the top of a php page.. It seems to be loading the one I give it (libociei.so) but then complains that it can't find libclntsh.so.10.1 which I have, and is sitting right next to libociei.so .. ( The error is : Warning: dl(): Unable to load dynamic library '/usr/local/lib/php/extensions/libociei.so' - libclntsh.so.10.1: cannot open shared object file: No such file or directory in /path/to/info.php on line 2 .. And /usr/local/lib/php/extensions/libclntsh.so.10.1 does exist ) Thought that maybe I've just got a path problem..?? Anyway - is the 'ONLY' solution to getting PHP to connect remotely to an Oracle server to download 1.5Gb's of Oracle CD's? Has anyone had any experience getting instantclient/php to work? Is there any way I can get the headers I need to compile --with-oci8 without the 1.5Gb download?? The download of the traditional Client Release is under 400M. Am I missing something blatantly obvious? Any advice/points-in-the-right-direction would be much appreciated, Thanks, Jimbo What exactly have you configured? Do you have LD_LIBRARY_PATH set? I'm using Instant Client with PHP on Linux and a pre-release Instant Client on Windows. I'm starting to put together some notes for http://otn.oracle.com/tech/opensource/index.html Instant Client doesn't yet come with headers for compiling (the statement I've read is that an SDK is under investigation). To get the headers I chose the Administrator install option in the Oracle Database 10g Client Release 1 (10.1.0.2) for Linux x86 release. I compiled PHP with this first. I then reran the same installer and chose the Instant Client option. This installed into non-system directories (unlike the Instant Client RPM from OTN). I configured PHP to use Instant Client by setting LD_LIBRARY_PATH to the new library directory, and unsetting ORACLE_HOME before starting Apache. For PHP you only need libociei.so, libnnz10.so and libclnts.so.10.1 from the Instant Client package. If re-compiling won't be needed, you can copy these libs to a directory of your choice and deinstall Oracle to save disk space. On Windows you can drop Instant Client straight onto the prebuilt PHP binaries. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle + PHP
Hello I have Oracle 9 + RedHat 7 + PHP 4.3.4 + Apache 1.3.29. I've compiled apache and php I've compiled PHP using the documentation and activating OCI. I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables case $1 in start) /opt/apache/bin/apachectl startssl ;; stop) /opt/apache/bin/apachectl stop ;; esac But the problem is the next: When I login as root (on a console or an xterm) and run that script (/etc/init.d/apache start) everything works fine. So I've created a link from /etc/rc5.d/S99apache to /etc/init.d/apache for starting it during boot process.. But when I reboot the system and apache is started on boot (oracle is launche thru S20oracle), it start. If you request a php page or other kind of webpage it works fine, until you request a php page that connects to oracle Then the instance that is serving that request dies, raise an error that says something like Couldn't connect to database and no more php+oracle pages can be requested... But php and apache still works. If I stop apache and launch it again from console using /etc/init.d/apache start It works again and works fine, all connections are successfull. User apache belongs to oinstall group and have read and execution access to all the oracle directories. Where can be the problem Why it works if I launch it from a console or xterm and not if the system starts it??? Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle + PHP
Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables Are the environment variables exported in the script?: ORACLE_HOME=/my/oracle/home export ORACLE_HOME Are all variables needed set? Are there any permission problems accessing the Oracle home directory during the boot process? Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle + PHP
Yes they are... I tried to put them into the httpd.conf file, like: SetEnv ORACLE_HOME /usr/oracle and so The problem still remains. Too, I've put all the environment variables in the root env into the script I thought it can be a problem with a missed variable But it doesn't work neither. root user's environment was the same that the one defined into the script, and it doesn't work neither. I don't know what more tests to do I check the permissions too They appear to be right. I'm completely lost Christopher Jones wrote: Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables Are the environment variables exported in the script?: ORACLE_HOME=/my/oracle/home export ORACLE_HOME Are all variables needed set? Are there any permission problems accessing the Oracle home directory during the boot process? Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle + PHP
Perhaps something that isn't obvious is missing. If you post more detail (e.g. the exact script and the exact permissions) someone might be able to help you. Chris Luis Moran Ochoa wrote: Yes they are... I tried to put them into the httpd.conf file, like: SetEnv ORACLE_HOME /usr/oracle and so The problem still remains. Too, I've put all the environment variables in the root env into the script I thought it can be a problem with a missed variable But it doesn't work neither. root user's environment was the same that the one defined into the script, and it doesn't work neither. I don't know what more tests to do I check the permissions too They appear to be right. I'm completely lost Christopher Jones wrote: Luis Moran Ochoa wrote: I've build the typical script for starting apache, it's like this: $ORACLE_HOME=blablahblah... more oracle variables Are the environment variables exported in the script?: ORACLE_HOME=/my/oracle/home export ORACLE_HOME Are all variables needed set? Are there any permission problems accessing the Oracle home directory during the boot process? Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle/PHP Issue
Hello, I am having a strange issue with Oracle and PHP. I am running PHP Version 4.3.4 on Red Hat AS 2.3 and trying to connect to Oracle 9i also on Red Hat AS 2.3. I compiled PHP successfully with OCI and oracle. My script uses the ocilogon($user, $password, $db); or ora_logon($user.'@'.$db, $password); depending on what interface I want to use in my abstraction layer. Note: All oracle failures (*** some error ***) are when I use the ora_logon, ocilogon, or the ocinlogon. Info about what works: - PHP can at lease partially talk to the remote Oracle DB. - If I give a bad username or password, PHP returns *** Oracle: Connection Failed: ORA-01017: invalid username/password; logon denied.*** So I know PHP is able to validate the username against the remote Oracle database. - If I give an unspecified TNS name, BDB1_broken, instead of BDB1 which is in the tnsnames.ora file, I get the following Oracle message though PHP: *** Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name ***. So I know that the TNS name is being verified against the remote database. - When I try to logon to the remote DB with SQLPlus using the same tnsnames.ora file used by PHP, I can logon just fine. Also, a plsql stored procedure running off a DAD on the server works. THE PROBLEM: When I use the correct username, password and ORACLE_SID, I get the following error: *** Oracle: Connection Failed: ORA-12545: Connect failed because target host or object does not exist *** I have: - Tried specifying the DB connection in the PHP code $DATABASE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = BDB1.world) ) ); - Tried using the IP address 192.168.2.2 and the host name both in the PHP and the tnsnames file. - Added apache and nobody to the oracle and the dbs groups. - Setting different environment vars in the PHP code putenv(ORACLE_HOME=/opt/ora9/product/9201); putenv(ORACLE_SID=BDB1) - Recompiling PHP - Using BDB1 and BDB1.PROD_DATABASE.MY_DOMAIN.COM in the putenv and the database name in the connection function. - Checked the Apache config ##ORACLE ENVIRONMENT ORACLE_HOME=/opt/ora9/product/9201 ORACLE_BASE=/opt/ora9/ export ORACLE_HOME ORACLE_BASE ORACLE_TERM=vt100 LD_LIBRARY_PATH=$ORACLE_HOME/lib PATH=$ORACLE_HOME/bin:$PATH export PATH LD_LIBRARY_PATH ORACLE_DOC=$ORACLE_BASE/doc ORACLE_SID=BDB1 TNS_ADMIN=/opt/ora9/product/9201/network/admin export ORACLE_DOC ORACLE_SID TNS_ADMIN Does anyone have any thoughts Thanks for any help, Paul ___ Paul Miller System-Wise pmillerATsystemDASHwiseDOTcom AT = @ DASH = - DOT = .
[PHP-DB] Oracle + PHP + Linux Red Hat {again}
Please, any idea to resolve my problem!!! I have the output: Connected to DataBase Oracle! Warning: OCIStmtExecute: ORA-03106: fatal two-task communication protocol error in /var/www/html/ora2.php on line 21 Warning: OCIFetchStatement: ORA-24374: define not done before fetch or execute and fetch in /var/www/html/ora2.php on line 22 Found: 0 results I'm running redhat 7.3 with oracle 9i client connecting to oracle 8.0.5 Server on NT. I put the putEnv to $ORACLE_HOME,$ORACLE_SID,I use OCIDefineByName, but the result is the error. When I'm using the oci functions I can't receive the error above, but if I use the old oracle functions of php, the results are good. Do someone have any idea to resolve my problem?? Thanks in advance. P.D. I probe to set up the User=oracle and Group dba in apache web server, but either, it's not working. The source code: ?php PutEnv(ORACLE_SID=upbback); PutEnv(ORACLE_HOME=/opt/oracle/product/9.2.0); $db_conn = ocilogon(generador,sinok,upbback); if (!$db_conn) { echo Connection failed; echo Error Message: [ . OCIError($db_conn) . ]; exit; } else { echo Connected to DataBase Oracle!; } $cmdstr = select cod_aula,nombre from aulas; $parsed = ociparse($db_conn, $cmdstr); OCIDefineByName($parsed,COD_AULA,$codaula); OCIDefineByName($parsed,NOMBRE,$nombre); OCIExecute($parsed); $nrows = ocifetchstatement($parsed, $results); echo Found: $nrows results\n; echo table border=1 cellspacing='0' width='50%' align=center\n; echo tr\n; echo tdbCodigo/b/td\n; echo tdbNombre/b/td\n; echo /tr\n; for ($i = 0; $i $nrows; $i++ ) { echo tr\n; echo td . $codaula. /td; echo td . $nombre. /td; echo /tr\n; } echo /table\n; OCIFreeStatement($parsed); OCILogoff($db_conn); ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle/PHP question...
Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP question...
Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP question...
Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP question...
AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: xxx [EMAIL PROTECTED] To: Anthony Carlos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re: [PHP-DB] Oracle/PHP question... Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
Correct. I am working on Unix, specifically HP-UX 11.00. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:38 AM To: xxx ; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: xxx [EMAIL PROTECTED] To: Anthony Carlos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re: [PHP-DB] Oracle/PHP question... Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP question...
As Anthony Carlos said - compile your php with oracle and oci support. Then you will have all the functions from the modules. The next thing to do after the compile (and web server restart). You said that you configured the SID and the HOME so that's fine. Just compile new binary Regards, Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; xxx [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:37 PM Subject: RE: [PHP-DB] Oracle/PHP question... Correct. I am working on Unix, specifically HP-UX 11.00. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:38 AM To: xxx ; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: xxx [EMAIL PROTECTED] To: Anthony Carlos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re: [PHP-DB] Oracle/PHP question... Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle/PHP question...
Compile with --with-oci8 Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:56 PM Subject: RE: [PHP-DB] Oracle/PHP question... I am running Oracle 8.0.6.3. Do I need both --with-oracle and --with-oci8? I was under the impression that I only needed the option --with-oci8. Thanks. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:46 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... As Anthony Carlos said - compile your php with oracle and oci support. Then you will have all the functions from the modules. The next thing to do after the compile (and web server restart). You said that you configured the SID and the HOME so that's fine. Just compile new binary Regards, Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; xxx [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:37 PM Subject: RE: [PHP-DB] Oracle/PHP question... Correct. I am working on Unix, specifically HP-UX 11.00. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:38 AM To: xxx ; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle/PHP question... AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: xxx [EMAIL PROTECTED] To: Anthony Carlos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re: [PHP-DB] Oracle/PHP question... Hy, in php.ini you have to uncomment the ;extension=php_oci8.dll ;extension=php_oracle.dll ; is a comment and restart the server cybercop78 On Tue, 17 Dec 2002 08:29:36 -0500, Anthony Carlos wrote Yes, you need to recompile PHP: ./configure --with-oci8=[your_oracle_home] -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php http://www.idilis.ro - Stiri, e-mail gratuit, download, SMS, server de counter-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle/PHP question...
I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks? :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
:-) ... Windows is the best at running the C# .NET applications I have to build to :make everyone happy that we are industry standard ... when big brother is not :looking I use PHP for everything I can get away with. I'm actually very impressed :with how easily PHP integrates into an IIS / MSSQL environment (in CGI mode that is) :... it has been quite stable and believe it or not upgrades don't require a reboot!!! :I have even called the php parser directly from sql server dts packages agent :jobs... PHP is much more powerful then anything m$ offers. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks? :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
BTW... I'm not the one stuck trying to figure out how to recompile my current version of PHP to include the oci functions... haha! And guess what, with every release you get to do it all over again... so polish up on the shell scripting unless you want to reinvent the wheel every month or two. :-D Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday, December 16, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... :-) ... Windows is the best at running the C# .NET applications I have to build to :make everyone happy that we are industry standard ... when big brother is not :looking I use PHP for everything I can get away with. I'm actually very impressed :with how easily PHP integrates into an IIS / MSSQL environment (in CGI mode that is) :... it has been quite stable and believe it or not upgrades don't require a reboot!!! :I have even called the php parser directly from sql server dts packages agent :jobs... PHP is much more powerful then anything m$ offers. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks? :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Oracle/PHP question...
Figuring how shouldn't be too tough. Compiling software for the most part is a breeze. My concern was whether I needed to recompile or not. I am now trying that, and hopefully this will address the problem for me. As to the recompiling with every release, that is no big deal either as the recompile is all of 4 entries on the command line. Putting this together in a shell script is simplicity in itself, and requires no polishing up even though most of my system scripting I do in Perl. It is nice to see though that you are not trying to tell me how Win-blows is better than Unix. Sure Windows is nice in that virtually everything is simple enough for a 3rd grader to do stuff on it, but I like to think I have a little more intelligence than your average 3rd grader. Oh well, I don't want this to degenerate any further so we can agree to disagree about platforms or you can admit to possibly being a closet Unix fan. :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:19 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... BTW... I'm not the one stuck trying to figure out how to recompile my current version of PHP to include the oci functions... haha! And guess what, with every release you get to do it all over again... so polish up on the shell scripting unless you want to reinvent the wheel every month or two. :-D Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday, December 16, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... :-) ... Windows is the best at running the C# .NET applications I have to build to make everyone happy that we are industry standard ... when big brother is not looking I use PHP for everything I can get away with. I'm actually very impressed with how easily PHP integrates into an IIS / MSSQL environment (in CGI mode that is) ... it has been quite stable and believe it or not upgrades don't require a reboot!!! I have even called the php parser directly from sql server dts packages agent jobs... PHP is much more powerful then anything m$ offers. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my web server is HP-UX. Didn't anyone ever tell you Win-blows sucks? :) -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on the system, and I have also setup the ORACLE_HOME and ORACLE_SID environment variables. Unfortunately at this point I am not even able to make a successful connection to the Oracle database. I am currently receiving the following error: Fatal error: Call to undefined function: ocilogon() in /www/DW/oratest.php on line 10 Do I need to recompile PHP to be Oracle aware or something? What is it I am missing at this point? Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] oracle php abstraction layer
On Saturday 06 April 2002 19:34, Pedro M.S. Oliveira wrote: Hi all ;) usually i just use mysql with php, but this time i will need to access an oracle database, knowing oracle is not a problem, but i'm searching for a DB abstraction layer that is tested and working. as i never used this before, just mysql_query () type things or ora type querys for instance, i would appreciate your advice on this matter, so i don't have to write a 2 versions program. You can try ADODB which is a pretty comprehensive DB abstraction layer supporting most popular DBs. http://php.weblogs.com/ADODB Or look in: http://www.phpclasses.com -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* A Smith Wesson beats four aces. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle-PHP (contd.)
Are you sure you need an environment variable to store that? if yes, this script should do the trick : putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); --- $tns = getenv(TNS_ADMIN); echo $tns; Regards, Philippe Vandana [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] With reference to my previous problem in connecting to the oracle database, I found out some additional information. I defined the TNS_ADMIN variable in the startup file and added this line to my php-script: putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); and when I tried to echo this variable echo($TNS_ADMIN); The value is not being printed, it is not defined.When I tried the same thing at the command prompt the value was defined.What is the reason that the value of TNS_ADMIN is not being available to the php-script. -- 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]
[PHP-DB] Oracle-PHP (contd.)
With reference to my previous problem in connecting to the oracle database, I found out some additional information. I defined the TNS_ADMIN variable in the startup file and added this line to my php-script: putenv(TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin); and when I tried to echo this variable echo($TNS_ADMIN); The value is not being printed, it is not defined.When I tried the same thing at the command prompt the value was defined.What is the reason that the value of TNS_ADMIN is not being available to the php-script. -- 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-DB] Oracle-PHP
I've just installed php4.0.4 , apache-1.3.14 and oracle8.1.6 on my RedHat 7.0 machine.I am trying to write a php script to connect to my oracle database.But I am facing problems.When I used the oci8 functions as follows: ?php putenv(ORACLE_SID=sid); putenv(ORACLE_HOME=/ora1/app/oracle/product/8.1.6); line 11 if($conn=OCILogon(scott,tiger)) { echo(Successful:Connected\n); } else { echo(Connection failed\n); } ? the error message was: Warning:OCISessionBegin: ORA-01034: ORACLE not available in /www/servers/index.php on line 11 Connection failed - And when I wrote the script with ordinary oracle function, replacing the OCILogon with a call to Ora_Logon, the error was as following: Fatal error: Maximum execution time of 30 seconds exceeded in /www/servers/index.php on line 11 --- Could somebody please help me with this problem? And also, is there any good tutorial for PHP/Oracle ? -- 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-DB] Oracle - PHP
Hi: I have PHP with mySQL compiled in. We are about to attempt to connect to Oracle. Of course we have to rebuild PHP with the added Oracle support, but I was just wondering if anyone has done this and if so, could you offer any noteworthies or comments about using PHP with Oracle. Thanks! - Jeremy D. Hise Consulting Direct, Inc. (212)736-5870 x228 -- 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]