Tag: firebird

[See remaining text…] 

please remove any firebird2.0-* packages from System -> Synaptic Package Manager (Mark them for complete removal)
If you had any firebird packages before or you want an clean firebird reinstall

You will be asked to
Delete password databse (click and check it)
Delete database from /var/lib/firebird2.0/data (click and check it)

Then click forward

Next install Firebird2.0-* packages from synaptic
Check all minus the firebird.2.0-classic that is not needed

And then click apply

you will be asked to choose the Firebird Version
then choose firebird2.0-super
password for SYSDBA
Choose an random password for you

Then install flamerobin and create an database in /tmp/foo.fdb
Firebird runs under firebird user and the directory where it writes must have
perimissions for that user

The employee.fdb archive will be under this dir
/usr/share/doc/firebird2.0-examples/examples/empbuild/
$cd /usr/share/doc/firebird2.0-examples/examples/empbuild/
$sudo gunzip employee.fdb.gz
$sudo chown firebird.firebird employee.fdb
$sudo mv employee.fdb /var/lib/firebird/2.0/data/
connect to db
$ isql-fb

SQL> connect “employee.fdb” user ‘SYSDBA’ password ‘masterkey’;

ps: you can reset the password with sudo dpkg-reconfigure firebird2.0-super

Also you can install from console http://www.firebirdnews.org/?p=1353

« Hide it