libcrypt.so.1

CenOS 8.3.2011

./gsec: error while loading shared libraries: libcrypt.so.1: cannot open shared object file: No such file or directory

http://mirror.centos.org/centos/8/BaseOS/x86_64/os/Packages/libxcrypt-4.1.1-4.el8.i686.rpm

CentOS8.2 Firebird1.5.6 SS install

メンテナンス用に、CentOS8.2 Firebird1.5.6 SS 

---

libxcrypt-4.1.1-4.el8.i686.rpm

ncurses-compat-libs-6.1-7.20180224.el8.i686.rpm

compat-libstdc++-33-3.2.3-72.el7.i686.rpm

FirebirdSS-1.5.6.5026-0.i686.rpm

---

1 　上の4つをダウンロード

2

3　GUIで、ソフトウェアのインストールで開く

4　インストールをクリック

5

6

7

8

9

10

11

12

13

14

15

Firebird 2.5.9

Windows　ISQL

https://symfoware.blog.fc2.com/blog-entry-1317.html

---

SQL> create database 'C:\data\sample.fdb'

CON> user 'sysdba'

CON> password 'masterkey'

CON> default character set utf8;

SQL> commit;

create database 'C:\data\s2.fdb' user 'sysdba' password 'masterkey' default character set cp932;

create database 'C:\data\s3.fdb' user 'sysdba' password 'masterkey' default character set sjis0208;

---

SQL> connect 'C:\data\sample.fdb'

CON> user 'sysdba'

CON> password 'masterkey';

Database: 'C:\data\test.fdb', User: sysdba

---

SQL> create table test (id int, name varchar(100));

SQL> insert into test(id,name) values (1, 'test_value');

SQL> commit;

---

SQL> select * from test;

---

quit;