From owner-freebsd-database Sun Nov 3 3:38: 9 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 622ED37B404 for ; Sun, 3 Nov 2002 03:38:06 -0800 (PST) Received: from m20.unixathome.org (m20.unixathome.org [66.11.168.227]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB37043EA9 for ; Sun, 3 Nov 2002 03:38:05 -0800 (PST) (envelope-from dan@langille.org) Received: by m20.unixathome.org (Postfix, from userid 1001) id D1ECC7A9C; Sun, 3 Nov 2002 06:37:51 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by m20.unixathome.org (Postfix) with ESMTP id 2C2AF1F07; Sun, 3 Nov 2002 06:37:51 -0500 (EST) Date: Sun, 3 Nov 2002 06:37:50 -0500 (EST) From: Dan Langille X-X-Sender: dan@m20.unixathome.org To: patrick gibson Cc: freebsd-database@freebsd.org Subject: Re: MySQL Password not masked in process listings In-Reply-To: Message-ID: <20021103063620.B12870-100000@m20.unixathome.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, 2 Nov 2002, patrick gibson wrote: > I've been noticing that in FreeBSD, when I run the MySQL client with a > password specified on the command line (eg. mysql -pMyPassword MY_DATABASE), > the password is not masked when I (or any other user!) issue a "ps" or "w" > command. > > > patrick 47724 ... 11:49AM 0:00.03 mysql -pMyPassword MY_DATABASE > > I recently switched from Linux, and somehow it knew to mask the password: > > > patrick 47724 ... 11:49AM 0:00.03 mysql -p******* MY_DATABASE > > Does anyone know if this is a FreeBSD issue, or is it a problem in the way > that MySQL is compiled for FreeBSD? It looks like Linux is familiar with mysql and masks that. It has nothing to do with mysql. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 3 3:41:19 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id AF52C37B406 for ; Sun, 3 Nov 2002 03:41:18 -0800 (PST) Received: from m20.unixathome.org (m20.unixathome.org [66.11.168.227]) by mx1.FreeBSD.org (Postfix) with ESMTP id C67F943E77 for ; Sun, 3 Nov 2002 03:41:14 -0800 (PST) (envelope-from dan@langille.org) Received: by m20.unixathome.org (Postfix, from userid 1001) id 7EB377A9B; Sun, 3 Nov 2002 06:41:11 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by m20.unixathome.org (Postfix) with ESMTP id 79AD41F07; Sun, 3 Nov 2002 06:41:11 -0500 (EST) Date: Sun, 3 Nov 2002 06:41:11 -0500 (EST) From: Dan Langille X-X-Sender: dan@m20.unixathome.org To: patrick gibson Cc: freebsd-database@freebsd.org Subject: Re: MySQL Password not masked in process listings In-Reply-To: Message-ID: <20021103064042.N12870-100000@m20.unixathome.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, 2 Nov 2002, patrick gibson wrote: > On 11/2/02 18:31, John Brooks wrote: > > > use "-p" without a password, you will be prompted for it and the > > ps listing will not be displaying it then > > I know I can do this -- but if I have a script which needs to connect to the > database, I would like to be able have a non-interactive connection. I'm > also aware that one can specify usernames and passwords in the ~/.my.cnf > file, but I connect to different databases with different passwords, so that > way would not really work for me either. > > I'm just wondering if anyone has noticed this difference between running > MySQL on FreeBSD and Linux. Perhaps you should direct your question at a mySQL list. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sun Nov 3 15:49:43 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A8FE137B401 for ; Sun, 3 Nov 2002 15:49:42 -0800 (PST) Received: from misery.sdf.com (misery.sdf.com [207.200.153.226]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5044043E75 for ; Sun, 3 Nov 2002 15:49:41 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 188TSS-0007Ro-00; Sun, 3 Nov 2002 14:43:04 -0800 Date: Sun, 3 Nov 2002 14:43:02 -0800 (PST) From: Tom Samplonius To: patrick gibson Cc: freebsd-database@freebsd.org Subject: Re: MySQL Password not masked in process listings In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, 2 Nov 2002, patrick gibson wrote: > I've been noticing that in FreeBSD, when I run the MySQL client with a > password specified on the command line (eg. mysql -pMyPassword MY_DATABASE), > the password is not masked when I (or any other user!) issue a "ps" or "w" > command. > > > patrick 47724 ... 11:49AM 0:00.03 mysql -pMyPassword MY_DATABASE > > I recently switched from Linux, and somehow it knew to mask the password: > > > patrick 47724 ... 11:49AM 0:00.03 mysql -p******* MY_DATABASE > > Does anyone know if this is a FreeBSD issue, or is it a problem in the way > that MySQL is compiled for FreeBSD? ... It is phony security. It is possible for a process to change its process name, but it can't be changed immediately, and it differs somewhat between OSes on how this works. But even on Linux, your password is visible, until mysql overwrites it. That leaves a window between the exec() of mysql and when mysql starts and overwrites the process name. I would just need to run "ps" in a loop, and I would eventually catch your password. If it would quite easy if you run mysql from Cron, and I know exactly when it will be started! Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 5 15:20:29 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2D81C37B414 for ; Tue, 5 Nov 2002 15:20:28 -0800 (PST) Received: from smtp.web.de (smtp02.web.de [217.72.192.151]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5BEAD43E42 for ; Tue, 5 Nov 2002 15:20:27 -0800 (PST) (envelope-from g.w.k@web.de) Received: from [217.232.140.183] (helo=pD9E88CB7.dip.t-dialin.net) by smtp.web.de with asmtp (WEB.DE(Exim) 4.91 #2) id 189Czg-0002EV-00 for freebsd-database@freebsd.org; Wed, 06 Nov 2002 00:20:25 +0100 Subject: Oracle 9i anyone? From: "Georg-W. Koltermann" To: freebsd-database@freebsd.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 06 Nov 2002 00:21:28 +0100 Message-Id: <1036538488.369.23.camel@bat.localnet> Mime-Version: 1.0 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi, was anyone successful installing and running Oracle9i on FreeBSD? I seem to get through with the installation if I hack genclntsh (add -L /usr/lib/gcc-lib/bla... -lgcc, and then remove "-z defs"). Unfortunately I cannot start the listener. Lsnrctl start complains "TNS-01150: The address of the specified listener name is incorrect TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))" This is with FreeBSD 4.7-Release, and with linux_base-7.1_1 and linux_devtools-7.1 (yes I also needed to add some symlinks so that sed, awk, and expr are found at the right pathes :-( ) -- Regards, Georg. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Nov 5 18:27:26 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6C19B37B401 for ; Tue, 5 Nov 2002 18:27:25 -0800 (PST) Received: from smtp2.apol.com.tw (smtp2.apol.com.tw [203.79.224.63]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4755043E77 for ; Tue, 5 Nov 2002 18:27:24 -0800 (PST) (envelope-from donny@CoreBit.com) Received: from mail.ebtnet.net (mail.ebtnet.net [203.79.224.99]) by smtp2.apol.com.tw (8.9.3/8.9.3) with ESMTP id KAA6788462 for ; Tue, 5 Nov 2002 10:24:43 +0800 (CST) Received: from sys.CoreBSD.com (167.c210-58-185.ethome.net.tw [210.58.185.167]) by mail.ebtnet.net (8.9.3/8.9.3) with ESMTP id KAA2204504 for ; Wed, 6 Nov 2002 10:27:19 +0800 (CST) Received: from CoreBit.com ([192.168.1.10]) by sys.CoreBSD.com (8.12.6/8.11.3) with ESMTP id gA62U3a8016676 for ; Wed, 6 Nov 2002 10:30:03 +0800 (CST) (envelope-from donny@CoreBit.com) Message-ID: <3DC87E06.2040106@CoreBit.com> Date: Wed, 06 Nov 2002 10:27:18 +0800 From: Donny Lee User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020314 Netscape6/6.2.2 X-Accept-Language: en, zh-tw MIME-Version: 1.0 To: freebsd-database@FreeBSD.ORG Subject: Re: Oracle 9i anyone? References: <1036538488.369.23.camel@bat.localnet> Content-Type: text/plain; charset=Big5 Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Georg-W. Koltermann wrote: > I seem to get through with the installation if I hack genclntsh (add -L > /usr/lib/gcc-lib/bla... -lgcc, and then remove "-z defs"). > > Unfortunately I cannot start the listener. Lsnrctl start complains > "TNS-01150: The address of the specified listener name is incorrect > TNS-01153: Failed to process string: > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))" > > This is with FreeBSD 4.7-Release, and with > linux_base-7.1_1 and linux_devtools-7.1 (yes I also needed to add some > symlinks so that sed, awk, and expr are found at the right pathes :-( I'm starting trying, with 5.0-Current, and not much luck. How come this list is so quite? :) -- // Donny To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Nov 6 0:10:21 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 684C537B401 for ; Wed, 6 Nov 2002 00:10:20 -0800 (PST) Received: from smtp.web.de (smtp03.web.de [217.72.192.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id 978E043E8A for ; Wed, 6 Nov 2002 00:10:19 -0800 (PST) (envelope-from g.w.k@web.de) Received: from [213.148.149.130] (helo=hunter.muc.macsch.com) by smtp.web.de with esmtp (WEB.DE(Exim) 4.91 #2) id 189LGG-0003eA-00; Wed, 06 Nov 2002 09:10:04 +0100 Subject: Re: Oracle 9i anyone? From: "Georg-W. Koltermann" To: Donny Lee Cc: freebsd-database@FreeBSD.ORG In-Reply-To: <3DC87E06.2040106@CoreBit.com> References: <1036538488.369.23.camel@bat.localnet> <3DC87E06.2040106@CoreBit.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 06 Nov 2002 09:10:44 +0100 Message-Id: <1036570251.69552.19.camel@hunter.muc.macsch.com> Mime-Version: 1.0 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Am Mi, 2002-11-06 um 03.27 schrieb Donny Lee: > [...] > I'm starting trying, with 5.0-Current, and not much luck. > > How come this list is so quite? :) > > -- > // Donny I can only figure that people (except for a very few) went away from FreeBSD as an Oracle platform, because with Oracle8i it used to be that you could not *install* Oracle on FreeBSD. The installer in 8i would only run with the included Linux JDK 1.1.8 which used native threads, and you may know that native (Linux) threads are very shaky in FreeBSD -- most times you get core dumps. With 8i you had to install Oracle on a Linux platform and then copy the directory hierarchy over to FreeBSD. Then it would work. It actually worked very reliably that way, I have been using it for about two years now, in software development. The problem is that 8i doesn't like newer Linux environments like linux_base-7.1. For native Linux there are patches by oracle which make it run, but for me the patches didn't work in FreeBSD (creating a database aborted because it couldn't figure out the tty of the current process). So now that I upgraded to 4.7R where linux_base-7.1 is the default I am inclined to also upgrade to Oracle9i and see how far I get here. -- Regards, Georg. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Nov 6 8:34:10 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D863D37B401 for ; Wed, 6 Nov 2002 08:34:08 -0800 (PST) Received: from scotth.emsphone.com (scotth.emsphone.com [199.67.51.179]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4E45143E88 for ; Wed, 6 Nov 2002 08:34:08 -0800 (PST) (envelope-from shildret@scotth.emsphone.com) Received: from scotth.emsphone.com (localhost [127.0.0.1]) by scotth.emsphone.com (8.12.3/8.12.3) with ESMTP id gA6GVEEq071894; Wed, 6 Nov 2002 10:31:14 -0600 (CST) (envelope-from shildret@scotth.emsphone.com) Received: (from shildret@localhost) by scotth.emsphone.com (8.12.3/8.12.3/Submit) id gA6GVDO1071893; Wed, 6 Nov 2002 10:31:13 -0600 (CST) Message-ID: X-Mailer: XFMail 1.5.2 on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <1036570251.69552.19.camel@hunter.muc.macsch.com> Date: Wed, 06 Nov 2002 10:31:13 -0600 (CST) From: shildreth@emsphone.com To: "Georg-W. Koltermann" Subject: Re: Oracle 9i anyone? Cc: freebsd-database@FreeBSD.ORG, Donny Lee Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Actually I was able to install 8.1.7 with the installer, if you look in the archives there was a link to instructions. On 06-Nov-2002 Georg-W. Koltermann wrote: > Am Mi, 2002-11-06 um 03.27 schrieb Donny Lee: >> [...] >> I'm starting trying, with 5.0-Current, and not much luck. >> >> How come this list is so quite? :) >> >> -- >> // Donny > > I can only figure that people (except for a very few) went away from > FreeBSD as an Oracle platform, because with Oracle8i it used to be that > you could not *install* Oracle on FreeBSD. The installer in 8i would > only run with the included Linux JDK 1.1.8 which used native threads, > and you may know that native (Linux) threads are very shaky in FreeBSD > -- most times you get core dumps. > > With 8i you had to install Oracle on a Linux platform and then copy the > directory hierarchy over to FreeBSD. Then it would work. It actually > worked very reliably that way, I have been using it for about two years > now, in software development. > > The problem is that 8i doesn't like newer Linux environments like > linux_base-7.1. For native Linux there are patches by oracle which make > it run, but for me the patches didn't work in FreeBSD (creating a > database aborted because it couldn't figure out the tty of the current > process). > > So now that I upgraded to 4.7R where linux_base-7.1 is the default I am > inclined to also upgrade to Oracle9i and see how far I get here. > > -- > Regards, > Georg. > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message ---------------------------------- E-Mail: shildreth@emsphone.com Date: 06-Nov-2002 Time: 10:29:24 ---------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Nov 6 8:38:24 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9B63637B401 for ; Wed, 6 Nov 2002 08:38:23 -0800 (PST) Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0B08543E88 for ; Wed, 6 Nov 2002 08:38:23 -0800 (PST) (envelope-from dan@langille.org) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id BADB93F4E for ; Wed, 6 Nov 2002 11:38:16 -0500 (EST) From: "Dan Langille" To: freebsd-database@FreeBSD.ORG Date: Wed, 06 Nov 2002 11:38:16 -0500 MIME-Version: 1.0 Subject: Re: Oracle 9i anyone? Message-ID: <3DC8FF28.20920.71217F47@localhost> In-reply-to: <3DC87E06.2040106@CoreBit.com> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On 6 Nov 2002 at 10:27, Donny Lee wrote: > How come this list is so quite? :) Because nobody has much to say. For what it's worth, I'm using mysql (on freebsddiary.org), postgresql (on freshports.org and freshsource.org). I much prefer postgresql, and mysql is only on freebsddiary.org because migration to postgresql is low on a long list of higher priorities. -- Dan Langille To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 7 0:35:50 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E980437B401 for ; Thu, 7 Nov 2002 00:35:49 -0800 (PST) Received: from ns2.wananchi.com (ns2.wananchi.com [62.8.64.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1363743E4A for ; Thu, 7 Nov 2002 00:35:48 -0800 (PST) (envelope-from fdisk@wananchi.com) Received: from [62.8.64.88] (helo=Gecko) by ns2.wananchi.com (Exim 4.10.8 #2 (FreeBSD)) protocol: smtp id 189i7w-00024N-00 for ; Thu, 07 Nov 2002 11:35:00 +0300 Message-ID: <004c01c28638$bbeda740$5840083e@wananchi.com> From: "Alex Vinogradoff" To: Subject: Oracle 8i Date: Thu, 7 Nov 2002 11:36:13 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *189i7w-00024N-00*jSqXWt1eYX6* Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hello, Anyone tried subj with linux_base7 ? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 7 3: 8:56 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1345037B401 for ; Thu, 7 Nov 2002 03:08:55 -0800 (PST) Received: from smtp.web.de (smtp03.web.de [217.72.192.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3E73543E4A for ; Thu, 7 Nov 2002 03:08:54 -0800 (PST) (envelope-from g.w.k@web.de) Received: from [213.148.149.130] (helo=hunter.muc.macsch.com) by smtp.web.de with esmtp (WEB.DE(Exim) 4.91 #2) id 189kWc-0004UC-00; Thu, 07 Nov 2002 12:08:38 +0100 Subject: Re: Oracle 8i From: "Georg-W. Koltermann" To: Alex Vinogradoff Cc: freebsd-database@freebsd.org In-Reply-To: <004c01c28638$bbeda740$5840083e@wananchi.com> References: <004c01c28638$bbeda740$5840083e@wananchi.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 07 Nov 2002 12:09:21 +0100 Message-Id: <1036667363.2312.5.camel@hunter.muc.macsch.com> Mime-Version: 1.0 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG I tried it a while ago on FreeBSD 4.6R. I copied Oracle 8.1.7 from a Linux machine. The Oracle software had the patches for compatibility with a current glibc already applied. I ran into a problem when I tried to create a database. I can only vaguely remember what it was exactly, but I think the message had something to do with "cannot determine tty". I traced the system calls, and it was doing stat(2)s on all the /dev/tty* nodes. Then I gave up. I am currently struggling with Oracle 9i on FreeBSD 4.7R, also with linux_base7. The best I get up to now is "lost connection" :-( -- Regards, Georg. Am Do, 2002-11-07 um 09.36 schrieb Alex Vinogradoff: > Hello, > > Anyone tried subj with linux_base7 ? > > > 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 Nov 7 7: 4:29 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C304437B401 for ; Thu, 7 Nov 2002 07:04:27 -0800 (PST) Received: from pebkac.owp.csus.edu (pebkac.owp.csus.edu [130.86.232.245]) by mx1.FreeBSD.org (Postfix) with ESMTP id 46B4A43E8A for ; Thu, 7 Nov 2002 07:04:27 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Received: (from root@localhost) by pebkac.owp.csus.edu (8.9.3/8.9.3) id HAA43790; Thu, 7 Nov 2002 07:07:34 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Received: from localhost (scottj@localhost) by pebkac.owp.csus.edu (8.9.3/8.9.3av) with ESMTP id HAA43783; Thu, 7 Nov 2002 07:07:31 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Date: Thu, 7 Nov 2002 07:07:31 -0800 (PST) From: Joseph Scott X-Sender: scottj@pebkac.owp.csus.edu To: "Georg-W. Koltermann" Cc: Alex Vinogradoff , freebsd-database@freebsd.org Subject: Re: Oracle 8i In-Reply-To: <1036667363.2312.5.camel@hunter.muc.macsch.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS perl-10 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On 7 Nov 2002, Georg-W. Koltermann wrote: # I tried it a while ago on FreeBSD 4.6R. I copied Oracle 8.1.7 from a # Linux machine. The Oracle software had the patches for compatibility # with a current glibc already applied. I've heard that this approach works, although I've never actually tried it. # I ran into a problem when I tried to create a database. I can only # vaguely remember what it was exactly, but I think the message had # something to do with "cannot determine tty". I traced the system calls, # and it was doing stat(2)s on all the /dev/tty* nodes. Then I gave up. # # I am currently struggling with Oracle 9i on FreeBSD 4.7R, also with # linux_base7. The best I get up to now is "lost connection" :-( Awhile back I came across PR docs/42058 (Installing Oracle 8i onto FreeBSD). I haven't had time to actually try this, but based on doing a recent install of Oracle8i on RedHat 7.x (.2 I think) it looks about right. You can find a complete version of the how to at : http://iamphet.fromru.com/linuxemu-oracle8i.html Note that this doc talks about doing the install on 4.5-R, so you may have to dig up some of the older linux emu packages. -Joseph To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Nov 7 21: 3: 6 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A18DE37B401 for ; Thu, 7 Nov 2002 21:03:04 -0800 (PST) Received: from ns2.wananchi.com (ns2.wananchi.com [62.8.64.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0616A43E77 for ; Thu, 7 Nov 2002 21:02:54 -0800 (PST) (envelope-from fdisk@wananchi.com) Received: from [62.8.64.88] (helo=Gecko) by ns2.wananchi.com (Exim 4.10.8 #2 (FreeBSD)) protocol: smtp id 18A1HI-0009q1-00 for ; Fri, 08 Nov 2002 08:01:56 +0300 Message-ID: <001b01c286e4$22f5e140$5840083e@wananchi.com> From: "Alex Vinogradoff" To: References: Subject: Re: Oracle 8i Date: Fri, 8 Nov 2002 08:03:10 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *18A1HI-0009q1-00*SR70xs/VRBI* Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Thanks a lot, but the question is about the linux_base7... Oracle works perfectly with linux_base6, it is known. ----- Original Message ----- From: "Joseph Scott" To: "Georg-W. Koltermann" Cc: "Alex Vinogradoff" ; Sent: Thursday, November 07, 2002 6:07 PM Subject: Re: Oracle 8i > > On 7 Nov 2002, Georg-W. Koltermann wrote: > > # I tried it a while ago on FreeBSD 4.6R. I copied Oracle 8.1.7 from a > # Linux machine. The Oracle software had the patches for compatibility > # with a current glibc already applied. > > I've heard that this approach works, although I've never actually > tried it. > > # I ran into a problem when I tried to create a database. I can only > # vaguely remember what it was exactly, but I think the message had > # something to do with "cannot determine tty". I traced the system calls, > # and it was doing stat(2)s on all the /dev/tty* nodes. Then I gave up. > # > # I am currently struggling with Oracle 9i on FreeBSD 4.7R, also with > # linux_base7. The best I get up to now is "lost connection" :-( > > Awhile back I came across PR docs/42058 (Installing Oracle 8i onto > FreeBSD). I haven't had time to actually try this, but based on doing a > recent install of Oracle8i on RedHat 7.x (.2 I think) it looks about > right. You can find a complete version of the how to at : > > http://iamphet.fromru.com/linuxemu-oracle8i.html > > Note that this doc talks about doing the install on 4.5-R, so you > may have to dig up some of the older linux emu packages. > > -Joseph > > > 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 Fri Nov 8 9:19:10 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 88C2B37B401 for ; Fri, 8 Nov 2002 09:19:09 -0800 (PST) Received: from pebkac.owp.csus.edu (pebkac.owp.csus.edu [130.86.232.245]) by mx1.FreeBSD.org (Postfix) with ESMTP id 15E2543E4A for ; Fri, 8 Nov 2002 09:19:09 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Received: (from root@localhost) by pebkac.owp.csus.edu (8.9.3/8.9.3) id JAA70552; Fri, 8 Nov 2002 09:22:17 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Received: from localhost (scottj@localhost) by pebkac.owp.csus.edu (8.9.3/8.9.3av) with ESMTP id JAA70545; Fri, 8 Nov 2002 09:22:13 -0800 (PST) (envelope-from joseph.scott@owp.csus.edu) Date: Fri, 8 Nov 2002 09:22:12 -0800 (PST) From: Joseph Scott X-Sender: scottj@pebkac.owp.csus.edu To: Alex Vinogradoff Cc: freebsd-database@freebsd.org Subject: Re: Oracle 8i In-Reply-To: <001b01c286e4$22f5e140$5840083e@wananchi.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS perl-10 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Fri, 8 Nov 2002, Alex Vinogradoff wrote: # Thanks a lot, but the question is about the linux_base7... Oracle works # perfectly with linux_base6, it is known. It doesn't work with linux_base7, period. The Oracle binaries were compiled against older pieces of linux, so it needs those present to work. This is exactly the same thing you have to do to make it work on newer versions of linux. When I installed Oracle8i on a Red Hat Linux 7.x box, I still had to install the older Red Hat 6.x pieces (glic, etc) that Oracle 8i needed to run. -Joseph To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message