Bug #71109 for DBD-Oracle: Segfault on Mac OS X

Okay, turns out this is because I installed the 64 bit libraries, but they're not (yet) compatible with Lion. http://only4left.jpiwowar.com/2011/08/instant-client-osx-lion-32-bit-only/ I've installed the 32 bit client, but now I have problems because my Perl is 64 bit. Think I'll just use RPMs on $work's server and give up on this for now. David

After discussion on irc.perl.org #dbi it may appear that the 64 bit instant client for osx does not work (needs link). However, 32bit instant client on osx is not much better - someone with latest osx and some tuits needs to look at this. Adding this only for reference only: <theory> mje_: Know much about getting DBD::Oracle working on Mac OS X? <mje_> theory, sorry, don't own a mac although I ported some drivers to it years ago - what is your problem? <theory> mje_: segfault: https://rt.cpan.org/Ticket/Attachment/979741/510057/ <mje_> theory, ah, I already saw that and am not sure - maybe I'll find some tuits to look at it <theory> I need to learn C better. * theory hunts around for Yanick or timbunce… <mje_> it is a read on address 0 (causing segfault) but beyond that I've not had time to look further. I'd be suspicious of "Can't find sqlplus. Pity, it would have helped." and install the sqlplus package and also check DYLD_* (whatever if is on osx) <mje_> theory, i.e., install the sqlplus zip in addition to the instant client zip <theory> I guess I could install sqlplus <theory> Been trying to avoid polluting my Mac with Oracle crap. <mje_> theory, you just unzip it in the same dir as instant client - hardly polluting - DBD::Oracle could not find oracle version so fell back to version 10 <theory> I told it to use v10 <theory> Note "perl Makefile.PL -V 10.x.x.x" * theory hunts for the sqlplus download… <mje_> theory, personally I'd not do that as it has a big affect on what is compiled in to DBD::Oracle - the Oracle server version is not relevent, it is the client version that needs to match <theory> Got it. * mje_ steps out for a minute (or 2) <theory> Yeah, that was the version of the instantclient I installed. <theory> Downloading sqlplus now <theory> Oh goodie. sqlplus segfaults too * mje_ thinks theory is stuck now, if sqlplus segfaults your going nowhere - is there not a more recent instant client for osx? <theory> Yeah, reading http://www.cjtravis.com/?p=744 <theory> "First off, Mac 10.7 is currently incompatible with the 64-bit version of the Oracle instant client." <theory> *sigh* <mje_> 32 bit not any good to you? <theory> Okay, 32 bit works. <theory> mje_: Yeah, silly me for assuming 64 bit would be better/preferred. <mje_> \o/ <theory> Going to rebuild now. <theory> grr <theory> "I can't find the header files I need in your Oracle installation." <theory> Oh, I need a symlink I think. <theory> Oh, Makefile.PL will create it if I run it as root. <theory> dammit <mje_> did you install instant client basic, sqlplus and instant client development (can't remember what it is called right now) <theory> NO, didn't install the sdk, which Makefile.PL is telling me, which is good. * theory downloads it <mje_> yes, sdk, I really am tired <theory> There we go <mje_> theory, could you update rt or mail me with reference to 64 bit oracle client does not work on osx and I'll commit a link to it <theory> Yeah, I'm looking for the repo <theory> will update README.macosx <mje_> theory, thank you <theory> ooh, svn <mje_> I only just realised you reported rt 71109 - sorry, if I had realised I'd have pulled out more stops <theory> mje_np <theory> mje_: np <theory> mje_: So this is is what I get from `make test`: http://dbi.privatepaste.com/eb62fece85 <mje_> weird oci_attrget has been arounf ages <mje_> s/oci_attrget/OCIAttrGet/ <theory> Maybe it's the NMEDIT thing? <theory> Hrm, no <theory> same error <theory> though fewer warnings during `make`. <theory> Oh crap <theory> My Perl is 64 bit of course. <theory> XXXXXX Oracle. <theory> Guess I have to wait for the 64-bit instantclient * theory goes to find lunch <mje_> theory, to be honest, Oracle still uses 32bit libs/binaries under hsodbc/dgodbc when linking a database via ODBC to other dbs <theory> mje_: Was reading the last post in this thread: http://www.webmasterkb.com/Uwe/Forum.aspx/perl-dbi/2465/Install-issues-Os-x-10-5-and-DBD-Oracle-1-23 <theory> My Perl is 64 bit. The oracle libs are 32 bit. <theory> I could rebuild Perl, but have a lot of other XXXX built on it already. * mje_ it is 20:43 here and I'm hungry - keep me in the loop and I'll help as much as I can Martin -- Martin J. Evans Wetherby, UK

Reading the ticket's thread. Fwiw, there's also a github mirror of the svn repo at https://github.com/yanick/DBD-Oracle, if it's more to your patch-palatable to you :-)