特殊:Badtitle/NS100:Firebird2 1:修订间差异
小 新页面: {{From|https://help.ubuntu.com/community/Firebird2%2e1}} {{Languages|UbuntuHelp:Firebird2%2e1}} The Firebird2.1 package for ubuntu gutsy 7.10 and hardy 8.04 is located into [https://launc... |
(没有差异)
|
2008年5月9日 (五) 18:57的最新版本
文章出处: |
{{#if: | {{{2}}} | https://help.ubuntu.com/community/Firebird2%2e1 }} |
点击翻译: |
English {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/af | • {{#if: UbuntuHelp:Firebird2%2e1|Afrikaans| [[::Firebird2 1/af|Afrikaans]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ar | • {{#if: UbuntuHelp:Firebird2%2e1|العربية| [[::Firebird2 1/ar|العربية]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/az | • {{#if: UbuntuHelp:Firebird2%2e1|azərbaycanca| [[::Firebird2 1/az|azərbaycanca]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/bcc | • {{#if: UbuntuHelp:Firebird2%2e1|جهلسری بلوچی| [[::Firebird2 1/bcc|جهلسری بلوچی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/bg | • {{#if: UbuntuHelp:Firebird2%2e1|български| [[::Firebird2 1/bg|български]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/br | • {{#if: UbuntuHelp:Firebird2%2e1|brezhoneg| [[::Firebird2 1/br|brezhoneg]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ca | • {{#if: UbuntuHelp:Firebird2%2e1|català| [[::Firebird2 1/ca|català]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/cs | • {{#if: UbuntuHelp:Firebird2%2e1|čeština| [[::Firebird2 1/cs|čeština]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/de | • {{#if: UbuntuHelp:Firebird2%2e1|Deutsch| [[::Firebird2 1/de|Deutsch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/el | • {{#if: UbuntuHelp:Firebird2%2e1|Ελληνικά| [[::Firebird2 1/el|Ελληνικά]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/es | • {{#if: UbuntuHelp:Firebird2%2e1|español| [[::Firebird2 1/es|español]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/fa | • {{#if: UbuntuHelp:Firebird2%2e1|فارسی| [[::Firebird2 1/fa|فارسی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/fi | • {{#if: UbuntuHelp:Firebird2%2e1|suomi| [[::Firebird2 1/fi|suomi]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/fr | • {{#if: UbuntuHelp:Firebird2%2e1|français| [[::Firebird2 1/fr|français]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/gu | • {{#if: UbuntuHelp:Firebird2%2e1|ગુજરાતી| [[::Firebird2 1/gu|ગુજરાતી]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/he | • {{#if: UbuntuHelp:Firebird2%2e1|עברית| [[::Firebird2 1/he|עברית]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/hu | • {{#if: UbuntuHelp:Firebird2%2e1|magyar| [[::Firebird2 1/hu|magyar]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/id | • {{#if: UbuntuHelp:Firebird2%2e1|Bahasa Indonesia| [[::Firebird2 1/id|Bahasa Indonesia]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/it | • {{#if: UbuntuHelp:Firebird2%2e1|italiano| [[::Firebird2 1/it|italiano]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ja | • {{#if: UbuntuHelp:Firebird2%2e1|日本語| [[::Firebird2 1/ja|日本語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ko | • {{#if: UbuntuHelp:Firebird2%2e1|한국어| [[::Firebird2 1/ko|한국어]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ksh | • {{#if: UbuntuHelp:Firebird2%2e1|Ripoarisch| [[::Firebird2 1/ksh|Ripoarisch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/mr | • {{#if: UbuntuHelp:Firebird2%2e1|मराठी| [[::Firebird2 1/mr|मराठी]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ms | • {{#if: UbuntuHelp:Firebird2%2e1|Bahasa Melayu| [[::Firebird2 1/ms|Bahasa Melayu]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/nl | • {{#if: UbuntuHelp:Firebird2%2e1|Nederlands| [[::Firebird2 1/nl|Nederlands]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/no | • {{#if: UbuntuHelp:Firebird2%2e1|norsk| [[::Firebird2 1/no|norsk]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/oc | • {{#if: UbuntuHelp:Firebird2%2e1|occitan| [[::Firebird2 1/oc|occitan]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/pl | • {{#if: UbuntuHelp:Firebird2%2e1|polski| [[::Firebird2 1/pl|polski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/pt | • {{#if: UbuntuHelp:Firebird2%2e1|português| [[::Firebird2 1/pt|português]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ro | • {{#if: UbuntuHelp:Firebird2%2e1|română| [[::Firebird2 1/ro|română]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/ru | • {{#if: UbuntuHelp:Firebird2%2e1|русский| [[::Firebird2 1/ru|русский]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/si | • {{#if: UbuntuHelp:Firebird2%2e1|සිංහල| [[::Firebird2 1/si|සිංහල]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/sq | • {{#if: UbuntuHelp:Firebird2%2e1|shqip| [[::Firebird2 1/sq|shqip]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/sr | • {{#if: UbuntuHelp:Firebird2%2e1|српски / srpski| [[::Firebird2 1/sr|српски / srpski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/sv | • {{#if: UbuntuHelp:Firebird2%2e1|svenska| [[::Firebird2 1/sv|svenska]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/th | • {{#if: UbuntuHelp:Firebird2%2e1|ไทย| [[::Firebird2 1/th|ไทย]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/tr | • {{#if: UbuntuHelp:Firebird2%2e1|Türkçe| [[::Firebird2 1/tr|Türkçe]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/vi | • {{#if: UbuntuHelp:Firebird2%2e1|Tiếng Việt| [[::Firebird2 1/vi|Tiếng Việt]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/yue | • {{#if: UbuntuHelp:Firebird2%2e1|粵語| [[::Firebird2 1/yue|粵語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/zh | • {{#if: UbuntuHelp:Firebird2%2e1|中文| [[::Firebird2 1/zh|中文]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/zh-hans | • {{#if: UbuntuHelp:Firebird2%2e1|中文(简体)| [[::Firebird2 1/zh-hans|中文(简体)]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Firebird2%2e1 | UbuntuHelp:Firebird2%2e1 | {{#if: | :}}Firebird2 1}}/zh-hant | • {{#if: UbuntuHelp:Firebird2%2e1|中文(繁體)| [[::Firebird2 1/zh-hant|中文(繁體)]]}}|}} |
{{#ifeq:UbuntuHelp:Firebird2%2e1|:Firebird2 1|请不要直接编辑翻译本页,本页将定期与来源同步。}} |
{{#ifexist: :Firebird2 1/zh | | {{#ifexist: Firebird2 1/zh | | {{#ifeq: {{#titleparts:Firebird2 1|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:Firebird2 1|1|-1|}} | zh | | }}
The Firebird2.1 package for ubuntu gutsy 7.10 and hardy 8.04 is located into this repository (ppa) until it will be included into the main The repository must be added into sources.list
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
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
Other Firebird Related Guides
You can start with the main Firebird documentation