Random authentication error

[Daniele Paoni]

Hello, I am using firebird 3 in an application and some customers are reporting intermittent connection errors to the server.

I use the following configuration

Server: Firebird 3.0.7, 32 bit, windows 10
Client: VB.NET, IBProvider.

The problem happens randomly and when it happens the client must restart the server to be able to work again.

The client error is [Firebird] Error occurred during login, please check server firebird.log for details The COM error code: E_FAIL. SQL State: "08006". Native DBMS Error Code: 335545106.

The server logs has these entries

NB-NEGOZIO    Thu Apr 22 13:40:45 2021
    INET/inet_error: read errno = 10054, client host = nb-negozio, address = 127.0.0.1/63109, user = enzo

NB-NEGOZIO    Thu Apr 22 15:14:47 2021
    Authentication error
    connection shutdown

NB-NEGOZIO    Thu Apr 22 15:14:47 2021
    Authentication error
    connection shutdown

I have tried to use both the internal driver of ibprovider and the fbclient.dll, the error does not change.

I have also asked to ibprovider support but they told me to ask in this group.

Here is my connection string

LCPI.IBProvider.5;dbclient_library=C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll;dbclient_type=fb;location=127.0.0.1/3090:C:\Users\Public\Documents\db.gdb;user id=SYSDBA;password=masterkey;remote:auth=Srp;auto_commit = True; CType=UTF8;unicode_mode=True;ctype_none=UTF8;OLE DB Services=-2;modify_trans_type=1;modify_trans_level=4096;auto_commit_level=4096

Here is my server config file

WireCrypt = Enabled
RemoteServicePort = 3090
TempBlockSize = 2M
TempCacheLimit = 32M
DefaultDbCachePages = 8000
AuthServer = Srp

Do you have an idea of what I can do to debug the problem?

[dan...@gmail.com]

Hello,

I have added some logs to the firebird server and I get the following messages when there is an authentication error.

Any idea?

LAPTOP-4L67BE98    Fri May 28 10:52:06 2021    

Srv: authenticate: ServerAuth calls plug Srp

LAPTOP-4L67BE98    Fri May 28 10:52:06 2021    

Srv: SRP phase1

LAPTOP-4L67BE98    Fri May 28 10:52:06 2021    

Srv: authenticate: No luck today - status:

LAPTOP-4L67BE98    Fri May 28 10:52:06 2021    

Authentication error     connection shutdown

[dan...@gmail.com]

Still having this problem, I tried to change to legacy authentication and got this message in firebird.log

DESKTOP-9RD3OSJ    Tue Jun 29 22:37:00 2021

    Authentication error
    cannot attach to password database
    Error in isc_attach_database() API call when working with legacy security database
    connection shutdown