Firebird 2.5 GBak Restore does not create a required USERS table when backing up and restoring a Fb2.0-formatted database. [CORE3772] #4116
Comments
|
Commented by: @dyemanov USERS is not a system table per se and it's not a part of the Firebird ODS. It exists in security2.fdb only and GSEC requires it being present there. But it *should not* exist in any other database. And GSEC *is not* intended to work with security in user databases. Thus I see no issue here and IMO this ticket must be rejected. |
Modified by: Sean Leyne (seanleyne)status: Open [ 1 ] => Resolved [ 5 ] resolution: Won't Fix [ 2 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Peter Vandel (petervandel)
To reproduce:
Use Firebird 2.5.1 utility gbak.exe to backup a Firebird database which has an old 2.0 format.
Use Firebird 2.5.1 utility gbak.exe to restore from the backup file made above.
The converted database does contain the new (2.1) Monitor tables (like MON$ATTACHMENTS, etc.)
HOWEVER, the same database does not contain a USERS (or RDB$USERS) table.
The USERS table is required by gsec.exe to add co-admins users to a custom database.
GSec reports the following if USERS does not exist.
"gsec -user sysdba -pass <pw> -database <database name/alias>"
GSEC> disp
gesec reports the following error: "invalid request BLR at offset 37 table USERS is not defined".
A workaround can be to create the table yourself in the database.
Ok, I hope this isue can be solved soon.
Thanks in advance,
Peter Vandel.
Firebird 2.5 GBak Restore does not create a USERS or RDB$USERS table when restoring a 2.0-formatted database
The text was updated successfully, but these errors were encountered: