Firebird 2.0.3 included in Ubuntu 7.10 (gutsy)
The new ubuntu 7.10 includes firebird 2.0.3 stable
Here is the package description , Here is how to install
You can inspect the packaged stable version
apt-cache search firebird2.0-*
install the super server package (you will be asked about the SYSDBA password and what service to enable :Choose Super Server)
sudo apt-get install firebird2.0-super
The following extra packages will be installed:
firebird2.0-common libfbclient2
Recommended packages:
firebird-utils
The following NEW packages will be installed:
firebird2.0-common firebird2.0-super libfbclient2
…
Setting up firebird2.0-common (2.0.3.12981.ds1-1ubuntu2) …
Setting up libfbclient2 (2.0.3.12981.ds1-1ubuntu2) …
Setting up firebird2.0-super (2.0.3.12981.ds1-1ubuntu2) …
Created default security.fdb
* Starting Firebird 2.0 server manager… [ OK ]
* Firebird 2.0 server manager already running.
Install the examples
$sudo apt-get install firebird2.0-examples firebird2.0-dev firebird-utils
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 ‘SYSDBApassword‘;
Now you can check the server version and the tables
SQL> show tables;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES
SQL> show version
CON> ;
ISQL Version: LI-V2.0.3.12981 Firebird 2.0
Server version:
Firebird/linux Intel (access method), version “LI-V2.0.3.12981 Firebird 2.0″
Firebird/linux Intel (remote server), version ” LI-V2.0.3.12981 Firebird 2.0/tcp (borkstation32)/P10″
Firebird/linux Intel (remote interface), version “LI-V2.0.1.12855 Firebird 2.0/tcp (borkstation32)/P10”
on disk structure version 11.0