search

evosec / metabase-firebird-driver

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

user and password are wrong after update #14

Closed sebierd closed 3 years ago

sebierd commented 3 years ago

I've updated the firebird-plugin to v. 1.3. After the update, I get the following error:

Your user name and password are not defined. Ask your database administrator to set up a Firebird login. [SQLState:28000, ISC error code:335544472]

I tried to setup a new connection, but the error message stays the same.

Metabase: 0.38.1 Plugin: 1.3 OS: Ubuntu 18.04.5

Nikos410 commented 3 years ago

Hm, I'm not sure I can help here. The firebird driver just takes whatever credentials you entered and passes it on to the database. Have you tried connecting to the DB with an SQL client like DBeaver with the same credentials?

sebierd commented 3 years ago

Hm, I'm not sure I can help here. The firebird driver just takes whatever credentials you entered and passes it on to the database. Have you tried connecting to the DB with an SQL client like DBeaver with the same credentials?

I only updated the plugin and metabase. The metabase database (mysql) stays the same.

FabriceWork commented 3 years ago

After updating to the latest Firebird driver I am getting the same Error. Nothing changed to the Firebird server and I can connect to it just fine with an SQL client using the same credentials used in Metabase.

dodgex commented 3 years ago

Maybe it is related to the upgraded jaybird from 3.0.x to 4.0.x.

Maybe the legacy auth stuff mentioned here? https://www.firebirdsql.org/file/documentation/drivers_documentation/java/4.0.0/release_notes.html#removed-legacy_auth-from-default-authentication-plugins

FabriceWork commented 3 years ago

Maybe it is related to the upgraded jaybird from 3.0.x to 4.0.x.

Maybe the legacy auth stuff mentioned here? https://www.firebirdsql.org/file/documentation/drivers_documentation/java/4.0.0/release_notes.html#removed-legacy_auth-from-default-authentication-plugins

I figured the same so I rebuilt the firebird driver for Metabase 0.38.2 locally with the old jaybird version 3.0.8 and the driver is working again for me.

bosborn52 commented 3 years ago

@FabriceWork Anyway you could share the rebuilt driver? I have only figured out how to start building the driver but it is erroring out...

FabriceWork commented 3 years ago

@FabriceWork Anyway you could share the rebuilt driver? I have only figured out how to start building the driver but it is erroring out...

Here is the rebuilt driver, if you still need it. I had to zip it because I can't upload .jar files.

firebird.metabase-driver.zip

Nikos410 commented 3 years ago

Hey @FabriceWork, thanks for your help :)

FYI: I've added an artifact built with Jaybird 3.x to the latest release and plan to do the same for future releases (If I forget, please remind me 😉). I've also added some information about this issue to the README.

kumajaya commented 2 years ago

We can still enable Legacy_Auth support with authPlugin connection property, example database name in Metabse: "YOURFIREBIRD3DATABASE?encoding=UTF8&roleName=RDB$ADMIN&authPlugins=Legacy_Auth"

Nikos410 commented 2 years ago

Hey @kumajaya do you have some documentation on this?

kumajaya commented 2 years ago

Hey @kumajaya do you have some documentation on this?

https://www.firebirdsql.org/file/documentation/drivers_documentation/java/4.0.0/release_notes.html#configure-authentication-plugins

Nikos410 commented 2 years ago

Thanks @kumajaya ! I've added that to the README section :)