From owner-freebsd-database Thu Dec 17 19:40:41 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA07096 for freebsd-database-outgoing; Thu, 17 Dec 1998 19:40:41 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA07077; Thu, 17 Dec 1998 19:40:36 -0800 (PST) (envelope-from jfieber@indiana.edu) Received: by fallout.campusview.indiana.edu (Postfix, from userid 8489) id F07221283; Thu, 17 Dec 1998 22:40:27 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by fallout.campusview.indiana.edu (Postfix) with ESMTP id A1A4111E1; Thu, 17 Dec 1998 22:40:27 -0500 (EST) Date: Thu, 17 Dec 1998 22:40:27 -0500 (EST) From: John Fieber X-Sender: jfieber@fallout.campusview.indiana.edu To: Alfred Perlstein Cc: "current@FreeBSD.ORG" , database@FreeBSD.ORG Subject: Re: Linux Threads patches available In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Thu, 17 Dec 1998, Alfred Perlstein wrote: > Does this in any positive way impact on running Linux oracle? :) I was under the impression that the main Oracle problem was with pipes. A pipe fix went recently. Who was working on Oracle? -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 19:50:06 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA08452 for freebsd-database-outgoing; Thu, 17 Dec 1998 19:50:06 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from dingo.cdrom.com (dingo.cdrom.com [204.216.28.145]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA08414; Thu, 17 Dec 1998 19:50:01 -0800 (PST) (envelope-from mike@dingo.cdrom.com) Received: from dingo.cdrom.com (localhost.cdrom.com [127.0.0.1]) by dingo.cdrom.com (8.9.1/8.8.8) with ESMTP id TAA01102; Thu, 17 Dec 1998 19:46:07 -0800 (PST) (envelope-from mike@dingo.cdrom.com) Message-Id: <199812180346.TAA01102@dingo.cdrom.com> X-Mailer: exmh version 2.0.2 2/24/98 To: John Fieber cc: Alfred Perlstein , "current@FreeBSD.ORG" , database@FreeBSD.ORG Subject: Re: Linux Threads patches available In-reply-to: Your message of "Thu, 17 Dec 1998 22:40:27 EST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 17 Dec 1998 19:46:07 -0800 From: Mike Smith Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > On Thu, 17 Dec 1998, Alfred Perlstein wrote: > > > Does this in any positive way impact on running Linux oracle? :) > > I was under the impression that the main Oracle problem was with > pipes. A pipe fix went recently. Who was working on Oracle? Soren, before his machine was stolen. Any chance you could look at these changes in the light of the pipe-related problems you were having with Sybase? -- \\ Sometimes you're ahead, \\ Mike Smith \\ sometimes you're behind. \\ mike@smith.net.au \\ The race is long, and in the \\ msmith@freebsd.org \\ end it's only with yourself. \\ msmith@cdrom.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 20:10:30 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA10676 for freebsd-database-outgoing; Thu, 17 Dec 1998 20:10:30 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gw.caamora.com.au (jonath5.lnk.telstra.net [139.130.41.237]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA10663 for ; Thu, 17 Dec 1998 20:10:26 -0800 (PST) (envelope-from jon@gw.caamora.com.au) Received: (from jon@localhost) by gw.caamora.com.au (8.8.8/8.8.8) id PAA00698; Fri, 18 Dec 1998 15:20:05 +1100 (EST) (envelope-from jon) Message-ID: <19981218152005.A411@caamora.com.au> Date: Fri, 18 Dec 1998 15:20:05 +1100 From: jonathan michaels To: freebsd-database@FreeBSD.ORG Subject: conversion from asksam Mail-Followup-To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.1i X-Operating-System: FreeBSD gw.caamora.com.au 2.2.7-RELEASE i386 X-Mood: i'm alive, if it counts Organisation: Caamora, PO Box 144, Rosebery NSW 1445 Australia Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk all, hello, and best wishes of christmass and new year. i have recently, taken over a task that involves maintaining an asksam (for dos) database. i was thinking that it would be much easier to have an office distributable database, as opposed to teh one machine and having to update teh two others on an ad hoc basis. i realise that schemas are going to have to be built and teh asksam database exported .. this isn't a problem or an issue. what i need to know is wether or not thier is a sql (assuming sql is up to the task) based methodology to handle purely text based information and or wether or not it is possible to get text information fields to be searcable ? sorry, this is not a really formated question. my database experience is limited to fiddling dbase3 flatfiles with clipper built engines doing teh searching. any assistance would be apreciated by this sql know-nothing. well this is not strictly true, i know sql exists .. grin. regards jonathan -- =============================================================================== Jonathan Michaels PO Box 144, Rosebery, NSW 1445 Australia =========================================================== To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 20:25:28 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA12828 for freebsd-database-outgoing; Thu, 17 Dec 1998 20:25:28 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from WEBBSD1.turnaround.com.au (webbsd1.turnaround.com.au [203.39.138.49]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA12816 for ; Thu, 17 Dec 1998 20:25:23 -0800 (PST) (envelope-from J_Shevland@TurnAround.com.au) Received: from simbarchi (dhcp110.turnaround.com.au [192.168.1.110] (may be forged)) by WEBBSD1.turnaround.com.au (8.8.7/8.8.7) with SMTP id PAA08626; Fri, 18 Dec 1998 15:28:04 +1100 (EST) (envelope-from J_Shevland@TurnAround.com.au) Reply-To: From: "Joe Shevland" To: "jonathan michaels" , Subject: RE: conversion from asksam Date: Fri, 18 Dec 1998 15:23:20 +1100 Message-ID: <001601be2a3e$24ba4a40$6e01a8c0@simbarchi.turnaround.com.au> 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 8.5, Build 4.71.2173.0 In-Reply-To: <19981218152005.A411@caamora.com.au> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I'd look into MySQL or PostgreSQL, depending on your needs. MySQL is lightning fast but doesn't support more complex RDBMS features (last I checked) like triggers and stored procedures. I like PostgreSQL personally... it installs nicely, is easy to maintain, and is as powerful as I need a SQL server to be. There's also ODBC drivers for it and (I vomit to say it) a Win32 admin tool. I think this'd handle what you're after... you may need to look into full text indexing though, I'm sure there's many ways of doing this with these products. HTH, joe. > -----Original Message----- > From: owner-freebsd-database@FreeBSD.ORG > [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of jonathan > michaels > Sent: Friday, December 18, 1998 3:20 PM > To: freebsd-database@FreeBSD.ORG > Subject: conversion from asksam > > > all, > > hello, and best wishes of christmass and new year. > > i have recently, taken over a task that involves maintaining an > asksam (for > dos) database. i was thinking that it would be much easier to > have an office > distributable database, as opposed to teh one machine and having > to update teh > two others on an ad hoc basis. > > i realise that schemas are going to have to be built and teh > asksam database > exported .. this isn't a problem or an issue. what i need to know > is wether or > not thier is a sql (assuming sql is up to the task) based methodology to > handle purely text based information and or wether or not it is > possible to > get text information fields to be searcable ? > > sorry, this is not a really formated question. my database experience is > limited to fiddling dbase3 flatfiles with clipper built engines doing teh > searching. > > any assistance would be apreciated by this sql know-nothing. well > this is not > strictly true, i know sql exists .. grin. > > regards > > jonathan > > -- > ================================================================== > ============= > Jonathan Michaels > PO Box 144, Rosebery, NSW 1445 Australia > =========================================================== amora.com.au> > > > 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 Dec 17 21:23:56 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA19902 for freebsd-database-outgoing; Thu, 17 Dec 1998 21:23:56 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA19775 for ; Thu, 17 Dec 1998 21:23:51 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zqrUU-0005Hv-00; Thu, 17 Dec 1998 20:26:14 -0800 Date: Thu, 17 Dec 1998 20:26:04 -0800 (PST) From: Tom To: jonathan michaels cc: freebsd-database@FreeBSD.ORG Subject: Re: conversion from asksam In-Reply-To: <19981218152005.A411@caamora.com.au> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 18 Dec 1998, jonathan michaels wrote: > i have recently, taken over a task that involves maintaining an asksam (for > dos) database. i was thinking that it would be much easier to have an office > i realise that schemas are going to have to be built and teh asksam database > exported .. this isn't a problem or an issue. what i need to know is wether or > not thier is a sql (assuming sql is up to the task) based methodology to > handle purely text based information and or wether or not it is possible to > get text information fields to be searcable ? What kind of database is asksam? It is flat file database? You seem to imply that it is some kind of free-form text database. A SQL RDMS might be poorly suited to a free-form test system. Oracle has a cool ConText package that provides nice free-form text indexing and searching, but it is very costly and kinda of useless if you aren't going to be using the rest of Oracle too. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 21:45:52 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA21232 for freebsd-database-outgoing; Thu, 17 Dec 1998 21:45:52 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA21227 for ; Thu, 17 Dec 1998 21:45:51 -0800 (PST) (envelope-from jfieber@indiana.edu) Received: by fallout.campusview.indiana.edu (Postfix, from userid 8489) id E333E1283; Fri, 18 Dec 1998 00:45:34 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by fallout.campusview.indiana.edu (Postfix) with ESMTP id C71AD11E1; Fri, 18 Dec 1998 00:45:34 -0500 (EST) Date: Fri, 18 Dec 1998 00:45:34 -0500 (EST) From: John Fieber X-Sender: jfieber@fallout.campusview.indiana.edu To: Mike Smith Cc: Alfred Perlstein , database@FreeBSD.ORG Subject: Re: Linux Threads patches available In-Reply-To: <199812180346.TAA01102@dingo.cdrom.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Thu, 17 Dec 1998, Mike Smith wrote: > Any chance you could look at these changes in the light of the > pipe-related problems you were having with Sybase? Yes, I had planned on doing that but have not had a chance yet--sybase got bumped from my machine (disk space pressure) and I've now cleared enough spaces to stick it back on. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 22:00:33 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA22628 for freebsd-database-outgoing; Thu, 17 Dec 1998 22:00:33 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gw.caamora.com.au (jonath5.lnk.telstra.net [139.130.41.237]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA22623 for ; Thu, 17 Dec 1998 22:00:28 -0800 (PST) (envelope-from jon@gw.caamora.com.au) Received: (from jon@localhost) by gw.caamora.com.au (8.8.8/8.8.8) id RAA00877; Fri, 18 Dec 1998 17:10:10 +1100 (EST) (envelope-from jon) Message-ID: <19981218171009.C411@caamora.com.au> Date: Fri, 18 Dec 1998 17:10:09 +1100 From: jonathan michaels To: freebsd-database@FreeBSD.ORG Subject: Re: conversion from asksam Mail-Followup-To: freebsd-database@FreeBSD.ORG References: <19981218152005.A411@caamora.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.1i In-Reply-To: ; from Tom on Thu, Dec 17, 1998 at 08:26:04PM -0800 X-Operating-System: FreeBSD gw.caamora.com.au 2.2.7-RELEASE i386 X-Mood: i'm alive, if it counts Organisation: Caamora, PO Box 144, Rosebery NSW 1445 Australia Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Thu, Dec 17, 1998 at 08:26:04PM -0800, Tom wrote: > > On Fri, 18 Dec 1998, jonathan michaels wrote: > > > i have recently, taken over a task that involves maintaining an asksam (for > > dos) database. i was thinking that it would be much easier to have an office > > > i realise that schemas are going to have to be built and teh asksam database > > exported .. this isn't a problem or an issue. what i need to know is wether or > > not thier is a sql (assuming sql is up to the task) based methodology to > > handle purely text based information and or wether or not it is possible to > > get text information fields to be searcable ? > > What kind of database is asksam? a free-form text type, like isys. > It is flat file database? as far as i know. > You seem to imply that it is some kind of free-form text database. yes, that is the term, 'free-form text', i just couldn't think of it. > A SQL RDMS might be poorly suited to a free-form test system. Oracle this is what i was afraid off, but, if i can rearange the stored information, into some sort of meaningfull 'schema', i'm hoping to be abble to get away with it so to speak. > has a cool ConText package that provides nice free-form text indexing and > searching, but it is very costly and kinda of useless if you aren't going > to be using the rest of Oracle too. 'fraid not, teh client is a not-for-profit outfit govt funded to provide information to disabled people about things that disabled people want to know about .. services, availability of same, contacts for govt depts, where services are located, etc, etc, etc, etc. unless the actuall database is striped and only the raw data is stored thier is not that much data (2 to 3 meg topside). it is not a 'big' job, just sort of confusing, not to say the hardest part being to work out which database engine will be the 'best' to use. one person has suggested postgresql. it has a field called a 'tuple' that can handle textual data and can index same, sounds promicing. i will get post* a bit later on tonight and start to read. i realise that it may be over the top, very much overkill. but, as most database admins findout really quickly .. give a user a taste and they soon want more, more and more, grin. so with this view i'm looking to long term functionality, as well as scalability. regards and thank you. jonathan -- =============================================================================== Jonathan Michaels PO Box 144, Rosebery, NSW 1445 Australia =========================================================== To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 17 23:48:33 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA03547 for freebsd-database-outgoing; Thu, 17 Dec 1998 23:48:33 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from freebsd.dk (sos.freebsd.dk [212.242.42.180]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA03540; Thu, 17 Dec 1998 23:48:30 -0800 (PST) (envelope-from sos@freebsd.dk) Received: (from sos@localhost) by freebsd.dk (8.9.1/8.9.1) id IAA55168; Fri, 18 Dec 1998 08:47:47 +0100 (CET) (envelope-from sos) From: Søren Schmidt Message-Id: <199812180747.IAA55168@freebsd.dk> Subject: Re: Linux Threads patches available In-Reply-To: <199812180346.TAA01102@dingo.cdrom.com> from Mike Smith at "Dec 17, 1998 7:46: 7 pm" To: mike@smith.net.au (Mike Smith) Date: Fri, 18 Dec 1998 08:47:47 +0100 (CET) Cc: jfieber@indiana.edu, bright@hotjobs.com, current@FreeBSD.ORG, database@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk It seems Mike Smith wrote: > > On Thu, 17 Dec 1998, Alfred Perlstein wrote: > > > > > Does this in any positive way impact on running Linux oracle? :) > > > > I was under the impression that the main Oracle problem was with > > pipes. A pipe fix went recently. Who was working on Oracle? > > Soren, before his machine was stolen. I am again on my latitude, and I keep it close to me at all times :) And the pipe patch doesn't make it work, allready been there.. I'm not sure if its still pipe related or not. There is still problems, and I'm loooking at it when I have a spare hour.... If anybody wants to help, please do so... -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Søren Schmidt (sos@freebsd.org) FreeBSD Core Team member To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 05:56:43 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA10863 for freebsd-database-outgoing; Fri, 18 Dec 1998 05:56:43 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gaia.euronet.nl (gaia.euronet.nl [194.134.0.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA10852 for ; Fri, 18 Dec 1998 05:56:40 -0800 (PST) (envelope-from marcel@scc.nl) Received: from scones.sup.scc.nl (i115.ztm.euronet.nl [194.134.112.76]) by gaia.euronet.nl (8.8.8/8.8.8) with ESMTP id OAA22077; Fri, 18 Dec 1998 14:56:29 +0100 (MET) Received: from scc.nl (scones.sup.scc.nl [192.168.2.4]) by scones.sup.scc.nl (8.9.1/8.9.1) with ESMTP id OAA38574; Fri, 18 Dec 1998 14:55:45 +0100 (CET) (envelope-from marcel@scc.nl) Message-ID: <367A5EE1.A55FEC50@scc.nl> Date: Fri, 18 Dec 1998 14:55:45 +0100 From: Marcel Moolenaar Organization: S.C.C. vof X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-CURRENT i386) X-Accept-Language: en MIME-Version: 1.0 To: Sxren Schmidt , remco@scc.nl, freebsd-database@FreeBSD.ORG Subject: Re: Linux Threads patches available References: <199812180346.TAA01102@dingo.cdrom.com> <199812180747.IAA55168@freebsd.dk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Sxren Schmidt wrote: > > It seems Mike Smith wrote: > > > On Thu, 17 Dec 1998, Alfred Perlstein wrote: > > > > > > > Does this in any positive way impact on running Linux oracle? :) > > > > > > I was under the impression that the main Oracle problem was with > > > pipes. A pipe fix went recently. Who was working on Oracle? > > > > Soren, before his machine was stolen. > > I am again on my latitude, and I keep it close to me at all times :) > And the pipe patch doesn't make it work, allready been there.. > I'm not sure if its still pipe related or not. > There is still problems, and I'm loooking at it when I have a spare > hour.... > If anybody wants to help, please do so... I currently have Oracle for Linux running on my FreeBSD-current machine (the server, that is). Unfortunately I am not able to start any listeners. They fail on the IPC protocal adapter. I'll check out the pipe fixes... I had to fix (was it boken?) the linux emulator. Oracle sends a signal 0 (null) to it's first child (monitor process). "kill(pid, 0)" returns EINVAL, which Oracle does not expect. This problem is addressed in PR 9082. marcel To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 06:30:48 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA14106 for freebsd-database-outgoing; Fri, 18 Dec 1998 06:30:48 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from freebsd.dk (sos.freebsd.dk [212.242.42.180]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA14100 for ; Fri, 18 Dec 1998 06:30:41 -0800 (PST) (envelope-from sos@freebsd.dk) Received: (from sos@localhost) by freebsd.dk (8.9.1/8.9.1) id PAA55873; Fri, 18 Dec 1998 15:30:25 +0100 (CET) (envelope-from sos) From: Søren Schmidt Message-Id: <199812181430.PAA55873@freebsd.dk> Subject: Re: Linux Threads patches available In-Reply-To: <367A5EE1.A55FEC50@scc.nl> from Marcel Moolenaar at "Dec 18, 1998 2:55:45 pm" To: marcel@scc.nl (Marcel Moolenaar) Date: Fri, 18 Dec 1998 15:30:25 +0100 (CET) Cc: remco@scc.nl, freebsd-database@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk It seems Marcel Moolenaar wrote: > Sxren Schmidt wrote: > > > > It seems Mike Smith wrote: > > > > On Thu, 17 Dec 1998, Alfred Perlstein wrote: > > > > > > > > > Does this in any positive way impact on running Linux oracle? :) > > > > > > > > I was under the impression that the main Oracle problem was with > > > > pipes. A pipe fix went recently. Who was working on Oracle? > > > > > > Soren, before his machine was stolen. > > > > I am again on my latitude, and I keep it close to me at all times :) > > And the pipe patch doesn't make it work, allready been there.. > > I'm not sure if its still pipe related or not. > > There is still problems, and I'm loooking at it when I have a spare > > hour.... > > If anybody wants to help, please do so... > > I currently have Oracle for Linux running on my FreeBSD-current machine (the > server, that is). Unfortunately I am not able to start any listeners. They > fail on the IPC protocal adapter. I'll check out the pipe fixes... > > I had to fix (was it boken?) the linux emulator. Oracle sends a signal 0 > (null) to it's first child (monitor process). "kill(pid, 0)" returns EINVAL, > which Oracle does not expect. This problem is addressed in PR 9082. OK, thanks for the pointer, that should brings us a step closer!! I'll look at it asap! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Søren Schmidt (sos@freebsd.org) FreeBSD Core Team member To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 06:45:08 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA15804 for freebsd-database-outgoing; Fri, 18 Dec 1998 06:45:08 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from freebsd.dk (sos.freebsd.dk [212.242.42.180]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA15799 for ; Fri, 18 Dec 1998 06:45:05 -0800 (PST) (envelope-from sos@freebsd.dk) Received: (from sos@localhost) by freebsd.dk (8.9.1/8.9.1) id PAA55903; Fri, 18 Dec 1998 15:44:54 +0100 (CET) (envelope-from sos) From: Søren Schmidt Message-Id: <199812181444.PAA55903@freebsd.dk> Subject: Re: Linux Threads patches available In-Reply-To: <367A5EE1.A55FEC50@scc.nl> from Marcel Moolenaar at "Dec 18, 1998 2:55:45 pm" To: marcel@scc.nl (Marcel Moolenaar) Date: Fri, 18 Dec 1998 15:44:54 +0100 (CET) Cc: remco@scc.nl, freebsd-database@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk It seems Marcel Moolenaar wrote: > > I currently have Oracle for Linux running on my FreeBSD-current machine (the > server, that is). Unfortunately I am not able to start any listeners. They > fail on the IPC protocal adapter. I'll check out the pipe fixes... > > I had to fix (was it boken?) the linux emulator. Oracle sends a signal 0 > (null) to it's first child (monitor process). "kill(pid, 0)" returns EINVAL, > which Oracle does not expect. This problem is addressed in PR 9082. Tried this out allready, it doesn't help the install process, its still dies. Back to ktrace again :) -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Søren Schmidt (sos@freebsd.org) FreeBSD Core Team member To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 07:28:15 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA19914 for freebsd-database-outgoing; Fri, 18 Dec 1998 07:28:15 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gaia.euronet.nl (gaia.euronet.nl [194.134.0.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA19909 for ; Fri, 18 Dec 1998 07:28:11 -0800 (PST) (envelope-from marcel@scc.nl) Received: from scones.sup.scc.nl (i416.ztm.euronet.nl [194.134.67.137]) by gaia.euronet.nl (8.8.8/8.8.8) with ESMTP id QAA07667; Fri, 18 Dec 1998 16:27:58 +0100 (MET) Received: from scc.nl (scones.sup.scc.nl [192.168.2.4]) by scones.sup.scc.nl (8.9.1/8.9.1) with ESMTP id QAA55583; Fri, 18 Dec 1998 16:27:24 +0100 (CET) (envelope-from marcel@scc.nl) Message-ID: <367A745A.7BA34417@scc.nl> Date: Fri, 18 Dec 1998 16:27:22 +0100 From: Marcel Moolenaar Organization: S.C.C. vof X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-CURRENT i386) X-Accept-Language: en MIME-Version: 1.0 To: =?iso-8859-1?Q?S=F8ren?= Schmidt CC: freebsd-database@FreeBSD.ORG Subject: Oracle for Linux on FreeBSD [was: Re: Linux Threads patches available] References: <199812181444.PAA55903@freebsd.dk> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk "Søren Schmidt" wrote: > > It seems Marcel Moolenaar wrote: > > > > I currently have Oracle for Linux running on my FreeBSD-current machine (the > > server, that is). Unfortunately I am not able to start any listeners. They > > fail on the IPC protocal adapter. I'll check out the pipe fixes... > > > > I had to fix (was it boken?) the linux emulator. Oracle sends a signal 0 > > (null) to it's first child (monitor process). "kill(pid, 0)" returns EINVAL, > > which Oracle does not expect. This problem is addressed in PR 9082. > > Tried this out allready, it doesn't help the install process, its still > dies. Back to ktrace again :) That's because the install process fails for a completely different reason. You may want to apply the following hack: *** rdbms/install/rdbms/rdbms.vrf.orig Sat Dec 5 14:35:42 1998 --- rdbms/install/rdbms/rdbms.vrf Sat Dec 5 14:46:31 1998 *************** *** 2999,3005 **** } /* Get the dba group from the user. */ ! group_list=unix_get_groups(); /* This is to circumvent a getgroups problem on some platforms */ if (not(member(group_list, Group))) --- 2999,3006 ---- } /* Get the dba group from the user. */ ! group_list=list(); ! add(group_list, default_dba_group); /* This is to circumvent a getgroups problem on some platforms */ if (not(member(group_list, Group))) The hack merely avoids the use of unix_get_groups(), which crashes the install process just before the point when it should install the RDBMS. The hack just creates a list in which "dba" is the sole group of which the oracle user is a member. The install program still fails to relink any binaries when you use the linux_lib and linux_devel ports. I removed those ports and installed the following Redhat packages (not all packages are important, especially tcl and tk): bash-2.02-1.i386.rpm binutils-2.9.1.0.7-1.i386.rpm filesystem-1.3.1-3.noarch.rpm fileutils-3.16-9.i386.rpm gcc-2.7.2.3-11.i386.rpm glib-1.0.1-3.i386.rpm glibc-2.0.7-17.i386.rpm glibc-devel-2.0.7-17.i386.rpm grep-2.2-2.i386.rpm info-3.12-6.i386.rpm kernel-headers-2.0.34-3.i386.rpm kernel-source-2.0.34-3.i386.rpm ld.so-1.9.5-7.i386.rpm ldconfig-1.9.5-3.i386.rpm libc-5.3.12-27.i386.rpm libtermcap-2.0.8-9.i386.rpm make-3.76.1-3.i386.rpm ncurses-4.2-6.i386.rpm rpm-2.5.2-1.i386.rpm setup-1.9.1-2.noarch.rpm tcl-8.0.2-17.i386.rpm termcap-9.12.6-11.noarch.rpm tk-8.0.2-17.i386.rpm zlib-1.1.2-2.i386.rpm You can compile the Redhat package tool (rpm-2.5.1.tar.gz) under native FreeBSD... marcel PS: I've a hacked version of kdump which uses the Linux syscall tables. If you're (or anybody else, for that matter) interested, I can send it to the mailinglist. It's a hack. Nothing fancy. It's just that it prevents you (or others) for doing it again... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 08:09:44 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id IAA24966 for freebsd-database-outgoing; Fri, 18 Dec 1998 08:09:44 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from freebsd.dk (sos.freebsd.dk [212.242.42.180]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id IAA24961 for ; Fri, 18 Dec 1998 08:09:41 -0800 (PST) (envelope-from sos@freebsd.dk) Received: (from sos@localhost) by freebsd.dk (8.9.1/8.9.1) id RAA56053; Fri, 18 Dec 1998 17:09:12 +0100 (CET) (envelope-from sos) From: Søren Schmidt Message-Id: <199812181609.RAA56053@freebsd.dk> Subject: Re: Oracle for Linux on FreeBSD [was: Re: Linux Threads patches available] In-Reply-To: <367A745A.7BA34417@scc.nl> from Marcel Moolenaar at "Dec 18, 1998 4:27:22 pm" To: marcel@scc.nl (Marcel Moolenaar) Date: Fri, 18 Dec 1998 17:09:12 +0100 (CET) Cc: freebsd-database@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL43 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk It seems Marcel Moolenaar wrote: > The hack merely avoids the use of unix_get_groups(), which crashes the > install process just before the point when it should install the RDBMS. The > hack just creates a list in which "dba" is the sole group of which the oracle > user is a member. Funny enough, when I got your mail, I'm just sitting here looking at the getgroups stuff in the emulator :) > The install program still fails to relink any binaries when you use the > linux_lib and linux_devel ports. I removed those ports and installed the > following Redhat packages (not all packages are important, especially tcl and > tk): That was to be expected I guess.... > PS: I've a hacked version of kdump which uses the Linux syscall tables. If > you're (or anybody else, for that matter) interested, I can send it to the > mailinglist. It's a hack. Nothing fancy. It's just that it prevents you (or > others) for doing it again... Have you looked at linux_kdump in the ports collection, it seems you've done what others did to prevent that :) -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Søren Schmidt (sos@freebsd.org) FreeBSD Core Team member To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 08:12:40 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id IAA25342 for freebsd-database-outgoing; Fri, 18 Dec 1998 08:12:40 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from o-o.org (o-o.org [207.252.201.100]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id IAA25333 for ; Fri, 18 Dec 1998 08:12:36 -0800 (PST) (envelope-from licia@o-o.org) Received: from localhost (root@localhost) by o-o.org (8.8.8/8.8.7) with SMTP id KAA02637; Fri, 18 Dec 1998 10:11:30 -0600 (CST) Date: Fri, 18 Dec 1998 10:11:29 -0600 (CST) From: Licia To: Søren Schmidt cc: Marcel Moolenaar , freebsd-database@FreeBSD.ORG Subject: Re: DB2 for Linux [was: Re: Oracle for Linux on FreeBSD [was: Re: Linux Threads patches available]] In-Reply-To: <199812181609.RAA56053@freebsd.dk> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I'm sorry to disrupt the other conversation, but I was wondering if anyone knows if the Linux beta of DB2 runs under FreeBSD? [ licia@o-o.org ] [ http://www.o-o.org/ ] [ IrcNick : Licia ] [ A happy user of FreeBSD : http://www.freebsd.org/ ] [ Why crawl through windows when you can walk through a door? ] [ This user boycotts all Microsoft products and services ] To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 09:23:20 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA02682 for freebsd-database-outgoing; Fri, 18 Dec 1998 09:23:20 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA02677 for ; Fri, 18 Dec 1998 09:23:19 -0800 (PST) (envelope-from jfieber@indiana.edu) Received: by fallout.campusview.indiana.edu (Postfix, from userid 8489) id 6A22D12E7; Fri, 18 Dec 1998 12:23:09 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by fallout.campusview.indiana.edu (Postfix) with ESMTP id 2C60A12C4; Fri, 18 Dec 1998 12:23:10 -0500 (EST) Date: Fri, 18 Dec 1998 12:23:09 -0500 (EST) From: John Fieber X-Sender: jfieber@fallout.campusview.indiana.edu To: Mike Smith Cc: database@FreeBSD.ORG Subject: Re: Linux Threads patches available In-Reply-To: <199812180346.TAA01102@dingo.cdrom.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Thu, 17 Dec 1998, Mike Smith wrote: > Any chance you could look at these changes in the light of the > pipe-related problems you were having with Sybase? Hmmm.... I re-installed today and it looks like the async I/O on a socket that I fixed a while back is broken again. :( Exactly the same symptoms as before, the dataserver never receives SIGIO when data is available, but you can make it work by firing SIGIO signals at the process from outside. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 10:19:24 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA08713 for freebsd-database-outgoing; Fri, 18 Dec 1998 10:19:24 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gaia.euronet.nl (gaia.euronet.nl [194.134.0.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA08698 for ; Fri, 18 Dec 1998 10:19:19 -0800 (PST) (envelope-from marcel@scc.nl) Received: from scones.sup.scc.nl (i334.ztm.euronet.nl [194.134.67.95]) by gaia.euronet.nl (8.8.8/8.8.8) with ESMTP id TAA12255; Fri, 18 Dec 1998 19:19:05 +0100 (MET) Received: from scc.nl (scones.sup.scc.nl [192.168.2.4]) by scones.sup.scc.nl (8.9.1/8.9.1) with ESMTP id TAA04771; Fri, 18 Dec 1998 19:18:30 +0100 (CET) (envelope-from marcel@scc.nl) Message-ID: <367A9C76.A2BEC4E9@scc.nl> Date: Fri, 18 Dec 1998 19:18:30 +0100 From: Marcel Moolenaar Organization: S.C.C. vof X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-CURRENT i386) X-Accept-Language: en MIME-Version: 1.0 To: Licia CC: freebsd-database@FreeBSD.ORG Subject: Re: DB2 for Linux [was: Re: Oracle for Linux on FreeBSD [was: Re: Linux Threads patches available]] References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Licia wrote: > > I'm sorry to disrupt the other conversation, but I was wondering > if anyone knows if the Linux beta of DB2 runs under FreeBSD? Sorry... I have not been paying any attention to non-oracle databases :-) marcel To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 18 10:42:47 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA12025 for freebsd-database-outgoing; Fri, 18 Dec 1998 10:42:47 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from gaia.euronet.nl (gaia.euronet.nl [194.134.0.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA12015 for ; Fri, 18 Dec 1998 10:42:44 -0800 (PST) (envelope-from marcel@scc.nl) Received: from scones.sup.scc.nl (i439.ztm.euronet.nl [194.134.67.160]) by gaia.euronet.nl (8.8.8/8.8.8) with ESMTP id TAA18998 from for ; Fri, 18 Dec 1998 19:42:33 +0100 (MET) Received: from scc.nl (scones.sup.scc.nl [192.168.2.4]) by scones.sup.scc.nl (8.9.1/8.9.1) with ESMTP id TAA05532 for ; Fri, 18 Dec 1998 19:41:59 +0100 (CET) (envelope-from marcel@scc.nl) Message-ID: <367AA1F7.BA79848B@scc.nl> Date: Fri, 18 Dec 1998 19:41:59 +0100 From: Marcel Moolenaar Organization: S.C.C. vof X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-CURRENT i386) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-database@FreeBSD.ORG Subject: Re: Oracle for Linux on FreeBSD [was: Re: Linux Threads patches available] References: <367A745A.7BA34417@scc.nl> <199812181609.RAA56053@freebsd.dk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Sxren Schmidt wrote: > > It seems Marcel Moolenaar wrote: > > > PS: I've a hacked version of kdump which uses the Linux syscall tables. If > > you're (or anybody else, for that matter) interested, I can send it to the > > mailinglist. It's a hack. Nothing fancy. It's just that it prevents you (or > > others) for doing it again... > > Have you looked at linux_kdump in the ports collection, it seems you've > done what others did to prevent that :) Desperately looking for a way to restore some credibility: scones# make ===> linux_kdump-1.0 is marked as broken: During build fails makesyscalls. :-) marcel To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message