今天在QQ上，有网友问我能否将FIREBIRD数据库迁移到unix/Linux，并作优化。俺心想，这个数据库平时比较小众，不像ORACLE,DB2,MYSQL这些数据库那么普遍，就不妨研究一下，就想着在LINUX下安装一套FIREBIRD数据库。
下面为安装过程：
首先就想着在centos 安装，首先yum search firebird,发现centos没有收录firebrid数据库。
root@co1 ~]# yum search Firebird
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Warning: No matches found for: Firebird
No Matches found
那么，就只能从官网拉源代码包，准备编译安装。
[root@co1 ~]# which wget
/usr/bin/wget
[root@co1 ~]# pwd
/root
[root@co1 ~]# wget https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0.amd64.tar.gz
解压源代码，发现只有三个文件，并且有一个install.sh文件：
[root@co1 install]# cd Firebird/
[root@co1 Firebird]# ls
Firebird-3.0.4.33054-0.amd64.tar.gz
[root@co1 Firebird]# tar zxvf *.tar.gz
Firebird-3.0.4.33054-0.amd64/
Firebird-3.0.4.33054-0.amd64/install.sh
Firebird-3.0.4.33054-0.amd64/buildroot.tar.gz
Firebird-3.0.4.33054-0.amd64/manifest.txt
[root@co1 Firebird]# cd Firebird-3.0.4.33054-0.amd64
[root@co1 Firebird-3.0.4.33054-0.amd64]# ls
buildroot.tar.gz install.sh manifest.txt
安装firebird.如下：
[root@co1 Firebird-3.0.4.33054-0.amd64]# ./install.sh
遇到报错：
irebird 3.0.4.33054-0.amd64 Installation
Press Enter to start installation or ^C to abort
Please install required library ‘libtommath’ before firebird, after it repeat firebird install
想着是lib，想着yum 会有收录，就直接yum search libtommath,还是找不到：
[root@co1 Firebird-3.0.4.33054-0.amd64]# yum search libtommath
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Warning: No matches found for: libtommath
No Matches found
[root@co1 Firebird-3.0.4.33054-0.amd64]# yum search tommath
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Warning: No matches found for: tommath
No Matches found
[root@co1 Firebird-3.0.4.33054-0.amd64]# yum search tommath
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Warning: No matches found for: tommath
No Matches found
通过baidu.找到lmt的sf 网址，下载一个lmt.tar.bz2的源代码，并且，从google搜到好像debian下apt下带有这个libtommath的源。加上不想花时间去编译这个 lmt.tar.bz2文件，就切换到debin操作系统下：
root@debdesk:~# apt-cache search libtommath
libtommath-dev – multiple-precision integer library [development files]
libtommath-docs – multiple-precision integer library [documentation]
libtommath1 – multiple-precision integer library [runtime]
libtfm1 – Fast multiple-precision integer library [runtime]
root@debdesk:~#
安装 libtommath ,如下：
apt-get install libtommath*
安装完成后，再次wget下载firebird源代码包：
wget https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0.amd64.tar.gz
再解压，再执行install.sh安装，继续遇到报错：
Press Enter to start installation or ^C to abort
Extracting install data
Please enter new password for SYSDBA user: <password>
/opt/firebird/bin/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory
Fatal error running ‘systemctl –quiet start firebird-superserver.service’ – exiting
提示找不到libtommath.so.0 ，但发现在/usr/lib/x86_64-linux-gnu目录下，有几个libtommath.so文件，那就将libtommath.so.1.0.0 建一个软链接，
ln -s libtommath.so.1.0.0 libtommath.so.0
再次运行install.sh ,终于顺利完成安装。
基本设置:
查看firebird运行服务：
root@debdesk:~# ps -ef | grep fire
firebird 539 1 0 22:36 ? 00:00:00 /opt/firebird/bin/fbguard -pidfile /var/run/firebird/firebird.pid -daemon -forever
firebird 544 539 0 22:36 ? 00:00:00 /opt/firebird/bin/firebird
root 969 896 0 22:54 pts/0 00:00:00 grep fire
firebird 成功启动，默认会打开监听端口3050
netstat -na ｜ｇｒｅｐ ３０５０
登陆firebird并新建数据库.
root@debdesk:~# cd /opt/firebird/bin/
root@debdesk:/opt/firebird/bin# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL>CREATE DATABASE ‘/opt/firebird/zymhdb.fdb’ page_size 8192;
最后用Firebirdmaestro等firebird客户端工具来连接 firebird数据库。
以下文章点击率最高
Loading…