--- In firebird-support@yahoogroups.com, "federonline"
<federonline@...> wrote:

>
> Greets.
>
> I just started porting a fairly large project to Ubuntu, which raised
> a couple questions.
>
> I started on FB 2.01; can anyone say when this will be released on
> Ubuntu? I use some features that would make going back difficult.
>
> Can I EASILY do something to step over their installation and install
> 2.01 or 2.03?
>
> I appreciate the advice; it's been 8 years since I worked on *NIX.
> Kurt.
>

Don't wait untill you will can install Firebird 2 on Ubuntu with apt-get.

This should be available after moderator aproval on HowTo Forge.

step 1. Prepare an nice Ubuntu server : fire a "The Perfect Setup -
Ubuntu" search on HowTo forge and follow the steps according to the OS
version you are decided to go on.

step 2. Do the libstdc++5 installation (before installing Firebird)


user@machine:~# sudo apt-get install libstdc++5

step 3. Download and expand Firebird installation kit from
http://firebirdsql.org (downloads) or source force : the 2.0.3 NTPL
superserver.

- for 32 bit OS :

user@machine:~# sudo wget
http://downloads.sourceforge.net/firebird/FirebirdSS-2.0.3.12981-1.nptl.i686.tar.gz


user@machine:~# sudo tar -xvf FirebirdSS-2.0.3.12981-1.nptl.i686.tar.gz


user@machine:~# cd cd FirebirdSS-2.0.3.12981-1.i686

- for 64 bit OS :

user@machine:~# sudo wget
http://downloads.sourceforge.net/firebird/FirebirdSS-2.0.3.12981-1.amd64.tar.gz


user@machine:~# sudo tar -xvf FirebirdSS-2.0.3.12981-1.amd64.tar.gz


user@machine:~# cd FirebirdSS-2.0.3.12981-1.amd64

(remark : is NTPL by default for 64 bit OS)

step 4. install Firebird.


- user@machine:~# sudo ./install.sh

(remark : install script will prompt you twice for the SYSDBA password

step 5. do some UDF's housekeeping.

- if you have UDF's please (sudo) put them in /opt/firebird/UDF/
folder. Of course the UDF's must be compiled according to OS version ....
- change rights on UDF's folder :

user@machine:~# sudo chown root:root /opt/firebird/UDF/*


user@machine:~# sudo chmod 444 /opt/firebird/UDF/*

- and restart firebird :

user@machine:~# sudo /etc/init.d/firebird reload

optional step 6. Move your data :
- do a backup on the old machine :
<put path (include ending slash at the end) to gbak here>gbak -b -t
-v -USER SYSDBA -PASS <put SYSDBA password here> <put path and name of
the database here> <put path and name of the backup file here>

- made home of the new database on the new machine :

user@machine:~# sudo mkdir <put path to the database location here>

- and give Firebird the needed rights there :

user@machine:~# sudo chown firebird:firebird <put path to the database
(include ending slash at the end) location here>


- move the backup file from old to the new machine in the <put path to
the database (include ending slash at the end) location here> folder
and restore data :

<put path (include ending slash at the end) to gbak here>gbak -c -v
-t -USER

SYSDBA -PASS <put SYSDBA password here> <put path and name of the
backup file

here> <put path and name of the database here>

Enjoy.