Ubuntu – Flamerobin connection failed with Firebird 3.0 in Ubuntu 16.04 LTS – Error: connection rejected by remote interface

firebirdfirebird-3.0flamerobinUbuntu

I just installed Firebird 3.0 in Ubuntu 16.04 LTS. I can connect to the server with Flamerobin from a Windows computer. I also installed Flamerobin in the server to be able to manage the databases locally, but after to register the server and database, connections fails. Flamerobin displays the following error message:

IBPP::SQLException
Context: Database::Connect,
Message: isc_attach_database failed,
SQL Message: -923, Connection not established,
Engine code: 335544421, Engine Message: connection rejected by remote interface.

Have you some suggestion to solve this issue and be able to connect locally using Flamerobin?

Best Answer

Ok, after a couple of days trying to configure Flamerobin to connect with Firebird 3.0, finally I can do it.

First we need to know which library Flamerobin is trying to load. To know it, we use the following command:

ldd /usr/bin/flamerobin | grep libfb

Output:

libfbclient.so.2 => /usr/lib/x86_64-linux-gnu/libfbclient.so.2 (0x00007f48bb6f0000)

So, Flamerobin loads an older version of client library. The correct client library for Firebird 3.0 is in the following path:

/opt/firebird/lib/libfbclient.so.3.0.0

After researching for several hours (I am new in Linux) I discovered that it was necessary create a symbolic link between the correct library and the path where Flamerobin loads the older library. To do this I typed the following command (first, I renamed the older library to "libfbclient.so.2_"):

sudo ln -s /opt/firebird/lib/libfbclient.so.3.0.0 /usr/lib/x86_64-linux-gnu/libfbclient.so.2

Finally, execute again Flamerobin and now it is connected. @MarkRotteveel thanks for the clues.

Related Topic