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 3.0.10 installer and later resets the password of SYSDBA to masterkey when upgrading. Passwords of possible other users are not reset. #7726

Open
pmatimmermans opened this issue Aug 28, 2023 · 2 comments
Assignees

Comments

@pmatimmermans
Copy link

Try the following to reproduce:

When installing Firebird 3.0.7 for instance, followed by changing the SYSBA password, then uninstalling without deleting security3.fdb, and reinstalling 3.0.7 again, the SYSDBA password is maintained. With Firebird 3.0.10 the password of SYSDBA is reset to masterkey when reinstalling Firebird 3.0.10. The same holds for Firebird 3.0.11. The password of possible other database users are maintained. It seems that the #7158 fix (#7158) introduced this bug.

@reevespaul reevespaul self-assigned this Aug 28, 2023
@reevespaul
Copy link
Contributor

Confirmed.
Until a fix is available perhaps the simplest the work around is to login with masterkey and change the password thus:

 create or alter user SYSDBA password 'mypassword' using plugin Srp;

@reevespaul
Copy link
Contributor

But obviously this needs to be fixed and 3.0.11 repackaged.

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

No branches or pull requests

2 participants