“UbuntuHelp:Firebird2.1”的版本间的差异
来自Ubuntu中文
小 |
小 |
||
第1行: | 第1行: | ||
{{From|https://help.ubuntu.com/community/Firebird2.1}} | {{From|https://help.ubuntu.com/community/Firebird2.1}} | ||
{{Languages|UbuntuHelp:Firebird2.1}} | {{Languages|UbuntuHelp:Firebird2.1}} | ||
− | In Ubuntu 9.04 Jaunty Firebird2.1.1 is [https://edge.launchpad.net/ubuntu/jaunty/+source/firebird2.1 included] by default | + | In Ubuntu 9.04 Jaunty Firebird2.1.1 is [https://edge.launchpad.net/ubuntu/jaunty/+source/firebird2.1 included] by default but the latest stable is into my ppa . |
− | The Firebird2.1 package (version 2.1. | + | The Firebird2.1 package (version 2.1.2) for Ubuntu 9.04 Jaunty, Intrepid 8.10, Hardy 8.04, Gutsy 7.10, Feisty 7.04, Dapper 6.06 is located into [https://launchpad.net/~mapopa/+archive this] repository (ppa) |
The repository must be added into sources.list , Here is the example for Intrepid Ibex | The repository must be added into sources.list , Here is the example for Intrepid Ibex | ||
<pre><nowiki> | <pre><nowiki> | ||
− | sudo | + | sudo pico /etc/apt/sources.list |
</nowiki></pre> | </nowiki></pre> | ||
and you should add these lines | and you should add these lines | ||
<pre><nowiki> | <pre><nowiki> | ||
− | deb http://ppa.launchpad.net/mapopa/ubuntu intrepid main | + | deb http://ppa.launchpad.net/mapopa/ppa/ubuntu intrepid main |
− | deb-src http://ppa.launchpad.net/mapopa/ubuntu intrepid main | + | deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu intrepid main |
+ | </nowiki></pre> | ||
+ | You need to import my [https://help.launchpad.net/PPAKeys gpg key] | ||
+ | <pre><nowiki> | ||
+ | sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com ea316a2f8d6bd55554c23f680be6d09eef648708 | ||
</nowiki></pre> | </nowiki></pre> | ||
Then you need to update the cache repository | Then you need to update the cache repository | ||
第45行: | 第49行: | ||
Install the examples and dev files | Install the examples and dev files | ||
<pre><nowiki> | <pre><nowiki> | ||
− | + | sudo apt-get install firebird2.1-examples firebird2.1-dev | |
</nowiki></pre> | </nowiki></pre> | ||
The employee.fdb archive will be under this dir | The employee.fdb archive will be under this dir | ||
/usr/share/doc/firebird2.1-examples/examples/empbuild/ | /usr/share/doc/firebird2.1-examples/examples/empbuild/ | ||
<pre><nowiki> | <pre><nowiki> | ||
− | + | 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/</nowiki></pre> | |
connect to db | connect to db | ||
<pre><nowiki> | <pre><nowiki> |
2009年5月12日 (二) 16:46的版本
点击翻译: |
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.2) for Ubuntu 9.04 Jaunty, Intrepid 8.10, Hardy 8.04, Gutsy 7.10, Feisty 7.04, Dapper 6.06 is located into this repository (ppa) The repository must be added into sources.list , Here is the example for Intrepid Ibex
sudo pico /etc/apt/sources.list
and you should add these lines
deb http://ppa.launchpad.net/mapopa/ppa/ubuntu intrepid main deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu intrepid 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