First version of "Firebird 5 Quick Start Guide"

[Mark Rotteveel]

I published a first version of the Firebird 5 Quick Start Guide. You can
find it on
https://firebirdsql.org/file/documentation/html/en/firebirddocs/qsg5/firebird-5-quickstartguide.html

I basically copied the Firebird 3 Quick Start Guide and made some
modifications. I still have some things I want to check and improve, but
it would be good if other people take a look and maybe point out glaring
omissions or errors.

Mark
--
Mark Rotteveel

[Alex Peshkoff]

At 3.2.4. Server modes

> The server mode can even be configured per database (consult the
> Firebird 3.0 Release Notes for details).

May be I missed something - but I do not remember such feature in fb5.

[Денис Симонов]

3.2.1. Before installation

> Upgrading the security database from Firebird 3 and higher
> Backup your security3.fdb or security4.fdb

The security databases security3.fdb and security4.fdb are not exactly identical in metadata.

/*
 * Firebird 3.0
**/
CREATE OR ALTER VIEW PLG$SRP_VIEW(
    PLG$USER_NAME,
    PLG$VERIFIER,
    PLG$SALT,
    PLG$COMMENT,
    PLG$FIRST,
    PLG$MIDDLE,
    PLG$LAST,
    PLG$ATTRIBUTES,
    PLG$ACTIVE)
AS
SELECT
  PLG$USER_NAME, PLG$VERIFIER, PLG$SALT, PLG$COMMENT,
  PLG$FIRST, PLG$MIDDLE, PLG$LAST, PLG$ATTRIBUTES, PLG$ACTIVE
FROM PLG$SRP
WHERE CURRENT_USER = 'SYSDBA'
   OR CURRENT_ROLE = 'RDB$ADMIN'
   OR CURRENT_USER = PLG$SRP.PLG$USER_NAME
;

/*
 * Firebird 4.0
**/
CREATE OR ALTER VIEW PLG$SRP_VIEW(
    PLG$USER_NAME,
    PLG$VERIFIER,
    PLG$SALT,
    PLG$COMMENT,
    PLG$FIRST,
    PLG$MIDDLE,
    PLG$LAST,
    PLG$ATTRIBUTES,
    PLG$ACTIVE)
AS
SELECT
  PLG$USER_NAME, PLG$VERIFIER, PLG$SALT, PLG$COMMENT,
  PLG$FIRST, PLG$MIDDLE, PLG$LAST, PLG$ATTRIBUTES, PLG$ACTIVE
FROM PLG$SRP
WHERE RDB$SYSTEM_PRIVILEGE(USER_MANAGEMENT)
   OR CURRENT_USER = PLG$SRP.PLG$USER_NAME
;

Therefore, after b/r security4.fdb -> security5.fdb all new features will be available. And after b/r security3.fdb -> security5.fdb some of the new features will not be available. So after b/r 3 -> 5 I recommended alter this view.

вторник, 7 ноября 2023 г. в 22:54:39 UTC+3, Alex Peshkoff:

[Mark Rotteveel]

On 07-11-2023 20:54, Alex Peshkoff wrote:
> At 3.2.4. Server modes
>
>> The server mode can even be configured per database (consult the
>> Firebird 3.0 Release Notes for details).
>
> May be I missed something - but I do not remember such feature in fb5.

This was already documented in the Firebird 3 Quick Start Guide, I'll
remove it from both.

Mark
--
Mark Rotteveel

[Mark Rotteveel]

Such upgrades should IMHO be managed by plugins on their own IMHO. Also,
this indicates that these upgrade instructions have historically been
missing from Firebird 4.0, including a suitable script in
misc/upgrade/v4.0/ and a mention in the Firebird 4.0 release notes.

Personally, I don't even think the security DB upgrade instructions
belong in a Quick Start Guide, but it already had them, so I included
instructions for Firebird 3.0+, but they certainly should not have
*that* level of detail.

In any case, I created two tickets for this:

* https://github.com/FirebirdSQL/firebird/issues/7830 (add upgrade
script to address the immediate issue)
* https://github.com/FirebirdSQL/firebird/issues/7829 (for a more
structural solution)

Mark
--
Mark Rotteveel