Hello,

I’ had a difficult problem.

A few month before, we are using firebird 2.1. For 6 weeks, I have installed the firebird 3 superserver and add a new user and changed the sysdba-password. All works fine, till yesterday. Some applications could not connect to the firebird database. We have taken a restart, after this, only the old sysdba password works to connect to our database. I have nothing changed! Now, I have tried to add the user again, in ibexpert I have it delete before. I get the following error

Commit nicht möglich

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.

add record error.

violation of PRIMARY or UNIQUE KEY constraint "INTEG_5" on table "PLG$SRP".

Problematic key value is ("PLG$USER_NAME" = 'SATRON').

The same message I get, If I try to change the sysdba password. I have backup the database and restore it, the same. I have deinstalled the server and installed it again, the same. Only the sysdba user with masterkey could connect, not the new user.

We have changed after this the firebird.conf ..authserver.. and add srp to legacy and now it works. But why worked it before and why sets the installer not this flag? I am confused. After I deleted the new user, in the access manager I have seen it strikethrough, after I have add this, I have seen it normally. One time, the database works not at all, I cant show some content, I must restore the database again.

Now, the new user works, but If I change the sysdba passwort with

ALTER USER SYSDBA

PASSWORD 'newpassword…'

The new password works, but why works the masterkey again?

Thanks for your help.

Best regards

Olaf