vShperedb - unable to delete vCenter entry

Icinga Modules
1

Hello Community,

recently we moved our 2 vCenters into a new one and I tried to delete the connections and the entry’s.
On the “Virtualization (VMware) → Configuration” the old entry’s are deleted, but on the Main page of “Virtualization (VMware)” it stills exist

image
image790×548 37.2 KB

Also inside the “Director → Import source” I can still select the old ones. Is there a way to cleanup the old connections?`

A simple:
delete from vcenter where name="vCenter-Name";
causes an error:

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`vspheredb`.`monitoring_connection`, CONSTRAINT `monitoring_vcenter` FOREIGN KEY (`vc
enter_uuid`) REFERENCES `vcenter` (`instance_uuid`) ON UPDATE CASCADE)

Thanks in advance

  • Director version (System - About):1.9.1
  • Icinga Web 2 version and modules (System - About): 2.9.5
  • Icinga 2 version (icinga2 --version): 2.13.2-1
  • vspheredb:1.4.0
  • Operating System and version: RockyLinux 8
  • Webserver, PHP versions:
    • Apache 2.4.37-41
    • PHP 7.4.19
2

There is a issue open about this: Allow to delete all data related to a vCenter · Issue #324 · Icinga/icingaweb2-module-vspheredb · GitHub

Did you try “ON DELETE CASCADE”? MySQL ON DELETE CASCADE: Deleting Data from Related Tables Automatically

3

Thank you @rivad ,
I did not try do delete the data with cascade.

Since this feature will be released with 1.5 I will wait some time and then delete them.