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>
next in thread | raw e-mail | index | archive | help
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).=20 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=3D1009270 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=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=20 Reinoud van Leeuwen (reinoud.v@n.leeuwen.net) July 10th, 2000=20 (log in as root)=20 1: create a user sybase. give it /usr/local/sybase as home=20 directory. I gave him bash as shell and put him in the group sybase=20 2: put the following files in /usr/local (they contain the path sybase):=20 - sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz=20 - sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz=20 - sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz=20 3: untar them:=20 tar xvzf sybase-ase-11.0.3.3-FreeBSD-6.i386.tgz=20 tar xvzf sybase-doc-11.0.3.3-FreeBSD-6.i386.tgz=20 tar xvzf sybase-ocsd-10.0.4-FreeBSD-6.i386.tgz=20 rm sybase*.tgz=20 =20 4: change the ownership of the tree to sybase:=20 chown -R sybase:sybase /usr/local/sybase=20 5: install the FreeBSD linux emulation:=20 a: add the following line to /etc/rc.conf=20 linux_enable=3D"YES"=20 b: build the following ports:=20 /usr/ports/emulators/linux_base=20 (TIP: move the nluug site up in the makefile, this speeds=20 up things considerably from the Netherlands!)=20 6: build a kernel that supports System V shared memory=20 blocks=20 make sure that the following lines are in the kernel=20 config file (/sys/i386/conf/YOUR_KERNEL)=20 options SYSVSHM=20 options SYSVMSG=20 options SYSVSEM=20 options SHMMAXPGS=3D"8192"=20 options SHMMAX=3D"(SHMMAXPGS*PAGE_SIZE+1)"=20 (this might be a good time to also enable your kernel for=20 Multi processor)=20 (log in as sybase or su to it; make sure that the SYBASE=20 environment variable is=20 set to /usr/local/sybase ; the .cshrc file should set it.)=20 6: brand some executables to make sure FreeBSD knows that=20 they are Linux ones=20 brandelf -t Linux /usr/local/sybase/install/sybinit=20 brandelf -t Linux /usr/local/sybase/install/startserver=20 brandelf -t Linux /usr/local/sybase/bin/*=20 7: run ./install/sybinit=20 with this program you should be able to install a sybase=20 server and a backup server.=20 (see the included docs or the online manials on=20 http://sybooks.sybase.com) 8: Make sybase start during system boot=20 copy this script to /usr/local/etc/rc.d and make it=20 executable by root=20 #!/bin/sh=20 # start all sybase servers on this system=20 # assume that sybase is installed in the home dir of user=20 # sybase=20 export SYBASE=3D`grep -e "^sybase" /etc/passwd | cut -d: -f 6`=20 export PATH=3D"${SYBASE}/bin:${SYBASE}/install:${PATH}"=20 unset LANG=20 unset LC_ALL=20 cd ${SYBASE}/install=20 for RUN_SERVER in RUN_*=20 do=20 su sybase -c "startserver -f ${RUN_SERVER}" > /dev/null 2>&1=20 echo -n "${RUN_SERVER} "=20 done=20 echo=20 # end of script=20 Getting 2 CPU's working=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Two get Sybase running on 2 CPU's involves two steps:=20 getting Unix working on 2 CPU's and=20 configuring Sybase to use them.=20 1: Getting FreeBSD to work on 2 CPU's.=20 Build a new kernel that supports 2 CPU's.=20 run the command mptable (as root). note the last few=20 lines of output, they will tell you what=20 you should include in your kernel file.=20 Edit the Kernel file and build it. Note the messages=20 during the next reboot. It should say=20 somewhere that it uses the second CPU now.=20 2: insert the following line in the sybase.sh startup script=20 in /usr/local/etc/rc.d=20 export SRV_CPUCOUNT=3D2=20 also insert this line in the files where environment=20 variables are set for the user sybase.=20 edit the config file for the sybase server(s) on your=20 system (/usr/local/sybase/<SERVERNAME>.cfg).=20 Change the values in the line "max online engines" from=20 "Default" to "2".=20 (another option is to give the SQL command 'sp_configure=20 "max online engines",2')=20 during the next Sybase reboot, the last line in the=20 errorlog should say something like:=20 engine 1, os pid xxx online.=20 there should be two processes with the name dataserver=20 now.=20 __________________________________________________ "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 message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?39787e36.1042078>