Subject Re: Firebird on Ubuntu
Author federonline
Thanks to everyone that responded...

This is awesome.
Kurt.


--- In firebird-support@yahoogroups.com, "Doru Ilasi" wrote:
>
> --- 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.
>