Kapcsolódó információk:
Paraméterezési útmutatók

Összehasonlított verziók

Kulcs

  • Beillesztett sor.
  • Törölt sor.
  • Formázás megváltoztatva.

Installation

  1. Install Firebird SQL 3.0 server
    During the setup process, password must be "masterkey" for SYSDBA user

    1. via package manager

      1. Debian/Ubuntu
        # apt update
        # apt install firebird3.0-server

      2. Other Linux, see firebirdsql.org

    2. via docker
      Recommended the jacobalberty/firebird image from DockerHUB

      https://hub.docker.com/r/jacobalberty/firebird

      https://github.com/jacobalberty/firebird-docker

  2. Create QSoft specific ini file in the same directory as firebird.conf 
    (e.g. in Debian 10: /etc/firebird/3.0/)

    1. # nano firebird-qsoft.conf

    2. Insert specific config lines (see below: QSoft specific firebird conf)

  3. Modify firebird.conf file
    insert into the first line: include $(this)/firebird-qsoft.conf

  4. Restart firebirdFirebird SQL service

  5. Test connection 
    1. on the server: telnet localhost 3050   
    2. from remote client : telnet <server.ip> 3050

  6. Possible causes, if the connection is not working properly
    1. sysdba user password is not set up properly
      Use isql utillity to set correct password, see Firebird SQL documentation
    2. firewall exists on Linux server
      If required, modify firewall rules to allow communication 3050/TCP and 33050/TCP
       
    3. SUP slowly started
      like above, possible Firewall restriction
    4. In some distribution, access is restricted only to localhost by default
      in this case, comment the line "RemoteBindAddress = localhost" in firebird.conf

QSoft specific firebird.conf

Bővebben

Oldal szerepeltetése
Firebird 3 QSoft config - firebird.conf
Firebird 3 QSoft config - firebird.conf

 

Other information

Server models

Choice of the server model is determined by settings for a new configuration parameter ServerMode,
defining the locking and cache modes. It is specified at global level in firebird.conf.

See in our documentation: Firebird szerver modellek 

or at firebirdsql.org:

Notes of the new version

Panel

Tartalomjegyzék
maxLevel2