Firebird connection error

Posts   
 
    
timbered
User
Posts: 53
Joined: 09-Feb-2020
# Posted on: 15-Dec-2024 02:22:30   

I have always used SQL Server with LlblGen, and this is the first time I'm attempting to use Firebird (version 5).

I can't connect to my newly installed Firebird server from Llblgen. I get the error "Incompatible wire encryption levels requested on client and server."

I have tried various permutations of changing the WireCrypt and AuthClient in my firebird.conf file to no avail (most changes to those two settings refuse to connect at all with a "Error occured during login".

This is the LlblGen error:

Exception information.
=============================================================
LLBLGen Pro version: v5.8. Build: 5.8.4

Exception details:
=====================
Message: Incompatible wire encryption levels requested on client and server
Source: FirebirdSql.Data.FirebirdClient
Stack trace: 
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString)
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
   at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
   at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData(Boolean showSuccess)

Inner exception:-----------------------
Exception details:
=====================
Message: Incompatible wire encryption levels requested on client and server
Source: FirebirdSql.Data.FirebirdClient
Stack trace: 
   at FirebirdSql.Data.Client.Managed.GdsConnection.Identify(String database)
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateManagedDatabase(FbConnectionString options)
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateDatabase(FbConnectionString options)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()

Inner exception: <null>
---------------------------------------

and my firebird.log file has either of these two errors in it:

VM-DEV2-TBFSC   Sat Dec 14 20:13:02 2024
    Authentication error
    No matching plugins on server


VM-DEV2-TBFSC   Sat Dec 14 20:13:05 2024
    INET/inet_error: read errno = 10054, client host = VM-DEV2-TBFSC, address = 10.0.0.104/53753, user = User

I realize this isn't specific to LlblGen, but I'm hoping you have more experience with Firebird than I do, and can point me to an easy fix.

P.S. I CAN connect to my server through JDBC / DBeaver

timbered
User
Posts: 53
Joined: 09-Feb-2020
# Posted on: 15-Dec-2024 04:55:20   

I managed to fix it, by setting these in my firebird.conf file:

AuthServer = Srp256, Srp
AuthClient = Srp256, Srp, Win_Sspi
UserManager = Srp
WireCrypt = Enabled

Something in the Firebird defaults for these isn't correct.

Leaving this post up to help future similar issues.

Thanks,

Ray

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39760
Joined: 17-Aug-2003
# Posted on: 15-Dec-2024 09:14:08   

Thanks for sharing!

Frans Bouma | Lead developer LLBLGen Pro