2009年11月17日 (二) 19:07的版本

文章出处:

https://help.ubuntu.com/community/Firebird2.1

点击翻译:

English

请不要直接编辑翻译本页，本页将定期与来源同步。

In Ubuntu 9.04 Jaunty Firebird2.1.1 is included by default but the latest stable is into my ppa . The Firebird2.1 package (version 2.1.3) for Ubuntu 9.04 Jaunty, Intrepid 8.10, Hardy 8.04, Dapper 6.06 is located into this repository (ppa) The repository must be added into sources.list , Here is the example for Jaunty

sudo pico /etc/apt/sources.list.d/firebird.list

and you should add these lines

deb http://ppa.launchpad.net/mapopa/ppa/ubuntu jaunty main
deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu jaunty main

You need to import my gpg key

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com ea316a2f8d6bd55554c23f680be6d09eef648708

Then you need to update the cache repository

sudo apt-get update

Here is how you can inspect the firebird2.1 related packages

apt-cache search firebird2.1-*

install the super server package (you will be asked about the SYSDBA password and what service to enable :Super Server or Classic )

sudo apt-get install firebird2.1-super

The following extra packages will be installed:
  firebird2.1-common firebird2.1-server-common libedit2 libfbclient2 libicu38
Suggested packages:
  firebird2.1-doc
The following NEW packages will be installed:
  firebird2.1-common firebird2.1-server-common firebird2.1-super libedit2 libfbclient2 libicu38
0 upgraded, 6 newly installed, 0 to remove and 1 not upgraded.
Need to get 11.7MB of archives.
After unpacking 28.4MB of additional disk space will be used.
Do you want to continue [Y/n]? y

Or install Classic if you have more than one cpu (dual core or SMP machine) and want SMP support

sudo apt-get install firebird2.1-classic

You need to configure the package after is installed

sudo dpkg-reconfigure firebird2.1-super

Install the examples and dev files

sudo apt-get install firebird2.1-examples firebird2.1-dev 

The employee.fdb archive will be under this dir /usr/share/doc/firebird2.1-examples/examples/empbuild/

cd /usr/share/doc/firebird2.1-examples/examples/empbuild/
sudo gunzip employee.fdb.gz
sudo chown firebird.firebird employee.fdb
sudo mv employee.fdb /var/lib/firebird/2.1/data/

connect to db

$ isql-fb

SQL> connect "/var/lib/firebird/2.1/data/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;
SQL> quit
CON>; 

For an GUI admin tool you might check the flamerobin administration tool included in ubuntu repository can be installed by an simple

sudo apt-get install flamerobin

Then use it from the menu Applications->Programming-> FlameRobin To use firebird with php , you will need the php5 driver

sudo apt-get install php5-interbase
sudo /etc/init.d/apache2 restart

Next if you need to install an php administration tool like ibwebadmin

sudo apt-get install ibwebadmin

and load it in the browser http://localhost/ibwebadmin It should look like this screen shot

Other Firebird Related Guides

You can start with the main Firebird documentation