From owner-freebsd-database Mon Jul 17 10:21:36 2000 Delivered-To: freebsd-database@freebsd.org Received: from mail2.uniserve.com (mail2.uniserve.com [204.244.156.10]) by hub.freebsd.org (Postfix) with ESMTP id 20CEC37BAC2 for ; Mon, 17 Jul 2000 10:21:33 -0700 (PDT) (envelope-from tom@uniserve.com) Received: from shell.uniserve.ca ([204.244.186.218]) by mail2.uniserve.com with esmtp (Exim 3.13 #1) id 13EEa3-0004Sn-00; Mon, 17 Jul 2000 10:21:23 -0700 Date: Mon, 17 Jul 2000 10:21:20 -0700 (PDT) From: Tom X-Sender: tom@shell.uniserve.ca To: Rich Cc: freebsd-database@freebsd.org Subject: Re: Maybe someone here has a solution? In-Reply-To: <002c01bff008$fc0a95e0$86a9e0d0@devnull.sprawlnet.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Mon, 17 Jul 2000, Rich wrote: > Most of our machines in this office run FreeBSD-3.x or 4.x and I need > to write an application that selects certain info from an Informix > database and displays the results in HTML. The Informix DB is on a SCO > OpenServer 5.x boxen ... > > I can very easily use APACHE/Mod_Perl + ESQL/C to write this > application ... but I can't find any info on using esql/c on a freebsd > box or even something similar that I can use. > > Anyone have any idea's or suggestions for th ebest solution? > > -thanks > Rich This belongs on freebsd-database, not freebsd-stable There are no Informix client drivers for FreeBSD. There should be a type 4 JDBC driver available, which would work, but it would require that you use Java. Tom Uniserve To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jul 19 7:35:51 2000 Delivered-To: freebsd-database@freebsd.org Received: from chmls06.mediaone.net (chmls06.mediaone.net [24.147.1.144]) by hub.freebsd.org (Postfix) with ESMTP id A52C137BFE2 for ; Wed, 19 Jul 2000 07:35:48 -0700 (PDT) (envelope-from pulsifer@mediaone.net) Received: from ahp3 (ahp.ne.mediaone.net [24.128.184.250]) by chmls06.mediaone.net (8.8.7/8.8.7) with SMTP id KAA23972 for ; Wed, 19 Jul 2000 10:35:46 -0400 (EDT) From: "Allen Pulsifer" To: Subject: Raima Database Manager aka Centura RDM Date: Wed, 19 Jul 2000 10:35:47 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Does anyone have any experience with Raima Database Manager? It looks like Centura now offers that products as Centura RDM, and has also released it open source as db.linux and db.star (their marketing dept is very confused). Is anyone trying/tried to use it as open source? What has been your experience with Raima Database Manager? Its looking like to only supports fixed length records. Can anyone confirm that? Thanks, Allen To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jul 19 8:21:38 2000 Delivered-To: freebsd-database@freebsd.org Received: from mogwai.math.uwaterloo.ca (mogwai.math.uwaterloo.ca [129.97.140.147]) by hub.freebsd.org (Postfix) with ESMTP id 64A3A37B86E for ; Wed, 19 Jul 2000 08:21:30 -0700 (PDT) (envelope-from sgkruk@barrow.uwaterloo.ca) Received: (from sgkruk@localhost) by mogwai.math.uwaterloo.ca (8.9.2/8.9.2) id LAA55340; Wed, 19 Jul 2000 11:17:27 -0400 (EDT) (envelope-from sgkruk@barrow.uwaterloo.ca) Date: Wed, 19 Jul 2000 11:17:27 -0400 (EDT) Message-Id: <200007191517.LAA55340@mogwai.math.uwaterloo.ca> X-Authentication-Warning: mogwai.math.uwaterloo.ca: sgkruk set sender to sgkruk@barrow.uwaterloo.ca using -f From: "Serge G. Kruk" To: pulsifer@mediaone.net Cc: freebsd-database@FreeBSD.ORG In-reply-to: Subject: Re: Raima Database Manager aka Centura RDM References: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I've used DbRaima about 10 years ago (was called dbVista then). It was then available in source form (at a fairly high price) and I found it exceptional. At the time I compared it to the handful of DB manager that were available and found it to be the most efficient and easiest to use, by far. They were not relational but used a Network design for better performance. During the past ten years, I would suspect it improved in flexibility and degraded in performance but if they kept their original philosophy, it must still be a terrific manager. Sorry if my information is stale. Serge From: "Allen Pulsifer" Date: Wed, 19 Jul 2000 10:35:47 -0400 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Sender: owner-freebsd-database@FreeBSD.ORG X-Loop: FreeBSD.ORG Precedence: bulk Does anyone have any experience with Raima Database Manager? It looks like Centura now offers that products as Centura RDM, and has also released it open source as db.linux and db.star (their marketing dept is very confused). Is anyone trying/tried to use it as open source? What has been your experience with Raima Database Manager? Its looking like to only supports fixed length records. Can anyone confirm that? Thanks, Allen To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Jul 20 15:44: 7 2000 Delivered-To: freebsd-database@freebsd.org Received: from smtp9.xs4all.nl (smtp9.xs4all.nl [194.109.127.135]) by hub.freebsd.org (Postfix) with ESMTP id 36D2B37C153 for ; Thu, 20 Jul 2000 15:43:47 -0700 (PDT) (envelope-from reinoud@xs4all.nl) Received: from mir.xs4all.nl (mir.xs4all.nl [194.109.55.190]) by smtp9.xs4all.nl (8.9.3/8.9.3) with SMTP id AAA17034 for ; Fri, 21 Jul 2000 00:43:38 +0200 (CEST) From: reinoud@xs4all.nl (Reinoud van Leeuwen) To: freebsd-database@freebsd.org Subject: Sybase 11.0.3.3 with support for FreeBSD is out! Date: Thu, 20 Jul 2000 22:44:02 GMT Organization: Not organized in any way Reply-To: reinoud@xs4all.nl Message-ID: <39787e36.1042078@smtp.xs4all.nl> X-Mailer: Forte Agent 1.5/32.451 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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/.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 From owner-freebsd-database Sat Jul 22 22:57:36 2000 Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id B174B37B8F7 for ; Sat, 22 Jul 2000 22:57:31 -0700 (PDT) (envelope-from fjoe@iclub.nsu.ru) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.9.3/8.9.3) with ESMTP id MAA73342; Sun, 23 Jul 2000 12:56:58 +0700 (NSS) (envelope-from fjoe@iclub.nsu.ru) Date: Sun, 23 Jul 2000 12:56:58 +0700 (NSS) From: Max Khon To: Reinoud van Leeuwen Cc: freebsd-database@FreeBSD.ORG Subject: Re: Sybase 11.0.3.3 with support for FreeBSD is out! In-Reply-To: <39787e36.1042078@smtp.xs4all.nl> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG hi, there! On Thu, 20 Jul 2000, Reinoud van Leeuwen wrote: > 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 GREAT! but registration does not work at this time (at least for me) /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Jul 22 23:56:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 86BAC37B8C0 for ; Sat, 22 Jul 2000 23:56:15 -0700 (PDT) (envelope-from tom@sdf.com) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13GFLO-0006lP-00; Sat, 22 Jul 2000 23:34:34 -0700 Date: Sat, 22 Jul 2000 23:34:30 -0700 (PDT) From: Tom Samplonius To: Max Khon Cc: Reinoud van Leeuwen , freebsd-database@FreeBSD.ORG Subject: Re: Sybase 11.0.3.3 with support for FreeBSD is out! In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Sun, 23 Jul 2000, Max Khon wrote: > hi, there! > > On Thu, 20 Jul 2000, Reinoud van Leeuwen wrote: > > > 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 > > GREAT! but registration does not work at this time (at least for me) It seems that the registration links are dead. Up in the top right corner this is a direct link to the Download page. However, on the download page, the link to the documentation tarball actually links to the server tarball! You will have to copy the URL and edit it, in order to download the documentation tarball. > /fjoe Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message