Rozdíly

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

--- firebird:firebird3 [2022/05/11 11:10] – [Script na vytvoreni backup a restore scriptu DB ODS 11->12] Karel Petrů
+++ firebird:firebird3 [2024/03/01 06:17] (aktuální) – [Instalace/upgrade FB2->3 Linux] Karel Petrů
@@ Řádek 10: / Řádek 10: @@
   * povolit firewall port 3050
+===== Instalace Linux =====
+  * nastavit [[:firebird:setenv|.obis_profile + .bashrc]]
+<code bash>
+#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
+sudo vim /lib/systemd/system/firebird-classic.socket #zmenit post 3050
+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 =====
@@ Řádek 19: / Řádek 97: @@
 cd /usr/lib/x86_64-linux-gnu/
 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
 cd /tmp/Firebird-3.0
@@ Řádek 37: / Řádek 116: @@
 gbak -R -V /mnt/backup/licence25.fbk localhost:/home/firebird/licence.fdb
 gbak -R -V /mnt/backup/data25.fbk localhost:/home/firebird/data.fdb
+sudo systemctl start cron
+sudo systemctl status cron
 </code>
@@ Řádek 59: / Řádek 140: @@
 <code 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
 #vytvoreni scriptu pro prevod: create_fbupgrade_scripts.sh [-d dataname] [/tmp/firebird64] #pro pomocnou embed verzi 2.5 - prevod zapomenutych DB
@@ Řádek 68: / Řádek 148: @@
 #  lftp ftp.epos.cz -e "get obis/firebird-clients/259/linux64-embed.tgz; exit"
 #  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
 #databaze velikost 1.6GB backup 60sec, restore 100sec, backup+restore 100sec (dellog_all_db zrychluje minimalne - 15sec)
@@ Řádek 127: / Řádek 209: @@
 echo "backup $LOCDB log /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
 EOF
@@ Řádek 139: / Řádek 221: @@
 echo "restore $LOCDB log /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
 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1
@@ Řádek 150: / Řádek 232: @@
 rm -f /tmp/$DBFN-25.log /tmp/$DBFN-30.log
 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
 echo "show version;" | $FBNEW/bin/isql $DB | tail -n 1