“UbuntuHelp:Firebird2.1”的版本间的差异
来自Ubuntu中文
小 （新页面: {{From|https://help.ubuntu.com/community/Firebird2.1}} {{Languages|UbuntuHelp:Firebird2.1}} In Ubuntu Intreprid Ibex 8.10 Firebird2.1 is [[https://edge.launchpad.net/ubuntu/intrepid/+sour...） |
小 |
||
| 第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 Intreprid Ibex 8.10 Firebird2.1 is | + | In Ubuntu Intreprid Ibex 8.10 Firebird2.1 is [https://edge.launchpad.net/ubuntu/intrepid/+source/firebird2.1 included] by default |
| − | The Firebird2.1 package for Ubuntu Hardy 8.04 , Gutsy 7.10 , Feisty 7.04 is located into | + | 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 repository must be added into sources.list , Here is the example for Hardy | The repository must be added into sources.list , Here is the example for Hardy | ||
<pre><nowiki> | <pre><nowiki> | ||
| 第35行： | 第35行： | ||
Do you want to continue [Y/n]? y | Do you want to continue [Y/n]? y | ||
</nowiki></pre> | </nowiki></pre> | ||
| − | Or install Classic if you have more than one cpu (dual core or SMP machine) and want | + | Or install Classic if you have more than one cpu (dual core or SMP machine) and want [http://www.firebirdsql.org/manual/qsg2-classic-or-super.html SMP support] |
<pre><nowiki> | <pre><nowiki> | ||
sudo apt-get install firebird2.1-classic | sudo apt-get install firebird2.1-classic | ||
| 第87行： | 第87行： | ||
sudo apt-get install ibwebadmin | sudo apt-get install ibwebadmin | ||
</nowiki></pre> | </nowiki></pre> | ||
| − | and load it in the browser | + | and load it in the browser [http://localhost/ibwebadmin http://localhost/ibwebadmin] |
| − | It should look like this | + | It should look like this [http://farm3.static.flickr.com/2414/2492058076_49c677058d_o.png screen shot] |
=Other Firebird Related Guides= | =Other Firebird Related Guides= | ||
| − | You can start with the main Firebird | + | You can start with the main Firebird [http://www.firebirdsql.org/?op=doc documentation] |
[[category:UbuntuHelp]] | [[category:UbuntuHelp]] | ||
2008年10月19日 (日) 15:08的版本
 |
点击翻译: |
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
