OPNsense Forum

Archive => 19.1 Legacy Series => Topic started by: intellim on May 28, 2019, 01:36:48 PM

Title: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: intellim on May 28, 2019, 01:36:48 PM
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
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: mimugmail on May 28, 2019, 03:06:17 PM
Sometimes you have to Install proxy4 twice, can you check If it's really installed?
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: intellim on May 28, 2019, 11:54:38 PM
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.


Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: mimugmail on May 29, 2019, 07:13:16 AM
Can you check the logs via console please?

tail -f /var/log/zabbix_proxy.log
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: intellim on May 29, 2019, 09:50:10 AM
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?
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: mimugmail on May 29, 2019, 10:07:50 AM
stop zabbix, then via CLI:
/var/db/zabbix/zabbix_proxy.db

and start again
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: intellim on May 29, 2019, 11:05:25 AM
I got it working thanks to you input. It works like a charm now.
Thanks!!!
Title: Re: Zabbix Porxy 4 service not starting after upgrade to 19.1
Post by: mimugmail on May 29, 2019, 11:31:15 AM
Great news!  8)