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

2017年05月23日

pgadmin3から接続 CentOS6.9 PostgreSQL10-beta ソースからコンパイルしてインストール

initdb --encoding=UTF8 --locale=C 

[root@localhost ~]# su - postgres
[postgres@localhost ~]$ psql
psql (10beta1)
Type "help" for help.

postgres=# \l
psql_\l.png


pgAdmin III より接続をこころみる (エラーが起こりました)

1. 警告
10beta.png

2.
ERROR:  function pg_last_xlog_receive_location() does not exist
LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
10bete-1.png

3.
Column not found in pgSet: usecreatedb
10bete-2.png


4.
Column not found in pgSet: usesuper
10bete-3.png

5.
Column not found in pgSet: upsince
10bete-4.png


6.
Column not found in pgSet: confloadedsince
10bete-5.png


7.
Column not found in pgSet: inrecovery
10bete-6.png

8.
Column not found in pgSet: replayloc
10bete-7.png


9.
Column not found in pgSet: receiveloc
10bete-8.png


10.
Column not found in pgSet: replay_timestamp
10bete-9.png

11.
Column not found in pgSet: isreplaypaused
10bete-10.png

そのご接続はOK
10bete-20.png

新しいデータベース...の作成もOK
10bete-21.png




posted by a23 at 16:09| Comment(0) | PostgreSQL