Migration from Firebird 1.5 to Firebird 4 Security.fdb

[jez-smxi]

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.

[aafemt]

Tables belonging to SRP user manager are created only when first SRP user is created. By design.

[jez-smxi]

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]

Only if Srp is the first entry in UserManager, otherwise you must explicitly include the using plugin Srp clause.

[mrotteveel]

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.