FreeTDS Development Group

[Brian Bruns <brian.bruns AT gmail.com>]

Hmmm...seems to cover all the bases.  it seems like it's not finding
it in the link path.  Do me a favor just for kicks,

export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH

and rerun.

Otherwise, are you able to run tsql?  Do an

ldd /usr/local/bin/tsql

Brian

On 4/13/05, albert wong <albert_wk_wong AT hotmail.com> wrote:
> Thanks Brian,
> 
> But I does same configuration as in Fedora Core 1 and it only doesn't work
> in Fedora Core 2.
> 
> *****Here is the libct location*****
> /usr/local/lib
> [root@dprhensim60 lib]# ls -la
> total 14436
> drwxr-xr-x   2 root root    4096 Apr 13 10:21 .
> drwxr-xr-x  15 root root    4096 Apr 12 17:52 ..
> -rw-r--r--   1 root root 1425496 Apr 13 10:21 libct.a
> -rwxr-xr-x   1 root root     689 Apr 13 10:21 libct.la
> lrwxrwxrwx   1 root root      12 Apr 13 10:21 libct.so -> libct.so.2.0
> lrwxrwxrwx   1 root root      14 Apr 13 10:21 libct.so.2 -> libct.so.2.0.0
> -rwxr-xr-x   1 root root  792737 Apr 13 10:21 libct.so.2.0
> -rwxr-xr-x   1 root root  792869 Apr 12 17:35 libct.so.2.0.0
> lrwxrwxrwx   1 root root      14 Apr 12 16:26 libct.so.3 -> libct.so.3.0.0
> -rwxr-xr-x   1 root root  837083 Apr 12 16:26 libct.so.3.0.0
> -rw-r--r--   1 root root 1564584 Apr 13 10:21 libsybdb.a
> -rwxr-xr-x   1 root root     710 Apr 13 10:21 libsybdb.la
> lrwxrwxrwx   1 root root      15 Apr 13 10:21 libsybdb.so -> libsybdb.so.4.0
> lrwxrwxrwx   1 root root      17 Apr 13 10:21 libsybdb.so.4 ->
> libsybdb.so.4.0.0
> -rwxr-xr-x   1 root root  871775 Apr 13 10:21 libsybdb.so.4.0
> -rwxr-xr-x   1 root root  872627 Apr 12 17:35 libsybdb.so.4.0.0
> lrwxrwxrwx   1 root root      17 Apr 12 16:26 libsybdb.so.5 ->
> libsybdb.so.5.0.0
> -rwxr-xr-x   1 root root  903046 Apr 12 16:26 libsybdb.so.5.0.0
> -rw-r--r--   1 root root 1175012 Apr 13 10:21 libtds.a
> -rwxr-xr-x   1 root root     696 Apr 13 10:21 libtds.la
> lrwxrwxrwx   1 root root      13 Apr 13 10:21 libtds.so -> libtds.so.3.0
> lrwxrwxrwx   1 root root      15 Apr 13 10:21 libtds.so.3 -> libtds.so.3.0.0
> -rwxr-xr-x   1 root root  646493 Apr 13 10:21 libtds.so.3.0
> -rwxr-xr-x   1 root root  647303 Apr 12 17:35 libtds.so.3.0.0
> lrwxrwxrwx   1 root root      15 Apr 12 16:26 libtds.so.4 -> libtds.so.4.0.0
> -rwxr-xr-x   1 root root  678303 Apr 12 16:26 libtds.so.4.0.0
> -rw-r--r--   1 root root 1296298 Apr 13 10:21 libtdssrv.a
> -rwxr-xr-x   1 root root     717 Apr 13 10:21 libtdssrv.la
> lrwxrwxrwx   1 root root      16 Apr 13 10:21 libtdssrv.so ->
> libtdssrv.so.1.0
> lrwxrwxrwx   1 root root      18 Apr 13 10:21 libtdssrv.so.1 ->
> libtdssrv.so.1.0.0
> -rwxr-xr-x   1 root root  704601 Apr 13 10:21 libtdssrv.so.1.0
> -rwxr-xr-x   1 root root  707683 Apr 12 17:35 libtdssrv.so.1.0.0
> lrwxrwxrwx   1 root root      18 Apr 12 16:26 libtdssrv.so.2 ->
> libtdssrv.so.2.0.0
> -rwxr-xr-x   1 root root  741870 Apr 12 16:26 libtdssrv.so.2.0.0
> 
> *****The path in CONFIG of DBD::Sybase*****
> SYBASE=/usr/local
> 
> *****The Make is successful*****
> [root@dprhensim60 DBD-Sybase-1.02]# perl Makefile.PL
> Sybase OpenClient  found.
> The DBD::Sybase module need access to a Sybase server to run the tests.
> To clear an entry please enter 'undef'
> Sybase server to use (default: JDBC):
> User ID to log in to Sybase (default: guest):
> Password (default: sybase):
> Sybase database to use on JDBC (default: pubs2):
> Note (probably harmless): No library found for -lcs
> Note (probably harmless): No library found for -lsybtcl
> Note (probably harmless): No library found for -lcomn
> Note (probably harmless): No library found for -lintl
> Using DBI 1.40 (for perl 5.008003 on i386-linux-thread-multi) installed in
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI
> Writing Makefile for DBD::Sybase
> 
> [root@dprhensim60 DBD-Sybase-1.02]# make
> gcc -c  -I/usr/local/include
> -I/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386
> -mcpu=i686   -DVERSION=\"1.02\" -DXS_VERSION=\"1.02\" -fPIC
> "-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE"   Sybase.c
> gcc -c  -I/usr/local/include
> -I/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBI
> -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386
> -mcpu=i686   -DVERSION=\"1.02\" -DXS_VERSION=\"1.02\" -fPIC
> "-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE"   dbdimp.c
> Running Mkbootstrap for DBD::Sybase ()
> chmod 644 Sybase.bs
> rm -f blib/arch/auto/DBD/Sybase/Sybase.so
> gcc  -L/usr/local/lib -shared -L/usr/local/lib Sybase.o dbdimp.o  -o
> blib/arch/auto/DBD/Sybase/Sybase.so   -L/usr/local/lib -lct -ltds -ldl -lm
> chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so
> cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs
> chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs
> Manifying blib/man3/DBD::Sybase.3
> 
> [root@dprhensim60 DBD-Sybase-1.02]# make install
> Files found in blib/arch: installing files in blib/lib into architecture
> dependent library tree
> Writing
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBD/Sybase/.packlist
> Appending installation info to
> /usr/lib/perl5/5.8.3/i386-linux-thread-multi/perllocal.pod
> 
> *****Here is the location of Sybase.so*****
> [root@dprhensim60 Sybase]# pwd
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBD/Sybase
> [root@dprhensim60 Sybase]# ls -la
> total 336
> drwxr-xr-x  2 root root   4096 Apr 12 17:38 .
> drwxr-xr-x  3 root root   4096 Apr 12 14:19 ..
> -rw-r--r--  1 root root    339 Apr 13 10:24 .packlist
> -r--r--r--  1 root root      0 Apr 12 14:18 Sybase.bs
> -r-xr-xr-x  1 root root 324542 Apr 12 17:38 Sybase.so
> 
> *****But the Sybase.so still can't recognize the libct*****
> install_driver(Sybase) failed: Can't load
> '/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
> for module DBD::Sybase: libct.so.2: cannot open shared object file: No such
> file or directory at
> /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at /download/test.pl line 4
> 
> >From: Brian Bruns <brian.bruns AT gmail.com>
> >Reply-To: brian AT bruns.com,FreeTDS Development Group
> ><freetds AT lists.ibiblio.org>
> >To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> >Subject: Re: [freetds] fedora Core 2 can't use freetds 0.6.2.1
> >Date: Wed, 13 Apr 2005 13:15:13 -0400
> >
> >Is freetds installed in someplace where the linker will find it?  If
> >not, make sure it's in the /etc/ld.so.conf or your LD_LIBRARY_PATH.
> >
> >Secondly, and maybe Michael can answer this, but does the SYBASE
> >environment variable need to be set to install DBD::Sybase, if it does
> >then set it to the directory above the lib directory where libct.so
> >lives. e.g.
> >export SYBASE=/usr/local
> >
> >Final dumb suggestion, make sure libct.so exists and got installed.
> >
> >If the easy stuff is all correct then we can look at it in more
> >detail, but I've installed on core 2 without incident.
> >
> >Brian
> >
> >On 4/13/05, albert wong <albert_wk_wong AT hotmail.com> wrote:
> > >
> > >
> > > I can use DBD-Sybase-1.02 and freetds-0.62.1 in fedora core 1. But it
> >shows
> > > following error when using in fedora core 2
> > >
> > > install_driver(Sybase) failed: Can't load
> > >
> >'/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBD/Sybase/Sybase.so'
> > > for module DBD::Sybase: libct.so.2: cannot open shared object file: No
> >such
> > > file or directory at
> > > /usr/lib/perl5/5.8.3/i386-linux-thread-multi/DynaLoader.pm line 229.
> > > at (eval 1) line 3
> > > Compilation failed in require at (eval 1) line 3.
> > > Perhaps a required shared library or dll isn't installed where expected
> > >
> > > Can anyone help?
> > > Regards,
> > > Albert
> > >
> > > >From: "albert wong" <albert_wk_wong AT hotmail.com> Reply-To: FreeTDS
> > > >Development Group <freetds AT lists.ibiblio.org> To:
> >freetds AT lists.ibiblio.org
> > > >Subject: [freetds] fedora Core 2 can't use freetds 0.6.2.1 Date: Wed,
> >13
> > > >Apr 2005 06:43:35 +0000
> > > >
> > > >
> > > >_______________________________________________ FreeTDS mailing list
> > > >FreeTDS AT lists.ibiblio.org
> >http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> > > _________________________________________________________________
> > > FREE pop-up blocking with the new MSN Toolbar - get it now!
> > > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> >_______________________________________________
> >FreeTDS mailing list
> >FreeTDS AT lists.ibiblio.org
> >http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>