v14.4.1

New Features

• Local account authentication is changed to one single account only
• Users can view local account login history
• Deployment behind Azure Front Door will see X-Azure-FDID header value in the about page of admin portal

Update and Fixes

• Logging enhancement for post, page, tag, category, friend link operations
• Remove .bmp format from default image extensions list
• Deprecate MetaWeblog API support
• Deprecate old password hashing method
• Deprecate NUglify library
• Migrate data accessing infrastructure to ardalis/Specification
• Remove default CSP rules for IIS, adding CSP is now fully under user's control in web server platforms
• Geo location HTTP header name is now x-geo-match to further decouple with Azure
• Bump .NET to 8.0.5

Upgrade from Previous Version

SQL Server

Run migration script in ./Deployment/mssql-migration.sql

-- v14.3.x - v14.4.1
CREATE TABLE [dbo].[LoginHistory](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[LoginTimeUtc] [datetime] NOT NULL,
	[LoginIp] [nvarchar](64) NULL,
	[LoginUserAgent] [nvarchar](128) NULL,
	[DeviceFingerprint] [nvarchar](128) NULL,
 CONSTRAINT [PK_LoginHistory] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

DROP TABLE [LocalAccount]
GO

EXEC sys.sp_rename 
    @objname = N'Category.RouteName', 
    @newname = 'Slug', 
    @objtype = 'COLUMN'
GO

IF EXISTS (
    SELECT 1
    FROM sys.columns c
    JOIN sys.objects o ON c.object_id = o.object_id
    WHERE o.name = 'Post' AND c.name = 'InlineCss'
)
BEGIN
    ALTER TABLE Post DROP COLUMN InlineCss;
END;
GO

Other Databases

I don't have knowledge of MySQL and PostgreSql. Please refer to SQL Server migration script and do it yourself.