Zabbix troubles on PFsense

[PeqX]

Hi Forum.
Been running zabbix for some time now - and have my setup running - as wanted.
But -- I do have a Zabbix Proxy installed on a PFsense SG-1100 ( Running our DMZ zone) for webpages.
I have installed zabbix and had it running - then PFsense had an update for their system, and afterwards I cannot get zabbix-Proxy running again - and when looking through the logfile on the PFsense - I'm only getting this info:

 [h=2]Last 50 Zabbix Proxy 4.4 Log Entries[/h]  
 Binary file (standard input) matches

And I can see that its now 21days since last contact.
I have tried to reinstall the zabbix-proxy without luck. I have removed it - rebooted the PFsense and installed it again ( It'll remember all my settings) but still the same error in zabbix Proxy log

So I cannot see where this issues lies - if it PFsense ( I have other 3 PFsense with the same build of Pfsense/zabbix-proxy running without issues - can anyone point me in the right direction for solving this issue

Thanks in advance

PeqX

[Hamardaban]

Go to the proxy settings and check all the values. If you use advanced parameters, temporarily remove them.
Save configuration. Restart the service.
Look in the zabbix proxy log for some error.

[PeqX]

Go to the proxy settings and check all the values. If you use advanced parameters, temporarily remove them.
Save configuration. Restart the service.
Look in the zabbix proxy log for some error.

Hi ad thanks for the answer - But I have no advanced parameters and all setting are valid - same as before updating the PFsense to 2.4.5

I cannot start the service - And when looking at the agent that sould connect to this - give this error

 
  6650:20200420:011157.585 **************************     6650:20200420:011157.585 using configuration file: /usr/local/etc/zabbix44/zabbix_agentd.conf  6650:20200420:011157.586 agent #0 started [main process]  9674:20200420:011157.640 agent #3 started[listener #2]  9696:20200420:011157.647 agent #4 started[listener #3]  7772:20200420:011157.744 agent #1 started [collector]  9301:20200420:011157.749 agent #2 started[listener #1]  9849:20200420:011157.766 agent #5 started [active checks #1] zabbix_agentd [12436]: Is this process already running? Could not lock PID file [/var/run/zabbix-agent/zabbix_agentd.pid]: [35] Resource temporarily unavailable  9849:20200420:011201.478 active check configuration update from [10.101.10.1:10051] started to fail (cannot connect to [[10.101.10.1]:10051]: [4] Interrupted system call)  5843:20200420:013431.301 Starting Zabbix Agent [pfsense-www]. Zabbix 4.4.5 (revision b93f5c4fc0).  5843:20200420:013431.305 **** Enabled features ****

But when looking into the log - i'm getting this error

 
  15237:20200420:073801.970 The proxy does not match Zabbix database. Current database version (mandatory/optional): UNKNOWN. Required mandatory version: 04040000.  15237:20200420:073801.970 Zabbix does not support SQLite3 database upgrade.  25201:20200420:073809.643 Starting Zabbix Proxy (active) [Insa-WWW]. Zabbix 4.4.5 (revision b93f5c4fc0).

So how can I remove this file on a PFsense proxy - or how is the right way to do - Since this was only happening on one of 3 PFsense Proxies - I have tried googling this and was recreating the Proxy.database with the command:

sqlite3 /var/db/zabbix-proxy/zabbix.db < schema.sql

But still the same issue and are not starting Proxy

[PeqX]

After creating manually the file with the command

 
 sqlite3 /var/db/zabbix-proxy/zabbix.db < schema.sql

Deleted the file /var/db/zabbix-proxy/zabbix.db and restarted the service - then it'll create the files and start

[Hamardaban]

That's right! The proxy does not support updating the sqlite database. If you delete the database file, the database will be created again automatically when the proxy starts.