UbuntuHelp:Firebird2.1

文章出处:

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

点击翻译:

English

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

In Ubuntu Intreprid Ibex 8.10 Firebird2.1 is included by default The Firebird2.1 package for Ubuntu Hardy 8.04 , Gutsy 7.10 , Feisty 7.04 is located into this repository (ppa) The repository must be added into sources.list , Here is the example for Hardy

sudo gedit /etc/apt/sources.list

and you should add these lines

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

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