Obis4SQL Wiki

Uživatelské nástroje

Nástroje pro tento web

Umístění: index » firebird » firebird3
Historie:
firebird:firebird3

Rozdíly

Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.

Odkaz na výstup diff

Obě strany předchozí revizePředchozí verze
Následující verze		Předchozí verze
firebird:firebird3 [2022/05/04 14:05] – [Instalace/upgrade FB2->3 Linux] Karel Petrůfirebird:firebird3 [2025/09/30 06:42] (aktuální) – [Instalace/upgrade FB2->3 Linux] Libor Kadaník
Řádek 10: Řádek 10:
   * povolit firewall port 3050   * povolit firewall port 3050
  
 +===== Instalace Linux =====
  
 +  * nastavit [[:firebird:setenv|.obis_profile + .bashrc]]
 +
 +<code bash>
 +apt install zsh
 +useradd -m -g users -G sudo -s /bin/zsh obis
 +passwd obis
 +mkdir /home/obis/.ssh/
 +cp /root/.ssh/authorized_keys /home/obis/.ssh/
 +chown obis:users /home/obis/.ssh -R
 +#pridat contrib do /etc/apt/sources.list
 +sudo apt update
 +sudo apt-get install libtommath1 libncurses5 vim mc unzip lftp ttf-mscorefonts-installer liblua5.3-0
 +cd /usr/lib/x86_64-linux-gnu/
 +sudo ln -s libtommath.so.1 libtommath.so.0
 +sudo dpkg-reconfigure locales
 +cd /tmp
 +wget https://github.com/FirebirdSQL/firebird/releases/download/...   #http://firebirdsql.org/en/firebird-3-0/
 +tar -xzvf Firebird-3.0
 +cd /tmp/Firebird-3.0
 +sudo ./install.sh  #nastavuje heslo sysdba
 +sudo systemctl status firebird-superserver.service
 +sudo /opt/firebird/bin/changeServerMode.sh
 +echo "WireCrypt = Required" | sudo tee -a /opt/firebird/firebird.conf
 +sudo systemctl edit firebird-classic.socket
 +[Socket]
 +ListenStream=
 +ListenStream=13050
 +sudo systemctl daemon-reload
 +sudo systemctl restart firebird-classic.socket
 +echo "show version;" | isql localhost:employee
 +sudo usermod -d /home/firebird firebird
 +sudo mkdir -p /home/firebird/fdbs
 +sudo chown firebird:firebird /home/firebird -R
 +sudo chmod g+rwX /home/firebird/fdbs
 +sudo tar -xzvf /tmp/data.tar.gz -C /home/firebird/fdbs
 +sudo chown firebird:firebird /home/firebird -R
 +sudo usermod -a -G firebird obis
 +isql localhost:/home/firebird/fdbs/licence.fdb
 +isql /home/firebird/fdbs/licence.fdb
 +</code>
 +
 +
 +==== OBIS ====
 +
 +<code bash>
 +unzip install/obis-client-64bit.zip
 +tar -xzvf install/obis-client-64bit.tar.gz
 +vim etc/obisrc.xml
 +cd lualib5.3/lib/x86_64-Linux
 +ln -s ssl.so.3.0.0 ssl.so
 +ln -s openssl.so.3.0.0 openssl.so
 +./bin64/passwd -dbpass $ISC_PASSWORD
 +./bin64/licencec -list
 +</code>
 +
 +==== SAMBA ====
 +
 +<code bash>
 +sudo apt-get install samba
 +sudo vim /etc/samba/smb.conf
 +sudo smbpasswd -a obis
 +sudo systemctl restart smbd.service
 +</code>
 +
 +
 +** smb.conf**
 +
 +<code>
 +preserve case = yes
 +
 +[obis]
 +   comment = Obis
 +   path = /mnt/data/obis5
 +   writeable = yes
 +   create mode = 664
 +   directory mode = 775
 +   guest ok = no
 +   #valid users = @users
 +
 +[obisdoc]
 +   comment = Obis dokumenty
 +   path = /mnt/data/obisdoc
 +   writeable = yes
 +   create mode = 664
 +   directory mode = 775
 +   guest ok = no
 +   #valid users = @users
 +</code>
 ===== Instalace/upgrade FB2->3 Linux ===== ===== Instalace/upgrade FB2->3 Linux =====
  
Řádek 19: Řádek 108:
 cd /usr/lib/x86_64-linux-gnu/ cd /usr/lib/x86_64-linux-gnu/
 sudo ln -s libtommath.so.1 libtommath.so.0 sudo ln -s libtommath.so.1 libtommath.so.0
-wget https://github.com/FirebirdSQL/firebird/releases/download/...+sudo systemctl stop cron 
 +wget https://github.com/FirebirdSQL/firebird/releases/download/... #https://firebirdsql.org/en/firebird-3-0/
 tar -xzvf Firebird-3.0 tar -xzvf Firebird-3.0
 cd /tmp/Firebird-3.0 cd /tmp/Firebird-3.0
Řádek 28: Řádek 118:
 sudo systemctl status xinetd.service sudo systemctl status xinetd.service
 sudo mv /opt/firebird /opt/firebird25.bk sudo mv /opt/firebird /opt/firebird25.bk
 +sudo systemctl stop "xmlrpcserver*.service"
 sudo killall fb_inet_server sudo killall fb_inet_server
 sudo ./install.sh  #nastavuje heslo sysdba sudo ./install.sh  #nastavuje heslo sysdba
 sudo systemctl status firebird-superserver.service sudo systemctl status firebird-superserver.service
 sudo /opt/firebird/bin/changeServerMode.sh sudo /opt/firebird/bin/changeServerMode.sh
 +echo "WireCrypt = Required" | sudo tee -a /opt/firebird/firebird.conf
 +
 +#nastaveni portu 13050
 +sudo EDITOR=vim systemctl edit firebird-classic.socket
 + [Socket]
 + ListenStream= 
 + ListenStream=13050
 +sudo systemctl daemon-reload
 +sudo systemctl restart firebird-classic.socket
 +
 sudo systemctl status firebird-classic.socket sudo systemctl status firebird-classic.socket
-echo "show version;" | isql localhost:employee.fdb+echo "show version;" | isql localhost/13050:employee.fdb
 sudo mv /home/firebird/*.fdb /tmp/ sudo mv /home/firebird/*.fdb /tmp/
-gbak -R -V /mnt/backup/licence25.fbk localhost:/home/firebird/licence.fdb +gbak -R -V /mnt/backup/licence25.fbk localhost/13050:/home/firebird/licence.fdb 
-gbak -R -V /mnt/backup/data25.fbk localhost:/home/firebird/data.fdb+gbak -R -V /mnt/backup/data25.fbk localhost/13050:/home/firebird/data.fdb 
 +passwd.bin -dbpass 'heslo_sysdba' 
 +sudo systemctl start cron 
 +sudo systemctl status cron 
 +sudo systemctl start "xmlrpcserver*.service" --all 
 + 
 +#doplnit  <WireCompression>1</WireCompression># 
 +#pustit backup-firebird 0-3 
 +#smazat popř. nologin 
 </code> </code>
  
Řádek 59: Řádek 169:
 <code bash> <code bash>
 #!/bin/bash #!/bin/bash
-#zkopirovat DB do /tmp/data.fdb +#etc/obisrc.xml - presunout data.fdb na prvni misto
-#./create_fbupgrade_scripts.sh -d data-tmp /home/kaja/obis4git/firebird25+
 #uzivatel musi mit pravo zapisu do /firebird/fdbs - jinak nejede restore rychle lokalne ale pomalu pres remote #uzivatel musi mit pravo zapisu do /firebird/fdbs - jinak nejede restore rychle lokalne ale pomalu pres remote
 #vytvoreni scriptu pro prevod: create_fbupgrade_scripts.sh [-d dataname] [/tmp/firebird64] #pro pomocnou embed verzi 2.5 - prevod zapomenutych DB #vytvoreni scriptu pro prevod: create_fbupgrade_scripts.sh [-d dataname] [/tmp/firebird64] #pro pomocnou embed verzi 2.5 - prevod zapomenutych DB
Řádek 68: Řádek 177:
 #  lftp ftp.epos.cz -e "get obis/firebird-clients/259/linux64-embed.tgz; exit" #  lftp ftp.epos.cz -e "get obis/firebird-clients/259/linux64-embed.tgz; exit"
 #  tar -xzvf linux64-embed.tgz #  tar -xzvf linux64-embed.tgz
 +#zkopirovat DB do /tmp/data.fdb
 +#./create_fbupgrade_scripts.sh -d data-tmp /home/kaja/obis4git/firebird25
 #  nasledne: backup_restore_all_db.sh #  nasledne: backup_restore_all_db.sh
 #databaze velikost 1.6GB backup 60sec, restore 100sec, backup+restore 100sec (dellog_all_db zrychluje minimalne - 15sec) #databaze velikost 1.6GB backup 60sec, restore 100sec, backup+restore 100sec (dellog_all_db zrychluje minimalne - 15sec)
Řádek 127: Řádek 238:
 echo "backup $LOCDB log /tmp/$DBFN-25.log" echo "backup $LOCDB log /tmp/$DBFN-25.log"
 rm -f /tmp/$DBFN-25.log rm -f /tmp/$DBFN-25.log
-$FBOLD/bin/gbak -z -b -g -v -st t -y /tmp/$DBFN-25.log  $LOCDB $BACKUPPATH/$DBFN.fbk+$FBOLD/bin/gbak -z -b -g -v -y /tmp/$DBFN-25.log  $LOCDB $BACKUPPATH/$DBFN.fbk
 ls -lh $BACKUPPATH/$DBFN.fbk ls -lh $BACKUPPATH/$DBFN.fbk
 EOF EOF
Řádek 133: Řádek 244:
 cat <<EOF >>$MOVESCRIPTS cat <<EOF >>$MOVESCRIPTS
 mv $LOCDB $BACKUPPATH/$DBFN.ods11.fdb mv $LOCDB $BACKUPPATH/$DBFN.ods11.fdb
-ls -lh $BACKUPPATH/*.ods11.fdb+ls -lh $BACKUPPATH/$DBFN.ods11.fdb
 EOF EOF
  
Řádek 139: Řádek 250:
 echo "restore $LOCDB log /tmp/$DBFN-30.log" echo "restore $LOCDB log /tmp/$DBFN-30.log"
 rm -f /tmp/$DBFN-30.log rm -f /tmp/$DBFN-30.log
-$FBNEW/bin/gbak -z -c -v -st t -y /tmp/$DBFN-30.log $BACKUPPATH/$DBFN.fbk $LOCDB+$FBNEW/bin/gbak -z -c -v -y /tmp/$DBFN-30.log $BACKUPPATH/$DBFN.fbk $LOCDB
 sudo chown firebird:firebird $LOCDB sudo chown firebird:firebird $LOCDB
 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1
Řádek 150: Řádek 261:
 rm -f /tmp/$DBFN-25.log /tmp/$DBFN-30.log rm -f /tmp/$DBFN-25.log /tmp/$DBFN-30.log
 mv $LOCDB $LOCDB.ods11 mv $LOCDB $LOCDB.ods11
-FIREBIRD=$FBOLD LD_LIBRARY_PATH=$FBOLD/lib $FBOLD/bin/gbak -z -b -g -v -st t -y /tmp/$DBFN-25.log $LOCDB.ods11 stdout | pv | $FBNEW/bin/gbak -z -c -v -st t -y /tmp/$DBFN-30.log stdin $LOCDB+FIREBIRD=$FBOLD LD_LIBRARY_PATH=$FBOLD/lib $FBOLD/bin/gbak -z -b -g -v -y /tmp/$DBFN-25.log $LOCDB.ods11 stdout | pv | $FBNEW/bin/gbak -z -c -v -y /tmp/$DBFN-30.log stdin $LOCDB
 sudo chown firebird:firebird $LOCDB sudo chown firebird:firebird $LOCDB
 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1
firebird/firebird3.1651673110.txt.gz · Poslední úprava: 2022/05/04 14:05 autor: Karel Petrů