You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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.
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: