Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Firebird .NET provider can not connect to Firebird 3 except sysdba using Legacy user manager [DNET872] #802

Closed
firebird-automations opened this issue Mar 5, 2019 · 3 comments

Comments

@firebird-automations
Copy link

Submitted by: Benny Bech (bennybechdk)

Duplicates DNET783

When trying to connect to Firebird 3 using NON sysdba (legacy user) error "Your user name and password are not defined. Ask your database administrator to set up a Firebird login." i s returned.

Test against Firebird 3 configured as:
AuthServer = Legacy_Auth, Srp
AuthClient = Legacy_Auth, Srp
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
ServerMode = Classic

Tried on 2 users:
CREATE USER USR_LEG PASSWORD 'PASLEG11' USING PLUGIN Legacy_UserManager;
CREATE USER USR_SRP PASSWORD 'PASSRP22' USING PLUGIN Srp;

User USR_LEG is working with FirebirdClient 4.10 and below
User USR_SRP is working with FirebirdClient 5.10 and above.

Both users is working using ISQL and IBexpert.

@firebird-automations
Copy link
Author

Modified by: Benny Bech (bennybechdk)

description: When trying to connect to Firebird 3 using NON sysdba (legacy user) error "Your user name and password are not defined. Ask your database administrator to set up a Firebird login." i s returned.

Test against Firebird 3 configured as:
AuthServer = Legacy_Auth
Srp AuthClient = Legacy_Auth
Srp UserManager = Legacy_UserManager
Srp WireCrypt = Enabled
ServerMode = Classic

Tried on 2 users:
CREATE USER USR_LEG PASSWORD 'PASLEG11' USING PLUGIN Legacy_UserManager;
CREATE USER USR_SRP PASSWORD 'PASSRP22' USING PLUGIN Srp;

User USR_LEG is working with FirebirdClient 4.10 and below
User USR_SRP is working with FirebirdClient 5.10 and above.

Both users is working using ISQL and IBexpert.

=>

When trying to connect to Firebird 3 using NON sysdba (legacy user) error "Your user name and password are not defined. Ask your database administrator to set up a Firebird login." i s returned.

Test against Firebird 3 configured as:
AuthServer = Legacy_Auth, Srp
AuthClient = Legacy_Auth, Srp
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
ServerMode = Classic

Tried on 2 users:
CREATE USER USR_LEG PASSWORD 'PASLEG11' USING PLUGIN Legacy_UserManager;
CREATE USER USR_SRP PASSWORD 'PASSRP22' USING PLUGIN Srp;

User USR_LEG is working with FirebirdClient 4.10 and below
User USR_SRP is working with FirebirdClient 5.10 and above.

Both users is working using ISQL and IBexpert.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue duplicates DNET783 [ DNET783 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Duplicate [ 3 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants