Matt -

I was having a rough time with SUSE + FB, and Frank Schlottman-Goedde kindly
provided some guidance. This has worked for me, and I'm a relative newbie
to Linux.

Hope this helps...
Jeff
-----Original Message-----
From: Ross, Matt [mailto:maross@...]
Sent: Tuesday, July 03, 2001 12:18 PM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] install problem


The reason I felt it was not installed correctly was because of the
response, "package FirebirdCS-0_9-4p1_i386.rpm is not installed" and the
fact that using /opt/interbase/bin/isql resulted in a message saying that it
was not a command.

At first, I assumed that I was using isql wrong, but when the rpm told me it
wasn't installed, I decided I was out of my league and emailed for help...

Should 'isql' work similar to the 'mysql' command for MySQL?

-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Tuesday, July 03, 2001 1:45 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] install problem


"Ross, Matt" wrote:

>
> I'm having difficulty installing Firebird SQL server. There doesn't seem

to

> be any info reguarding it that I can find...
> This is on an upgraded SuSE 7.0 dist.
> FYI, I'm a linux newbie that was assigned to find a new DBMS with a

lighter

> footprint than Oracle for our smaller web apps, which will be run under
> SuSE, as we finally got the go-ahead to switch from IIS and MS SQL Server.
>
> root@heinlein:/usr/local/httpd/sql > rpm -i FirebirdCS-0_9-4p1_i386.rpm
> package FirebirdCS-0.9-4p1 is already installed
> root@heinlein:/usr/local/httpd/sql > rpm -y FirebirdCS-0_9-4p1_i386.rpm
> package FirebirdCS-0_9-4p1_i386.rpm is not installed
> root@heinlein:/usr/local/httpd/sql > rpm -i FirebirdCS-0_9-4p1_i386.rpm
> package FirebirdCS-0.9-4p1 is already installed
>

I'm at a loss to see the problem. The Classic version (CS) installs and runs
without any real problems that I can recall. In fact it is such a no-brainer
that there has to be something really simple that you have overlooked.

FWIW, I installed exactly the same rpm on my SuSE 7.0 box about three weeks
ago.
Never used it since then - until now, when I tested it. Connected and
selected
without problem. There are no known problems with running Firebird on SuSE
7.0
(which is more than can be said for RedHat 7.0).

So, question is, Why don't you think it is installed correctly?

Have you tried executing this in a console window:

/opt/interbase/bin/isql /opt/interbase/examples/employee.gdb

If it doesn't work, what error message are you getting?


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


----------

Frank Schlottmann-Goedde's instructions on firing up Firebird under SUSE 7.0

Assumes that we're using the classic version.

a.) Get the latest build from

ftp://firebird.sourceforge.net/pub/firebird/snapshot_builds/linux/fb_cs_linux_snapshot.tar.gz
(Beta-Testers are always welcome :-)

open a shell window (or a virtual console) and do sth. like

frank@franks:~ > cd /tmp
frank@franks:/tmp > mkdir fb
frank@franks:/tmp > cd fb
frank@franks:/tmp/fb > ftp firebird.sourceforge.net

Name (firebird.sourceforge.net:frank): anonymous
331 Anonymous login ok, send your complete e-mail address as password.
Password:
230 Anonymous access granted, restrictions apply.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> cd /pub/firebird/snapshot_builds/linux/
250 CWD command successful.
ftp> get fb_cs_linux_snapshot.tar.gz
226 Transfer complete.
2432962 bytes received in 05:17 (7.49 KB/s)
ftp> quit
221 Goodbye.

b.) unpack the archive:

frank@franks:/tmp/fb > tar -xzf fb_cs_linux_snapshot.tar.gz

c.) install that thing

frank@franks:/tmp/fb > cd csinstall
frank@franks:/tmp/fb/csinstall > ls
install.sh interbase.tar.gz scripts
frank@franks:/tmp/fb/csinstall > su root
Password:
root@franks:/tmp/fb/csinstall > sh ./install.sh
<snip some error messages>
Please enter new password for SYSDBA user:
Install completed
root@franks:/tmp/fb/csinstall > exit
frank@franks:/tmp/fb/csinstall >

d.) Test it:

frank@franks:/tmp/fb/csinstall > /opt/interbase/bin/isql -u SYSDBA
-p masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'test.gdb';
SQL> show version;
ISQL Version: LI-T0.9.5.211 Firebird Beta1
InterBase/linux Intel (access method), version "LI-T0.9.5.211
Firebird Beta1"
on disk structure version 10.0
SQL> quit;


I usually add the path to the binaries to /etc/profile:

# make path more comfortable
#
MACHINE=`test -x /bin/uname && /bin/uname --machine`
PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/opt/interbase/bin


hope this gets you started.

If you want to install the superserver version, you have to add
localhost to the list of trusted hosts:

echo localhost >> /etc/hosts.equiv

and you probably want to get an init script that starts the server at
boot time:
http://home.t-online.de/home/schlottmann-goedde/download/ib_suse.tar.gz


[Non-text portions of this message have been removed]