From owner-freebsd-questions Fri May 11 7:34: 7 2001 Delivered-To: freebsd-questions@freebsd.org Received: from bcfw1d.bridge.com (bcfw1d.ext.bridge.com [167.76.159.31]) by hub.freebsd.org (Postfix) with ESMTP id 0205337B424 for ; Fri, 11 May 2001 07:33:58 -0700 (PDT) (envelope-from tayers@bridge.com) Received: (from uucp@localhost) by bcfw1d.bridge.com (8.10.2/8.10.2) id f4BEZ3c24963; Fri, 11 May 2001 09:35:03 -0500 (CDT) Received: from (unknown [167.76.56.34]) by bcfw1d via smap (V2.1) id xma024782; Fri, 11 May 01 09:34:37 -0500 Received: from mnmailhost (mnmailhost.bridge.com [167.76.155.14]) by mail1srv.bridge.com (8.8.8/8.7.3) with SMTP id JAA11560; Fri, 11 May 2001 09:33:26 -0500 (CDT) Received: from 89-7 by mnmailhost (SMI-8.6/SMI-4.1) id KAA03784; Fri, 11 May 2001 10:33:19 -0400 To: freebsd-questions@FreeBSD.ORG Subject: Re: DBD::Sybase References: <51442.989509075@axl.fw.uunet.co.za> From: Tim Ayers Date: 11 May 2001 09:33:16 -0500 In-Reply-To: Sheldon Hearn's message of "Thu, 10 May 2001 17:37:55 +0200" Message-ID: Lines: 87 User-Agent: Gnus/5.0803 (Gnus v5.8.3) Emacs/20.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi Sheldon, I haven't seen an answer to your question, but here's what I know... >>>>> "S" == Sheldon Hearn 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:*:: $ adduser Name: sybase Fullname: Sybase Uid: Gid: 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 ! $ 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