[csw-users] DBD::Sybase perl module

[Dagobert Michelsen]

Hi Chirag,

Am 11.12.2012 um 15:57 schrieb <chirag.parikh at thomsonreuters.com>:
> Thanks. I had installed both freetds and OCS, but neither seem to have Sybase.pm module, or do they?

They do:
  /opt/csw/lib/perl/site_perl/DBD/Sybase.pm f none 0444 root bin 75443 5553 1289051389 CSWpm-dbd-sybase-freetds

The FreeTDS-flavor contains the basic stuff for DBD::Sybase, the OCS-flavor is an addon that
takes precedence:

-r--r--r--   1 root     bin            0 Nov 23  2010 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-freetds.bs
-r-xr-xr-x   1 root     bin       145320 Nov 23  2010 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-freetds.so
-r--r--r--   1 root     bin            0 Nov 23  2010 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.bs
-r-xr-xr-x   1 root     bin       252928 Nov 23  2010 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.so
lrwxrwxrwx   1 root     other         57 Dec 11 16:02 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase.bs -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.bs
lrwxrwxrwx   1 root     other         57 Dec 11 16:02 /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase.so -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.so

> I'll try setting LD path variable as you suggested since Sybase installation is in different path and let you know. Thanks.

This must work without errors:
  ldd -r /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase.so

If you have a different path you can either symlink /opt/csw/sybase/OCS-12_5/lib to your location
(recommended) or use LD_LIBRARY_PATH to point to your lib location.


Best regards

  -- Dago


> 
> Chirag.
> 
> ----- Original Message -----
> From: Dagobert Michelsen [mailto:dam at opencsw.org]
> Sent: Tuesday, December 11, 2012 02:46 AM
> To: Questions and discussions <users at lists.opencsw.org>
> Subject: Re: [csw-users] DBD::Sybase perl module
> 
> Hi Chirag,
> 
> Am 10.12.2012 um 22:06 schrieb <chirag.parikh at thomsonreuters.com>:
>> I'm getting below errors. It seems that DBD::Sybase perl module is missing and I can't locate it via "pkgutil". Please help!
> 
> What commands did you try? There are two flavors of DBD::Sybase, one with Sybase ASE
> bindings and one for FreeTDS:
> 
>> dam at login [login]:/export/mirror/opencsw-official > pkgutil -a sybase
>> You're not root and didn't set -W, using home dir.
>> => Fetching new catalog and descriptions (file:///export/mirror/opencsw-official/unstable/sparc/5.10) if available ...
>> Checking integrity of /home/dam/.pkgutil/catalog._export_mirror_opencsw-official_unstable_sparc_5.10 with gpg.
>> gpg: Signature made Tue Dec 11 06:46:38 2012 CET using DSA key ID 9306CC77
>> gpg: Good signature from "OpenCSW catalog signing <board at opencsw.org>"
>> gpg: WARNING: This key is not certified with a trusted signature!
>> gpg:          There is no indication that the signature belongs to the owner.
>> Primary key fingerprint: 4DCE 3C80 AAB2 CAB1 E60C  9A3C 05F4 2D66 9306 CC77
>> ==> 3560 packages loaded from /home/dam/.pkgutil/catalog._export_mirror_opencsw-official_unstable_sparc_5.10
>> common               package              catalog                        size
>> pm_dbd_sybase_freetds CSWpm-dbd-sybase-freetds 1.11,REV=2010.11.23        119.9 KB
>> pm_dbd_sybase_ocs    CSWpm-dbd-sybase-ocs 1.11,REV=2010.11.23         96.7 KB
> 
> 
> 
>> install_driver(Sybase) failed: Can't locate loadable object for module DBD::Sybase in @INC (@INC contains: /ilx/lib /opt/csw/lib/perl/site_perl /opt/csw/share/perl/site_perl /opt/csw/lib/perl/csw /opt/csw/share/perl/csw /opt/csw/lib/perl/5.10.1 /opt/csw/share/perl/5.10.1 .) at (eval 10) line 3
>> Compilation failed in require at (eval 10) line 3.
>> Perhaps a module that DBD::Sybase requires hasn't been fully installed
> 
> 
> After installation you need to have the Sybase OCS installation in /opt/csw/sybase/OCS-12_5
> as the RUNPATH is included in the Perl module:
>  [10]    RUNPATH         /opt/csw/sybase/OCS-12_5/lib
> You can also set the LD_LIBRARY_PATH to match if you have a different location.
> 
> 
> Best regards
> 
>  -- Dago
> 
> 
> -- 
> "You don't become great by trying to be great, you become great by wanting to do something,
> and then doing it so hard that you become great in the process." - xkcd #896
> 
> _______________________________________________
> users mailing list
> users at lists.opencsw.org
> https://lists.opencsw.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users at lists.opencsw.org
> https://lists.opencsw.org/mailman/listinfo/users

-- 
"You don't become great by trying to be great, you become great by wanting to do something,
and then doing it so hard that you become great in the process." - xkcd #896