FlameRobin unable to connect to Firebird4.0

[Fuad Gasimzade]

I have FlameRobin 0.9.3 installed on a Windows machine. I can successfully connect to Firebird 3.0 database running on CentOS

Now I have another Firebird 4.0 database on a separate Almalinux machine and I am not able to connect to it or create a new DB from my FlameRobin. The error I get is "Install incomplete. To complete security database initialization CREATE USER."

I was able to create a test DB from Almalinux itself with CREATE DATABASE '/db/xeroxnew.fdb' USER 'SYSDBA' PASSWORD 'masterkey';

But still unable to connect to it from FlameRobin

All necessary libraries for  Firebird 4.0 were installed on Flamerobin machine

Any ideas?

[Mark Rotteveel]

On 11/06/2024 07:45, Fuad Gasimzade wrote:
> I have FlameRobin 0.9.3 installed on a Windows machine. I can
> successfully connect to Firebird 3.0 database running on CentOS
>
> Now I have another Firebird 4.0 database on a separate Almalinux machine
> and I am not able to connect to it or create a new DB from my
> FlameRobin. The error I get is "Install incomplete. To complete security
> database initialization CREATE USER."

That means FlameRobin attempted to authenticate with Srp, but the
security database wasn't initialized yet for Srp. You need to create at
least one user using the Srp plugin to initialize the security database.

So, connect - with ISQL, in embedded mode - to a database (e.g. to
employee) and execute `create user sysdba password '<a password>' using
plugin srp;`

> I was able to create a test DB from Almalinux itself with CREATE
> DATABASE '/db/xeroxnew.fdb' USER 'SYSDBA' PASSWORD 'masterkey';

That created a database using an embedded connection, which doesn't
perform any authentication.

> But still unable to connect to it from FlameRobin

You won't be able to connect with *anything* using a remote protocol if
it only attempts to use Srp authentication. It is not just FlameRobin.

> All necessary libraries for  Firebird 4.0 were installed on Flamerobin
> machine
>
> Any ideas?

See above, initialize the security database by creating a user with the
Srp plugin.

Mark
--
Mark Rotteveel

[Fuad Gasimzade]

Thank you, Mark

All worked