search

evosec / metabase-firebird-driver

A plugin that allows Metabase to connect to FirebirdSQL databases.
https://github.com/metabase/metabase/
MIT License
28 stars 7 forks source link

Cannot connect metabase to my firebird #8

Closed tcondeixa closed 2 years ago

tcondeixa commented 3 years ago

I'm having problems connecting my metabase using the firebird driver

I'm always having the following error: connection rejected by remote interface [SQLState:08004, ISC error code:335544421]

metabase version: 0.36.6 firebird version: 3.0.6

firebird.conf AuthServer = Legacy_Auth, Srp UserManager = Legacy_UserManager, Srp AuthClient = Legacy_Auth, Srp WireCrypt = Enabled

The configurations in metabase for FirebirdSql should be straight-forward but maybe I'm doing something wrong. I'm using the alias name as the Database name.

I tried to use a SQL client with support to firebird and I was able to connect with exact same parameters from my laptop.

Do you have any idea what could I try?

Thanks a lot, Tiago

Nikos410 commented 3 years ago

Hi @tcondeixa ,

are using your SQL client on the same maching Metabase is running on? If not, try if you can access the database port from your server.

Try running telnet {db-server-host} 3050 from your metabase server. It should look like this:

nikos@N190009 ~ % telnet {db-server} 3050
Trying {ip}...
Connected to {db-server}.
Escape character is '^]'.

If it looks like this:

nikos@N190009 ~ % telnet {db-server} 3050
Trying {ip}...
telnet: connect to address {ip}: Connection refused
telnet: Unable to connect to remote host

that means your Metabase server can not access port 3050 on your DB server. There might be some firewall/proxy/iptables settings that are preventing your Metabase server from connecting.

Nikos410 commented 2 years ago

Closing this issue due to inactivity.