HQbird Firebird

HQbird is commercial Firebird distribution with monitoring and maintenance (backups, sweep, etc) tools for FirebirdSQL databases. Firebird version 3.0 + HQbird version 10.1.1209.

HQbird provides replication and improved performanace for big Firebird databases, and includes web consoles for managing backups, maintenance and performance monitoring.

Software Included

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Creating an App using the API

In addition to creating a Droplet from the HQbird Firebird 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB HQbird Firebird Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token) to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image": "ibsurgeon-hqbirdfirebird"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying HQbird Firebird

Steps to deploy your Firebird database:

1. To start using HQbird, login to http://your_droplet_public_ipv4:8082 and enter user and password: admin/strong password

HQbird has free 30 days trial, already activated on this image. 2. In HQbird web-console, enable embedded FTP - for this open dialog (click on FTP sign in the right upper corner), set checkmark “Enabled” and change password and/or username. 3. Upload database using embedded FTP. Default folder /fdb

Access to database files is restricted to /fdb by default. 4. Register databases you need to manage and monitor - for this click in the right bottom of HQbird to wheel “Add database”, specify full path for the database, and then setup backups, replication, etc.

See HQbird User Guide for details

After adding database, you can access monitoring web console http://your_droplet_public_ipv4:8083 5. Default passwords for Firebird databases SYSDBA/masterkey(for both Srp and Legacy_UserManager). 6. For security reasons, change all passwords: SYSDBA, FTP and HQbird.

To change default FTP password - use dialog with FTP settings (righ upper corner of web-console).

To change default HQbird password - use dialog with settings - click on the servername in the left upper corner

To change default SYSDBA database password, use SQL commands

ALTER USER SYSDBA PASSWORD ‘yournewpass’ USING PLUGIN SRP;

ALTER USER SYSDBA PASSWORD ‘yournewpass’ USING PLUGIN Legacy_UserManager;

Then it will be necessary to change SYSDBA password in web-console of HQbird, in the left upper corner, widget Server.