Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PHP5 and Oracle 10g

Re: PHP5 and Oracle 10g

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 17 Dec 2005 01:55:33 GMT
Message-Id: <pan.2005.12.17.01.55.30.771961@sbcglobal.net> 





On Fri, 16 Dec 2005 20:21:39 -0500, PHPguy wrote:



> Which ones would they be since sqlplus and tnsping are working.



I've had this configuration working on Linux, Windows and Solaris.
On Linux, I'm using the following script to start the Apache server:



$ cat /etc/init.d/apache


#!/bin/sh




# httpd        Startup script for the Apache HTTP Server

#

# chkconfig: - 85 15

# description: Apache is a World Wide Web server.  It is used to serve \

#              HTML files and CGI.

# processname: httpd

# config: /opt/apache/conf/httpd.conf



APACHE_HOME=/opt/apache


# ORACLE_HOME=/oracle/product/client



ORACLE_HOME=/oracle/product/10g


TNS_ADMIN=$ORACLE_HOME/network/admin


TWO_TASK=local


PATH=$APACHE_HOME/bin:$PATH


LD_LIBRARY_PATH=$ORACLE_HOME/lib


LOCK=/var/lock/subsys/apache


LANG=en_US


export TNS_ADMIN ORACLE_HOME TWO_TASK


export APACHE_HOME PATH LD_LIBRARY_PATH


export LANG


case "$1" in


start)

        apachectl start
        touch $LOCK
        ;;
stop)
        apachectl stop
        rm -f $LOCK
        ;;
restart)
        apachectl restart
        ;;




esac;


$



My version of PHP5 was downloaded, compiled and configured manually, 
without any packages or RPM stuff. I'll have to confess that I don't
trust the prepackaged versions.



Can you, please, publish the output of the phpinfo() executed in the web
server. In my case, the output looks like this:
PHP Version 5.1.1


System 	Linux medo.noip.com 2.6.12-1.1381_FC3 #1 Fri Oct 21 03:46:55 EDT 2005 i686
Build Date 	Nov 28 2005 19:52:37
Configure Command 	'./configure' '--with-apxs2=/opt/apache/bin/apxs' '--with-xmlrpc' '--with-zlib' '--with-bz2' '--with-ttf' '--with-gd' '--enable-gd-native-ttf' '--with-freetype-dir' '--with-jpeg-dir' '--with-png-dir' '--with-config-file-path=/usr/local/lib/php' '--enable-sigchild' '--without-sqlite' '--disable-mysql' '--disable-pdo' '--with-oci8'
Server API 	Apache 2.0 Handler
Virtual Directory Support 	disabled
Configuration File (php.ini) Path 	/usr/local/lib/php/php.ini
PHP API 	20041225
PHP Extension 	20050922
Zend Extension 	220051025
Debug Build 	no
Thread Safety 	disabled
Zend Memory Manager 	enabled
IPv6 Support 	enabled
Registered PHP Streams 	php, file, http, ftp, compress.bzip2, compress.zlib
Registered Stream Socket Transports 	tcp, udp, unix, udg
Registered Stream Filters 	string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, convert.iconv.*, bzip2.*, zlib.*





Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2005 Zend Technologies



PHP Credits


Configuration


PHP Core

Directive	Local Value	Master Value
allow_call_time_pass_reference	Off	Off
allow_url_fopen	On	On
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	no value	no value
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	2047	2047
expose_php	On	On
extension_dir	/usr/local/lib/php/extensions	/usr/local/lib/php/extensions
file_uploads	On	On
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/usr/local/lib/php:/usr/local/PHP	.:/usr/local/lib/php:/usr/local/PHP
log_errors	On	On
log_errors_max_len	1024	1024
magic_quotes_gpc	Off	Off
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
mail.force_extra_parameters	no value	no value
max_execution_time	30	30
max_input_time	60	60
open_basedir	no value	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	16K	16K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
register_globals	Off	Off
register_long_arrays	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
safe_mode	Off	Off
safe_mode_exec_dir	no value	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i 	/usr/sbin/sendmail -t -i 
serialize_precision	100	100
short_open_tag	On	On
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	2M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	On	On
zend.ze1_compatibility_mode	Off	Off

apache2handler
Apache Version 	Apache/2.0.54 (Unix) PHP/5.1.1
Apache API Version 	20020903
Server Administrator 	gogala_at_sbcglobal.net
Hostname:Port 	localhost:80
User/Group 	nobody(99)/-1
Max Requests 	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 15
Virtual Server 	No
Server Root 	/opt/apache
Loaded Modules 	core mod_access mod_auth mod_include mod_log_config mod_env mod_setenvif prefork http_core mod_mime mod_status mod_autoindex mod_asis mod_cgi mod_negotiation mod_dir mod_imap mod_actions mod_userdir mod_alias mod_so mod_php5

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment
Variable	Value
HTTP_HOST 	localhost
HTTP_USER_AGENT 	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Fedora/1.0.7-1.1.fc3 Firefox/1.0.7
HTTP_ACCEPT 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.5
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 	300
HTTP_CONNECTION 	keep-alive
PATH 	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE 	<address>Apache/2.0.54 (Unix) PHP/5.1.1 Server at localhost Port 80</address>
SERVER_SOFTWARE 	Apache/2.0.54 (Unix) PHP/5.1.1
SERVER_NAME 	localhost
SERVER_ADDR 	127.0.0.1
SERVER_PORT 	80
REMOTE_ADDR 	127.0.0.1
DOCUMENT_ROOT 	/opt/apache/htdocs
SERVER_ADMIN 	gogala_at_sbcglobal.net
SCRIPT_FILENAME 	/usr/local/mydoc/first.php
REMOTE_PORT 	35173
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/mydoc/first.php
SCRIPT_NAME 	/mydoc/first.php





HTTP Headers Information


HTTP Request Headers

HTTP Request 	GET /mydoc/first.php HTTP/1.1
Host 	localhost
User-Agent 	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Fedora/1.0.7-1.1.fc3 Firefox/1.0.7
Accept 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language 	en-us,en;q=0.5
Accept-Encoding 	gzip,deflate
Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 	300
Connection 	keep-alive
HTTP Response Headers
X-Powered-By 	PHP/5.1.1
Keep-Alive 	timeout=15, max=100
Connection 	Keep-Alive
Transfer-Encoding 	chunked
Content-Type 	text/html; charset=ISO-8859-1

bz2
BZip2 Support 	Enabled
Stream Wrapper support 	compress.bz2://
Stream Filter support 	bzip2.decompress, bzip2.compress
BZip2 Version 	1.0.2, 30-Dec-2001

ctype
ctype functions 	enabled

date
date/time support 	enabled
Timezone Database Version 	2005.14
Timezone Database 	internal
Default timezone 	America/New_York

Directive	Local Value	Master Value
date.timezone	no value	no value

dom
DOM/XML 	enabled
DOM/XML API Version 	20031129
libxml Version 	2.6.22
HTML Support 	enabled
XPath Support 	enabled
XPointer Support 	enabled
Schema Support 	enabled
RelaxNG Support 	enabled

gd
GD Support 	enabled
GD Version 	bundled (2.0.28 compatible)
FreeType Support 	enabled
FreeType Linkage 	with freetype
FreeType Version 	2.1.9
GIF Read Support 	enabled
GIF Create Support 	enabled
JPG Support 	enabled
PNG Support 	enabled
WBMP Support 	enabled
XBM Support 	enabled

iconv
iconv support 	enabled
iconv implementation 	glibc
iconv library version 	2.3.6

Directive	Local Value	Master Value
iconv.input_encoding	ISO-8859-1	ISO-8859-1
iconv.internal_encoding	ISO-8859-1	ISO-8859-1
iconv.output_encoding	ISO-8859-1	ISO-8859-1

libxml
libXML support 	active
libXML Version 	2.6.22
libXML streams 	enabled

oci8
OCI8 Support 	enabled
Revision 	$Revision: 1.269.2.3 $
Active Persistent Links 	0
Active Links 	0
Oracle Version 	10.1
Compile-time ORACLE_HOME 	/oracle/product/10g
Libraries Used 	no value
Temporary Lob support 	enabled
Collections support 	enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	6.2 01-Aug-2005

PDO
PDO support	enabled
PDO drivers 	oci

PDO_OCI
PDO Driver for OCI 8 and later	enabled

posix
Revision 	$Revision: 1.70.2.1 $

session
Session Support 	enabled
Registered save handlers 	files user
Registered serializer handlers 	php php_binary

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.bug_compat_42	Off	Off
session.bug_compat_warn	On	On
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_secure	Off	Off
session.entropy_file	no value	no value
session.entropy_length	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.hash_bits_per_character	5	5
session.hash_function	0	0
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	no value	no value
session.serialize_handler	php	php
session.use_cookies	On	On
session.use_only_cookies	Off	Off
session.use_trans_sid	0	0

SimpleXML
Simplexml support	enabled
Revision 	$Revision: 1.151.2.7 $
Schema support 	enabled

SPL
SPL support	enabled
Interfaces 	Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes 	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileObject, SplObjectStorage, UnderflowException, UnexpectedValueException

standard
Regex Library 	Bundled library enabled
Dynamic Library Support 	enabled
Path to sendmail 	/usr/sbin/sendmail -t -i

Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.83	90.83
date.sunset_zenith	90.83	90.83
default_socket_timeout	60	60
safe_mode_allowed_env_vars	PHP_	PHP_
safe_mode_protected_env_vars	LD_LIBRARY_PATH	LD_LIBRARY_PATH
url_rewriter.tags	a=href,area=href,frame=src,input=src,form=fakeentry	a=href,area=href,frame=src,input=src,form=fakeentry
user_agent	no value	no value

tokenizer
Tokenizer Support 	enabled

xml
XML Support 	active
XML Namespace Support 	active
libxml2 Version 	2.6.22

xmlrpc
core library version 	xmlrpc-epi v. 0.51
php extension version 	0.51
author 	Dan Libby
homepage 	http://xmlrpc-epi.sourceforge.net
open sourced by 	Epinions.com

zlib
ZLib Support 	enabled
Stream Wrapper support 	compress.zlib://
Stream Filter support 	zlib.inflate, zlib.deflate
Compiled Version 	1.2.2.2
Linked Version 	1.2.2.2

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value





Additional Modules


Module Name



Environment

Variable	Value
CONSOLE 	/dev/console
SELINUX_INIT 	YES
TERM 	linux
TWO_TASK 	local
LD_LIBRARY_PATH 	/opt/apache/lib:/oracle/product/10g/lib
INIT_VERSION 	sysvinit-2.85
PATH 	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
TNS_ADMIN 	/oracle/product/10g/network/admin
runlevel 	5
RUNLEVEL 	5
PWD 	/
LANG 	en_US
previous 	N
PREVLEVEL 	N
SHLVL 	3
HOME 	/
APACHE_HOME 	/opt/apache
ORACLE_HOME 	/oracle/product/10g
_ 	/opt/apache/bin/httpd

PHP Variables
Variable	Value
_SERVER["HTTP_HOST"]	localhost
_SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050922 Fedora/1.0.7-1.1.fc3 Firefox/1.0.7
_SERVER["HTTP_ACCEPT"]	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_LANGUAGE"]	en-us,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"]	300
_SERVER["HTTP_CONNECTION"]	keep-alive
_SERVER["PATH"]	/opt/apache/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"]	<address>Apache/2.0.54 (Unix) PHP/5.1.1 Server at localhost Port 80</address>
_SERVER["SERVER_SOFTWARE"]	Apache/2.0.54 (Unix) PHP/5.1.1
_SERVER["SERVER_NAME"]	localhost
_SERVER["SERVER_ADDR"]	127.0.0.1
_SERVER["SERVER_PORT"]	80
_SERVER["REMOTE_ADDR"]	127.0.0.1
_SERVER["DOCUMENT_ROOT"]	/opt/apache/htdocs
_SERVER["SERVER_ADMIN"]	gogala_at_sbcglobal.net
_SERVER["SCRIPT_FILENAME"]	/usr/local/mydoc/first.php
_SERVER["REMOTE_PORT"]	35173
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["REQUEST_METHOD"]	GET
_SERVER["QUERY_STRING"]	no value
_SERVER["REQUEST_URI"]	/mydoc/first.php
_SERVER["SCRIPT_NAME"]	/mydoc/first.php
_SERVER["PHP_SELF"]	/mydoc/first.php
_SERVER["REQUEST_TIME"]	1134784177





PHP License



This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE



This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.



If you did not receive a copy of the PHP license, or have any questions
about PHP licensing, please contact license_at_php.net. 



-- 
http://www.mgogala.com


Received on Fri Dec 16 2005 - 19:55:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US