Zabbix Proxy 4.x + MariaDB IoP with Zabbix Server 4.x

[Gianluca Torriglia]

Hi,

I have a perfectly working environment running on Zabbix on RPI3-B with the following versions:

Raspbian GNU/Linux 9 (stretch)
Zabbix_server (Zabbix) 4.0.27
MariaDB Server version: 10.0.28-MariaDB-2+b1 Raspbian

My need was to install a remote Zabbix-proxy on another RPI3B without moving to Zabbix 5.0 but following the procedure here (Install Zabbix-Proxy on Raspberry Pi (RPi) in 10 minutes! (bestmonitoringtools.com)) I had some issues described below:

Basically I followed the recommendation to install the same version (4.x) of the proxy but when installing MariaDB with the command:

apt -y install mariadb-server

the following version was installed: Server version: 10.3.31-MariaDB-0+deb10u1 Raspbian 10

In these conditions when I try to import the strucure with the command :

zcat /usr/share/doc/zabbix-proxy-mysql*/schema.sql.gz | mysql -uzabbix -p'zabbixDBpass' zabbix_proxy

I get the following error:

ERROR 1118 (42000) at line 1090: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix

I anticipate I followed all possible solution on Zabbix forum and elsewhere to fix the issue but NO WAY.

So I tried to install the zabbix_proxy v.5.0 (even if not recommended), so I bypassed the error but when configuring the proxy on the server (... you'll say, as expected) the DB structure probably is slight different and I got the following message (zabbix_proxy log):

failed to update local proxy configuration copy: invalid field name "interface.bulk"

Looking at the two tables on Zabbix 4.x Server I have

+-------------+---------------------+------+-----+-----------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+-----------+-------+
| interfaceid | bigint(20) unsigned | NO | PRI | NULL | |
| hostid | bigint(20) unsigned | NO | MUL | NULL | |
| main | int(11) | NO | | 0 | |
| type | int(11) | NO | | 0 | |
| useip | int(11) | NO | | 1 | |
| ip | varchar(64) | NO | MUL | 127.0.0.1 | |
| dns | varchar(255) | NO | | | |
| port | varchar(64) | NO | | 10050 | |
| bulk | int(11) | NO | | 1 | |
+-------------+---------------------+------+-----+-----------+-------+

on Zabbix_proxy 5.x no bulk field:

+-------------+---------------------+------+-----+-----------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+-----------+-------+
| interfaceid | bigint(20) unsigned | NO | PRI | NULL | |
| hostid | bigint(20) unsigned | NO | MUL | NULL | |
| main | int(11) | NO | | 0 | |
| type | int(11) | NO | | 0 | |
| useip | int(11) | NO | | 1 | |
| ip | varchar(64) | NO | MUL | 127.0.0.1 | |
| dns | varchar(255) | NO | | | |
| port | varchar(64) | NO | | 10050 | |
+-------------+---------------------+------+-----+-----------+-------+

I also tried to add this field manually but it doesn't solved the issue.

I also tried to export the DB structure from the server and import on the proxy but I got again the aforementoned error:

ERROR 1118 (42000) at line 1090: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix

I anybody can help me to make zabbix_proxy to work without upgrading the server which is working perfectly since more than 1 year it's appreciated, thanks in advance.

GL

[tim.mooney]

The problem is that on your new proxy you're trying to mix the Zabbix 4.0.x schema with MariaDB 10.3. That's been shown not to work.

If you're unwilling to go to Zabbix 5.0.x on your server (where the schema is compatible & tested with MariaDB 10.3.x), then your best bet is to install the older Raspbian release (v9 ?) on your new proxy, so that you also get MariaDB 10.0.x there too, instead of 10.3.x. MariaDB 10.0.x or 10.1.x will likely be fine with the Zabbix 4.0.x schema.

Also, the proxy doesn't use the full server database schema, so copying your server's DB structure to your proxy was not a good idea. You should definitely start over with a fresh import of the proxy schema, once you've gotten a compatible version of MariaDB installed on the proxy.

[Gianluca Torriglia]

Hi thanks, I supposed something related to MariaDB version ... but I dind't found a way to force MariaDB 10.0.28 on the RPI hosting the proxy so far. Do you have any clue? Thanks a lot