Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: moon19990716

Message # 1025115:
Date: 04/05/05 11:27
By: Banzai
Subject: RE: Problem in connecting Oracle with PHP

You have to compile Apache with PHP and Oracle extensions. Here is a quick reference i created when I was setting up mine, ignore the lines that do not apply and remove references to the packages you ignored from apache compilation command line.
Apache 2 - PHP 5- Oracle 10g - SSL on AS 3:
Download source for every package.
SSL:
config --prefix=/usr/local/openssl
make
make test
make install
ln -s /usr/local/openssl/bin/openssl /usr/local/bin/openssl
use the same openssl binary to create keys and certifcates for Apache SSL.
Apache:
configure --prefix= /usr/local/apache --enable-rewrite --enable-ssl --with-ssl =/usr/local/openssl --enable-so
make
make install
Use openssl command line tool to generate ssl keys and certificates.
openssl genrsa -des3 -out ca.key 1024
openssl req -new -x509 -days 10000 -key ca.key -out ca.crt
openssl genrsa -des3 -out server.key 1024
backup and encode key so apache will not ask for password on each reboot
mv server.key server.key.secure
openssl req -new -days 10000 -key server.key -out server.csr
sign.sh server.csr
mkdir ssl.crt ssl.key
cp server.crt ssl.crt
cp server.key ssl.key
HTTPD='/usr/local/apache/bin/httpd -DSSL'

Oracle:
Requires Oracle 10g client package installation. During install chose custom to select required libraries for PHP support (assumes remote Oracle server)
Independent Products:
Oracle Home: oracle10g_webservers_client
Sun JDK extensions 9.0.4.0.0
Sun JDK 1.4.2.0.0
Java Runtime Environment 1.4.2.0.0
SSL Required Support Files for InstantClient 10.1.0.2.0
Oracle10g Real Application Clusters Common Files 10.1.0.2.0
JDBC Common Files 10.1.0.2.0
Oracle JDBC Thin Driver for JDK 1.2 10.1.0.2.0
Oracle Display Fonts 9.0.2.0.0
Bali Share 1.1.18.0.0
Oracle JFC Extended Windowing Toolkit 4.2.18.0.0
Documentation Required Support Files 10.1.0.2.0
SQL*Plus Required Support Files 10.1.0.2.0
Oracle Net Required Support Files 10.1.0.2.0
DBJAVA Required Support Files 10.1.0.2.0
regexp 2.1.9.0.0
Oracle Extended Windowing Toolkit 3.4.28.0.0
Oracle JDBC Thin Driver for JDK 1.4 for Instant Client 10.1.0.2.0
JDBC/OCI Common Files for Instant Client 10.1.0.2.0
Oracle Ice Browser 5.2.3.3.0
Oracle Help For Java 4.2.5.0.0a
XDK Required Support Files 10.1.0.2.0
RDBMS Required Support Files 10.1.0.2.0
Oracle Client Required Support Files 10.1.0.2.0
Agent Required Support Files 10.1.0.2.0
Precompiler Required Support Files 10.1.0.2.0
Parser Generator Required Support Files 10.1.0.2.0
PL/SQL Required Support Files 10.1.0.2.0
LDAP Required Support Files 10.1.0.2.0
SSL Required Support Files 10.1.0.2.0
Oracle Locale Builder 10.1.0.2.0
JDBC/OCI Common Files 10.1.0.2.0
Platform Required Support Files 10.1.0.2.0
Oracle JDBC Thin Driver for JDK 1.4 10.1.0.2.0
Oracle JDBC/OCI Driver for JDK 1.4 10.1.0.2.0
Oracle JDBC/OCI Interfaces 10.1.0.2.0
Oracle Core Required Support Files 10.1.0.2.0
Oracle Globalization Support 10.1.0.2.0
Required Support Files 10.1.0.2.0
Oracle Code Editor 1.2.1.0.0I
SQL*Plus 10.1.0.2.0
Enterprise Manager Minimal Integration 10.1.0.2.0 Beta
Oracle UIX 2.1.21.0.0a
Enterprise Manager plugin Common Files 10.1.0.2.0 Beta
Installation Common Files 10.1.0.2.0
Extended Windowing Toolkit 3.3.18.0.0 Beta
Assistant Common Files 10.1.0.2.0
Oracle Net Configuration Assistant 10.1.0.2.0
Oracle Net Manager 10.1.0.2.0
Oracle Net 10.1.0.2.0
Oracle Network Utilities 10.1.0.2.0
Installer SDK Component 10.1.0.2.0
Oracle RAC Required Support Files 10.1.0.2.0
Oracle RAC Required Support Files-HAS 10.1.0.2.0
Oracle One-Off Patch Installer 10.1.0.2.0
Oracle C++ Call Interface for Instant Client 10.1.0.2.0
Precompiler Common Files 10.1.0.2.0
Advanced Queueing (AQ) API 10.1.0.2.0
CSS Single-instance Common Files 10.1.0.2.0
Object Type Translator 10.1.0.2.0
Oracle C++ Call Interface 10.1.0.2.0
*Oracle Call Interface (OCI) 10.1.0.2.0
*Oracle Call Interfaces 10.1.0.2.0
Utilities Common Files 10.1.0.2.0
Character Set Migration Utility 10.1.0.2.0
Recovery Manager 10.1.0.2.0
SQL*Loader 10.1.0.2.0
Export/Import 10.1.0.2.0
Oracle Database Utilities 10.1.0.2.0
Oracle Client 10.1.0.2.0
PHP:
configure --with-apache=/usr/local/apache --with-oci8=/oraclient/product/10.1.0/client_1 --with-mysql --with-apxs2=/usr/local/apache/bin/apxs --enable-sigchild

Previous Message | Next Message


Comments:
PHP4.1.1 and Apache2 soen't workmoneer02/09/06 14:26
PHP4 Apache Email (again)ChaosZen01/14/06 11:41
Phph - i want to learnLucian08/08/05 03:29
upload code for php filesMike06/30/05 07:44
RE: Problem in connecting Oracle with PHPBanzai04/05/05 11:27
RE: PHP w/ IIS : Help is here!Anup03/22/05 02:03
begginercijo12/13/04 00:40
RE: File Upload problem w/ Apache Win32cbaucom01/28/03 14:10
RE: Apache 2 & PHP4 - can't setupthebainer01/21/03 21:55
PHP EditorSokrates01/20/03 13:14
RE: Apache 2 & PHP4 - can't setupJim01/02/03 12:02
RE: Apache 2 & PHP4 - can't setupDan12/09/02 12:27
RE: Apache 2 & PHP4 - can't setupDejo4u10/23/02 15:52
Need the installer of Apache and Php4 for WinHasnain Kapadia10/16/02 03:12
myPHPsession not runing in IISiyuss10/10/02 22:00
RE: can't transmit variables via get or postslowman09/23/02 20:23
Apache 1.3.26 and php3Kalva08/21/02 14:32
File upload errorsAndy Christianson08/15/02 16:23
RE: File Upload problem w/ Apache Win32Kevin08/08/02 10:43
RE: can't transmit variables via get or postvic08/05/02 09:04
RE: Apache 2 & PHP4 - can't setupRPB07/10/02 11:51
Apache 2 and PHP4 AddModule LineRayed Mon07/01/02 23:48
RE: Apache 2 & PHP4 - can't setupJoe06/13/02 12:24
PHP4/Apache/Windows98seTaSko06/06/02 12:24
RE: File Upload problem w/ Apache Win32Waribam Bhalindra06/04/02 00:30
RE: Apache DOS WIndow Disappear on Win 98Bene05/25/02 04:48
installing apachebenchomar05/23/02 14:46
RE: PHP Session Handling in Apache NT not workingEzrad05/23/02 06:52
RE: Apache chrashes when using sessionsGary Mailer05/15/02 06:06
apache && mysql as services on win98/meAdrian05/09/02 04:02
RE: Apache DOS WIndow Disappear on Win 98Nulle05/07/02 10:50
checking network folder sizes (nt 4 servers)Chris Gibson04/29/02 07:53
RE: mail() not working on apache win32Neil Donald04/21/02 13:28
Apache chrashes when using sessionschris04/17/02 12:13
RE: mail() not working on apache win32Sam Burns04/13/02 07:52
RE: mail() not working on apache win32Kyle O'Brien04/12/02 19:39
Problem in connecting Oracle with PHPKapil Sethi04/11/02 09:17
PHP Session Handling in Apache NT not workingBurkeHokie04/03/02 13:00
mail() not working on apache win32Mario03/26/02 02:57
Username & Password.Gary03/01/02 19:39
RE: File Upload problem w/ Apache Win32AnneSo02/25/02 11:23
RE: Apache 2 & PHP4 - can't setupNezih02/15/02 08:03
RE: Easy Apache installationJulian Harris02/14/02 14:48
RE: php extensionsMarc02/08/02 08:54
Apache 2 & PHP4 - can't setupCyprian Libera02/05/02 02:11
php extensionsVinodKumar01/24/02 09:25
Easy Apache installationStefan01/22/02 03:48
RE: PHP4 + Apache 1.3.20 -> Great!Jacob Wodzynski01/16/02 14:15
EasyPHP... Why not use that instead....Jason Earl01/03/02 15:33
Finished SETUP exe with Apache & PHP4!Christian Haugan12/23/01 09:43
Windows, Apache - Won't let web pages loadlanka12/20/01 13:23
PHP 4.1 + php_gd.dllJacob Wodzynski12/14/01 10:44
RE: How to use PHP with IIS?Grant11/30/01 14:06
easy if...tony11/22/01 13:03
PHP w/ IIS : Help is here!Jeff11/03/01 18:55
RE: php editorSreenivas10/10/01 05:41
How to use PHP with IIS?Phong09/27/01 20:48
RE: php editorWdean09/25/01 20:30
RE: Apache DOS WIndow Disappear on Win 98Ian Mellor09/24/01 07:15
HELP (URGENT)Blanca09/10/01 13:44
RE: php editorMicheal08/12/01 15:45
RE: Apache + PHP4 with PosgreSQL under WindowsBenoit FOULETIER08/10/01 12:20
RE: PHP TriadMicheal08/08/01 20:31
PHP4 + Apache 1.3.20 -> Great!Lukasz Szmit07/17/01 10:06
RE: php editorScott Cooley07/06/01 15:32
File Upload problem w/ Apache Win32Scott Cooley07/06/01 15:29
PHP Cannot be installedBill Wiriawan06/25/01 01:06
apache v's cgi apigary mailer05/24/01 08:22
RE: Apache DOS WIndow Disappear on Win 98Udo05/22/01 08:49
RE: Setting up PHP4 as a module on windowsNurmi05/19/01 09:09
RE: browser wants to download the filegary mailer05/09/01 11:44
browser wants to download the filenick giannoulois04/25/01 15:19
RE: ApacheAndreas Indahl04/20/01 07:12
Apache + PHP4 with PosgreSQL under WindowsAnnabelle04/20/01 04:29
RE: ApacheKien04/19/01 18:58
php editorPhilip Simard04/12/01 19:30
ApachePhilip Simard04/12/01 09:09
RE: that is too complicatedRavage03/28/01 10:45
Apache DOS WIndow Disappear on Win 98Anthony03/19/01 12:23
RE: Help!!!frewuill03/13/01 17:51
PHP-SELFPete03/13/01 10:08
Help!!!Marcela Durán02/23/01 05:34
RE: Setting up PHP4 as a module on windowsMarco van den Akker02/06/01 04:34
RE: Setting up PHP4 as a module on windowsRicardo Martins02/04/01 18:46
RE: PHP Triad; All-in-oneJose Lourenco02/03/01 10:09
RE: php_mod vs CGIShanx02/02/01 19:16
RE: PHP TriadJuan Manuel Fluxa01/21/01 12:10
PHP Triadalan01/20/01 12:16
no tthat complicated..Hari01/10/01 13:29
RE: that is too complicatedDave12/28/00 21:14
that is too complicatedMiro Svrtan12/22/00 16:45
Setting up PHP4 as a module on windowsMark A. Gutierrez12/17/00 23:20
php_mod vs CGISpatz11/20/00 04:50
Be careful with extensions.Malcontent11/14/00 03:34
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.