Symptoms
- VM Directory Import is successful
- Virtual Machines are imported but Hosts appear to have failed.
- vHost Inspector does not show hosts when querying
Solution
Summary
The vHost inspector is looking at the classic vHost tables in the backend after upgrading from 6.1.3 to 6.1.4.
Fix
Logon to the Appliance with the database, that can be either the HUB or Remote Database depending on the configuration and execute the following commands as root:
- Check vHosts are on the DB:
Putty in as friend / sspassword
Switch to root using this command: su -
Then run the command: echo "select * from tnt_config.vmhost;" | su - postgres -c 'psql portal'
- Run the following to fix to point the host to current tables in the db and restart database:
sudo echo "begin;select partman.undo_partition('tnt_audit.hoststats');select partman.create_parent('tnt_audit.hoststats', 'end_date', 'partman', 'daily');commit;"| sudo su - postgres -c 'psql portal'