From owner-freebsd-database Mon Dec 4 1:13:32 2000
From owner-freebsd-database@FreeBSD.ORG Mon Dec 4 01:13:30 2000
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from www.kpi.com.au (www.kpi.com.au [203.39.132.210])
by hub.freebsd.org (Postfix) with ESMTP id 5EB0A37B400
for <freebsd-database@freebsd.org>; Mon, 4 Dec 2000 01:13:29 -0800 (PST)
Received: from grail (www.kpi.com.au [203.39.132.210])
by www.kpi.com.au (8.9.3/8.9.3) with SMTP id UAA83479;
Mon, 4 Dec 2000 20:17:26 +1100 (EST)
(envelope-from shevlandj@kpi.com.au)
From: "Joe Shevland" <shevlandj@kpi.com.au>
To: "List, Interbase" <interbase@mers.com>
Cc: <freebsd-database@freebsd.org>
Subject: Interclient 1.6 on FreeBSD 4.1.1
Date: Mon, 4 Dec 2000 20:13:12 +1100
Message-ID: <IOEALGALKLLJILALBBOMGEOCCFAA.shevlandj@kpi.com.au>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Importance: Normal
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG
Just wondering if anyone has successfully set up Interclient 1.6 on =
FreeBSD? I'm using FreeBSD 4.1.1 and I've got the Interbase 6/Firebird =
1.0 server running fine, but I now need to get access to this from a =
remote Java application.
I've downloaded the Linux version of Interclient which installed fine, =
but when I do a:
telnet localhost 3060
I receive the following error message:
interserver: error in loading shared libraries: libgds.so: ELF file ABI =
version invalid.
(well, after I symlinked libgds.so into /compat/linux/lib which is where =
it was looking). I've tried branding the library with brandelf to no =
avail (different error message). Perhaps if its not too hard I can play =
with creating a native FreeBSD version.
Regards,
Joe
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message
From owner-freebsd-database Mon Dec 4 20: 4:26 2000
From owner-freebsd-database@FreeBSD.ORG Mon Dec 4 20:04:25 2000
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 B88D337B400
for <freebsd-database@freebsd.org>; Mon, 4 Dec 2000 20:04:23 -0800 (PST)
Received: from tom (helo=localhost)
by misery.sdf.com with local-esmtp (Exim 2.12 #1)
id 1438eL-00037J-00; Mon, 4 Dec 2000 19:20:13 -0800
Date: Mon, 4 Dec 2000 19:20:11 -0800 (PST)
From: Tom Samplonius <tom@sdf.com>
To: Joe Shevland <shevlandj@kpi.com.au>
Cc: "List, Interbase" <interbase@mers.com>,
freebsd-database@freebsd.org
Subject: Re: Interclient 1.6 on FreeBSD 4.1.1
In-Reply-To: <IOEALGALKLLJILALBBOMGEOCCFAA.shevlandj@kpi.com.au>
Message-ID: <Pine.BSF.4.05.10012041917540.11928-100000@misery.sdf.com>
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, 4 Dec 2000, Joe Shevland wrote:
> Just wondering if anyone has successfully set up Interclient 1.6 on
> FreeBSD? I'm using FreeBSD 4.1.1 and I've got the Interbase 6/Firebird
> 1.0 server running fine, but I now need to get access to this from a
> remote Java application.
>
> I've downloaded the Linux version of Interclient which installed fine,
> but when I do a:
>
> telnet localhost 3060
>
> I receive the following error message:
>
> interserver: error in loading shared libraries: libgds.so: ELF file
> ABI version invalid.
>
> (well, after I symlinked libgds.so into /compat/linux/lib which is
> where it was looking). I've tried branding the library with brandelf
> to no avail (different error message). Perhaps if its not too hard I
> can play with creating a native FreeBSD version.
First of all, it looks like you have a server problem, not a client
problem. The server doesn't seem to be working at all. You should
probably build a native FreeBSD version of the Interbase server, and test
with the command-line utilities first before trying to get an Interclient
app working.
Tom
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message
From owner-freebsd-database Mon Dec 4 20:27:46 2000
From owner-freebsd-database@FreeBSD.ORG Mon Dec 4 20:27:43 2000
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from www.kpi.com.au (www.kpi.com.au [203.39.132.210])
by hub.freebsd.org (Postfix) with ESMTP id EBEB937B400
for <freebsd-database@freebsd.org>; Mon, 4 Dec 2000 20:27:41 -0800 (PST)
Received: from grail (www.kpi.com.au [203.39.132.210])
by www.kpi.com.au (8.9.3/8.9.3) with SMTP id PAA88504;
Tue, 5 Dec 2000 15:31:07 +1100 (EST)
(envelope-from shevlandj@kpi.com.au)
From: "Joe Shevland" <shevlandj@kpi.com.au>
To: "Tom Samplonius" <tom@sdf.com>
Cc: "List, Interbase" <interbase@mers.com>,
<freebsd-database@freebsd.org>
Subject: RE: Interclient 1.6 on FreeBSD 4.1.1
Date: Tue, 5 Dec 2000 15:26:41 +1100
Message-ID: <IOEALGALKLLJILALBBOMEEAFCGAA.shevlandj@kpi.com.au>
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
In-Reply-To: <Pine.BSF.4.05.10012041917540.11928-100000@misery.sdf.com>
Importance: Normal
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG
Hi Tom,
Thanks for your response, but the server is working OK (using the =
Firebird kit by Geoffrey Speicher), as I can make a connection to it =
from Interbase Workbench from a remote Windows client using a standard =
TCP/IP connection to port 3050. IB Workbench worked OK, I created a new =
database and ran some simple tests as SYSDBA.
What I will need I believe is a native version of Interserver for =
FreeBSD because of where the Linux version is looking for the shared =
library 'libgds.so' (/compat/linux/lib which is fair enough as I'm =
trying to run a Linux binary).
Regards,
Joe
> -----Original Message-----
> From: Tom Samplonius [mailto:tom@sdf.com]
> Sent: Tuesday, 5 December 2000 2:20 PM
> To: Joe Shevland
> Cc: List, Interbase; freebsd-database@freebsd.org
> Subject: Re: Interclient 1.6 on FreeBSD 4.1.1
>=20
>=20
>=20
> On Mon, 4 Dec 2000, Joe Shevland wrote:
>=20
> > Just wondering if anyone has successfully set up Interclient 1.6 on
> > FreeBSD? I'm using FreeBSD 4.1.1 and I've got the Interbase =
6/Firebird
> > 1.0 server running fine, but I now need to get access to this from a
> > remote Java application.
> >=20
> > I've downloaded the Linux version of Interclient which installed =
fine,
> > but when I do a:
> >=20
> > telnet localhost 3060
> >=20
> > I receive the following error message:
> >=20
> > interserver: error in loading shared libraries: libgds.so: ELF file
> > ABI version invalid.
> >=20
> > (well, after I symlinked libgds.so into /compat/linux/lib which is
> > where it was looking). I've tried branding the library with brandelf
> > to no avail (different error message). Perhaps if its not too hard I
> > can play with creating a native FreeBSD version.
>=20
> First of all, it looks like you have a server problem, not a client
> problem. The server doesn't seem to be working at all. You should
> probably build a native FreeBSD version of the Interbase server, and =
test
> with the command-line utilities first before trying to get an =
Interclient
> app working.
>=20
> Tom
>=20
>=20
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message
From owner-freebsd-database Wed Dec 6 14:29:19 2000
From owner-freebsd-database@FreeBSD.ORG Wed Dec 6 14:29:16 2000
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from Millions.Ca (h-207-228-120-32.gen.cadvision.com [207.228.120.32])
by hub.freebsd.org (Postfix) with ESMTP id A3C8E37B402
for <freebsd-database@FreeBSD.ORG>; Wed, 6 Dec 2000 14:29:15 -0800 (PST)
Received: (from uucp@localhost)
by Millions.Ca (8.9.3/8.9.3) id PAA05087
for <freebsd-database@FreeBSD.ORG>; Wed, 6 Dec 2000 15:29:14 -0700 (MST)
(envelope-from stacy@Millions.CA)
Received: from Oak.Millions.Ca(192.168.64.1)
via SMTP by mail-gw-0.millions.ca, id smtpdwd5085; Wed Dec 6 15:29:09 2000
Received: from Millions.CA (Maple.Millions.Ca [192.168.64.2])
by oak.millions.ca (8.8.8/8.8.5) with ESMTP id PAA29748
for <freebsd-database@FreeBSD.ORG>; Wed, 6 Dec 2000 15:29:08 -0700 (MST)
Message-ID: <3A2EBDAA.A772EC9@Millions.CA>
Date: Wed, 06 Dec 2000 15:28:58 -0700
From: Stacy Millions <stacy@millions.ca>
Organization: Millions Consulting Limited
X-Mailer: Mozilla 4.75 [en] (WinNT; U)
X-Accept-Language: en-US
MIME-Version: 1.0
To: freebsd-database@FreeBSD.ORG
Subject: Oracle 8.1.6 install on FreeBSD 4-Stable
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG
Success!
I have managed to coerce Oracle8i 8.1.6 for Linux to install on
FreeBSD-Stable using that F.... umh ... Fine installer of Oracle's.
I am posting this in the hopes that it might help someone, who
is searching the mail list archives looking for tips on installing oracle.
I am not sure I could do it again... so please don't mistake this for
step by step instructions on how to do it. Rather, think of this as
my memoires (subject to the accuracy of my memory... which isn't all
that great :-)
First read the how-to:
http://www.FreeBSD.org/handbook/linuxemu-oracle.html
Oracle's install doc for Linux:
http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82848/toc.htm
and the install docs at http://www.oralinux.org/
You will need to install the Linux jre 1.1.6 from Blackdown.org. This will
not run with out manually beating on it. You need to force it to only run
with green_threads, the installer will invoke the jre for native, but
there are no native thread support with this version.
I installed it in
/compat/linux/usr/local/jre116_v5 and created a symlink
/compat/linux/usr/local/linux to point to it
I also made a /compat/linux/usr/local/jre link, but that was
because I was playing with the 8.0.5 installer at the same time.
I tried the Blackdown 1.1.8, but the oracle installer hangs after
(sometimes while) loading the splash screen. I was not able to
resolve this.
I upgraded my linux glibc to glibc-2.1.3-15. I'm not sure if this was
required or not... I had done it while trying to resolve my problems
with jre1.1.8. It doesn't seem to hurt, anyway.
Modify the install/oraparam.ini and change the JRE_LOCATION to be
JRE_LOCATION=/usr/local
runInstaller will use that to create the path to the jre exec
as /usr/local/linux/bin/jre (hence the silly symlink above).
Installer gremlins:
==================
you must have a /compat/linux/etc/mtab file that matches your mounted
file systems or the installer will die on a null pointer exception
(good error checking :-)
see: http://www.mcsr.olemiss.edu/cgi-bin/man-cgi?mtab+4
your oracle dba group and oracle install group must exist in the
/compat/linux/etc/group file or the installer will complain about
not being able to find the group (well, at least the error checking is
getting better).
your oracle user must be defined in the /compat/linux/etc/password file
or the installer will die on another null pointer exception (so
much for the error checking, again).
Root.sh
=======
When the installer prompted me to run the root.sh script,
I su'ed to root and ran /compat/oracle/bin/sh to get a 'Linux environment'
The only path that was incorrect was awk needed to be changed from
/bin/awk to /usr/bin/awk.
After running root.sh, but before continuing with the installer, you
need to change a symlink. Oracle installs a symlink $ORACLE_HOME/JRE to
point to their bundled jre, you need to remove this link and recreate it
pointing to the jre1.1.6 you installed earlier. Otherwise, when the
installer
tries to invoke the assistants at the end of the install, it will use
the bundled jre that does not work.
Unresolved issues
=================
dbassist does not run. It dies on a number format exception. I have not
tracked this one down, but I suspect it is more good error checking :-)
Can any one suggest how Oracle might be trying to calculate
Available Memory? What linux file it might be looking at that does
not exist in FreeBSD?
That is it for my memoires, I hope this helps some one else get
oracle 8.1.6 installed. Happy hacking :-)
-stacy
--
Nothing spoils fun like finding out it builds character.
- Calvin
Stacy Millions stacy@millions.ca
Millions Consulting Limited
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message