Episode 1: Fishbowl Database Security Basics (application that uses Firebird)

Here are the security notes for an application that uses Firebird:

Another thing to keep in mind while securing your database: sometimes when we release new versions of Fishbowl, it upgrades your database to a new version, as well. When this happens, Fishbowl makes two different backups. One is a copy of the database; the other is a Firebird database dump. I like to call these the “Murphy’s Law backups” because you shouldn’t need them, and you won’t need them – until you don’t have them. They are created for rollback purposes during the upgrade. Leaving these unprotected is just as bad as leaving your main database unprotected. You can find these files in C:\Program Files (x86)\Fishbowl\database\data – inside the “old” and “backup” directories.

Perl driver DBD::Firebird 0.7.0 released

This release brings many changes and docs cleanup

  • use standard ROWS alternative to Mysql LIMIT
  • In firebird 2.5.x standard way is to use sequences
  • dialects cleanup
  • tests-setup: avoid passing credentials on the command line
  • link with libfbembed if given a special environment variable
  • fix missing database check during tests
  • test 81-event-fork.t when linked with libfbembed
  • implement add ib_enable_utf8 dynamic attribute
  • remove $Id$ markers from CVS/Subversion
  • add test for RT#55244
  • test 47-nulls.t: ensure inserting undef in a non-null field fails
  • fix $dbh->do() and $sth->execute() to properly return the number of affected records

Firebird Perl DBI driver 0.60 released

New version of DBI driver for Firebird is available at cpan with many changes and bugfixes . Please report any bugs and add them to the github project’s issues list

To download from cpan and install, simply do:

wget http://search.cpan.org/CPAN/authors/id/M/MA/MARIUZ/DBD-Firebird-0.60.tar.gz
tar -zxvf DBD-Firebird-0.60.tar.gz
cd DBD-Firebird-0.60/
perl Makefile.PL
make
make install

optional step

DBI_PASS=masterkey make test

1 2 3