“UbuntuHelp:Firebird2.0”的版本间的差异
来自Ubuntu中文
小 (新页面: {{From|https://help.ubuntu.com/community/Firebird2.0}} {{Languages|UbuntuHelp:Firebird2.0}} The ubuntu gutsy 7.10 and hardy 8.04 includes firebird 2.0.3 , ubuntu intrepid icludes both fir...) |
小 |
||
第84行: | 第84行: | ||
[[http://flamerobin.blogspot.com/2008/04/simple-way-to-install-flamerobin-in.html]] | [[http://flamerobin.blogspot.com/2008/04/simple-way-to-install-flamerobin-in.html]] | ||
=Other Guides= | =Other Guides= | ||
− | Here is how to install [[Firebird2.1]] on dapper, feisty , hardy , gutsy and intrepid ibex | + | Here is how to install [[UbuntuHelp:Firebird2.1]] on dapper, feisty , hardy , gutsy and intrepid ibex |
− | + | [http://howtoforge.com/installing-firebird-2.0.3-database-server-on-ubuntu-7.10 This tutorial] explains how you can install the Firebird database server (version 2.0.3) on an Ubuntu 7.10 server using the | |
official tar.gz installer | official tar.gz installer | ||
For an older guide (firebird 1.5.x) Read the page bellow | For an older guide (firebird 1.5.x) Read the page bellow | ||
− | [[Firebird1.5|Installing Firebird 1.5.x]] How to install and set Firebird server in ubuntu | + | [[UbuntuHelp:Firebird1.5|Installing Firebird 1.5.x]] How to install and set Firebird server in ubuntu |
[[category:UbuntuHelp]] | [[category:UbuntuHelp]] |
2008年10月19日 (日) 15:08的版本
点击翻译: |
English |
请不要直接编辑翻译本页,本页将定期与来源同步。 |
The ubuntu gutsy 7.10 and hardy 8.04 includes firebird 2.0.3 , ubuntu intrepid icludes both firebird 2.0.4 and firebird 2.1.x Here is how you can inspect the firebird2.0 related packages
apt-cache search firebird2.0-*
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.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 0 upgraded, 3 newly installed, 0 to remove and 1 not upgraded. Need to get 4355kB of archives. After unpacking 10.6MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://archive.ubuntu.com gutsy/universe firebird2.0-common 2.0.3.12981.ds1-1ubuntu2 [894kB] Get:2 http://archive.ubuntu.com gutsy/universe libfbclient2 2.0.3.12981.ds1-1ubuntu2 [614kB] Get:3 http://archive.ubuntu.com gutsy/universe firebird2.0-super 2.0.3.12981.ds1-1ubuntu2 [2847kB] Fetched 4355kB in 9s (459kB/s) Preconfiguring packages ... Selecting previously deselected package firebird2.0-common. (Reading database ... 206209 files and directories currently installed.) Unpacking firebird2.0-common (from .../firebird2.0-common_2.0.3.12981.ds1-1ubuntu2_i386.deb) ... Selecting previously deselected package libfbclient2. Unpacking libfbclient2 (from .../libfbclient2_2.0.3.12981.ds1-1ubuntu2_i386.deb) ... Selecting previously deselected package firebird2.0-super. Unpacking firebird2.0-super (from .../firebird2.0-super_2.0.3.12981.ds1-1ubuntu2_i386.deb) ... 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... * Firebird 2.0 server manager already running.
Install the examples and dev files
$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 "/var/lib/firebird/2.0/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 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
For an GUI admin tool you might check the flamerobin administration tool included in ubuntu can be installed by an simple
sudo apt-get install flamerobin
Then use it from the menu Applications->Programming-> FlameRobin There is an easier method using the apt-url [[1]]
Other Guides
Here is how to install UbuntuHelp:Firebird2.1 on dapper, feisty , hardy , gutsy and intrepid ibex This tutorial explains how you can install the Firebird database server (version 2.0.3) on an Ubuntu 7.10 server using the official tar.gz installer For an older guide (firebird 1.5.x) Read the page bellow Installing Firebird 1.5.x How to install and set Firebird server in ubuntu