个人工具
登录
查看“UbuntuHelp:Firebird2.0”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:Firebird2.0”的源代码
来自Ubuntu中文
←
UbuntuHelp:Firebird2.0
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{From|https://help.ubuntu.com/community/Firebird2.0}} {{Languages|UbuntuHelp:Firebird2.0}} ubuntu intrepid/jaunty includes both firebird 2.0.4 and firebird 2.1.x Here is how you can inspect the firebird2.0 related packages <pre><nowiki> apt-cache search firebird2.0-* </nowiki></pre> install the super server package (you will be asked about the SYSDBA password and what service to enable :Super Server or Classic ) <pre><nowiki> 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. </nowiki></pre> Install the examples and dev files <pre><nowiki> sudo apt-get install firebird2.0-examples firebird2.0-dev firebird-utils </nowiki></pre> The employee.fdb archive will be under this dir /usr/share/doc/firebird2.0-examples/examples/empbuild/ <pre><nowiki> 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/</nowiki></pre> connect to db <pre><nowiki> isql-fb SQL> connect "/var/lib/firebird/2.0/data/employee.fdb " user 'SYSDBA' password 'SYSDBApassword';</nowiki></pre> Now you can check the server version and the tables <pre><nowiki> 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</nowiki></pre> For an GUI admin tool you might check the flamerobin administration tool included in ubuntu can be installed by an simple <pre><nowiki> sudo apt-get install flamerobin </nowiki></pre> Then use it from the menu Applications->Programming-> FlameRobin There is an easier method using the apt-url [http://flamerobin.blogspot.com/2008/04/simple-way-to-install-flamerobin-in.html] =Other Guides= Here is how to install [[UbuntuHelp:Firebird2.1|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 For an older guide (firebird 1.5.x) Read the page bellow [[UbuntuHelp:Firebird1.5|Installing Firebird 1.5.x]] How to install and set Firebird server in ubuntu [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:Firebird2.0
。