滚圆滚圆

分类： Firebird

  • Firebird3.0安装使用

    Ubuntu20，apt安装

    apt install firebird3.0 firebird-dev firebird3.0-server firebird3.0-server-core firebird3.0-utils libdbd-firebird-perl

    测试数据库

    isql-fb /var/lib/firebird/3.0/system/security3.fdb -user sysdba -password masterkey

    重启服务

    service firebird3.0 restart
    配置文件目录

    /etc/firebird/3.0

    编辑 /etc/firebird/3.0/firebird.conf 文件

    DatabaseAccess = Full
    表示所有目录的数据库都可以访问
    DatabaseAccess = None
    表示只有“别名数据库”可以访问
    选择默认即可

    RemoteAccess = true
    允许远程访问，建议开启，要不然很多都操作不了

    RemoteBindAddress = localhost
    远程访问地址绑定，有非本机(127.0.0.1)访问需求的，把这行注释掉加#，建议注释掉
    Firebird2.5版本
    RemoteBindAddress = 0.0.0.0

    问题

    connection rejected by remote interface

    编辑/etc/firebird/3.0/firebird.conf，
取消注释(如果使用fbclient 2.x)，
并更改以下参数以禁用WireCrypt并为旧式身份验证设置更高的优先级:

WireCrypt = Disabled
AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi

  • Firebird安装问题

    rpm -ivh FirebirdSS-2.1.6.18547-0.amd64.rpm
    error: Failed dependencies:
    libncurses.so.5 is needed by FirebirdSS-2.1.6.18547-0.amd64
    libstdc++.so.5 is needed by FirebirdSS-2.1.6.18547-0.amd64

    yum install ncurses-libs.i686 ncurses-devel.i686
    解决 libncurses.so.5 is needed by FirebirdSS-2.1.6.18547-0.amd64

    yum install compat-libstdc++-33.x86_64 compat-libstdc++-33.i686 compat-libstdc++-296.i686  libstdc++-devel.i686 libstdc++-devel.x86_64
    解决 libstdc++.so.5 is needed by FirebirdSS-2.1.6.18547-0.amd64

    思路：
    首先找台没问题的服务器
    find / -name libncurses.so.5
    find / -name libstdc++.so.5

    /lib/libncurses.so.5
    /lib64/libncurses.so.5

    /usr/lib/libstdc++.so.5
    /usr/lib64/libstdc++.so.5

    rpm -qf /lib/libncurses.so.5
    ncurses-libs-5.7-3.20090208.el6.i686
    rpm -qf /lib64/libncurses.so.5
    ncurses-libs-5.7-3.20090208.el6.x86_64

    然后 yum 相对应的rpm包，即可解决类似问题。

    yum install postgresql-python postgresql-libs compat-postgresql-libs postgresql-server postgresql postgresql-devel

    yum install ncurses-libs.i686 ncurses-devel.i686 compat-libstdc++-33.x86_64 compat-libstdc++-33.i686 compat-libstdc++-296.i686 libstdc++.i686 libstdc++-devel.i686

    安装firebird 解决 libgds.so 不能加载的问题
    yum install ncurses-libs.i686 ncurses-devel.i686

    yum install compat-libstdc++-33.x86_64 compat-libstdc++-33.i686 compat-libstdc++-296.i686 libstdc++-devel.i686 libstdc++-devel.x86_64
    yum install firebird

    Centos7

    rpm -ivh FirebirdCS-2.5.5.26952-0.amd64.rpm
    Preparing… ################################# [100%]
    file / from install of FirebirdCS-2.5.5.26952-0.amd64 conflicts with file from package filesystem-3.2-25.el7.x86_64
    file /usr/lib64 from install of FirebirdCS-2.5.5.26952-0.amd64 conflicts with file from package filesystem-3.2-25.el7.x86_64

    解决办法

    Firebird-3.0.4.33054-0.amd64.tar.gz

    源码方式安装

    ./install.sh

    yum 提示缺少组件，按照提示完成安装

    changeServerMode.sh 选择服务器模式

    Which option would you like to choose: (super|classic) [super] 默认super

    Firebird启动，完成安装

  • 如何在Linux下运行Firebird SuperClassic服务器？

    Firebird 2.5 创制了一种新的架构：SuperClassic 。官方发布的FB2.5 Linux发行包同时包含了SuperClassic和Classic两种架构的文件，当你安装了官方的包时，它默认激活为Classic架构服务器。
    如果想把服务器架构切换到SuperClassic, 可以通过执行 changeMultiConnectMode.sh 来实现。
    执行命令后，得到提示：“Which option would you like to choose: multi-(process|thread) [process]“
    回答thread,可以激活为SuperClassic . 如果回答 process 会激活为Classic .

    Firebird SuperClassic 下面
    ps ax |grep fire
    2054 ?        S      0:00 /opt/firebird/bin/fbguard -pidfile /var/run/firebird/default.pid -daemon -forever
    2055 ?        Sl     0:00 /opt/firebird/bin/fb_smp_server

    Firebird SuperServer下面
    ps ax |grep fire
    6862 ?        S      0:00 /opt/firebird/bin/fbguard -f
    6863 ?        Sl    27:34 /opt/firebird/bin/fbserver