as tu essaié directement en php d'accéder à ta base oracle?
(oci_connect, ...)
en affichant les messages d'erreurs ça pourrait te renseigner sur le problème.

fab,

En fait j'avais installé il y a quelques temps un logiciel de monitoring (Zabbix) nécessitant Apache, PHP et une base de données. En utilisant MySQL, j'avais réussi à faire la connection PHP/MySQL et faire tourner cette application.

Mais là je dois mettre Oracle comme base de données.

Voici les tests effectués par Zabbix lors de son premier démarrage :

1ère série de tests :
PHP version: 5.2.3 Ok
PHP Memory limit: 128M Ok
PHP post max size: 8M Ok
PHP max execution time: 300 sec Ok
PHP Databases support: Oracle Ok
PHP BC math support yes Ok
GD Version: bundled (2.0.34 compatible) Ok
Image formats: PNG Ok
PHP Timezone: EUROPE/PARIS Ok

2ème série de tests :
Please create database manually.
And set the configuration parameters of connection to this database.
And press "Test connection" button.
Type : Oracle
Host : 10.1.10.247
Port : ****
Name : ****
User : ****
Password : ****
FAIL


(A noter : j'ai accés à la base de données par l'assistant Oracle, donc elle fonctionne bien.)

C'est pourquoi je me demandais si je n'avais pas oublié un paramètre dans le configure de PHP.

Sébastien

[/img][/i]

Merci de ton aide.
Sébastien

Voici mon phpinfo :

[code]
oracle_home : /apps/ora10/10.2.0

PHP Version 5.2.3

System Linux Tungsten 2.6.18-8.el5 #1 SMP Tue Jun 5 23:11:13 EDT 2007 i686
Build Date Oct 15 2007 03:11:33
Configure Command './configure' '--enable-shared' '--with-oci8=/apps/ora10/10.2.0' '--with-pdo-oci=/apps/ora10/10.2.0' '--with-oracle' '--with-re2c=/usr/bin' '--with-apache2=/apps/zabbix/httpd' '--with-mod-dav=/apps/zabbix/httpd/modules' '--with-apxs2=/apps/zabbix/httpd/bin/apxs' '--prefix=/apps/zabbix/php-5.2.3' '--enable-bcmath' '--with-gd'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /apps/zabbix/php-5.2.3/lib
Loaded Configuration File /usr/local/lib/php.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp
Registered Stream Socket Transports tcp, udp, unix, udg
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*

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



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
allow_url_include Off Off
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 On On
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 6135 6135
expose_php On On
extension_dir ./ ./
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 .:/apps/zabbix/php-5.2.3/lib/php .:/apps/zabbix/php-5.2.3/lib/php
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 300 300
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
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 EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache2handler
Apache Version Apache/2.2.3 (Unix) mod_ssl/2.2.3 OpenSSL/0.9.8b DAV/2 PHP/5.2.3
Apache API Version 20051115
Server Administrator [no address given]
Hostname:Port 127.0.0.1:80
User/Group daemon(2)/2
Max Requests Per Child: 10000 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server Yes
Server Root /apps/zabbix/httpd
Loaded Modules core prefork http_core mod_so mod_authn_file mod_authn_dbm mod_authn_anon mod_authn_dbd mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_dbm mod_authz_owner mod_authz_default mod_auth_basic mod_auth_digest mod_file_cache mod_cache mod_disk_cache mod_dbd mod_dumpio mod_ext_filter mod_include mod_filter mod_deflate mod_log_config mod_log_forensic mod_logio mod_env mod_mime_magic mod_cern_meta mod_expires mod_headers mod_ident mod_usertrack mod_unique_id mod_setenvif mod_version mod_proxy mod_proxy_connect mod_proxy_ftp mod_proxy_http mod_proxy_ajp mod_proxy_balancer mod_ssl mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_cgi mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imagemap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_php5

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


Apache Environment
Variable Value
UNIQUE_ID GC9MdX8AAAEAABA-aTEAAAAA
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
HTTP_ACCEPT_LANGUAGE fr
HTTP_UA_CPU x86
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
HTTP_HOST 10.1.10.247
HTTP_CONNECTION Keep-Alive
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/apps/ora10/10.2.0/bin
SERVER_SIGNATURE no value
SERVER_SOFTWARE Apache/2.2.3 (Unix) mod_ssl/2.2.3 OpenSSL/0.9.8b DAV/2 PHP/5.2.3
SERVER_NAME 10.1.10.247
SERVER_ADDR 10.1.10.247
SERVER_PORT 80
REMOTE_ADDR 10.1.10.124
DOCUMENT_ROOT /apps/zabbix/httpd/frontends/php
SERVER_ADMIN [no address given]
SCRIPT_FILENAME /apps/zabbix/httpd/frontends/php/toto.php
REMOTE_PORT 1640
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /toto.php
SCRIPT_NAME /toto.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /toto.php HTTP/1.1
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
Accept-Language fr
UA-CPU x86
Accept-Encoding gzip, deflate
User-Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Host 10.1.10.247
Connection Keep-Alive
HTTP Response Headers
X-Powered-By PHP/5.2.3
Keep-Alive timeout=5, max=100
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html


bcmath
BCMath support enabled


ctype
ctype functions enabled


date
date/time support enabled
"Olson" Timezone Database Version 2007.5
Timezone Database internal
Default timezone EUROPE/PARIS

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone EUROPE/PARIS EUROPE/PARIS


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


filter
Input Validation and Filtering enabled
Revision $Revision: 1.52.2.39 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value


gd
GD Support enabled
GD Version bundled (2.0.34 compatible)
GIF Read Support enabled
GIF Create Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled


hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5


iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.5

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


json
json support enabled
json version 1.2.1


libxml
libXML support active
libXML Version 2.6.26
libXML streams enabled


oci8
OCI8 Support enabled
Version 1.2.3
Revision $Revision: 1.269.2.16.2.32 $
Active Persistent Connections 0
Active Connections 0
Oracle Version 10.1
Compile-time ORACLE_HOME /apps/ora10/10.2.0
Libraries Used no value
Temporary Lob support enabled
Collections support enabled

Directive Local Value Master Value
oci8.default_prefetch 10 10
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics 0 0
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.0 18-Dec-2006


PDO
PDO support enabled
PDO drivers sqlite2, sqlite, oci


PDO_OCI
PDO Driver for OCI 8 and later enabled


pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $
SQLite Library 3.3.6


posix
Revision $Revision: 1.70.2.3.2.15 $


Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33.2.39 2007/05/29 08:44:05 helly Exp $


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

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
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_httponly Off Off
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 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
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.22.2.26 $
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, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException


SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.9 2007/05/19 17:58:22 iliaa Exp $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0


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
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=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent no value no value


tokenizer
Tokenizer Support enabled


xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.26


xmlreader
XMLReader enabled


xmlwriter
XMLWriter enabled


Additional Modules
Module Name


Environment
Variable Value
HOSTNAME Tungsten
SHELL /bin/bash
TERM xterm
HISTSIZE 1000
SSH_CLIENT 10.1.10.124 1311 22
NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
SSH_TTY /dev/pts/2
USER root
LS_COLORS no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
LD_LIBRARY_PATH :/usr/lib/libsqlora8.so:/usr/lib:/apps/ora10/10.2.0/lib:/usr/lib/php/modules/
ORACLE_SID ZABBIX
ORACLE_BASE /apps/zabbix/database
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/apps/ora10/10.2.0/bin
MAIL /var/spool/mail/root
TNS_ADMIN /apps/ora10/10.2.0/network/admin
PWD /apps/zabbix/httpd
INPUTRC /etc/inputrc
LANG en_US.UTF-8
SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass
HOME /root
SHLVL 2
LOGNAME root
CVS_RSH ssh
SSH_CONNECTION 10.1.10.124 1311 10.1.10.247 22
LESSOPEN |/usr/bin/lesspipe.sh %s
ORACLE_HOME /apps/ora10/10.2.0
G_BROKEN_FILENAMES 1
_ bin/httpd


PHP Variables
Variable Value
_SERVER["UNIQUE_ID"] GC9MdX8AAAEAABA-aTEAAAAA
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] fr
_SERVER["HTTP_UA_CPU"] x86
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
_SERVER["HTTP_HOST"] 10.1.10.247
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/apps/ora10/10.2.0/bin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache/2.2.3 (Unix) mod_ssl/2.2.3 OpenSSL/0.9.8b DAV/2 PHP/5.2.3
_SERVER["SERVER_NAME"] 10.1.10.247
_SERVER["SERVER_ADDR"] 10.1.10.247
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 10.1.10.124
_SERVER["DOCUMENT_ROOT"] /apps/zabbix/httpd/frontends/php
_SERVER["SERVER_ADMIN"] [no address given]
_SERVER["SCRIPT_FILENAME"] /apps/zabbix/httpd/frontends/php/toto.php
_SERVER["REMOTE_PORT"] 1640
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /toto.php
_SERVER["SCRIPT_NAME"] /toto.php
_SERVER["PHP_SELF"] /toto.php
_SERVER["REQUEST_TIME"] 1192412176
_SERVER["argv"] Array
(
)


_SERVER["argc"] 0
_ENV["HOSTNAME"] Tungsten
_ENV["SHELL"] /bin/bash
_ENV["TERM"] xterm
_ENV["HISTSIZE"] 1000
_ENV["SSH_CLIENT"] 10.1.10.124 1311 22
_ENV["NLS_LANG"] AMERICAN_AMERICA.WE8ISO8859P1
_ENV["SSH_TTY"] /dev/pts/2
_ENV["USER"] root
_ENV["LS_COLORS"] no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
_ENV["LD_LIBRARY_PATH"] :/usr/lib/libsqlora8.so:/usr/lib:/apps/ora10/10.2.0/lib:/usr/lib/php/modules/
_ENV["ORACLE_SID"] ZABBIX
_ENV["ORACLE_BASE"] /apps/zabbix/database
_ENV["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/apps/ora10/10.2.0/bin
_ENV["MAIL"] /var/spool/mail/root
_ENV["TNS_ADMIN"] /apps/ora10/10.2.0/network/admin
_ENV["PWD"] /apps/zabbix/httpd
_ENV["INPUTRC"] /etc/inputrc
_ENV["LANG"] en_US.UTF-8
_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass
_ENV["HOME"] /root
_ENV["SHLVL"] 2
_ENV["LOGNAME"] root
_ENV["CVS_RSH"] ssh
_ENV["SSH_CONNECTION"] 10.1.10.124 1311 10.1.10.247 22
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["ORACLE_HOME"] /apps/ora10/10.2.0
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["_"] bin/httpd
[/code]

Puis si tu pouvais être un peu plus précis sur ton ça marche pas ça pourrait nous aider, par exemple tu as peut être un message d'erreur

Difficile à dire sans la configuration du serveur. Mets un lien vers ton phpinfo() pour voir ?

Bonjour,

J'ai installé sur un Redhat OEL 5 :
- Apache 2.2.3
- PHP 5.2.3
- Oracle Server 10.2.0.3
- libsqlora8

Les installations se sont bien déroulées.
Apache, PHP et Oracle fonctionnent séparemment.
Mais lorsque j'essaye d'utiliser la connection PHP/Oracle pour un autre logiciel (Zabbix qui fonctionne aussi), je n'y arrive pas.

Est-ce que quelqu'un pourrait me dire si j'ai oublié d'installer un module?

Merci.

Sébastien