Zabbix Proxy - Fresh installation is getting DB upgrade error

[anjo_ed]

Hello!

So, I've just installed a zabbix proxy following this instructions: https://www.zabbix.com/download?zabbix=6.4&os_distribution=ubuntu&os_vers ion=22.04&components=proxy&db=mysql&ws= and I started the proxy. However, I have been getting this error:

102084:20240304:143548.480 Starting Zabbix Proxy (active) [ContaboVPS5]. Zabbix 6.4.12 (revision dba2d5bd63b).
102084:20240304:143548.480 **** Enabled features ****
102084:20240304:143548.480 SNMP monitoring:       YES
102084:20240304:143548.480 IPMI monitoring:       YES
102084:20240304:143548.480 Web monitoring:        YES
102084:20240304:143548.480 VMware monitoring:     YES
102084:20240304:143548.480 ODBC:                  YES
102084:20240304:143548.480 SSH support:           YES
102084:20240304:143548.480 IPv6 support:          YES
102084:20240304:143548.480 TLS support:           YES
102084:20240304:143548.480 **************************
102084:20240304:143548.480 using configuration file: /etc/zabbix/zabbix_proxy.conf
102084:20240304:143548.494 current database version (mandatory/optional): 02010008/02010008
102084:20240304:143548.494 required mandatory version: 06040000
102084:20240304:143548.494 mandatory patches were found
102084:20240304:143548.495 cannot retrieve database time
102084:20240304:143548.495 starting automatic database upgrade
102084:20240304:143548.496 [Z3005] query failed: [1054] Unknown column 'applicationid' in 'httptest' [alter table httptest modify `applicationid` bigint unsigned]
102084:20240304:143548.496 database upgrade failed on patch 02010009, exiting in 10 seconds

I don't understand, why it is trying to do a query to unknown column ? If you open /usr/share/zabbix-sql-scripts/mysql/proxy.sql, this column doesn't exist.
Do you know what is wrong ?

More details about my environment:

Ubuntu 22.04.4 LTS
mariadb Ver 15.1 Distrib 10.11.7-MariaDB
Zabbix Proxy 6.4.12

apt list --installed | grep -i zabbix

zabbix-agent2/jammy,now 1:6.4.12-1+ubuntu22.04 amd64 [installed]
zabbix-frontend-php/jammy,now 1:6.4.12-1+ubuntu22.04 all [installed]
zabbix-proxy-mysql/jammy,now 1:6.4.12-1+ubuntu22.04 amd64 [installed]
zabbix-release/jammy,now 1:6.4-1+ubuntu22.04 all [installed]
zabbix-server-mysql/jammy,now 1:6.4.12-1+ubuntu22.04 amd64 [installed]
zabbix-sql-scripts/jammy,now 1:6.4.12-1+ubuntu22.04 all [installed]


Maybe Mariadb 10.11 isn't supported ?


Thanks.

[sdennis9]

In case anyone else is wondering, I had the same issue, could resolve it with adding this line to the create table part in the script:

/usr/share/zabbix-sql-scripts/mysql/proxy.sql

`applicationid` bigint unsigned NOT NULL,

Looks like this:

CREATE TABLE `httptest` (
`httptestid` bigint unsigned NOT NULL,
`applicationid` bigint unsigned NOT NULL,
`name` varchar(64) DEFAULT '' NOT NULL,
`delay` varchar(255) DEFAULT '1m' NOT NULL,
`status` integer DEFAULT '0' NOT NULL,
`agent` varchar(255) DEFAULT 'Zabbix' NOT NULL,
`authentication` integer DEFAULT '0' NOT NULL,
`http_user` varchar(255) DEFAULT '' NOT NULL,
`http_password` varchar(255) DEFAULT '' NOT NULL,
`hostid` bigint unsigned NOT NULL,
`templateid` bigint unsigned NULL,
`http_proxy` varchar(255) DEFAULT '' NOT NULL,
`retries` integer DEFAULT '1' NOT NULL,
`ssl_cert_file` varchar(255) DEFAULT '' NOT NULL,
`ssl_key_file` varchar(255) DEFAULT '' NOT NULL,
`ssl_key_password` varchar(64) DEFAULT '' NOT NULL,
`verify_peer` integer DEFAULT '0' NOT NULL,
`verify_host` integer DEFAULT '0' NOT NULL,
`uuid` varchar(32) DEFAULT '' NOT NULL,
PRIMARY KEY (httptestid)

[PmGs]

Thanks you.