问题描述
我从firebird 2.5.x迁移到了3.0我已经更改了firebird.conf:
I migrated from firebird 2.5.x to 3.0i have changed firebird.conf :
WireCrypt = Enabled
AuthServer = Legacy_Auth, Srp, Win_Sspi
在那之后，您就是发生了什么:
after that here you are what happened:
我可以使用SYSDBA万能键从Netbeans IDE中进行连接.我可以使用SYSDBA和其他密码从FlameRobin(数据库管理工具)进行连接.我无法使用具有该其他密码的SYSDBA从Wild-Fly服务器进行连接.
I can connect from Netbeans IDE using SYSDBA masterkey.I can connect from FlameRobin (database admin. tool) using SYSDBA with other password.I can not connect from Wild-Fly server using SYSDBA with that other password.
我真的很想知道！！
推荐答案
从Netbeans和Wildfly连接时，我假设您正在使用Jaybird 2.2.x(或更早版本).在Firebird 3中，引入了一种新的身份验证模型，称为SRP(安全远程密码). Jaybird 2.2.x不支持此新的身份验证模型(将在Jaybird 3.0中添加支持)，因此您需要使用Legacy_Auth插件.
I assume you are using Jaybird 2.2.x (or earlier) when connecting from Netbeans and Wildfly. With Firebird 3 a new authentication model was introduced called SRP (Secure Remote Password). Jaybird 2.2.x doesn't support this new authentication model (support will be added in Jaybird 3.0), so you need to use the Legacy_Auth plugin.
每个插件的用户都有一个单独的身份，这意味着您(可以)有两个名为SYSDBA的用户，一个用于SRP，一个用于Legacy_Auth.这些用户拥有自己的密码.
Users have a separate identity per plugin, this means that you (can) have two users with the name SYSDBA, one for SRP and one for Legacy_Auth. These users have their own passwords.
因此，当您从Netbeans和Wildfly连接时，您需要指定旧式身份验证用户的密码.该密码似乎是masterkey，或者实际上是:masterke，因为旧密码只有8个字符.
So when you connect from Netbeans and Wildfly, you need to specify the password of the legacy authentication user. This password appears to be masterkey, or actually: masterke as legacy passwords are only 8 characters.
从Flamerobin连接时，您可以使用(SRP sysdba用户的)其他"密码，因为Flamerobin使用Firebird 3 fbclient.dll/libfbclient.so，因此支持新的SRP身份验证模型.
When you connect from flamerobin, you can use the 'other' password (of the SRP sysdba user) as flamerobin uses the Firebird 3 fbclient.dll/libfbclient.so and therefor supports the new SRP authentication model.
据我所知，flamerobin还应该能够使用旧版sysdba用户的密码进行身份验证(登录失败时，它应该尝试下一个插件).明天我会测试.
As far as I know flamerobin should also be able to authenticate with the password of the legacy sysdba user (when login fails, it should try the next plugin). I will test that tomorrow.
这篇关于Firebird 3 sysdba密码令人震惊的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！