FreeTDS Development Group

[Gordon Ross <ross AT fas.harvard.edu>]

Hi Steve,

>         My guess, actually, is   that there's  a 64/32-bit  problem  with
>    Apache, since having libraries for both 32-bit and 64-bit calls loaded
>    into the same memory space is a  tricky problem.  In that case, making
>    sure everything is built in 64-bit mode should also fix the segfaults.
>    I  don't use mod_perl though,   so I'd have   a hard time testing this
>    hypothesis on Linux or otherwise.

          I thought  about this over  the  weekend and  remembered that the
     Oracle 9i client has the same problem with its DBD:  the fix is to use
     the (supplied  but not default)  32 bit library modules.  (The default
     on 64 bit platforms for Oracle client is 64 bit libriaries.)  The same
     thing   appears to be  the  case for Tru64  and the dbd-sybase/freetds
     build.

          Testing, so far, with the 32 bit  libraries has been flawless for
     version 0.60.

               -- Gord

     ======================================================================

> > > >         I've tested  FreeTDS on Linux/Alpha  before, and have just  
> > > > run a
> > > >    quick test using  0.61pre1 and DBD::Sybase (0.93).  I  had no 
> > > > problems
> > > >    here; if  there is a specific  test I can  run that he knows  to 
> > > > cause
> > > >    problems, I'm  happy to give it  a shot here.  However,  my build 
> > > > logs
> > > >    for 0.60 show  no 64bit-specific errors, which makes  me think 
> > > > this is
> > > >    somehow a Tru64 problem, not a 64-bit problem.
> > >
> > >           The problem I experience  is when perl/dbd-sybase/freetds is 
> > > used
> > >      via a mod_perl application in apache.  Outside of apache I have 
> > > had no
> > >      problems with 0.60.  The freetds build is performing properly.
>
> > Well in that case I'm guessing that it's an environment variable
> > problem. This can be LD_LIBRARY_PATH and/or SYBASE. You should set these
> > in Apache's httpd.conf file via the SetEnv directive.
>
> My guess, actually, is that there's a 64/32-bit problem with Apache,
> since having libraries for both 32-bit and 64-bit calls loaded into the
> same memory space is a tricky problem.  In that case, making sure
> everything is built in 64-bit mode should also fix the segfaults.  I
> don't use mod_perl though, so I'd have a hard time testing this
> hypothesis on Linux or otherwise.
>
> --
> Steve Langasek
> postmodern programmer
>