Re: Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10

I have updated the tutorial for Firebird 2.1 classic and Ubuntu Karmic koala http://www.firebirdnews.org/?p=1338

sudo apt-get install firebird2.1-dev

I have installed latest DBI
wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.609.tar.gz
tar -zxvf DBI-1.609.tar.gz
cd DBI-1.609
perl Makefile.PL
sudo make install

Then install the Firebird driver
wget http://search.cpan.org/CPAN/authors/id/E/ED/EDPRATOMO/DBD-InterBa
+se-0.48.tar.gz
tar -zxvf DBD-InterBase-0.48.tar.gz
cd DBD-InterBase-0.48
perl Makefile.PL
make
make test (optional step)
make install
[download]

Comment on Re: Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10 Download Code

Replies are listed 'Best First'.
Re^2: Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10 by mapopa (Acolyte) on Nov 03, 2009 at 10:18 UTC
I have forgot to put the console output there you can see the firebird paths for include/libs .. http://paste.ubuntu.com/308245/	[reply]
Re^3: Getting a Perl connection to a Firebird2.1-classic database in Kubuntu 9.10 by Steve_BZ (Chaplain) on Nov 03, 2009 at 14:38 UTC
Hi Mariuz, Thanks very much for you answer, and for all the effort you went to to update the firebirdnews page. I've tried it out from a clean install, using KPackage to install firebirs2.1-classic and DBI-Perl. I still get an error (see below): steve@steve-desktop:~/DBI-1.609/DBD-InterBase-0.48$ perl Makefile.PL InterBase/Firebird bin directory : [/usr/bin] InterBase/Firebird include directory : [/usr/include] Multiple copies of Driver.xst found in: /usr/local/lib/perl/5.10.0/aut +o/DBI /usr/lib/perl5/auto/DBI at Makefile.PL line 92 main::locate_dbi_arch_dir() called at Makefile.PL line 333 InterBase/Firebird lib directory : [/usr/lib] Build with libfbembed? (y/n) [n] n Full path to your test database: /tmp/foo /tmp/foo 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: /usr/bin/isql-fb Use CONNECT or CREATE DATABASE to specify a database Statement failed, SQLCODE = -902 cannot attach to password database After line 0 in file ./t/create.sql Fail calling /usr/bin/isql-fb -i t/create/sql: 256 at Makefile.PL line + 295, <STDIN> line 8. # Looks like your test died before it could output anything. [download] It seemed to me the isql-fb had a problem, so I tried again with a DB of my own, however this also crashed (see below). steve@steve-desktop:~/DBI-1.609/DBD-InterBase-0.48$ perl Makefile.PL InterBase/Firebird bin directory : [/usr/bin] InterBase/Firebird include directory : [/usr/include] Multiple copies of Driver.xst found in: /usr/local/lib/perl/5.10.0/aut +o/DBI /usr/lib/perl5/auto/DBI at Makefile.PL line 92 main::locate_dbi_arch_dir() called at Makefile.PL line 333 InterBase/Firebird lib directory : [/usr/lib] Build with libfbembed? (y/n) [n] Full path to your test database: /home/steve/Documents/endo.fdb /home/steve/Documents/endo.fdb exists. Trying to use an existing database.. Please enter a username to connect. Username : SYSDBA Password : masterkey Can't execute /usr/bin/0: No such file or directory at Makefile.PL lin +e 204, <STDIN> line 7. # Looks like your test died before it could output anything. [download] Regards Steve	[reply] [d/l] [select]