icingaweb2-module-vspheredb icon indicating copy to clipboard operation
icingaweb2-module-vspheredb copied to clipboard

Published 20 hours ago • verified publisher icon Icinga

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

Open ShowMeYourSkil opened this issue 2 years ago • 0 comments

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

ShowMeYourSkil avatar May 05 '22 17:05 ShowMeYourSkil