Brand new install/setup on Ubuntu 22.04 and I'm getting DB schema errors

[dsegel]

I followed the instructions here exactly: https://www.zabbix.com/download?zabb...ubuntu&os_vers ion=22.04&components=server_frontend_agent&db=mysq l&ws=apache

There were no problems with the install, and I verified that the MySQL DB and user were created successfully.

Now when I go to /setup.php I get errors:

• mysqli::real_connect(): Passing null to parameter #7 ($flags) of type int is deprecated [setup.php:100 → CSetupWizard->__construct() → CSetupWizard->eventHandler() → CSetupWizard->dbConnect() → DBconnect() → MysqlDbBackend->connect() → mysqli->real_connect() in include/classes/db/MysqlDbBackend.php:173]
• The Zabbix database version does not match current requirements. Your database version: 6000000. Required version: 5000000. Please contact your system administrator.
• substr(): Passing null to parameter #1 ($string) of type string is deprecated [setup.php:108 → CPageHeader->__construct() → substr() in include/classes/html/pageheader/CPageHeader.php:67]

I also tried with version 7.0LTS from that same site and got pretty much the same error except the "database version" was 7000000 instead of 6000000.

I'm running php8.1 if it matters.

[cyber]

Soemthing is not correctly installed. "Your database version: 6000000. Required version: 5000000." It kind of indicates that some parts, like frontend is v5, but DB and its schema is v6... Verify and fix..

[dsegel]

I did an apt purge for all the zabbix pieces and then used locate and find to find and delete everything with Zabbix in the name and tried again with with both 6 LTS and 7 LTS the same result.

After running apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent there is a new directory /usr/share/zabbix, and in /usr/share/zabbix/include/defined.inc.php it has these lines:

define('ZABBIX_VERSION', '5.0.17');
define('ZABBIX_API_VERSION', '5.0.17');
define('ZABBIX_EXPORT_VERSION', '5.0');

During Setup it does say "Welcome to Zabbix 5.0".

I'll try 6.4 next.

EDIT: I figured it out. For some reason this one system is pulling zabbix-frontend-php from https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main instead of the zabbix repo installed earlier in the process, and Ubuntu has 5.0.17 in their repository. I installed on a different but supposedly identical system and it worked correctly. I'll figure out what's wrong with the current system.