Installing HQbird ServerSide for Windows
Please read the full version of the installation process in HQbird User Guide.
HQbird ServerSide 2017 includes Firebird 2.5 and 3.0 as part of its installer, so Firebird will be installed as part of HQbird. It is mandatory to install Firebird bundled with HQbird ServerSide installer if you plan to use replication (it also requires HQbird Enterprise license, full or trial).
Optionally you can choose not to install Firebird with HQbird and use previously installed Firebird – in this case, make sure that installed version is compatible (1.5, 2.0, 2.1, 2.5.2, 2.5.5, 2.5.6, 2.5.7, 3.0.1, 3.0.2).
Please note, that only Firebird 2.5 and 3.0 are fully supported in HQbird, the old Firebird versions are supported partially. We offer the affordable Firebird migration service with guaranteed and fast result to migrate Firebird to the latest version.
Installing HQbird Server-Side Tools
Download HQbird Server-Side Tolls from http://ib-aid.com/en/hqbird/
. The distribution package of HQbird is the same for the 32-bit and 64-bit versions of the Firebird engine.
Make sure that HQbird Server-Side Tools is signed with the iBase.ru certificate and run it:
Figure 1. HQbird Server-Side Tools should have the signature
The HQbird Server-Side Tools installation wizard will be launched after that and it will take you through several steps, such as agreeing to the license agreement and selecting the installation folder.
After that you will see the installation step where you can select components to be installed:
Figure 2. Select components from HQbird Server-Side Tools to be installed
If you select to install Firebird with HQbird (recommended), it will install Firebird in the subfolder of HQbird installation, by default C:\HQBird\Firebird25 (C:\HQBird\Firebird30). The installation wizard will ask to specify the port for Firebird engine installed with HQbird. By default, the port is 3050. If the port will be occupied by another running Firebird, the installation wizard will warn you and make to choose another port. Or, you can stop and uninstall another Firebird service.
If you don't opt to install Firebird with HQbird, the installation wizard will ask you to specify the folder where Firebird is installed:
Figure 3. Confirm the location of the current Firebird instance
Attention! In this step, the installation wizard checks the availability and compatibility of the installed Firebird version with HQbird. If the specified folder does not contain a correctly installed Firebird version, you will see the following warning:
Figure 4. This warning from the installation wizard prompts you to select the correct Firebird folder
If the specified folder contains a version of Firebird incompatible with HQbird, you will see the following warning:
Figure 5. This warning informs you that you need to update Firebird
You should update Firebird to version 2.5.5 or higher for HQbird Standard to be installed.
After that you should select folders for storing configuration files, backup copies, statistics, and HQbird log files:
Figure 6. Select folders for HQbird configuration and log files
By default, the installation wizard offers to create folders for configuration and log files in C:\HQbirdData.
Usually, we recommend that you select another location for these purposes on a disk with a larger amount of free space.
If configuration files already exist in the selected location, the installation wizard will display the corresponding warning:
Figure 7. Warning about existing configuration files
If you decide to rename the existing configuration folder, the installation wizard will display one more warning:
Figure 8. Renaming confirmation
After you confirm it, the folder with the existing configuration files will be renamed and the installation will continue.
You may have to restart the computer after the installation:
After that, you have to activate HQbird (see How to Activate HQbird
) and proceed to configure the HQbird components.
Installing HQbird Administrator (Windows)
To install HQBird Administrator, download the distribution package from http://hqbird.com/en/hqbird/.
Run the installation wizard and follow the standard installation steps: select the installation folder:
Figure 9. Select where to install HQbird Administrator
Select the tools to install after that. We recommend that you install all tools.
Figure 10. Select tools to install
Follow the instructions after that. After the installation is over, you will be offered to launch the activation wizard.
How to Activate HQbird
To activate HQbird, you can either use a separate utility included in the server and administrator packages for Windows, or use the registration mechanism embedded into the HQBird Firebird DataGuard web interface (for Windows and Linux), or run any tool from the administrator software and use the built-in activation wizard.
The activation wizard looks and works the same both in the tools and in the separate utility. It is enough to perform activation once on any computer that can connect to the server where HQbird Server-Side Tools is installed.
You can launch the registration utility from the Start
menu (IBSurgeon\HQbird Admin\Register HQbird). It looks something like this:
Figure 11. HQbird Registration Utility
If you click the Register
button (or Re-Register for repeated registration), you will see the activation wizard:
Figure 12. HQbird Activation Wizard
To activate HQbird, specify the IP address or the name of the server HQbird is installed on in the upper input field and click Connect to HQbird Server
Then enter your registration data. If you have a license, enter your e-mail address and password that you used to register with the IBSurgeon Deploy Center and click Activation
If you have no license, specify your e-mail address and click Activation
. You will be automatically registered and the password will be sent to your e-mail address.
Right after you click Activation
, the registration wizard will try to connect to the IBSurgeon Deploy Center (http://deploy.ib-aid.com
) and obtain a license. If it succeeds, you will see the corresponding message. If there are any problems, you will see the error message.
If you forget the password, click the I forgot password...
button and it will open the browser with the password recovery form.
If you need to purchase a new or additional license or renew your subscription, click Order now!
Click Close this window
after the registration is over.
Internet Activation via a Client Computer
If the server with HQbird Server-Side Tools installed on it does not have access to the Internet, you can still activate it via the Internet: you can install HQbird Administrator on any client computer that has both access to the Internet and access to the HQbird Server-Side Tools server and perform activation.
If the server and all client computers have no access to the Internet, you should use offline activation. To do it, contact us at [email protected]
specifying the number of your order.
How to install Firebird for Windows
To install Firebird, download the HQbird Server (Firebird Engine) module from http://hqbird.com/en/hqbird/download-hqbird (select the 32-bit or 64-bit version depending on the operating system and other requirements).
This module is actually an archive file with Firebird 2.5.5. Unpack the archive file to a suitable location (for instance, C:\Firebird255), go to the Bin folder and then use the Run As Administrator option to run the batch file with the architecture you need.
We recommend that you run the file install-superclassic.bat that will install Firebird with the SuperClassic architecture. Provided that you use the optimized configuration file firebird.conf (see Optimized Configurations below), this architecture is the best default choice for Firebird 2.5 running on systems with medium loads.
Of course, you can choose the SuperServer or Classic architecture if you know what you need.
As a result of running the command file, Firebird of the selected architecture will be installed and run as a service. You can make sure the Firebird service is installed and running in the Services snap-in (services.msc):
Figure 13. Firebird Service
In this example, Firebird is installed in the folder H:\Firebird\Firebird-188.8.131.52928-0_x64 and running as a service with the SuperClassic architecture.
How to Update Firebird on Windows
If you get the message that you need to update Firebird to version 2.5.5 during the installation of HQbird Server-Side Tools, do the following:
1) Download the HQbird Server (Firebird Engine) archive file corresponding to the version of Firebird installed on your computer. For instance, if you have 64-bit Firebird 2.5.3 installed, you should download HQbird 64-bit.
2) Back up all Firebird databases with the help of the gbak utility (or make sure that you have an up-to-date backup copy created with gbak).
3) Close all user and system applications using Firebird.
4) Stop the Firebird service. Note that if you use the Classic architecture, you will have to not only stop the service but also manually stop (e.g. in Task Manager) all fb_inet_server.exe processes.
5) Rename the bin folder in the Firebird folder into binOrig.
6) Copy the bin folder from HQbird Server (Firebird Engine) to the Firebird folder.
7) Start the Firebird service and make sure your applications are running correctly.
8) If you update Firebird from version 2.5.1 or earlier, schedule to run the backup/restore cycle for your databases as soon as possible in order to make the on-disk structure (ODS) of your database compliant with the Firebird version being used or otherwise some important features will be unavailable. If you update from version 2.5.2 or higher, the backup/restore cycle is not required.
9) Continue installing HQbird Server-Side Tools.
What HQbird Modules Consist of
It is possible to single out components in the HQbird modules that are responsible for certain operations (such as backup, monitoring, database repair).
Figure 15. HQbird Modules
The table below shows how features are distributed among the HQbird modules:
(automated verified and incremental backup, cloud backup)
||FBDataGuard runs on the server side and performs all kinds of backup
(balanced, read-intensive and write-intensive)
|FBDataGuard, a collection of optimized configurations
||The optimized configuration file is finally customized on the basis of recommendations from FBDataGuard
|Performance Test Suite
||Performance Test Suite
||The test measures the hardware performance
|Monitoring SQL Queries
(MON$, TraceAPI, and FBScanner)
|Performance Monitor, MON$Logger, FBScanner
||Three different monitoring methods are used in different scenarios
(online validation, database health check, log analysis)
||Everything is carried out on the server. FBDataGuard sends notifications by e-mail.
(dynamic analysis of transaction markers)
|FBDataGuard, Transaction Monitor, MON$Logger
||FBDataGuard tracks problems with transactions, Transaction Monitor and MON$Logger show the dynamics of changes and the current status of active transactions.
|Database Structure Analysis
(table and index sizes, fragmentation, versioning, etc.)
||Database Analyst analyzes the database structure in detail and shows warnings and recommendations.
|SQL Development & Debugging
(a GUI tool for developing databases and queries)
||SQL Studio is a powerful tool for developing and debugging database objects and SQL queries.
(database recovery, backup recovery, record undeletion)
|FirstAID, FBDataGuard, IBBackupSurgeon, IBUndelete
||FirstAID repairs databases when they get corrupted, FBDataGuard stores important metadata thus increasing the chances of successful repairs, IBBackupSurgeon exports data from corrupted backup copies. IBUndelete and FirstAID undo record deletion.
|The HQbird Enterprise edition includes replication and high availability tools.