Repository navigation
Migration from Firebird 1.5 to Firebird 4 Security.fdb #8442
Description
Backed up and restored from 1.5 > 2 > 2.5 >3.0 > 4 (SuperServer)
Following the upgrade instructions in the misc/upgrade folder:
_In firebird 2.5 backup security database:
gbak -user sysdba -pas masterkey -b {host/path}security2.fdb security.fbk
In firebird 3 restore copy of 2.5 security database:
gbak -user sysdba -pas masterkey -c security.fbk {host/path}security2.5
And run users upgrade sql script:
isql -user sysdba -pas masterkey -i security_database.sql {host/path}security2.5_
There are no PLG$USERS or PLG$SRP tables created when restoring from 2.5 to 3.0. There is only the RDB$USERS table.
Activity
aafemt commentedon Feb 19, 2025
Tables belonging to SRP user manager are created only when first SRP user is created. By design.
jez-smxi commentedon Feb 19, 2025
But isnt that what the security_database.sql is supposed to do?
sql = 'create or alter user "' || usr || '" password ''' || passwd || '''';
if (frst is not null) then sql = sql || ' firstname ''' || frst || '''';
if (mddl is not null) then sql = sql || ' middlename ''' || mddl || '''';
if (lst is not null) then sql = sql || ' lastname ''' || lst || '''';
sql = sql || ' active';
mrotteveel commentedon Feb 19, 2025
Only if
Srpis the first entry inUserManager, otherwise you must explicitly include theusing plugin Srpclause.mrotteveel commentedon Feb 19, 2025
Also, for support questions, please use firebird-support or create a discussion instead of an issue. Issues are for bug reports and feature requests. I'll convert this issue to a discussion shortly.