Building Firebird 2.5 from debian git repository

sudo apt-get git-core devscripts
sudo apt-get build-dep firebird2.1

you need to check out the firebird 2.5 repository from debian git

git clone git://git.debian.org/pkg-firebird/2.5.git

cd 2.5

debuild -uc -us
and wait for it to build it for you
here are my results

ls ../*deb

../firebird2.5-classic_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-server-common_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-classic-common_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-super_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-common_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-superclassic_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-dev_2.5.0.25784~rc1.ds1-1_all.deb
../libfbclient2_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-doc_2.5.0.25784~rc1.ds1-1_all.deb ../libfbembed2.5_2.5.0.25784~rc1.ds1-1_amd64.deb
../firebird2.5-examples_2.5.0.25784~rc1.ds1-1_all.deb
../libib-util0_2.5.0.25784~rc1.ds1-1_amd64.deb

Also you can speed it up with make -j options: 
there is a patch applied that allows the build to be made
in parallel. Add -jX to dpkg-buildpackage or debuild command line to
use it. (X is to be replaced with the number of desired parallel build
processes)
Example:
you can add debuild -uc -us -j2

Install SuperServer and dependences

sudo dpkg -i firebird2.5-super_2.5.0.25784~rc1.ds1-1_amd64.deb libfbclient2_2.5.0.25784~rc1.ds1-1_amd64.deb libib-util0_2.5.0.25784~rc1.ds1-1_amd64.deb firebird2.5-common_2.5.0.25784~rc1.ds1-1_amd64.deb firebird2.5-common-doc_2.5.0.25784~rc1.ds1-1_all.deb firebird2.5-server-common_2.5.0.25784~rc1.ds1-1_amd64.deb

sudo su
dpkg-reconfigure firebird2.5-super
dpkg -i firebird2.5-examples_2.5.0.25784~rc1.ds1-1_all.deb
cat /usr/share/doc/firebird2.5-common-doc/examples/empbuild/employee.fdb.gz > gunzip > /tmp/employee.fdb

isql-fb
SQL>connect "/tmp/employee.fdb " user 'SYSDBA' password 'SYSDBApassword';

ps: for the moment i get an remote interface rejection so stay tuned

creating an db with isql-fb in firebird classic

If you try to create an db from isql-fb utility and you use firebird classic

then you might need to add the host in the connection string

$ isql-fb -user SYSDBA -password masterkey

Use CONNECT or CREATE DATABASE to specify a database

SQL> create database "/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

Statement failed, SQLCODE = -902

cannot attach to password database

SQL>

Here is the correct way to create the database with classic

$ isql-fb -user SYSDBA -password masterkey

SQL> create database "localhost:/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

.:(firebird):..:(databases):..:(sql):.

firebird2.0 2.0.3.12981.ds1-14 (source) in Ubuntu

latest package 2.0.3 from debian is now imported in ubuntu intrepid
https://bugs.edge.launchpad.net/ubuntu/+source/firebird2.0/2.0.3.12981.ds1-14

and here are the successful (power and sparc are new )

Builds

• intrepid sparc Successfully built (DONE)
• intrepid powerpc Successfully built (DONE)
• intrepid lpia Successfully built (DONE)
• intrepid i386 Successfully built (DONE)
• intrepid amd64 Successfully built (DONE)

.:(firebird):..:(databases):..:(sql):.

someone is using firebird on ubuntu

here is his blog where machines are described

.:(firebird):..:(databases):..:(sql):.

building firebird 2.1 from debian git repository

apt-get install libicu-dev libedit-dev git-core

you need to check out the firebird 2.1 repository from debian git

http://lists.alioth.debian.org/pipermail/pkg-firebird-general/2007q3/001125.html

git-clone git://git.debian.org/git/pkg-firebird/2.1
cd 2.1
debuild -i
and wait for it to build it for you

.:(firebird):..:(databases):..:(sql):.

IBPhoenix Open Source ODBC Driver

compiling and installing it on ubuntu
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co OdbcJdbc

cd OdbcJdbc/Builds/Gcc.lin
make -f makefile.linux

Next read the readme.linux

driver seems to be in OdbcJdbc/Builds/Gcc.lin/Release
sudo cp *.so /usr/lib
sudo ln -s /usr/lib/IscDbc.so /usr/lib/IscDbc

sudo ln -s /usr/lib/libIscDbc.so /usr/lib/IscDbc

cat /etc/odbcinst.ini
[Firebird]
Description = InterBase/Firebird ODBC Driver
Driver = /usr/lib/libOdbcJdbc.so
Setup = /usr/lib/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

cat /etc/odbc.ini
[help]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/2.0/system/help.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No


isql -v help
+---------------------------------------+
| Connected!                 |
+---------------------------------------+
SQL> select * from topics;
IBPhoenix Open Source ODBC Driver

Blogged with Flock