Hello Sean, Please make Firebird a greater product and do not resolve this ticket. Please, first ask some other specialists. Read the QuickStart 2.5.1 manual about 'Appointing co-administrators' and tell me then how to appoint co-admins in a custom Firebird database that was in the old v2.0-format, is backed up and restore with gbak 2.5.1. Best regards, Peter. -----Oorspronkelijk bericht----- Van: Sean Leyne (JIRA) [mailto:tr...@fi...] Verzonden: vrijdag 24 februari 2012 19:25 Aan: pv...@zo... Onderwerp: [FB-Tracker] Resolved: (CORE-3772) Firebird 2.5 GBak Restore does not create a required USERS table when backing up and restoring a Fb2.0-formatted database. [ http://tracker.firebirdsql.org/browse/CORE-3772?page=com.atlassian.jira.plug in.system.issuetabpanels:all-tabpanel ] Sean Leyne resolved CORE-3772. ------------------------------ Resolution: Won't Fix > Firebird 2.5 GBak Restore does not create a required USERS table when backing up and restoring a Fb2.0-formatted database. > ---------------------------------------------------------------------- > ---------------------------------------------------- > > Key: CORE-3772 > URL: http://tracker.firebirdsql.org/browse/CORE-3772 > Project: Firebird Core > Issue Type: Bug > Components: GBAK > Affects Versions: 2.5.1 > Environment: Firebird 2.5.1 on Windows (7, Vista and XP) > Reporter: Peter Vandel > > 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 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira |