Table of contents
No headerssource
step 1. Prepare a nice Ubuntu server : fire up 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 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 may 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>
You are not logged in. Log in 
I successfully installed Linux Firebird on Puppy Linux. Puppy is not multi-user, and Firebird requires a user=firebird and a group=firebird to install. Puppy Linux has a small package called tinylogin to create the required user and group, but, of course it has one small bug.
After installing tinylogin using the "PetGet" package manager, do this in a console:
adduser firebird
and
addgroup -g firebird
(the -g is used normally to create a numerical group ID so go figure.....) but it won't work with "addgroup firebird"
Then you can follow the above instructions and install the 32-bit Firebird package
You can verify that the group firebird has been added by checking the file "/etc/groups", and/or by creating a blank file by running the command "touch myfile", then seeing if you can change the group of myfile with the command "chgrp firebird myfile" edited 06:33, 28 Mar 2008