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

firebird2.1 Debian package for itanium

The firebird2.1 Debian package has been successfuly built[1] on IA64

[1] http://experimental.debian.net/fetch.php?&pkg=firebird2.1&ver=2.1.0.17798-0.ds1-4&arch=ia64&stamp=1211549239&file=log&as=raw


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

Debian Bug report logs for firebird project

some bugs are solved like mips, mipsel firebird port and also the security related
Here is the full report
.:(firebird):..:(databases):..:(sql):..:(debian):..:(bugs):.

debian romanian translations

Eddy Petrisor made an good translation for the debian package
Here are the details with the new translation
.:(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):.

Installing DBI driver for Firebird RDBMS server

DBI driver for Firebird and RDBMS server
This was tested on debian stable with firebird 1.5.x version installed (from repository )
also with perl module DBI aready installed
wget http://search.cpan.org/CPAN/authors/id/E/ED/EDPRATOMO/DBD-InterBase-0.47.tar.gz
tar -zxvf DBD-InterBase-0.47.tar.gz
cd DBD-InterBase-0.47
perl Makefile.PL
make
make test (optional step)
make install

Here are the logs for perl Makefile.PL
perl Makefile.PL
InterBase/Firebird bin directory : [/opt/firebird/bin]
InterBase/Firebird include directory : [/opt/firebird/include]
InterBase/Firebird lib directory : [/opt/firebird/lib]

Full path to your test database:   /tmp/foo.fdb
/tmp/foo.fdb does not exist.
Trying to create the test database..
Please enter a username with CREATE DATABASE permission.
Username :  sysdba
Password :  masterkey
Enter full path to isql:  [/opt/firebird/bin/isql]
Use CONNECT or CREATE DATABASE to specify a database
Checking if your kit is complete...
Looks good
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.4/auto/DBI/
Writing Makefile for DBD::InterBase
For make test
make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base..............ok
t/10dsnlist...........ok
t/20createdrop........ok
t/30insertfetch.......ok
t/40alltypes..........ok
t/40bindparam.........ok
t/40blobs.............ok
t/40cursor............ok
t/40cursoron..........ok
t/40datetime..........ok
t/40doparam...........ok
t/40listfields........ok
t/40nulls.............ok
t/40numrows...........ok
t/41numeric...........ok
t/50chopblanks........ok
t/50commit............ok
t/60leaks.............skipped
        all skipped: Long running memory leak test
t/61settx.............ok
t/62timeout...........ok
        12/14 skipped: wait timeout is not available
t/70nestedoff.........ok
t/70nestedon..........ok
t/80event-ithreads....ok
t/81event-fork........ok 1/17# kid gets sighup
t/81event-fork........ok
t/90dbinfo............ok
        10/13 skipped: active_tran_count is not available
t/91txinfo............ok
t/ak-dbd..............ok
t/dbdadmin............ok
All tests successful, 1 test and 22 subtests skipped.
Files=28, Tests=683, 21 wallclock secs ( 3.02 cusr +  0.32 csys =  3.34 CPU)

And for make install
 make install
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.so
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.bs
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/TypeInfo.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/GetInfo.pm
Installing /usr/local/man/man3/DBD::InterBase.3pm
Writing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/.packlist
Appending installation info to /usr/local/lib/perl/5.8.8/perllocal.pod

Edwin Pratomo / DBD-InterBase-0.47 - search.cpan.org

Blogged with Flock