vShpereDB logged in to ESXi hosts but not getting data

The expected behavior

See resource usage and capacity of ESXi hosts.

The actual behavior

I see that the API connections with all configured hosts are fine but I don’t see any data there. The CPU, memory, and storage usage and capacity are all null.

I tried both HTTPS and HTTP protocols. The ESXi’s host agent log shows successful Icinga-vSphereDB/1.3 login:

2022-06-24T10:29:15.998Z info hostd[2100127] [Originator@6876 sub=Default opID=abfc843a] Accepted password for user root from 10.69.X.Y
2022-06-24T10:29:15.998Z warning hostd[2100127] [Originator@6876 sub=Vimsvc opID=abfc843a] Refresh function is not configured.User data can't be added to scheduler.User name: root
2022-06-24T10:29:15.998Z info hostd[2100127] [Originator@6876 sub=Vimsvc.ha-eventmgr opID=abfc843a] Event 1128 : User root@10.69.X.Y logged in as Icinga-vSphereDB/1.3

General information

  • Everything installed according to the manual from the Icinga website

  • icinga2 --version
    icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.3-1)

  • icinga2 feature list

Disabled features: command compatlog debuglog elasticsearch gelf graphite icingadb influxdb influxdb2 livestatus opentsdb perfdata statusdata syslog
Enabled features: api checker ido-mysql mainlog notification
  • icinga2 daemon -C
[2022-06-24 12:17:11 +0200] information/cli: Icinga application loader (version: r2.13.3-1)
[2022-06-24 12:17:11 +0200] information/cli: Loading configuration file(s).
[2022-06-24 12:17:11 +0200] information/ConfigItem: Committing config item(s).
[2022-06-24 12:17:11 +0200] information/ApiListener: My API identity: icinga252
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 NotificationComponent.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 IdoMysqlConnection.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 CheckerComponent.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 UserGroup.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 3 TimePeriods.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 User.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 11 Services.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 3 ServiceGroups.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 ScheduledDowntime.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 3 Zones.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 2 NotificationCommands.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 12 Notifications.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 Host.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 IcingaApplication.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 2 HostGroups.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 Downtime.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 Endpoint.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 FileLogger.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 2 ApiUsers.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 244 CheckCommands.
[2022-06-24 12:17:11 +0200] information/ConfigItem: Instantiated 1 ApiListener.
[2022-06-24 12:17:11 +0200] information/ScriptGlobal: Dumping variables to file '/var/cache/icinga2/icinga2.vars'
[2022-06-24 12:17:11 +0200] information/cli: Finished validating the configuration file(s).
  • Icinga Web 2 version and modules
    icingaweb_about

  • OS
    CentOS Linux release 7.9.2009 (Core)

  • PHP

rh-php73-php-cli.x86_64                                           7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-common.x86_64                                        7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-fpm.x86_64                                           7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-gd.x86_64                                            7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-intl.x86_64                                          7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-json.x86_64                                          7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-ldap.x86_64                                          7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-mbstring.x86_64                                      7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-mysqlnd.x86_64                                       7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-pdo.x86_64                                           7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-pgsql.x86_64                                         7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-process.x86_64                                       7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-soap.x86_64                                          7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-xml.x86_64                                           7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-php-zip.x86_64                                           7.3.29-1.el7                                      @centos-sclo-rh
rh-php73-runtime.x86_64                                           1-1.el7                                           @centos-sclo-rh

Logs

I haven’t found anything suspicious in the icinga2.log. The error.log is empty.

I installed everything again, and it works fine. This time with the recently released Icinga DB.

I think that a communication issue between Icinga and the database might have been the reason in June.