Linux ODBC Driver: Cannot access database remotely using Firebird

[wuchadoin]

I have been using the Firebird ODBC Driver on Windows for about 3 years with no issues. I am connected to a database located on another server. With using pyodbc I am able to successfully connect, and query data, using my Windows Firebird ODBC Driver. After installing the driver on Ubuntu 20.04 I get the infamous error message:
Your user name and password are not defined. Ask your administrator to setup a Firebird login.
My connection string is the exact same on my Windows machine so I don't know what else to do. I only have the ODBC Driver installed on Ubuntu - no server or client (other than libfbclient2). Seeing as I have no server or client installed, I don't know why I am getting the error as I have the actual credentials to access the database? I have tried all the credentials I know including the default SYSDBA and masterkey. One thing that stood out was the docs that Firebird provided stating that some versions of Linux include a random password found in '/opt/firebird/' but it doesn't state what that file is or it's location in the folder.

Any help is greatly appreciated!

[Mark Rotteveel]

Are you connecting to a Firebird 3 server? Does your Ubuntu have a
Firebird 3 libfbclient.so or an earlier version? If so, the problem
might be that your user on the server is created using the Srp user
manager. If so, you need a Firebird 3 libfbclient.so, otherwise you need
to create a user using the Legacy_UserManager, and configure your
Firebird server to accept legacy authentication by including Legacy_Auth
in AuthServer, and setting WireCrypt to Enabled (instead of Required).

As an aside, if you're connecting to the same Firebird server as your
Windows installation, then you don't need to look for that random
password, that is only if you install Firebird server on Linux.

Mark

[Dave Schulz]

Thank you for the reply. So as a quick follow up (because I got further at the end of the day), I found out that, yes, FireBird 3.0 wouldn't connect because our database is a 2.5 version. So I removed 3.0 and downloaded just the 2.5 ODBC Driver. After successfully getting the driver installed, I linked my firebird libfbclient.so.2 to libgds.so. Everything works as expected, but now after copying and pasting the database locally to my vm I am now getting:

Unable to complete network request to host "localhost"

Here is my connection string:

Driver=Firebird;Dbname=/home/my_user/my_database.fdb;UID=user;PWD=password

 

Now, as a troubleshooting test, I was able to connect to the local database on my vm using isql-fb and oddly enough it didn't even ask for a user or password, but it seems only when I am using an ODBC connection do I get this error message.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4f123f25c4d5a5e49f6381a07ad21967%40lawinegevaar.nl.

[Dave Schulz]

I was able to get it. Pyodbc hates linux firebird drivers. I had to switch to sqlalchemy and everything works perfectly.

[Marcin Bury]

-------- Oryginalna wiadomość --------
Od: Dave Schulz <schul...@gmail.com>
Data: pt., 21 maj 2021, 17:21
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Linux ODBC Driver: Cannot access database remotely using Firebird

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAJdQpy%3DfD4oAa-NfuVvDbaoCKR%2B-a3hvdknW2zD0pFsX%2B9vHLw%40mail.gmail.com.