Date: Thu, 20 Jul 2000 22:44:02 GMT From: reinoud@xs4all.nl (Reinoud van Leeuwen) To: freebsd-database@freebsd.org Subject: Sybase 11.0.3.3 with support for FreeBSD is out! Message-ID: <39787e36.1042078@smtp.xs4all.nl>
index | next in thread | raw e-mail
Sybase has made an update of their free 11.0.3.3 SQL server available. This updated version includes some bug fixes and *FreeBSD support*. the 11.0.3.3 version is unsupported, but Free for development *and production*! The server still runs under the Linux emulation, but theere is a native SDK (libraries). download on http://www.sybase.com/linux/ase/ (Sybase would like you to regsiter before download, please indicate that you use FreeBSD :-) some extra info on: http://my.sybase.com/detail?id=1009270 Here are the notes I made to get everything working (still working on things like sybperl, dbd::sybase and PHP :-) notes on getting sybase to work on FreeBSD 4.0 RELEASE ====================================================== Reinoud van Leeuwen (reinoud.v@n.leeuwen.net) July 10th, 2000 (log in as root) 1: create a user sybase. give it /usr/local/sybase as home directory. I gave him bash as shell and put him in the group sybase 2: put the following files in /usr/local (they contain the path sybase): - sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz - sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz - sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz 3: untar them: tar xvzf sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz tar xvzf sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz tar xvzf sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz rm sybase*.tgz 4: change the ownership of the tree to sybase: chown -R sybase:sybase /usr/local/sybase 5: install the FreeBSD linux emulation: a: add the following line to /etc/rc.conf linux_enable="YES" b: build the following ports: /usr/ports/emulators/linux_base (TIP: move the nluug site up in the makefile, this speeds up things considerably from the Netherlands!) 6: build a kernel that supports System V shared memory blocks make sure that the following lines are in the kernel config file (/sys/i386/conf/YOUR_KERNEL) options SYSVSHM options SYSVMSG options SYSVSEM options SHMMAXPGS="8192" options SHMMAX="(SHMMAXPGS*PAGE_SIZE+1)" (this might be a good time to also enable your kernel for Multi processor) (log in as sybase or su to it; make sure that the SYBASE environment variable is set to /usr/local/sybase ; the .cshrc file should set it.) 6: brand some executables to make sure FreeBSD knows that they are Linux ones brandelf -t Linux /usr/local/sybase/install/sybinit brandelf -t Linux /usr/local/sybase/install/startserver brandelf -t Linux /usr/local/sybase/bin/* 7: run ./install/sybinit with this program you should be able to install a sybase server and a backup server. (see the included docs or the online manials on http://sybooks.sybase.com) 8: Make sybase start during system boot copy this script to /usr/local/etc/rc.d and make it executable by root #!/bin/sh # start all sybase servers on this system # assume that sybase is installed in the home dir of user # sybase export SYBASE=`grep -e "^sybase" /etc/passwd | cut -d: -f 6` export PATH="${SYBASE}/bin:${SYBASE}/install:${PATH}" unset LANG unset LC_ALL cd ${SYBASE}/install for RUN_SERVER in RUN_* do su sybase -c "startserver -f ${RUN_SERVER}" > /dev/null 2>&1 echo -n "${RUN_SERVER} " done echo # end of script Getting 2 CPU's working ======================= Two get Sybase running on 2 CPU's involves two steps: getting Unix working on 2 CPU's and configuring Sybase to use them. 1: Getting FreeBSD to work on 2 CPU's. Build a new kernel that supports 2 CPU's. run the command mptable (as root). note the last few lines of output, they will tell you what you should include in your kernel file. Edit the Kernel file and build it. Note the messages during the next reboot. It should say somewhere that it uses the second CPU now. 2: insert the following line in the sybase.sh startup script in /usr/local/etc/rc.d export SRV_CPUCOUNT=2 also insert this line in the files where environment variables are set for the user sybase. edit the config file for the sybase server(s) on your system (/usr/local/sybase/<SERVERNAME>.cfg). Change the values in the line "max online engines" from "Default" to "2". (another option is to give the SQL command 'sp_configure "max online engines",2') during the next Sybase reboot, the last line in the errorlog should say something like: engine 1, os pid xxx online. there should be two processes with the name dataserver now. __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud@xs4all.nl http://www.xs4all.nl/~reinoud __________________________________________________ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the messagehelp
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?39787e36.1042078>