HQbird Firebird v3.0

HQbird Firebird 3.0.12.33746-11.0.0703 installed on Centos 9

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.

Deploy to DO

Creating an App using the API

In addition to creating a Droplet from the HQbird Firebird v3.0 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB HQbird Firebird v3.0 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-hqbirdfirebirdv3"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying HQbird Firebird v3.0

Steps to deploy your Firebird database:

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.

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.

Upload database using embedded FTP. Default folder /opt/database

Access to database files is restricted to /opt/database by default.

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

Default passwords for Firebird databases SYSDBA/masterkey(for both Srp and Legacy_UserManager).

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.