Month: November 2007

[See remaining text…] 

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

« Hide it