2020年07月01日

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つをダウンロード
Screenshot from 2020-06-28 15-18-39.png

2
Screenshot from 2020-06-28 15-18-42.png

3 GUIで、ソフトウェアのインストールで開く
Screenshot from 2020-06-28 15-18-47.png

4 インストールをクリック
Screenshot from 2020-06-28 15-18-51.png
5
Screenshot from 2020-06-28 15-19-02.png
6
Screenshot from 2020-06-28 15-19-09.png
7
Screenshot from 2020-06-28 15-19-16.png

8
Screenshot from 2020-06-28 15-19-22.png
9
Screenshot from 2020-06-28 15-19-27.png
10
Screenshot from 2020-06-28 15-19-37.png
11
Screenshot from 2020-06-28 15-19-42.png
12
Screenshot from 2020-06-28 15-20-43.png

13
Screenshot from 2020-06-28 15-21-19.png
14
15



posted by a23 at 12:34| Comment(0) | Firebird

2020年06月27日

Firebird 2.5.9

Windows ISQL


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;
posted by a23 at 14:42| Comment(0) | Firebird

2020年01月30日

Firebirdで壊れたDBの修復


gfix -m -user sysdba -password masterkey bkmkapp.fdb
gbak -b -e -g -user sysdba -password masterkey bkmkapp.fdb newdb.fdb


cd /opt/firebird/bin

gfix -m -user sysdba -password masterkey /var/FbSQL/bkmkapp.fdb

gbak -b -e -g -user sysdba -password masterkey /var/FbSQL/bkmkapp.fdb /var/FbSQL/newdb.fdb


./isql -u sysdba -p masterkey




---------------------------
IBConsole ANSI Edition (32bit)
---------------------------
database file appears corrupt ()

wrong page type

page 130134 is of wrong type (expected 6, found 5)
---------------------------
OK   
---------------------------

10.png




posted by a23 at 07:56| Comment(0) | Firebird