Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [stellation-res] Firebird installation on Windows 
Hi Jonathan -

I've got Firebird running now, and will try it with Stellation shortly.
A couple of minor hiccups along the way (mostly mentioned here for
others who may want to try Firebird).

- A useful document for getting up and running quickly
is the Quick Start Guide, available at:
http://www.ibphoenix.com/downloads/qsg.pdf

- With the Firebird 1.5 RC1 installer (mentioned previously), Firebird
was installed as a service under Win2K (Service Pack 3),
in "SuperServer" rather than "Classic" mode.
After rebooting, I found that "Firebird Service Manager" had been installed as a Control Panel applet. However, the service name was not immediately apparent.
- Using Control Panel > Administrative Tools > Service, I found that Firebird 1.5 Guardian and Firebird 1.5 Server were both running as services. The Guardian service apparently monitors Firebird and restarts it if necessary (it can be disabled using the Firebird 
Service Manager applet, if desired).  The Firebird service name was also not
immediately apparent to me ("Firebird 1.5 Server" didn't work).
After a "Doh!" moment, I looked at the Properties for the Server service more closely. It clearly states, at the top, that the Service name is "FirebirdServer". No spaces. 
That worked fine, not surprisingly.

- I used IBQuery to test my installation, per your suggestion.
With the current version (MiTeC IBQuery version 3.1 [Build: 605]), the following 
steps were used to verify Firebird server installation:
1. Open Database Connection Editor (Session > Connect to Database ....)
2. Set Alias field to 'FirebirdServer'
3. Make sure Local Server radio button is selected (for server and client running 
on the same machine).
4. Enter a fully qualified pathname for a database to be created.
For example: "C:\FirebirdTest\test.fdb"
5. Enter username as 'sysdba' and password as 'masterkey'.
6. Verify SQL Dialect is set to 1.
7. Click 'Create'
The IB Query Object Explorer pane then opened to display various bits of information about 
the newly created test db.

------
I've also downloaded and built the current Stellation source (no problems here). 
(Which reminds me:  I need to apply the #36670 patch before proceeding).

Next step: add some test users and run the Ant tests.

I'll keep you posted --

Jim

At 02:17 PM 4/22/2003, Jonathan Gossage wrote:

You found the right stuff. Would you believe I was transcribing directly
from the website page and could not type. Glad that they have the installer
with RC1 now. This is new.

Regards

Jonathan

----- Original Message -----
From: "Jim Wright - IBM Research" <jwright@xxxxxxxxxxxxxx>
To: <stellation-res@xxxxxxxxxxxxxxx>
Sent: Tuesday, April 22, 2003 1:56 PM
Subject: Re: [stellation-res] Firebird installation on Windows


> Thanks, Jonathan.
>
> I'm working on it now, and noticed a couple of things.
>
> First,  I found a self-installing version:
> Firebird-1.5.0.3233_RC1_win32_setup.exe
> The install went fine, so perhaps it's not necessary to install 1.0.2
first.
>
> Second - I couldn't find "Firebird-jca-driver 1.0.0-RC3" as such.
> However, I did find "firebird-jca-jdbc-driver",
> filename  FirebirdSQL-1.0.0RC3.zip.
> I assume this is what you meant.
>
> I''ll keep you posted ---
>
> Jim
>
> At 06:57 PM 4/21/2003, Jonathan Gossage wrote:
> >First I recommend that you install Firebird 1.5 RC1. This is what I did
my
> >testing on and I had absolutely no problems with it. There is only one
> >installation catch. The 1.5 download is not a full installation but an
> >upgrade. This means that you will need to first install Firebird 1.02
which
> >is a complete installation.
> >
> >You will also need to get the JDBC-JCA driver aka Jaybird. You can find
all
> >these files at
http://sourceforge.net/project/showfiles.php?group_id=9028.
> >The specific items you want are, in order on the download page:
> >
> >Firebird-jca-driver 1.0.0-RC3
> >firebird-win32 1.5.0.3233-RC1
> >firebird-win32 1.0.2-Release
> >
> >You should download the documentation. You will need the complete
Interbase
> >documentation for InterBase 6.0
> >This can be accessed from the following link:
> >http://firebird.sourceforge.net/index.php?op=doc&id=userdoc
> >
> >The base download includes a set of command line administration tools.
There
> >are also a number of third party GUI based admin tools, both open source
and
> >commercial. The one I use is called IbAccess and is available from
> >http://www.ibaccess.org
> >
> >Setup is quite simple. First install Firebird 1.0.2 by double-clicking
the
> >downloaded executable and following the on-screen instructions. Once this
is
> >done, you can immediately upgrade to 1.5 by unzipping the 1.5 zip file on
> >top of the installed files. Just make sure you manually stop the Firebird
> >service first.\
> >
> >Then unzip the JDBC driver. There are several Jar files that you will
need
> >to make available to Stellation in the same way as the Postgres Jar.
> >Specifically, you will need firebirdjmx.jar, firebirdsql.jar,
> >mini-concurrent.jar, and mini-j2ee.jar.
> >
> >Once everything is installed, use either command line tools or ibaccess
to
> >add whatever users you need. You get the master user called sysdba with a
> >password of masterkey for free as part of the installation. Then create
the
> >Stellation database, either with ibaccess or using the technique used in
the
> >merge tests build.xml. Once this is done you are ready to go.
> >
> >All of this is from memory so I hope there are no omissions.
> >
> >Regards
> >
> >Jonathan
> >
> >
> >
> >
> >
> >_______________________________________________
> >stellation-res mailing list
> >stellation-res@xxxxxxxxxxxxxxx
> >http://dev.eclipse.org/mailman/listinfo/stellation-res
>
> --
> Jim Wright, IBM T.J. Watson Research Center
> *** The Stellation project: Advanced SCM for Collaboration
> *** http://www.eclipse.org/stellation
> *** Work Email: jwright@xxxxxxxxxxxxxx ------- Personal Email:
> jim.wright@xxxxxxx
>
> _______________________________________________
> stellation-res mailing list
> stellation-res@xxxxxxxxxxxxxxx
> http://dev.eclipse.org/mailman/listinfo/stellation-res

_______________________________________________
stellation-res mailing list
stellation-res@xxxxxxxxxxxxxxx
http://dev.eclipse.org/mailman/listinfo/stellation-res


--
Jim Wright, IBM T.J. Watson Research Center
*** The Stellation project: Advanced SCM for Collaboration
*** http://www.eclipse.org/stellation
*** Work Email: jwright@xxxxxxxxxxxxxx ------- Personal Email: jim.wright@xxxxxxx

Back to the top