Date: 11 May 2001 09:33:16 -0500 From: Tim Ayers <tayers@bridge.com> To: freebsd-questions@FreeBSD.ORG Subject: Re: DBD::Sybase Message-ID: <heysc5w3.fsf@tim.bridge.com> In-Reply-To: Sheldon Hearn's message of "Thu, 10 May 2001 17:37:55 %2B0200" References: <51442.989509075@axl.fw.uunet.co.za>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Sheldon, I haven't seen an answer to your question, but here's what I know... >>>>> "S" == Sheldon Hearn <sheldonh@uunet.co.za> writes: S> Has anyone managed to get DBD::Sybase to build and link against the S> libraries installed by FreeTDS on FreeBSD? FreeTDS exists in the ports S> tree, but DBD::Sybase doesn't seem to. I have not used FreeTDS, but I have used Sybase's FreeBSD libraries to get DBD::Sybase working. It's slightly involved, but not too bad. These are the steps I used (logged in as root of course). # Add a group and user for sybase $ vi /etc/group - Add sybase:*:<something unique>: $ adduser Name: sybase Fullname: Sybase Uid: <whatever> Gid: <whatever sybase group is> Class: Groups: HOME: /usr/local/sybase Shell: /usr/local/bin/bash pass: xxxxxx # Add SYBASE variable to everyone's environment $ vi /etc/profile - Add export SYBASE=/usr/local/sybase # Get the FreeBSD Sybase libraries $ cd /usr/local/src $ ftp http://linux.sybase.com/REL11033/sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz $ ftp http://linux.sybase.com/REL11033/sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz $ ftp http://linux.sybase.com/REL11033/sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz # Extract the sybase libraries $ su sybase $ cd /usr/local $ tar xvpzf /usr/local/src/sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz $ tar xvpzf /usr/local/src/sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz $ tar xvpzf /usr/local/src/sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz # Add your interfaces info. NOTE! The interfaces file on FreeBSD can # be (needs to be?) in the old, easy-to-read format. For example, # here's mine. The master/query lines need to start with a <TAB>! $ cat ~sybase/interfaces HGOVCDEV master tcp ether hgovcdev 4074 query tcp ether hgovcdev 4074 HMUNICENT master tcp ether hmunicent 4074 query tcp ether hmunicent 4074 # stop being user 'sybase' $ exit # Install DBD::Sybase $ perl -MCPAN -eshell cpan> install DBI ... cpan> look DBD::Sybase ... Trying to open a subshell in the build directory... $ vi PWD # add your testing server, user, password info $ perl Makefile.pl $ make && make test $ make $ exit # go back to CPAN $ exit Congratulations. You've successfully installed DBD::Sybase on FreeBSD. :-) HTH and Hope you have a very nice day, :-) Tim Ayers (tayers@bridge.com) P.S. Sybase has Linux RPM's for new versions of Sybase (11.9.2 and 12.0), but only FreeBSD tarballs for 11.0.3.3. I use these OCSD libraries with 11.9.2 servers without any problems. I haven't tried to extract the RPMs. You can find everything at "ftp linux.sybase.com". To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?heysc5w3.fsf>