“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 | + | In Ubuntu 9.04 Jaunty Firebird2.1.1 is [https://edge.launchpad.net/ubuntu/jaunty/+source/firebird2.1 included] by default |
− | The Firebird2.1 package for Ubuntu Hardy 8.04 , Gutsy 7.10 , Feisty 7.04 is located into [https://launchpad.net/~mapopa/+archive this] repository (ppa) | + | The Firebird2.1 package (version 2.1.1) for Ubuntu 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 | + | The repository must be added into sources.list , Here is the example for Intrepid Ibex |
<pre><nowiki> | <pre><nowiki> | ||
sudo gedit /etc/apt/sources.list | sudo gedit /etc/apt/sources.list | ||
第9行: | 第9行: | ||
and you should add these lines | and you should add these lines | ||
<pre><nowiki> | <pre><nowiki> | ||
− | deb http://ppa.launchpad.net/mapopa/ubuntu | + | deb http://ppa.launchpad.net/mapopa/ubuntu intrepid main |
− | deb-src http://ppa.launchpad.net/mapopa/ubuntu | + | deb-src http://ppa.launchpad.net/mapopa/ubuntu intrepid main |
</nowiki></pre> | </nowiki></pre> | ||
Then you need to update the cache repository | Then you need to update the cache repository |
2008年12月16日 (二) 18:32的版本
点击翻译: |
English |
请不要直接编辑翻译本页,本页将定期与来源同步。 |
In Ubuntu 9.04 Jaunty Firebird2.1.1 is included by default The Firebird2.1 package (version 2.1.1) for Ubuntu 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 gedit /etc/apt/sources.list
and you should add these lines
deb http://ppa.launchpad.net/mapopa/ubuntu intrepid main deb-src http://ppa.launchpad.net/mapopa/ubuntu intrepid 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