Hi When You install perl modules via cpan, you need to make sure you start the proper perl aka:
/opt/perl/bin/perl -MCPAN -e shell

or inside a untarred module
/opt/perl/bin/perl ./MAKEFILE.PL

Or you can use perlbrew which sets up the PERL5LIB environment variable accordingly.

Here's my perl -V output:

>:~$ perl -V
Summary of my perl5 (revision 5 version 16 subversion 3) configuration
+:

  Platform:
    osname=linux, osvers=2.6.32-279.el6.x86_64, archname=x86_64-linux
    uname='linux nyctrdmonp02 2.6.32-279.el6.x86_64 #1 smp fri jun 22 
+12:19:21 utc 2012 x86_64 x86_64 x86_64 gnulinux '
    config_args=''
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=undef, usemultiplicity=undef
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=und
+ef
    use64bitint=define, use64bitall=define, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -pipe -fstack-protector -I
+/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O2',
    cppflags='-fno-strict-aliasing -pipe -fstack-protector -I/usr/loca
+l/include'
    ccversion='', gccversion='4.4.7 20120313 (Red Hat 4.4.7-3)', gccos
+andvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=1
+6
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
+ lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
    libpth=/usr/local/lib /lib/../lib64 /usr/lib/../lib64 /lib /usr/li
+b /lib64 /usr/lib64
    libs=-lnsl -ldb -ldl -lm -lcrypt -lutil -lc
    perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
    libc=/lib/libc-2.12.so, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version='2.12'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib -fstac
+k-protector'


Characteristics of this binary (from libperl):
  Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_DONT_CREATE_GVSV
                        PERL_MALLOC_WRAP PERL_PRESERVE_IVUV USE_64_BIT
+_ALL
                        USE_64_BIT_INT USE_LARGE_FILES USE_LOCALE
                        USE_LOCALE_COLLATE USE_LOCALE_CTYPE
                        USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
  Built under linux
  Compiled at May 21 2014 13:54:14
  @INC:
    /export/home/scratch/perl/lib/site_perl/5.16.3/x86_64-linux
    /export/home/scratch/perl/lib/site_perl/5.16.3
    /export/home/scratch/perl/lib/5.16.3/x86_64-linux
    /export/home/scratch/perl/lib/5.16.3
[download]

So the problem is ultimately that I need DBD::Sybase, which fails when using CPAN.

When searched around for the errors I was getting, I picked up a lot of hints that CPAN was trying to install 32-bit versions which were clashing on my 64-bit box.

When i went back to the non-prod box that was built out by a guy not with the company any more, I noticed that all the DB(I|D) modules were in the architecture specific directory:

>:/export/home/scratch/perl/lib$ find . -name DBI*
./site_perl/5.16.3/CGI/Session/Driver/DBI.pm
./site_perl/5.16.3/Log/Log4perl/Appender/DBI.pm
./site_perl/5.16.3/DBI
./site_perl/5.16.3/x86_64-linux/Win32/DBIODBC.pm
./site_perl/5.16.3/x86_64-linux/DBI
./site_perl/5.16.3/x86_64-linux/auto/DBI
./site_perl/5.16.3/x86_64-linux/auto/DBI/DBI.bs
./site_perl/5.16.3/x86_64-linux/auto/DBI/DBI.so
./site_perl/5.16.3/x86_64-linux/auto/DBI/DBIXS.h
./site_perl/5.16.3/x86_64-linux/DBI.pm
./site_perl/5.16.3/x86_64-linux/Bundle/DBI.pm
>:/export/home/scratch/perl/lib$ find . -name DBD*
./site_perl/5.16.3/DBD
./site_perl/5.16.3/x86_64-linux/DBD
./site_perl/5.16.3/x86_64-linux/DBI/DBD
./site_perl/5.16.3/x86_64-linux/DBI/DBD.pm
./site_perl/5.16.3/x86_64-linux/auto/DBD
./site_perl/5.16.3/x86_64-linux/Bundle/DBD
[download]

Also notice that there is a DBI folder under the standard site_perl directory, but the DBI.pm package is only in the x86... directory. Never seen that, but again, not very experienced with building a good perl install.

From there I started looking around for 64-bit specific DBI and DBD packages and found a source for rpms. But that seems fairly tedious, so...here I am. Truth be told, I'm not even sure that these RPM's will work.

Short version: I want DBI with DBD::Sybase and DBD::Oracle but perl complains when I try to install via CPAN.

dsb
This @ISA my( $cool ) %SIG

"I want DBI with DBD::Sybase and DBD::Oracle but perl complains..."

It's just an idea - but are you aware that you need a Sybase environment as well as an Oracle environment to build this modules?

In other words: you need to build DBD::Sybase as user sybase and DBD::Oracle as user oracle.

Else it's like banging your head against a wall ;-)

Regards, Karl

Maybe, it would be better if you provide the command that you use when you install DBD::Sybase and the error that you get.

output from the failures in make:

>:~/packages/DBD-Sybase-1.15$ make 2>&1 | tee -a make.1.log
cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod
cp Sybase.pm blib/lib/DBD/Sybase.pm
/export/home/scratch/perl/bin/perl -p -e "s/~DRIVER~/Sybase/g" /export
+/home/scratch/perl/lib/site_perl/5.16.3/x86_64-linux/auto/DBI/Driver.
+xst > Sybase.xsi
/export/home/scratch/perl/bin/perl /export/home/scratch/perl/lib/5.16.
+3/ExtUtils/xsubpp  -typemap /export/home/scratch/perl/lib/5.16.3/ExtU
+tils/typemap  Sybase.xs > Sybase.xsc && mv Sybase.xsc Sybase.c
cc -c  -I/apps/sybase/include -DSYB_LP64 -I/export/home/scratch/perl/l
+ib/site_perl/5.16.3/x86_64-linux/auto/DBI -fno-strict-aliasing -pipe 
+-fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OF
+FSET_BITS=64 -O2   -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I
+/export/home/scratch/perl/lib/5.16.3/x86_64-linux/CORE"   Sybase.c
cc -c  -I/apps/sybase/include -DSYB_LP64 -I/export/home/scratch/perl/l
+ib/site_perl/5.16.3/x86_64-linux/auto/DBI -fno-strict-aliasing -pipe 
+-fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OF
+FSET_BITS=64 -O2   -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I
+/export/home/scratch/perl/lib/5.16.3/x86_64-linux/CORE"   dbdimp.c
dbdimp.c: In function ‘syb_st_execute’:
dbdimp.c:3906: warning: passing argument 2 of ‘ct_results’ from incomp
+atible pointer type
/apps/sybase/include/ctpublic.h:363: note: expected ‘CS_INT *’ but arg
+ument is of type ‘int *’
dbdimp.c:3930: warning: passing argument 5 of ‘ct_bind’ from incompati
+ble pointer type
/apps/sybase/include/ctpublic.h:110: note: expected ‘CS_INT *’ but arg
+ument is of type ‘int *’
Running Mkbootstrap for DBD::Sybase ()
chmod 644 Sybase.bs
rm -f blib/arch/auto/DBD/Sybase/Sybase.so
LD_RUN_PATH="/apps/sybase/lib" cc  -L/apps/sybase/lib -shared -O2 -L/u
+sr/local/lib -fstack-protector Sybase.o dbdimp.o  -o blib/arch/auto/D
+BD/Sybase/Sybase.so  \
           -L/apps/sybase/lib -lct -lcs -lcomn -lintl -lblk -lskrb -ld
+l -lm     \

/usr/bin/ld: skipping incompatible /apps/sybase/lib/libct.so when sear
+ching for -lct
/usr/bin/ld: skipping incompatible /apps/sybase/lib/libct.a when searc
+hing for -lct
/usr/bin/ld: skipping incompatible /apps/sybase/lib/libct.so when sear
+ching for -lct
/usr/bin/ld: skipping incompatible /apps/sybase/lib/libct.a when searc
+hing for -lct
/usr/bin/ld: cannot find -lct
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/Sybase/Sybase.so] Error 1
[download]

Part of my own confusion is whether I need to point the CONFIG towards the freetds directories or the sybase directories. These are errors are with the sybase directories.


dsb
This @ISA my( $cool ) %SIG

So, it might be that your Sybase installation is 32-bit. Normally, perl modules link against libraries provided by the application. In this case, linker searches for these libraries in /apps/sybase/lib, it needs library with name 'ct'. The ones that it finds are not compatible with the object currently created.

So, I would recommend you to check Sybase installation and leave CPAN alone :) You can use 'file' utility to see type of the object.

andal is bang on.
You Sybase libs are 32bit. The 64bit libs are named libct64.so (etc). However, given the name of the libs this appears to be Sybase 12.x (or maybe even earlier), and may not exist as 64bit code at all (depending on the platform).

Michael