blabub
25.01.08, 15:08
Hi there,
First my problem is, that when I try to start a db connection over pdo_oci, php will crash.
More information later in the post.
My system:
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
Apache/2.2.6 (Unix)
PHP Version 5.2.5
Oracle Instant client 10.2.0
I've build PHP with following flags:
'./configure' '--with-apxs2=/CHBS/apps_local/apps/apache2/bin/apxs' '--with-mysql=/CHBS/apps_local/apps/mysql' '--prefix=/CHBS/apps_local/apps/php' '--with-config-file-path=/CHBS/apps_local/apps/php' '--enable-force-cgi-redirect' '--disable-cgi' '--with-zlib' '--with-gettext' '--with-gdbm' '--exec-prefix=/CHBS/apps_local/apps/php' '--with-zlib' '--with-oci8=instantclient,/u01/home/oracle/product/10.2.0/CL'
PHP compiled without problems.
My env-vars:
ORACLE_HOME=/u01/home/oracle/product/10.2.0/CL
TNS_ADMIN=/u01/home/oracle/local
ORACLE_SID=orcl
LD_LIBRARY_PATH=/u01/home/oracle/product/10.2.0/CL/lib
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
The PHP-File:
<?php
$pdo = new PDO( "oci:host=mydb;dbname=mydb", "myuser", "mypassword", array( PDO::ATTR_PERSISTENT => true ) );
echo "Connection done";
?>
This file will work on gentoo.
php bash output:
bash-3.00# php -a test.php
Interactive mode enabled
Connection done
If I try to call the file over the web, the page will not load. Get this message:
[code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator.
There is no information logged in the apache error log.
Now I don't know where the problem can be.
Some last information:
php.ini
extension=pdo_oci.so
phpinfo()
oci8:
Version 1.2.4
Revision $Revision: 1.269.2.16.2.38 $
Oracle Instant Client Version 10.2
Temporary Lob support enabled
Collections support enabled
PDO:
PDO drivers sqlite2, sqlite, oci
PDO Driver for OCI 8 and later enabled
other:
libxml2 Version 2.6.16
ZLib Support enabled
HOSTTYPE i386-linux
TNS_ADMIN /u01/home/oracle/local
C_INCLUDE_PATH /u01/home/oracle/product/10.2.0/CL/include
ORACLE_HOME /u01/home/oracle/product/10.2.0/CL
NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
apache configuration:
./configure --prefix=/CHBS/apps_local/apps/apache2 --enable-so--enable-cgi--enable-info--enable-rewrite--enable-speling--enable-usertrack--enable-deflate --enable-ssl--enable-mime-magic --exec-prefix=/CHBS/apps_local/apps/apache2
So that all information I have.
Thanks a lot for help
First my problem is, that when I try to start a db connection over pdo_oci, php will crash.
More information later in the post.
My system:
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
Apache/2.2.6 (Unix)
PHP Version 5.2.5
Oracle Instant client 10.2.0
I've build PHP with following flags:
'./configure' '--with-apxs2=/CHBS/apps_local/apps/apache2/bin/apxs' '--with-mysql=/CHBS/apps_local/apps/mysql' '--prefix=/CHBS/apps_local/apps/php' '--with-config-file-path=/CHBS/apps_local/apps/php' '--enable-force-cgi-redirect' '--disable-cgi' '--with-zlib' '--with-gettext' '--with-gdbm' '--exec-prefix=/CHBS/apps_local/apps/php' '--with-zlib' '--with-oci8=instantclient,/u01/home/oracle/product/10.2.0/CL'
PHP compiled without problems.
My env-vars:
ORACLE_HOME=/u01/home/oracle/product/10.2.0/CL
TNS_ADMIN=/u01/home/oracle/local
ORACLE_SID=orcl
LD_LIBRARY_PATH=/u01/home/oracle/product/10.2.0/CL/lib
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
The PHP-File:
<?php
$pdo = new PDO( "oci:host=mydb;dbname=mydb", "myuser", "mypassword", array( PDO::ATTR_PERSISTENT => true ) );
echo "Connection done";
?>
This file will work on gentoo.
php bash output:
bash-3.00# php -a test.php
Interactive mode enabled
Connection done
If I try to call the file over the web, the page will not load. Get this message:
[code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator.
There is no information logged in the apache error log.
Now I don't know where the problem can be.
Some last information:
php.ini
extension=pdo_oci.so
phpinfo()
oci8:
Version 1.2.4
Revision $Revision: 1.269.2.16.2.38 $
Oracle Instant Client Version 10.2
Temporary Lob support enabled
Collections support enabled
PDO:
PDO drivers sqlite2, sqlite, oci
PDO Driver for OCI 8 and later enabled
other:
libxml2 Version 2.6.16
ZLib Support enabled
HOSTTYPE i386-linux
TNS_ADMIN /u01/home/oracle/local
C_INCLUDE_PATH /u01/home/oracle/product/10.2.0/CL/include
ORACLE_HOME /u01/home/oracle/product/10.2.0/CL
NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
apache configuration:
./configure --prefix=/CHBS/apps_local/apps/apache2 --enable-so--enable-cgi--enable-info--enable-rewrite--enable-speling--enable-usertrack--enable-deflate --enable-ssl--enable-mime-magic --exec-prefix=/CHBS/apps_local/apps/apache2
So that all information I have.
Thanks a lot for help