Manual in PDF format

1. Firebird database server installation

1.1. Download the installer

  • Download the Firebird 2.5 database server installer, which can be found on its official website www.firebirdsql.org/en/downloads under the “Server Packages” category. There are several variants to choose from for 32-bit and 64-bit systems.
  • Download the variant “Classic, Superclassic&Superserver – Windows executable installer for full Superclassic/Classic or Superserver, recommended for first-time users” according to your system.
  • This guide covers installing Firebird version 2.5.8. in the SuperClassic version.

1.2. Firebird installation

  • After running the installer, you may be asked by the system if you want to allow the installer to make changes to your computer – select “Yes”.

Obrázek.png

  • In the next step, select the required installation language, read and agree to the license agreement, and select the location where you want to install Firebird.
  • The default path is “C:\ProgramFiles\Firebird\Firebird_2_5”, do not change this path.
  • Next, select “Classic server binary” – this option is not checked by default.

Obrázek.png

  • In the next step, select “Use SuperClassic” – this option is not checked by default.

Obrázek.png

  • During the installation of the Firebird database server, it is possible to set the server to three versions – “Classic”, “SuperClassic” and “SuperServer”. One of the main differences between the three versions is the number of instances of the processes used. The “Classic” version creates a separate “fb_inet_server.exe” process for each client that accesses the Firebird database. The “SuperClassic” version creates one “fb_inet_server.exe” process for all users with a number of threads that corresponds to the number of logged in users. The latest version of “SuperServer” creates only one single-threaded “fb_server.exe” process for all users.
  • For example, for 50 users logged in to NET Genium is:
    • In the “Classic” version, 50 “fb_inet_server.exe” processes have been created.
    • In the “SuperClassic” version, one process “fb_inet_server.exe” with 50 threads.
    • In the “SuperServer” version, one process “fb_server.exe” with one thread.
  • We recommend the “SuperClassic” version when installing the Firebird database server for NET Genium.
  • At the end of the installation, an overview of the items that will be installed will be displayed. Click the “Next” button and select “Install”.

1.3. Additional settings

1.3.1. Creating a “Classic.txt” file

  • Create a “Classic.txt” file in the data directory where you want to store all your Firebird databases, eg “C:\Firebird\Classic.txt” (the content of this file does not matter).
  • In order for NET Genium to be able to identify the version of the Firebird database without having to search the processes running on the system, it is necessary to insert the “Classic.txt” file into the “Firebird” directory (where the individual databases are stored). If the “Classic.txt” file is stored in the “Firebird” directory, NET Genium automatically knows that it is a “Classic” or “SuperClassic” version.
  • Each time the database structure is changed (adding a new column, renaming a column, changing a column data type, deleting a column), NET Genium will try to identify the “Classic” or “SuperClassic” version by searching for the “Classic.txt” file. If this file is found, NET Genium will try to synchronize the new database structure in all processes or threads by running the “FbConnection.ClearPool” command. In fact, this means that all currently open connections to the database are closed and the “connection pool” is emptied. If any of these connections are actively in use at the same time, the “FbConnection.ClearPool” command will fail and the error message “Update Firebird metadata cache failed. Please run FbConnection.ClearPool manually.” will be displayed. This error message does not limit the administrator who initiated the database structure change. Its thread has changed structure, so its thread is already out of sync. Only other users could see error messages such as “Column not found in database” and so on. Usually, you just have to wait a while for other users' threads to sync. If this does not happen for a long time and the situation needs to be addressed urgently, it is possible to run the “FbConnection.ClearPool command manually directly from the NET Genium tools.

1.3.2. Installing the library “ngudf.dll”

  • The “ngudf.zip” archive is located in the “bin” directory of NET Genium. The contents of this archive are files “ngudf.dll” and “download-and-install.txt” – separately in folders for 64-bit and 32-bit systems. Depending on your system copy the file “ngudf.dll” to the directory “UDF” where you have Firebird installed (eg “C:\ProgramFiles\Firebird\Firebird_2_5\UDF”).

1.4. Installing Microsoft Visual C++ 2015 Redistributable (vc_redist)

Obrázek.png

1.5. Determining the version of the Firebird database server

  • If the Firebird database server has been installed on your computer or server for some time and you need to find out which version it is, start the “Task Manager” application and find the “Firebird SQL Server” process here, click on it right-click and select “Properties”.

Obrázek.png

Obrázek.png

  • If multiple instances of the Firebird database process are found in the list, this is the “Classic” version.
  • Go to the “General” tab and see what is listed in the process name. If indicated “fb_inet_server.exe”, this is the “SuperClassic” version, but if “fb_server.exe”, this is the “SuperServer” version.

Obrázek.png

1.6. Restart the Firebird database server

  • If for some reason it is necessary to restart the Firebird database server, start the “Task manager” application.

Obrázek.png

  • Then you need to select the “Services” tab and right-click on “FirebirdServerDefaultInstance” from the list of services. Then all you have to do is select an option from the menu that appears “Restart”.
  • In some cases, it will only happen that the service will be stopped, so it is then necessary to press “Start”.

Obrázek.png

2. FlameRobin installation

2.1. Installing Microsoft Visual C++ 2015 Redistributable (vc_redist)

Obrázek.png

2.2. Download the installer FlameRobin

2.3. FlameRobin installation

  • Read and agree to the license terms and click the button “Next”.

Obrázek.png

  • Select the location where you want to install FlameRobin and click the button “Next”.

Obrázek.png

  • You can then choose whether to place a program shortcut in the “Start” menu and an icon on the desktop.
  • Click the button Install”
  • To continue using FlameRobin, you must create or register your new database server and its database.

Obrázek.png

2.4. Registration of an existing database

  • To register an existing database, you must first have NET Genium installed.
  • In FlameRobin, click on “Database” and select “Register existing database…”.

Obrázek.png

  • Fill in:
    • The path where you have the database stored
    • Your database name (filled in automatically if you select the database path as the first step)
    • Username “sysdba”
    • Password “masterkey”
    • Charset “WIN1250”
  • Click the button “Save”.

Obrázek.png