Oracle OCI8 - Win32 Linux difference

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Oracle OCI8 - Win32 Linux difference

Postby supermonkeyman » 20. July 2007 00:45

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!!!!!!!!!
supermonkeyman
 
Posts: 5
Joined: 20. July 2007 00:34

Postby sixd » 20. July 2007 18:07

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.
sixd
 
Posts: 3
Joined: 20. July 2007 17:49

Postby supermonkeyman » 20. July 2007 18:46

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.
supermonkeyman
 
Posts: 5
Joined: 20. July 2007 00:34

Postby Oswald » 21. July 2007 12:02

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
User avatar
Oswald
Apache Friends
 
Posts: 2718
Joined: 26. December 2002 19:51
Location: Berlin, Germany
XAMPP Version: 5.5.19
Operating System: Linux

Postby supermonkeyman » 21. July 2007 23:14

Hi Oswald.

Top Man !!! :D

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.
supermonkeyman
 
Posts: 5
Joined: 20. July 2007 00:34

Postby sixd » 09. August 2007 19:35

Thanks Oswald.
sixd
 
Posts: 3
Joined: 20. July 2007 17:49

Postby Oswald » 31. August 2007 17:37

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
User avatar
Oswald
Apache Friends
 
Posts: 2718
Joined: 26. December 2002 19:51
Location: Berlin, Germany
XAMPP Version: 5.5.19
Operating System: Linux

Postby supermonkeyman » 03. September 2007 13:08

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.
supermonkeyman
 
Posts: 5
Joined: 20. July 2007 00:34

Re: Oracle OCI8 - Win32 Linux difference

Postby CarlHL » 18. March 2011 14:11

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
Last edited by CarlHL on 07. March 2015 03:05, edited 2 times in total.
If I had eight hours to chop down a tree, I'd spend six sharpening my ax. Abraham Lincoln
CarlHL
 
Posts: 1
Joined: 07. March 2011 00:58

Re: Oracle OCI8 - Win32 Linux difference

Postby Oswald » 18. March 2011 14:17

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
User avatar
Oswald
Apache Friends
 
Posts: 2718
Joined: 26. December 2002 19:51
Location: Berlin, Germany
XAMPP Version: 5.5.19
Operating System: Linux

Re: Oracle OCI8 - Win32 Linux difference

Postby StewMadison » 04. August 2011 14:42

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
StewMadison
 
Posts: 1
Joined: 31. July 2011 16:28


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests