Unable to start Zabbix server due to unsupported MariaDB database version (10.11.02)

[coudy]

Hello,
after recently upgrade of my Debian system I have this error

1697672:20230306:143151.479 Unsupported DB! MariaDB version is 101102 which is higher than maximum of 101099
1697672:20230306:143151.479
1697672:20230306:143151.479 Unable to start Zabbix server due to unsupported MariaDB database version (10.11.02).
1697672:20230306:143151.479 Must not be higher than (10.10.xx).
1697672:20230306:143151.479 Use of supported database version is highly recommended.​

my DB version is

mariadb Ver 15.1 Distrib 10.11.2-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

my zabbix-server is installed over apt

zabbix_server (Zabbix) 6.0.13
Revision fdfa8cef9ce 1 February 2023, compilation time: Feb 26 2023 00:13:37

Copyright (C) 2023 Zabbix SIA
License GPLv2+: GNU GPL version 2 or later <https://www.gnu.org/licenses/>.
This is free software: you are free to change and redistribute it according to
the license. There is NO WARRANTY, to the extent permitted by law.

Compiled with GnuTLS 3.7.9
Running with GnuTLS 3.7.9​

So I have checked documentations, and there should be new parameter for this issue AllowUnsupportedDbVersions in version 6.0 https://www.zabbix.com/documentation.../zabbix_server

root@nas:/etc/zabbix# tail zabbix_server.conf
## Option: ListenBacklog
#       The maximum number of pending connections in the queue. This parameter is passed to
#       listen() function as argument 'backlog' (see "man listen").
#
# Mandatory: no
# Range: 0 - INT_MAX (depends on system, too large values may be silently truncated to implementation-specified maximum)
# Default: SOMAXCONN (hard-coded constant, depends on system)
# ListenBacklog=

AllowUnsupportedDbVersions=1

​

But even with this parameter I can't start zabbix server. I have another error in logs: "unknown parameter "AllowUnsupportedDbVersions" in config file"

root@nas:/etc/zabbix# systemctl status zabbix-server
× zabbix-server.service - Zabbix Server (MySQL/MariaDB)
     Loaded: loaded (/lib/systemd/system/zabbix-server.service; enabled; preset: enabled)
     Active: failed (Result: exit-code) since Mon 2023-03-06 14:42:34 CET; 53s ago
   Duration: 8ms
       Docs: man:zabbix_server
    Process: 1710787 ExecStart=/usr/sbin/zabbix_server --foreground (code=exited, status=1/FAILURE)
   Main PID: 1710787 (code=exited, status=1/FAILURE)

mar 06 14:42:34 nas systemd[1]: Started zabbix-server.service - Zabbix Server (MySQL/MariaDB).
mar 06 14:42:34 nas zabbix_server[1710787]: zabbix_server [1710787]: unknown parameter "AllowUnsupportedDbVersions" in config file "/etc/zabbix/zabbix_server.conf", line 875
mar 06 14:42:34 nas systemd[1]: zabbix-server.service: Main process exited, code=exited, status=1/FAILURE
mar 06 14:42:34 nas systemd[1]: zabbix-server.service: Failed with result 'exit-code'.​

Any help ?

[guille.rodriguez]

You have a typo

AllowUnsupportedDBVersions=1


JeffNL I have a Ubuntu VM with this version of MariaDB working (with AllowUnsupportedDBVersions flag enabled =1 )

Server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04

Sorry I re-read your post, if you want to upgrade your DB Backend, just make a mysqldump of the Zabbix Database, upgrade and test... if your server is a VM, then do a snapshot and try with the new version

[JeffNL]

I am following this thread now because I also wanted to upgrade the backend to MariaDB 10.11

The latest two LTS releases are these:
MariaDB 10.6
MariaDB 10.11

I would expect that it would be made possible to upgrade the backend to MariaDB 10.11 without any workaround.
The question for me is how and when we will be notified of this.

[guille.rodriguez]

You have a typo

AllowUnsupportedDBVersions=1


JeffNL I have a Ubuntu VM with this version of MariaDB working (with AllowUnsupportedDBVersions flag enabled =1 )

Server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04

Sorry I re-read your post, if you want to upgrade your DB Backend, just make a mysqldump of the Zabbix Database, upgrade and test... if your server is a VM, then do a snapshot and try with the new version

[coudy]

You are right guille.rodriguez , There was issue with "Db" and "DB". Probably it was wrong written on wiki, or somewhere where I copied it from, because I'm using ditto clipboard manager, and it was copied with lowercase "b".



Anyway Thank You.