Rocky Linux 8.5にデータベースFirebirdをインストールする

2021年11月26日

1.OSバージョンの確認

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
# cat /etc/redhat-release
Rocky Linux release 8.5 (Green Obsidian)
# cat /etc/redhat-release Rocky Linux release 8.5 (Green Obsidian)
# cat /etc/redhat-release
Rocky Linux release 8.5 (Green Obsidian)

2.firebirdインストール

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
# sudo dnf install firebird
インストール済み:
firebird-4.0.0.2496-2.el8.x86_64 firebird-utils-4.0.0.2496-2.el8.x86_64
libfbclient2-4.0.0.2496-2.el8.x86_64 libib-util-4.0.0.2496-2.el8.x86_64
libtomcrypt-1.18.2-5.el8.x86_64 libtommath-1.1.0-1.el8.x86_64
# sudo dnf install firebird 略 インストール済み: firebird-4.0.0.2496-2.el8.x86_64 firebird-utils-4.0.0.2496-2.el8.x86_64 libfbclient2-4.0.0.2496-2.el8.x86_64 libib-util-4.0.0.2496-2.el8.x86_64 libtomcrypt-1.18.2-5.el8.x86_64 libtommath-1.1.0-1.el8.x86_64
# sudo dnf install firebird
略
インストール済み:
firebird-4.0.0.2496-2.el8.x86_64 firebird-utils-4.0.0.2496-2.el8.x86_64
libfbclient2-4.0.0.2496-2.el8.x86_64 libib-util-4.0.0.2496-2.el8.x86_64
libtomcrypt-1.18.2-5.el8.x86_64 libtommath-1.1.0-1.el8.x86_64

3.Firebird の接続
# isql-fb
Use CONNECT or CREATE DATABASE to specify a database
SQL>

4.データベース生成
SQL> create database 'arkgameb’ default character set utf8;

データベースが生成されたことを確認

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> show database;
Database: arkgameb
Owner: SYSDBA
PAGE_SIZE 8192
Number of DB pages allocated = 224
Number of DB pages used = 216
Number of DB pages free = 8
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 1
Transaction - oldest active = 2
Transaction - oldest snapshot = 2
Transaction - Next = 7
ODS = 13.0
Database not encrypted
Default Character set: UTF8
SQL> show database; Database: arkgameb Owner: SYSDBA PAGE_SIZE 8192 Number of DB pages allocated = 224 Number of DB pages used = 216 Number of DB pages free = 8 Sweep interval = 20000 Forced Writes are ON Transaction - oldest = 1 Transaction - oldest active = 2 Transaction - oldest snapshot = 2 Transaction - Next = 7 ODS = 13.0 Database not encrypted Default Character set: UTF8
SQL> show database;
Database: arkgameb
        Owner: SYSDBA
PAGE_SIZE 8192
Number of DB pages allocated = 224
Number of DB pages used = 216
Number of DB pages free = 8
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 1
Transaction - oldest active = 2
Transaction - oldest snapshot = 2
Transaction - Next = 7
ODS = 13.0
Database not encrypted
Default Character set: UTF8

終了
SQL> exit;

Rocky Linux 8

Posted by arkgame