Apache Friends Support Forum

Hi.

I've a Win32 box running xampp which reports the following thru phpinfo()...

PHP 5.1.1 win32
oci8
OCI8 Support enabled
Revision $Revision: 1.285 $
Active Persistent Connections 0
Active Connections 0
Temporary Lob support enabled
Collections support enabled

Directive Local Value Master Value
oci8.default_prefetch 10 10
oci8.max_persistent 10 10
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

On a Linux (Oracle Unbreakable//Redhat 4), also running xampp I get

PHP 5.2.1, Linux
oci8
OCI8 Support enabled
Version 1.2.3
Revision $Revision: 1.269.2.16.2.30 $
Active Persistent Connections 0
Active Connections 0
Oracle Version 9.0
Compile-time ORACLE_HOME /opt/oracle/OraHome1
Libraries Used -Wl,-rpath,/opt/oracle/OraHome1/lib -L/opt/oracle/OraHome1/lib -lclntsh
Temporary Lob support disabled
Collections support disabled

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

Why?????

I need temporary LOB support - why is it missing on the Linux distro?

More importantly, how can I get it enabled - I've googled but nothing is returned relating to "how to get it working".

On the Linux box, Instant Client is installed - LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib

Help!!!!!!!!!

PHP in XAMMP needs to be recompiled using Oracle 10g libraries,
e.g. the free libraries from
http://www.oracle.com/technology/tech/o ... index.html

This is how PHP on Windows is built.

The only drawback for Linux users is they will also need to have
Oracle 10g libraries at runtime, and won't be able to connect to very
old Oracle databases - but this is also true on Windows and hasn't
caused a problem.

It is better for XAMMP to have a consistent distribution.

Hi SIXD.

Thanks for that. I completely agree about XAMPP needing to be the same across platforms.

I'll email the XAMPP Linux people (if I can find an address) to try and get the build sorted so that it's the same across releases.

-- D.

Dear sixd and supermonkeyman!

You both are absolutely right. I was aware of this difference but since nobody ever complained I didn't saw the need to fix it. But now I'll fix it in one of the next releases.

Greetings
Oswald

Hi Oswald.

Top Man !!!

I work at the BBC (http://www.bbc.co.uk) and use XAMPP extensively, both Win32 and Linux variants.

This is excellent news. I'll look forward to reading the changelog and upgrading.

-- D.

Thanks Oswald.

Hi supermonkeyman, sixd!

In the next version of XAMPP for Linux PHP will be compiled against Oracle 10 with temporary LOB and Collections support enabled. A current (untested) preview is available at http://www.apachefriends.org/en/xampp-beta.html

Many greetings
Oswald

Hi Oswald.

Thanks for the update. I'm hoping to test in the next two weeks or so and will post here the results.

-- Dave.

Ran into an issue installing XAMPP on Ubuntu Linux using version 1.7.3a. Seems to be a problem with the integrity of the installer. Where can I get the correct value of the MD5 checksum and also any recommendations for Cheap Dedicated Linux Server Hosting would be appreciated. Thanks for your help, Carl

Hi Carl!

CarlHL wrote:Ran into an issue installing XAMPP on Ubuntu Linux using version 1.7.3a. Seems to be a problem with the integrity of the installer. Where can I get the correct value of the MD5 checksum? Thanks for your help, Carl

It's 89c13779cf6f0925d5c1c400d31a1cc3. See http://sourceforge.net/projects/xampp/f ... ux/1.7.3a/

Greetings
Oswald

CarlHL wrote:Ran into an issue installing XAMPP on Ubuntu Linux using version 1.7.3a. Seems to be a problem with the integrity of the installer. Where can I get the correct value of the MD5 checksum and also any recommendations for Best Linux Server Hosting would be appreciated. Thanks for your help, Carl

You should check the installer by checking the MD5 Checksum of the downloaded installer and compare with the correct one. If they are not the same, the installer you have downloaded may be corrupt and it will not run properly when installed. You can get the "correct value" of the MD5 checksum on the XAMPP Linux Page: http://www.apachefriends.org/en/xampp-linux.html