Zabbix host windows host not found

Steps to reproduce:

Basically after upgrading from 4.4.x to 5.0-alpha3/4 the agent / server are complaining from «host [hostname] nor found».

The odd part is that a few hosts are working and a some are not.

One host with agent 5.0 (from compilation) works

Some hosts with 4.4.6 works (with or without PSK) and others don’t (with or without PSK)

I first noticed that he started auto registering hosts with the same name and same IP. I disabled auto registration, but there are no changes.

Maybe DB upgrade was not as expected from 4.4 to 5 ?

Looking at the agents and configurations I cannot explain the behavior.

Result:

2590578:20200407:143901.238 item "messier67:master_system" became supported

2590654:20200407:143935.623 autoregistration from "192.168.1.148" denied (host:"arch-epsilon.science.net" ip:"192.168.1.148" port:100
50): connection type "TLS with PSK" is not allowed for autoregistration

2590654:20200407:143935.624 cannot send list of active checks to "192.168.1.148": host [arch-epsilon.science.net] not found

2590654:20200407:143935.836 cannot send list of active checks to "192.168.1.250": host [mercury.science.net] not found

2590657:20200407:143937.826 autoregistration from "192.168.1.142" denied (host:"arch-eta.science.net" ip:"192.168.1.142" port:10050):
 connection type "TLS with PSK" is not allowed for autoregistration

2590657:20200407:143937.826 cannot send list of active checks to "192.168.1.142": host [arch-eta.science.net] not found

2590656:20200407:143941.015 cannot send list of active checks to "192.168.1.210": host [beehive.science.net] not found

2590658:20200407:143944.788 cannot send list of active checks to "192.168.1.22": host [lagrange1.science.net] not found

2590658:20200407:144015.723 autoregistration from "192.168.1.10" denied (host:"messier67" ip:"192.168.1.10" port:10050): connection t
ype "TLS with PSK" is not allowed for autoregistration

2590658:20200407:144015.724 cannot send list of active checks to "192.168.1.10": host [messier67] not found

2590658:20200407:144021.867 cannot send list of active checks to "192.168.1.2": host [orion.science.net] not found

Above you have agents from FreeBSD, OpenBSD, CentOS, Archlinux all of them were working find before update.

The Server zabbix_agentd.conf

Server=127.0.0.1,192.168.100.100

### Option: ListenPort
#   Agent will listen on this port for connections from the server.
#
# Mandatory: no
# Range: 1024-32767
# Default:
# ListenPort=10050


### Option: ListenIP
#   List of comma delimited IP addresses that the agent should listen on.
#   First IP address is sent to Zabbix server if connecting to it to retrieve list of active checks.
#
# Mandatory: no
# Default:
# ListenIP=0.0.0.0

### Option: StartAgents
#   Number of pre-forked instances of zabbix_agentd that process passive checks.
#   If set to 0, disables passive checks and the agent will not listen on any TCP port.
#
# Mandatory: no
# Range: 0-100
# Default:
 StartAgents=8

##### Active checks related

### Option: ServerActive
#   List of comma delimited IP:port (or hostname:port) pairs of Zabbix servers for active checks.
#   If port is not specified, default port is used.
#   IPv6 addresses must be enclosed in square brackets if port for that host is specified.
#   If port is not specified, square brackets for IPv6 addresses are optional.
#   If this parameter is not specified, active checks are disabled.
#   Example: ServerActive=127.0.0.1:20051,zabbix.domain,[::1]:30051,::1,[12fc::1]
#
# Mandatory: no
# Default:
# ServerActive=

ServerActive=192.168.100.100:10051

### Option: Hostname
#   Unique, case sensitive hostname.
#   Required for active checks and must match hostname as configured on the server.
#   Value is acquired from HostnameItem if undefined.
#
# Mandatory: no
# Default:
# Hostname=

Hostname=scidb601

The Client zabbix_agentd.conf

        Server=192.168.100.100
        ### Option: ListenPort
        #   Agent will listen on this port for connections from the server.
        #
        # Mandatory: no
        # Range: 1024-32767
        # Default:
        # ListenPort=10050
        ### Option: ListenIP
        #   List of comma delimited IP addresses that the agent should listen on.
        #   First IP address is sent to Zabbix server if connecting to it to retrieve list of active checks.
        #
        # Mandatory: no
        # Default:
        # ListenIP=0.0.0.0
        ### Option: StartAgents
        #   Number of pre-forked instances of zabbix_agentd that process passive checks.
        #   If set to 0, disables passive checks and the agent will not listen on any TCP port.
        #
        # Mandatory: no
        # Range: 0-100
        # Default:
        # StartAgents=3
        ##### Active checks related
        ### Option: ServerActive
        #   List of comma delimited IP:port (or hostname:port) pairs of Zabbix servers for active checks.
        #   If port is not specified, default port is used.
        #   IPv6 addresses must be enclosed in square brackets if port for that host is specified.
        #   If port is not specified, square brackets for IPv6 addresses are optional.
        #   If this parameter is not specified, active checks are disabled.
        #   Example: ServerActive=127.0.0.1:20051,zabbix.domain,[::1]:30051,::1,[12fc::1]
        #
        # Mandatory: no
        # Default:
        # ServerActive=
        ServerActive=192.168.100.100
        ### Option: Hostname
        #   Unique, case sensitive hostname.
        #   Required for active checks and must match hostname as configured on the server.
        #   Value is acquired from HostnameItem if undefined.
        #
        # Mandatory: no
        # Default:
        # Hostname=
        Hostname=scidb601

**

The zabbix_server.log shows:
cannot send list of active checks to [192.168.100.96]: host [scidb601] not found

And in mysql database, there is a host="scidb601" and user="zabbix".


I can not visit the page which adds a host. 

Please help me! Thanks a lot!

[root@scidb601 ~]# service mysqld status
mysqld (pid 22917) is running...

Mysql error log:

150814 20:46:41 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
150814 20:46:41 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
150814 20:46:41 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
150814 20:46:41 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
150814 20:46:41 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
150814 20:46:41 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
150814 20:46:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-cll-lve'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp