CODEWITHSUNDEEP
ubuntufirebirdflamerobinfirebird-3.0
AngelAvila
AngelAvila

Reputation: 435

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

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?

Upvotes: 4

Views: 7038

Answers (3)

Willian Coutinho
Willian Coutinho

Reputation: 1

Excellent tip, AngelAvila. It was appearing the error "Engine code: 335544421, Engine Message: connection rejected by remote interface."

It worked for me. In my specifically case, a had to do do two things:

  1. Since the file /usr/lib/i386-linux-gnu/libfbclient.so.2 already existed, I renamed it to libfbclient.so.2test:

    sudo su
    mv . /usr/lib/i386-linux-gnu/libfbclient.so.2 > /usr/lib/i386-linux-gnu/libfbclient.so.2test

  2. After that, two little modification in the files used ("...i386-..." instead "...x86-64..." and "...libfbclient.so.3.0.1" instead "...libfbclient.so.3.0.0"):

    sudo ln -s /opt/firebird/lib/libfbclient.so.3.0.1 /usr/lib/i386-linux-gnu/libfbclient.so.2

Finally, the database is now connected in Flamerobin.

Upvotes: 0

AngelAvila
AngelAvila

Reputation: 435

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.

Upvotes: 6

Ulises Sánchez
Ulises Sánchez

Reputation: 1

You need run the service fbguard. (Install Firebird before of flamerobin)

I am doing some like this: $ cd /opt/firebird/bin/ sudo ./fbguard

Or $ cd /opt/firebird/bin/ sudo ./fbguard -onetime -daemon

Upvotes: 0

Related Questions