Geek Answers Handbook

Firebird 3 sysdba password staggering problem

I switched from firebird 2.5.x to 3.0 I changed firebird.conf:

WireCrypt = Enabled AuthServer = Legacy_Auth, Srp, Win_Sspi

after that, here is what you did:

I can connect from the NetBeans IDE using the SYSDBA masterkey. I can connect from FlameRobin (database administration tool) using SYSDBA with a different password. I cannot connect to the Wild-Fly server using SYSDBA with this other password.

I'm really curious. !!

+4
source share
1 answer

I assume that you are using Jaybird 2.2.x (or earlier) when connecting from Netbeans and Wildfly. Firebird 3 introduced a new authentication model called SRP (Secure Remote Password). Jaybird 2.2.x does not support this new authentication model (support will be added in Jaybird 3.0), so you need to use the Legacy_Auth plugin.

Users have a separate identifier for the plugin, which means that you (maybe) have two users named SYSDBA, one for SRP and one for Legacy_Auth. These users have their own passwords.

Therefore, when you connect from Netbeans and Wildfly, you need to specify the password of the inherited authentication user. This password looks like masterkey or in fact: masterke , because outdated passwords have only 8 characters.

When you connect from Flamerobin, you can use a "different" password (sysdba SRP user), since flamerobin uses Firebird 3 fbclient.dll / libfbclient.so and therefore supports the new SRP authentication model.

As far as I know, flamerobin should also be able to authenticate with the password of the inherited sysdba user (if the login fails, he should try the following plugin). I will check it out tomorrow.

+7
source

More articles:


All Articles