Zabbix Porxy 4 service not starting after upgrade to 19.1

[intellim]

Hi All,

I maintain 3 OPNsense firewalls for 3 different customers. On all three I've Zabbix Agent and Zabbix Proxy installed and that worked fine until I did the upgrade to OPNsense version 19.1.7. and Zabbix Proxy 4. After that update Zabbix Proxy didn't start anymore on 2 of the 3 systems. The Agent starts without a problem. I tried downgrading to Zabbix Proxy 3, but that didn't solve anything. Does anyone have encountered this problem? Or does anyone know how to fix this?

Thanks,
Marc

[mimugmail]

Sometimes you have to Install proxy4 twice, can you check If it's really installed?

[intellim]

Yes, it is really installed. I did a uninstall and install more than a few times and rebooting the firewall also.
I've add it for a few days now.

[mimugmail]

Can you check the logs via console please?

tail -f /var/log/zabbix_proxy.log

[intellim]

This is the last entry:

9398:20190528:171550.674 Starting Zabbix Proxy (active) [HBA Proxy]. Zabbix 4.0.7 (revision 92831).
  9398:20190528:171550.675 **** Enabled features ****
  9398:20190528:171550.675 SNMP monitoring:       YES
  9398:20190528:171550.675 IPMI monitoring:        NO
  9398:20190528:171550.675 Web monitoring:        YES
  9398:20190528:171550.675 VMware monitoring:      NO
  9398:20190528:171550.675 ODBC:                  YES
  9398:20190528:171550.676 SSH2 support:           NO
  9398:20190528:171550.676 IPv6 support:          YES
  9398:20190528:171550.676 TLS support:           YES
  9398:20190528:171550.676 **************************
  9398:20190528:171550.676 using configuration file: /usr/local/etc/zabbix4/zabbix_proxy.conf
  9398:20190528:171550.720 The proxy does not match Zabbix database. Current database version (mandatory/optional): 03000000/03000000. Required mandatory version: 04000000.
  9398:20190528:171550.720 Zabbix does not support SQLite3 database upgrade.


You found the problem, but how to fix it! And why on 2 firewalls and 1 not?

[mimugmail]

stop zabbix, then via CLI:
/var/db/zabbix/zabbix_proxy.db

and start again

[intellim]

I got it working thanks to you input. It works like a charm now.
Thanks!!!

[mimugmail]

Great news!  8)