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

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]