Firebird SQL

Navigation:  Installation - ERP Sirius > Steps to take after installation >

Firebird SQL

Previous pageReturn to chapter overviewNext page

 

Firebird SQL is the default database used with ERPSirius +Mobile.

 

 

Download Firebird 3.0.7 from the site below, it is recommend to use the x64 bit version of Firebird.

 

https://firebirdsql.org/en/firebird-3-0/

 

 

You can install Firebird 3 SQL on your MS Windows Server or a PC that will act as your server, or on your local PC if you are a single user.

 

ERP Sirius uses Firebird 3.0 with and encrypted database to protect sensitive data from the unauthorized access and prevent the direct work with the databases: 

 

 

Run the Firebird install program that you downloaded noting the 32 or 64 bit version.

 






clip0002


clip0003






clip0004


clip0005






clip0006

 

Select the default location for the Firebird install. You can install into a different drive if required. 

 


clip0007






clip0008


clip0009






clip0010

 

Create the password masterkey. Sirius will only work with default password of masterkey. If you require Sirius to work with another Firebird userid & password please email us.

 

 


clip0011






clip0012


clip0013

 

 

 

 

 

 

 

 

Copy Encryption plug-in files to Firebird Server:

 

Firebird 3.0 has introduced the ability to encrypt databases to protect sensitive data from the unauthorized access and prevent the direct work with the databases: only designated applications should be able to work with strong (AES256) encryption encrypted databases. 

 

 - it is limited until it is limited until January 2022

 

More info on https://ib-aid.com/en/firebird-encryption-plugin-framework/

 

 

 

clip0014

 

 

Put the following files to server/plugins from the folder WinSrv64Bit_ServerPart \plugins

DbCrypt.dll

DbCrypt.conf -  This files is limited until December 30, 2020 and will have to be updated after Dec 2020 or an encryption license purchased. 

KeyHolder.dll

 

 Put the following files into Firebird root from the folder WinSrv64Bit_ServerPart

fbcrypt.dll

libcrypto-1_1-x64.dll

libssl-1_1-x64.dll

gbak.exe

firebird.msg

firebird.conf (optional, can be used as an example)

 

If you have installed the 32bit version for Firebird

Copy all the files that are in  \ERP Sirius\WinSrv32Bit_ServerPart to \Program Files\Firebird\Firebird_3_0 

Copy all the files that are in \ERP Sirius\WinSrv32Bit_ServerPart\plugins to \Program Files\Firebird\Firebird_3_0\plugins 

 

 

If you have installed the 64bit version for Firebird

Copy all the files that are in \ERP Sirius\WinSrv64Bit_ServerPart to \Program Files\Firebird\Firebird_3_0 

Copy all the files that are in \ERP Sirius\WinSrv64Bit_ServerPart\plugins to \Program Files\Firebird\Firebird_3_0\plugins 

 

 

Restart the Firebird service or restart your PC or server where you installed Firebird SQL.

clip0015