2017年05月29日

Firebird 3.0.2 (64bit) source install CentOS 6 [成功]

CentOS6.9(64bit) / Firebird 3.0.2 (64bit) / source install

1. Firewall 3050port をopen

vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3050 -j ACCEPT
/etc/init.d/iptables restart

2. yum
yum -y update
yum -y install libstdc++.so.5
yum -y install libstdc++.so.6
yum -y install libncurses.so.5

3. libtommathをinstall
cd /usr/local/src
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -Uvh epel-release-6-8.noarch.rpm
yum -y install libtommath-devel
11_fb_libtom.png

4. Firebird-3.0.2.32703-0.amd64.tar.gz  ( libtommathとbitを合わす)
cd /usr/local/src
wget https://sourceforge.net/projects/firebird/files/firebird-linux-amd64/3.0.2-Release/Firebird-3.0.2.32703-0.amd64.tar.gz
tar zxvf Firebird-3.0.2.32703-0.amd64.tar.gz
cd Firebird-3.0.2.32703-0.amd64
12_wegt.png

5. ./install.sh
014_install.png

6.
chkconfig --list firebird
chkconfig  firebird on

service firebird stop
service firebird start

7.データ用フォルダの作成と権限
mkdir /var/fdb
chown -R firebird.firebird /var/fdb

8. ISQL
cd /opt/firebird/bin
./isql -u sysdba -p masterkey
CREATE DATABASE '/var/fdb/TEST1.FDB' page_size 8192  default character set utf8;
CREATE DATABASE '/var/fdb/TEST2.FDB' default character set utf8;
exit;

9.データベース作成後に再度権限
chown -R firebird.firebird /var/fdb

posted by a23 at 15:44| Comment(0) | Firebird

2017年05月27日

Firebird 3.0.2 source install CentOS 6 / 7 [失敗]

CentOS 6 / 7 に libtommath.so.0 を入れる方法が不明

/opt/firebird/bin/fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory                            [失敗]
となる




firewall
001_ファイアウォールの設定.png

yum -y update
yum -y install libstdc++.so.5
yum -y install libstdc++.so.6
yum -y install libncurses.so.5
002_yum_so.png

cd /usr/local/src
003_wget_.png

ls
004_ls.png

rpm -ihv libtommath-0.42.0-3.el6.x86_64.rpm
005_rpm.png

tar zxvf Firebird-3.0.2.32703-0.i686.tar.gz
ls
006_tar.png

cd Firebird-3.0.2.32703-0.i686
ls
007_cd.png

./install.sh
008_install.png
  Firebird 3.0.2.32703-0.i686 Installation
  Press Enter to start installation or ^C to abort
Enterキーを押します

Please enter new password for SYSDBA user:
009_password.png



masterkey
Screenshot-root@localhost:-usr-local-src-Firebird-3.0.2.32703-0.i686-1.png
Press Enter to start installation or ^C to abort
Extracting install data
Updated /etc/services
Please enter new password for SYSDBA user: masterkey
/opt/firebird/bin/gsec: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory

Starting Firebird server [default] /usr/bin/dirname: extra operand `-daemon'
詳しくは `/usr/bin/dirname --help' を実行して下さい.
/opt/firebird/bin/fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory
                                                           [失敗]
Starting Firebird server [default] /usr/bin/dirname: extra operand `-daemon'
詳しくは `/usr/bin/dirname --help' を実行して下さい.
/opt/firebird/bin/fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory
                                                           [失敗]
Looks like standalone server failed to start
Trying to continue anyway...
Install completed
[root@localhost Firebird-3.0.2.32703-0.i686]#


cd /opt/firebird/bin
./isql -u sysdba -p masterkey
isql.png












CentOS 7

rpm -ihv libtommath-0.42.0-4.el7.x86_64.rpm
c7_rpm.png

Screenshot from 2017-05-27 18-43-20.png

Screenshot from 2017-05-27 18-44-10.png

Screenshot from 2017-05-27 18-44-17.png

Screenshot from 2017-05-27 18-44-30.png

Done.
Deleting...
Done.
Extracting install data
Please enter new password for SYSDBA user: masterkey
/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











ftp://ftp.muug.mb.ca/mirror/fedora/linux/releases/23/Everything/x86_64/os/Packages/l/libtommath-0.42.0-6.fc23.x86_64.rpm





download
cd /usr/local/src
rpm -ihv libtommath-0.42.0-6.fc23.x86_64.rpm
tar zxvf Firebird-3.0.2.32703-0.i686.tar.gz
ls
./install.sh

chkconfig --list firebird
service firebird stop
service firebird start
mkdir /var/fdb
chown -R firebird.root /var/fdb

cd /opt/firebird/bin
./isql -u sysdba -p masterkey
create database '/var/fdb/TEST.FDB';
exit;
ls /var/fdb

yum -y install gcc
yum -y install readline
yum -y install readline-devel
yum -y install zlib
yum -y install zlib-devel

[   ] epel-release-6-8.noarch.rpm   
http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm




cenos6
firewall
yum -y update
yum -y install libstdc++.so.5
yum -y install libstdc++.so.6
yum -y install libncurses.so.5



cd /usr/local/src
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

sansyo
https://centos.pkgs.org/6/epel-x86_64/libtommath-devel-0.42.0-3.el6.x86_64.rpm.html

rpm -Uvh epel-release-6-8.noarch.rpm

yum install libtommath-devel

wget https://sourceforge.net/projects/firebird/files/firebird-linux-i386/3.0.2-Release/Firebird-3.0.2.32703-0.i686.tar.gz

tar zxvf Firebird-3.0.2.32703-0.i686.tar.gz

cd Firebird-3.0.2.32703-0.i686

./install.sh


./isql -u sysdba -p masterkey
CREATE DATABASE /var/fdb/TEST4.FDB page_size 8192 default character set utf8;↵
CREATE DATABASE '/var/fdb/TEST4.FDB' page_size 8192 default character set utf8;↵
CREATE DATABASE '/var/fdb/TEST5.FDB' default character set utf8;↵
exit;

posted by a23 at 09:50| Comment(0) | Firebird

2015年12月23日

internal gds software consistency check (page in use during flush (210))

Firebird1.5.6でエラー

IBConsoleで、

internal gds software consistency check (page in use during flush (210))

database file appears corrupt()
wrong page type 
page 0 is of wrong type (expected 4, found 1)

1.jpg


IBExpeertで、
2ibexp.jpg


IBFirestAIDで。
3fa.jpg
4fa.jpg
ごこから先は、有償になるようです。




posted by a23 at 13:10| Comment(0) | Firebird