1.3. fejezet, Firebird

sudo apt-get install firebird3.0-server
sudo usermod -a -G firebird pzoli
# login-logout
 
# adatbázisok lokációja
nano /etc/firebird/3.0/firebird.conf 
> DatabaseAccess = Restrict /home/pzoli/work/interbase
 
# adatbázis alias hozzáadása
nano /etc/firebird/3.0/databases.conf 
> mytest = /home/pzoli/work/interbase/fb.fdb
> fb1 = /var/lib/firebird/3.0/data/fb.fdb
 
sudo mkdir /var/lib/firebird/3.0/data/
 
# szolgáltátás újraindítása
sudo service firebird3.0 restart
 
# sql kliens kapcsolat
sudo isql-fb
SQL > create database '/var/lib/firebird/3.0/data/fb.fdb' user 'sysdba' password 'password';
SQL > quit;
 
chown firebird:firebird -R /var/lib/firebird/3.0/data/
 
isql-fb
SQL > connect fb1 user sysdba password 'password';
SQL > create user pzoli password 'password';
SQL > CREATE TABLE posts (id integer generated by default as identity primary key, username VARCHAR(50));
SQL > grant select, insert, update, delete on posts to pzoli;
 
# GUI kliens
sudo apt-get install flamerobin
# database path = fb1