当前位置：首页 > news >正文

学习关系型数据库：在Ubuntu和FreeBSD下安装firebird

news 来源：原创 2024/9/19 9:33:30

Firebird是一种关系型数据库管理系统，它使用SQL（结构化查询语言）进行数据操作。与许多其他数据库系统相比，Firebird以其卓越的性能、稳定性和可扩展性而著称。

在Ubuntu下安装firebird

在Linux下使用apt search查找firebird，看到很多相关软件包：

apt search firebird
Sorting... Done
Full Text Search... Done
centreon-plugins/jammy 0.0~20220113-1 allCollection of Nagios plugins to monitor OS, services and network devicesfirebird-dev/jammy 3.0.8.33535.ds4-1ubuntu2 amd64Development files for Firebirdfirebird3.0-common/jammy 3.0.8.33535.ds4-1ubuntu2 allcommon files for firebird 3.0 server, client and utilitiesfirebird3.0-common-doc/jammy 3.0.8.33535.ds4-1ubuntu2 allcopyright, licensing and changelogs of firebird3.0firebird3.0-doc/jammy 3.0.8.33535.ds4-1ubuntu2 allDocumentation files for firebird database version 3.0firebird3.0-examples/jammy 3.0.8.33535.ds4-1ubuntu2 allExamples for Firebird databasefirebird3.0-server/jammy 3.0.8.33535.ds4-1ubuntu2 amd64Firebird Server - an RDBMS based on InterBase 6.0 codefirebird3.0-server-core/jammy 3.0.8.33535.ds4-1ubuntu2 amd64Firebird engine corefirebird3.0-utils/jammy 3.0.8.33535.ds4-1ubuntu2 amd64Firebird command line utilities

使用apt install 安装firebird

sudo apt install firebird-dev firebird3.0-server firebird3.0-examples

或者

apt install firebird-dev firebird3.0-server firebird3.0-examples

GRUB选项

安装过程中有如下选择项：

Continue without installing GRUB? [yes/no]

感觉有点奇怪，怎么跟grub关联的？选yes

提示密码

Firebird有一个名为SYSDBA的特殊用户，该用户
可以访问所有数据库。SYSDBA还可以创建新的数据库
以及用户。因此，有必要使用密码。
密码存储在/etc/firebird/3.0/SYSDBA.password中
（只能由root读取）。你可以在那里修改它（别忘了
也可以使用gsec实用程序更新安全数据库），或者
可以使用dpkg重新配置来更新两者。
如果你不输入密码，将使用随机密码（和
存储在SYSDBA.password中）。

设好密码，安装完成。

有些版本firebird的默认密码是masterkey

启动服务

service firebird3.0 start* Starting Firebird 3.0 server...                          [ OK ]

在FreeBSD下安装firebird

pkg update
pkg install firebird30-client firebird30-server

FreeBSD下安装还是挺方便的，完成后的提示：

Firebird 3 was installed.1) Before start the server ensure that the following line exists in /etc/services:gds_db		3050/tcp  #InterBase Database Remote Protocol2) If you use inetd (Classic Server) then add the following line to /etc/inetd.confgds_db  stream  tcp     nowait  firebird        /usr/local/sbin/firebird  firebirdAnd finally restart inetd.3) If you want to use change firebird modes then you must modify the ServerModevariable into /usr/local/etc/firebird/firebird.conf file.ServerMode="Super"# ServerMode="SuperClassic"# ServerMode="Classic"4) It is STRONGLY recommended that you change the SYSDBA
password with:# gsec -user SYSDBA -pass masterkeyGSEC> modify SYSDBA -pw newpasswordGSEC> quitbefore doing anything serious with Firebird.5) See documentation in /usr/local/share/doc/firebird/ for more information.6) Some firebird tools were renamed for avoid conflicts with some other ports/usr/local/bin/isql	-> 	/usr/local/bin/isql-fb/usr/local/bin/gstat	->	/usr/local/bin/fbstat/usr/local/bin/gsplit	->	/usr/local/bin/fbsplit6) Enjoy it ;)

总体感觉FreeBSD下比较靠谱。