个人工具
登录
查看“UbuntuHelp:Firebird2.1”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:Firebird2.1”的源代码
来自Ubuntu中文
←
UbuntuHelp:Firebird2.1
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{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/+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 repository must be added into sources.list , Here is the example for Hardy <pre><nowiki> sudo gedit /etc/apt/sources.list </nowiki></pre> and you should add these lines <pre><nowiki> deb http://ppa.launchpad.net/mapopa/ubuntu hardy main deb-src http://ppa.launchpad.net/mapopa/ubuntu hardy main </nowiki></pre> Then you need to update the cache repository <pre><nowiki> sudo apt-get update </nowiki></pre> Here is how you can inspect the firebird2.1 related packages <pre><nowiki> apt-cache search firebird2.1-* </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.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 </nowiki></pre> 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> sudo apt-get install firebird2.1-classic </nowiki></pre> You need to configure the package after is installed <pre><nowiki> sudo dpkg-reconfigure firebird2.1-super </nowiki></pre> Install the examples and dev files <pre><nowiki> $sudo apt-get install firebird2.1-examples firebird2.1-dev </nowiki></pre> The employee.fdb archive will be under this dir /usr/share/doc/firebird2.1-examples/examples/empbuild/ <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 <pre><nowiki> $ isql-fb SQL> connect "/var/lib/firebird/2.1/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; SQL> quit CON>; </nowiki></pre> For an GUI admin tool you might check the flamerobin administration tool included in ubuntu repository can be installed by an simple <pre><nowiki> sudo apt-get install flamerobin </nowiki></pre> Then use it from the menu Applications->Programming-> FlameRobin To use firebird with php , you will need the php5 driver <pre><nowiki> sudo apt-get install php5-interbase sudo /etc/init.d/apache2 restart </nowiki></pre> Next if you need to install an php administration tool like ibwebadmin <pre><nowiki> sudo apt-get install ibwebadmin </nowiki></pre> and load it in the browser [http://localhost/ibwebadmin http://localhost/ibwebadmin] It should look like this [http://farm3.static.flickr.com/2414/2492058076_49c677058d_o.png screen shot] =Other Firebird Related Guides= You can start with the main Firebird [http://www.firebirdsql.org/?op=doc documentation] [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:Firebird2.1
。