Skip to content

is mariadb 10.7 or higher necessary? #2497

@Meindert-van-den-berg

Description

@Meindert-van-den-berg

When trying to update from filesender 2.57 to 2.63 I could log in but connection to the database failed. In de logs there I found:

[2026-01-05 16:57:47] [rest:error] [DBIUsageException details uid:695bdf7b31da9] "SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user 'filesender'@'localhost' for routine 'filesender.NATURAL_SORT_KEY'"

After some digging I noticed that NATURAL_SORT_KEY is available from mariadb 10.7 and up. We where running 10.5.
So I decided to upgrade to 10.11. Then no problem with the database connection.

The filesender install documentation states:
A PostgreSQL or MariaDB database (10.0 or above, 10.2 or later recommended).

Should that be 10.7 or later?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions