OpenCSW question about package CSWpm-dbd-sybase-freetds
Dagobert Michelsen
dam at opencsw.org
Fri Sep 12 14:48:43 CEST 2014
Hi Jeremy,
Am 12.09.2014 um 14:38 schrieb jérémy Blondel <jeremy.blondel.pro at gmail.com>:
> Thanks again for your answer.
>
> In fact, I haven't pkgutil installed on the machine, I install all packages with pkgadd -d <packagexxx>.pkg
Please use pkgutil. It is easier and safer.
> From my knowledge, I have followed the process :
> - install freetds library
> - install Sybase drivers
No. With pkgutil you pick what you want and everything else is done automatically
including dependencies and necessary updates.
> I am not aware about OCS, in this way, I would like to use Freetds.
Sure.
> Moreover, when you sais : "Please read the sections in the manual and
> follow these procedure and don’t manually install packages or things
> won’t work. There are two packages for DBD::Sybase, either linked against
> FreeTDS or Sybase OCS and the symlinks are done via alternatives."
>
> Questions :
> 1°) could you please send me the url for manual to see procedure, I am not sure to have the right one.
1. Set up local mirror
2. Install pkgutil on target machine
3. Adjust /etc/opt/csw/pkgutil.conf
4. pkgutil -y -i pm_dbd_sybase_freetds
5. Everything works
This is again all described in the links I already gave you:
> > Just start here:
> > http://www.opencsw.org/manual/for-administrators/getting-started.html
> >
> > As you don’t have direct internet access just set up a local mirror:
> > http://www.opencsw.org/manual/for-administrators/mirror-setup.html
> >
Read the few pages for-administrators and you are all set.
> 2°) You say two packages are available for DBD::Sybase, the one I have is therefore FreeTDS. and you said I have to install again the alternatives packages to have symlinks ?
It doesn’t work afterwards.
Best regards
— Dago
>
> Thanks
>
> Jeremy
>
> 2014-09-12 14:27 GMT+02:00 Dagobert Michelsen <dam at opencsw.org>:
> Hi Jeremy,
>
> Am 12.09.2014 um 14:17 schrieb jérémy Blondel <jeremy.blondel.pro at gmail.com>:
> > I have installed packages :
> > pm_dbd_sybase_freetds-1.11,REV=2010.11.23-SunOS5.9-sparc-CSW.pkg
> > freetds-0.91,REV=2011.12.17-SunOS5.9-sparc-CSW.pkg
> > libreadline6-6.2,REV=2011.07.02-SunOS5.9-sparc-CSW.pkg
> > libiconv2-1.14,REV=2011.08.07-SunOS5.9-sparc-CSW.pkg
> > libncurses5-5.9,REV=2011.11.21-SunOS5.9-sparc-CSW.pkg
> >
> > I have edited the freetds.conf into /etc/opt/csw and I can now connect via command lines to SQL server DB.
> >
> > However, I have now to edit my perl script by including DBD:Sybase perl module, but the Sybase.pm is not included into the package pm_dbd_sybase_freetds-1.11,
> > REV=2010.11.23-SunOS5.9-sparc-CSW.pkg.
> >
> > Could you please advice on this point and maybe about install procedure for this part ?
> >
> > Thank you very much for your support.
>
> Did you use pkgutil for installation? You are still lacking CSWalternatives
> and probably other things. Please read the sections in the manual and
> follow these procedure and don’t manually install packages or things
> won’t work. There are two packages for DBD::Sybase, either linked against
> FreeTDS or Sybase OCS and the symlinks are done via alternatives.
> It must look similar to this:
>
> /opt/csw/share/man/man3/DBD::Sybase.3 f none 0444 root bin 74333 47533 1290531466 CSWpm-dbd-sybase-freetdsunstable9s% ls -l /opt/csw/lib/perl/site_perl/auto/DBD/Sybase
> total 518
> -r--r--r-- 1 root bin 0 Nov 23 2010 Sybase-freetds.bs
> -r-xr-xr-x 1 root bin 145320 Nov 23 2010 Sybase-freetds.so
> -r--r--r-- 1 root bin 0 Nov 23 2010 Sybase-ocs.bs
> -r-xr-xr-x 1 root bin 252928 Nov 23 2010 Sybase-ocs.so
> lrwxrwxrwx 1 root other 57 Dec 11 2012 Sybase.bs -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.bs
> lrwxrwxrwx 1 root other 57 Dec 11 2012 Sybase.so -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.so
>
> Please don’t make these links manually or things break next time!!
>
> BTW, if you use OCS instead of FreeTDS you must install or link it to
> /opt/csw/sybase/OCS-12_5/lib
> or set LD_LIBRARY_PATH.
>
>
> Best regards
>
> — Dago
>
> >
> > Best regards
> >
> > Jeremy
> >
> >
> > 2014-09-12 12:48 GMT+02:00 Dagobert Michelsen <dam at opencsw.org>:
> > Hi Jeremy,
> >
> > Am 12.09.2014 um 10:36 schrieb jérémy Blondel <jeremy.blondel.pro at gmail.com>:
> >> Thanks for your quick answer !
> >>
> >> I now understand the issue I have.
> >> In this case, if I understand well, I am going to pkgrm all packages freetds and their dependencies listed in my previous mail and then install same packages from same source (OpenCSW) from here http://www.opencsw.org/packages/
> >
> > Yes.
> >
> >> Could you please indicate me related packages I need from OpenCSW ?
> >
> > Just start here:
> > http://www.opencsw.org/manual/for-administrators/getting-started.html
> >
> > As you don’t have direct internet access just set up a local mirror:
> > http://www.opencsw.org/manual/for-administrators/mirror-setup.html
> >
> > Please make sure to read the admin guide :-)
> >
> >
> > 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
> >
> >
>
> --
> "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
>
>
--
"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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencsw.org/pipermail/users/attachments/20140912/bd728d77/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2418 bytes
Desc: not available
URL: <http://lists.opencsw.org/pipermail/users/attachments/20140912/bd728d77/attachment-0001.p7s>
More information about the users
mailing list