Guide – How To Start – Firebird 3.0.7 on Ubuntu 20.04 LTS

Firebird is an SQL relational database management system that runs on Linux, Microsoft Windows, macOS, and several Unix platforms. It is powerful and lightweight and performs excellently and scales impressively

This is a quick deployment and ready-to-run image.
Simple and rapid installation. Easy to maintain.

Connection to Firebird 3.0.7 on Ubuntu Server 20.04 LTS using DBeaver through SSH Tunnel

1. For the connection to the server, you should know the IP address of the VM. You can find it in the Azure personal page for VM. Select the virtual machine from the list, and by clicking the “Overview” item, your IP is displayed in the line of “Public IP Address”.

2. Go to the page of downloading DBeaver – Download

3. Download the software distribution that is convenient for you, Windows 64 bit installer for example. 

4. Run the downloaded file and finish the installation process

5. Start the DBeaver

6. Click on the button to establishing the new connection

7. In the list that appeared, find and select “Firebird”, then click the “Next” button

8. In the “Path” field, specify the path to the Firebird database file located on the VM. For example: /opt/firebird/examples/empbuild/employee.fdb 

In the “User Name” field, enter the username sysdba and the password masterkey to connect to DB. The other fields in the tab leave with no changes. It is strongly recommended to change the password, after connecting to the database.

9. Go to the “SSH” tab and tick the “Use SSH tunnel” checkbox

In the “Host/IP” field, enter the address of the virtual machine

In the “Username” field, enter the username to connect to the VM

In the “Password” field, type the password, which was used to connect to the virtual machine before

Click “Finish” to save the connection settings and establish the connection 

10.  During the connection process, the window with the driver files installation may appear. Click  “Download”, after that the connection to the database will be continued.

11. Your Firebird is ready

12. To start and stop the Firebird server manually, you should connect to a VM. 
13. With OpenSSH

In the Windows 10 operating system (starting with version 1809), an OpenSSH client is available, with which you can connect to Linux servers via SSH. If Windows 10 is appropriate and the OpenSSH client is installed, you can start connecting via SSH. To do this, launch a normal Windows command prompt and enter the command “ssh user@*vm_ip*” (1), where “user” is the username that was specified while creating the virtual machine and “*vm_ip*” is the VM IP address.

Then type “Yes” (2) and enter a password (3) that was specified while creating the virtual machine.

2. With the PuTTY application 

To do this, you need the PuTTY application to connect via ssh. You can download it at the following link – Download

Run Putty, enter the VM address in the “Host” field (1) and click “Open” (2) to connect.

In the opened console, you will need to enter a username (1) and password (2) that were specified while the VM was being created (you will not see the password in the console while entering it). 

13. To stop the server, enter the command:

$ sudo systemctl stop firebird-superserver

14. To start the server, enter the command:

$ sudo systemctl start firebird-superserver