<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Jeremy,<div><br><div><div>Am 12.09.2014 um 14:38 schrieb jérémy Blondel <<a href="mailto:jeremy.blondel.pro@gmail.com">jeremy.blondel.pro@gmail.com</a>>:</div><blockquote type="cite"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>Thanks again for your answer.<br><br></div>In fact, I haven't pkgutil installed on the machine, I install all packages with pkgadd -d <packagexxx>.pkg<br></div></div></div></div></div></div></div></div></div></div></div></blockquote><div><br></div><div>Please use pkgutil. It is easier and safer.</div><br><blockquote type="cite"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div>From my knowledge, I have followed the process :</div></div></div>- install freetds library<br></div>- install Sybase drivers<br></div></div></div></div></div></div></div></blockquote><div><br></div><div>No. With pkgutil you pick what you want and everything else is done automatically</div><div>including dependencies and necessary updates.</div><br><blockquote type="cite"><div dir="ltr"><div><div><div><div><div><div>I am not aware about OCS, in this way, I would like to use Freetds.</div></div></div></div></div></div></div></blockquote><div><br></div><div>Sure.</div><br><blockquote type="cite"><div dir="ltr"><div><div><div><div><div>Moreover, when you sais : "Please read the sections in the manual and</div>
follow these procedure and don’t manually install packages or things<br>
won’t work. There are two packages for DBD::Sybase, either linked against<br>
FreeTDS or Sybase OCS and the symlinks are done via alternatives."<br><br></div>Questions : <br></div>1°) could you please send me the url for manual to see procedure, I am not sure to have the right one.<br></div></div></div></blockquote><div><br></div><div>1. Set up local mirror</div><div>2. Install pkgutil on target machine</div><div>3. Adjust /etc/opt/csw/pkgutil.conf</div><div>4. pkgutil -y -i pm_dbd_sybase_freetds</div><div>5. Everything works</div><div><br></div><div>This is again all described in the links I already gave you:</div><div><br></div><div><blockquote type="cite"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; position: static; z-index: auto;"><div class="HOEnZb"><div class="h5">> Just start here:<br>> <a href="http://www.opencsw.org/manual/for-administrators/getting-started.html" target="_blank">http://www.opencsw.org/manual/for-administrators/getting-started.html</a><br>><br>> As you don’t have direct internet access just set up a local mirror:<br>> <a href="http://www.opencsw.org/manual/for-administrators/mirror-setup.html" target="_blank">http://www.opencsw.org/manual/for-administrators/mirror-setup.html</a><br>><br></div></div></blockquote></div></div></blockquote><br></div><div>Read the few pages for-administrators and you are all set.</div><br><blockquote type="cite"><div dir="ltr"><div>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 ?<br></div></div></blockquote><div><br></div><div>It doesn’t work afterwards.</div><div><br></div><div>Best regards</div><div><br></div><div> — Dago</div><br><blockquote type="cite"><div dir="ltr"><div><br></div>Thanks<br><br>Jeremy<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-09-12 14:27 GMT+02:00 Dagobert Michelsen <span dir="ltr"><<a href="mailto:dam@opencsw.org" target="_blank">dam@opencsw.org</a>></span>:<br><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; position: static; z-index: auto;">Hi Jeremy,<br>
<br>
Am 12.09.2014 um 14:17 schrieb jérémy Blondel <<a href="mailto:jeremy.blondel.pro@gmail.com">jeremy.blondel.pro@gmail.com</a>>:<br>
<span class="">> I have installed packages :<br>
> pm_dbd_sybase_freetds-1.11,REV=2010.11.23-SunOS5.9-sparc-CSW.pkg<br>
> freetds-0.91,REV=2011.12.17-SunOS5.9-sparc-CSW.pkg<br>
> libreadline6-6.2,REV=2011.07.02-SunOS5.9-sparc-CSW.pkg<br>
> libiconv2-1.14,REV=2011.08.07-SunOS5.9-sparc-CSW.pkg<br>
> libncurses5-5.9,REV=2011.11.21-SunOS5.9-sparc-CSW.pkg<br>
><br>
> I have edited the freetds.conf into /etc/opt/csw and I can now connect via command lines to SQL server DB.<br>
><br>
> 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,<br>
> REV=2010.11.23-SunOS5.9-sparc-CSW.pkg.<br>
><br>
> Could you please advice on this point and maybe about install procedure for this part ?<br>
><br>
> Thank you very much for your support.<br>
<br>
</span>Did you use pkgutil for installation? You are still lacking CSWalternatives<br>
and probably other things. Please read the sections in the manual and<br>
follow these procedure and don’t manually install packages or things<br>
won’t work. There are two packages for DBD::Sybase, either linked against<br>
FreeTDS or Sybase OCS and the symlinks are done via alternatives.<br>
It must look similar to this:<br>
<br>
/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<br>
total 518<br>
-r--r--r-- 1 root bin 0 Nov 23 2010 Sybase-freetds.bs<br>
-r-xr-xr-x 1 root bin 145320 Nov 23 2010 Sybase-freetds.so<br>
-r--r--r-- 1 root bin 0 Nov 23 2010 Sybase-ocs.bs<br>
-r-xr-xr-x 1 root bin 252928 Nov 23 2010 Sybase-ocs.so<br>
lrwxrwxrwx 1 root other 57 Dec 11 2012 Sybase.bs -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.bs<br>
lrwxrwxrwx 1 root other 57 Dec 11 2012 Sybase.so -> /opt/csw/lib/perl/site_perl/auto/DBD/Sybase/Sybase-ocs.so<br>
<br>
Please don’t make these links manually or things break next time!!<br>
<br>
BTW, if you use OCS instead of FreeTDS you must install or link it to<br>
/opt/csw/sybase/OCS-12_5/lib<br>
or set LD_LIBRARY_PATH.<br>
<br>
<br>
Best regards<br>
<br>
— Dago<br>
<div class="HOEnZb"><div class="h5"><br>
><br>
> Best regards<br>
><br>
> Jeremy<br>
><br>
><br>
> 2014-09-12 12:48 GMT+02:00 Dagobert Michelsen <<a href="mailto:dam@opencsw.org">dam@opencsw.org</a>>:<br>
> Hi Jeremy,<br>
><br>
> Am 12.09.2014 um 10:36 schrieb jérémy Blondel <<a href="mailto:jeremy.blondel.pro@gmail.com">jeremy.blondel.pro@gmail.com</a>>:<br>
>> Thanks for your quick answer !<br>
>><br>
>> I now understand the issue I have.<br>
>> 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 <a href="http://www.opencsw.org/packages/" target="_blank">http://www.opencsw.org/packages/</a><br>
><br>
> Yes.<br>
><br>
>> Could you please indicate me related packages I need from OpenCSW ?<br>
><br>
> Just start here:<br>
> <a href="http://www.opencsw.org/manual/for-administrators/getting-started.html" target="_blank">http://www.opencsw.org/manual/for-administrators/getting-started.html</a><br>
><br>
> As you don’t have direct internet access just set up a local mirror:<br>
> <a href="http://www.opencsw.org/manual/for-administrators/mirror-setup.html" target="_blank">http://www.opencsw.org/manual/for-administrators/mirror-setup.html</a><br>
><br>
> Please make sure to read the admin guide :-)<br>
><br>
><br>
> Best regards<br>
><br>
> — Dago<br>
><br>
> --<br>
> "You don't become great by trying to be great, you become great by wanting to do something,<br>
> and then doing it so hard that you become great in the process." - xkcd #896<br>
><br>
><br>
<br>
--<br>
"You don't become great by trying to be great, you become great by wanting to do something,<br>
and then doing it so hard that you become great in the process." - xkcd #896<br>
<br>
</div></div></blockquote></div><br></div>
</blockquote></div><br><div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span style="font-family: monospace; ">-- </span><br style="font-family: monospace; "><span style="font-family: monospace; ">"You don't become great by trying to be great, you become great by wanting to do something,</span><br style="font-family: monospace; "><span style="font-family: monospace; ">and then doing it so hard that you become great in the process." - xkcd #896</span></div>
</div>
<br></div></body></html>