firebird 3.0.8 on almalinux

#1 · 4 enero, 2022, 12:49 pm

dnf install epel-release -y
dnf makecache
yum groupinstall "Development Tools"
dnf install libicu-devel
dnf install libtermcap-devel
dnf install -y libtommath
wget https://github.com/FirebirdSQL/firebird/releases/download/v3.0.8/Firebird-3.0.8.33535-0.tar.bz2
ln -s /usr/lib64/libtommath.so.1.1.0 /usr/lib64/libtommath.so.0
ln -s /usr/lib64/libncurses.so.6.1 /usr/lib64/libncurses.so.5
cd Firebird-3.0.8.33535-0
./install.sh
password masterkey
vi ~/.bash_profile
PATH=$PATH:$HOME/bin:/opt/firebird/bin/
source ~/.bash_profile
firewall-cmd --permanent --add-port=3050/tcp
firewall-cmd --reload
sudo nano ~/.bashrc
al final export PATH=$PATH:/opt/firebird/bin/

#2 · 4 enero, 2022, 12:51 pm

scripts de copias

#!/bin/bash

dia=(`date +"%m-%d-%Y"`)

gbak -b -t -v -user SYSDBA -password masterkey /raid/database/xxxx.ibs /raid/backupsdata/xxxxxx.$dia.gbk
gbak -b -t -v -user SYSDBA -password masterkey /raid/database/xxxxxx.ibs /raid/backupsdata/xxxxxx.$dia.gbk
gbak -b -t -v -user SYSDBA -password masterkey /raid/database/xxxxxx.ibs /raid/backupsdata/xxxxxx.$dia.gbk

#3 · 4 enero, 2022, 1:13 pm

Restore

gbak -c -user SYSDBA -password masterkey E:\database.fbk E:\database_restore.fdb

#4 · 4 enero, 2022, 1:21 pm

operar on isql;

connect /rutadelabasededatos/nombrefichero.ext

user 'SYSDBA' password 'masterkey';↵

#5 · 4 enero, 2022, 6:09 pm

firebird-classic@.service

Unit]
Description=Firebird Database Server ( Classic )
After=syslog.target

[Service]
User=firebird
Group=firebird
ExecStart=/opt/firebird/bin/firebird
StandardInput=socket
StandardError=syslog

#6 · 4 enero, 2022, 6:10 pm

firebird-classic.socket

[Unit]
Description=Firebird Classic Activation Socket
Conflicts=firebird-superserver.service

[Socket]
ListenStream=3050
Accept=true
MaxConnections=2048
KeepAlive=true

[Install]
WantedBy=sockets.target

Hispanitat nº 7 Local C

+34 600 676 872

Lunes-Viernes: 9:30 a 13:30 - 16:30 a 20:00

firebird 3.0.8 on almalinux

servicios

textos legales

Contacto