Problems with the query of data from the Vcenter database after update

Icinga Web Modules
,
1

Expected Behavior

When querying the Vcenter status icingacli vspheredb check vcenterconnection --vCenter IP Address or Domain should return the Vcenter health.

Current Behavior

The module throws the following error when queried: [UNKNOWN] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘0x’ in ‘where clause’, query was: SELECT vcenter.* FROM vcenter WHERE (instance_uuid = 0x)

Possible Solution

I could not find the error

Steps to Reproduce (for bugs)

  1. Open a SSH Connection to your Icinga2 Master Instanz
  2. Use the Command vspheredb check vcenterconnection --vCenter IP Address or Domain
  3. See error [UNKNOWN] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘0x’ in ‘where clause’, query was: SELECT vcenter.* FROM vcenter WHERE (instance_uuid = 0x)

Your Environment

  • VMware vCenter®/ESXi™-Version: vCenter Server 7.0 Update 3d
  • Version/GIT-Hash of this module: 1.4.0
  • Icinga Web 2 version: 2.10.1
  • Operating System and version: Debian10
  • Webserver, PHP versions: 7.3
2

you should use the vcenter id instead of IP address. You can get the vcenter id from the vspheredb using this query “select id, name from vspheredb.vcenter;”.