Firebird 4 Authentication error

2,746 views
Skip to first unread message

Kyle Green

unread,
May 22, 2021, 1:08:59 PM5/22/21
to firebird-net-provider
I have new firebird 4 install on a new windows 2019 server, with the newest Provider

I can connect to the database with the newest FlameRobin.

I have websites and connection strings that worked on Server 2012, and Firebird 3. Also, similar connection strings work on my dev machine running Firebird 3.


Firebird.log says:
  Authentication error
  No matching plugins on server

I have tried various  versions of this connection string in my web.config:

 <add name="MainDb"
connectionString="Database=d:\db\Fb\Data\MyProj\MyProj.fdb;
user=SYSDBA;
password=mypass;
role=RDB$ADMIN;
DataSource=localhost;
Port=3050;
Pooling=true;
MinPoolSize=0;
MaxPoolSize=100;
Connection Lifetime=0;
Connection Timeout=15;" />

What am I missing?

Thanks, 

Kyle

Jiří Činčura

unread,
May 22, 2021, 1:11:36 PM5/22/21
to 'Mr. John' via firebird-net-provider
You probably don't have "Srp" in auth server in the config.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Mark Rotteveel

unread,
May 22, 2021, 1:18:25 PM5/22/21
to firebird-n...@googlegroups.com
On 22-05-2021 19:11, Jiří Činčura wrote:
> You probably don't have "Srp" in auth server in the config.

Haven't you added Srp256 support yet?

Mark
--
Mark Rotteveel

Jiří Činčura

unread,
May 22, 2021, 1:26:41 PM5/22/21
to 'Mr. John' via firebird-net-provider
> Haven't you added Srp256 support yet?

Nope.
https://github.com/FirebirdSQL/NETProvider/issues/864

Kyle Green

unread,
May 24, 2021, 10:44:18 PM5/24/21
to firebird-net-provider
config for Firebird4 has no explicit settings. I looked at my dev machine Firebird 3, to see what settings might need to be set explicitly. 
I set these:

AuthServer = Srp256, Srp
AuthClient = Srp256, Srp, Win_Sspi                      #Windows clients
UserManager = Srp

Wirecrypt is no longer present in Firebird4 config (unless I missed it)

I'm still having some trouble, but it may be a different issue. One of my two sites is now working,

Thank you!

Mark Rotteveel

unread,
May 29, 2021, 3:17:04 AM5/29/21
to firebird-n...@googlegroups.com
On 25-05-2021 04:44, Kyle Green wrote:
> Wirecrypt is no longer present in Firebird4 config (unless I missed it)

Firebird 4 definitely still has the WireCrypt setting (line 754 of the
default firebird.conf of the latest snapshot).

Mark
--
Mark Rotteveel

Kyle Green

unread,
Jun 2, 2021, 12:43:25 AM6/2/21
to firebird-net-provider
Yes, I see the setting is still there, but it is remarked out on my default install of Firebird4. Firebird3 had it enabled I think, maybe something I did in the distant past :)
Reply all
Reply to author
Forward
0 new messages