From time to time you need to find the moref of an object in vCenter. This is a quick powercli one liner to get the name and ID of an object type (VM, Datastore etc)
This assumes you are already connected to vCenter using Connect-VIServer
Get-Datastore | Select Name,ID
This command returns output like below. In this example i have 1 datastore
Get-VM | Select Name,ID
This command returns output like below
Use the following procedure to change the root password for a VMware appliance. This process uses single user mode so it allow you to change the root password if you have forgotten it!
Open the VM console and reboot the appliance
Select the line that starts with kernel and type e to edit the line
At the end of the line, press the spacebar and type init=/bin/sh
Press Enter to exit edit mode.
On the GRUB screen, type b to boot into single-user mode.
The virtual appliance boots in single-user mode.
To change the root user password, type passwd root and follow the on-screen prompts to enter a new password for the root user
To restart the virtual appliance, type reboot and press Enter.
When the virtual appliance restarts, you can log in using the new password.
Came across this issue in the lab today when trying to deploy a vApp template from the vCD catalog
Did some googling and came across a post by Jason Boche here that points to an issue with the QRTZ SQL tables (Who knew!). Thanks to Jason’s post i was able to run the script below to delete some rows from the tables. Once i restarted my vCD cells i was again able to deploy vApps. Script below (modified by jason to adhere to upper case table names). Be sure to stop all vCD cells and backup the SQL DB before executing. Change the DB name to whatever your DB is called
delete from QRTZ_SCHEDULER_STATE
delete from QRTZ_FIRED_TRIGGERS
delete from QRTZ_PAUSED_TRIGGER_GRPS
delete from QRTZ_CALENDARS
delete from QRTZ_TRIGGER_LISTENERS
delete from QRTZ_BLOB_TRIGGERS
delete from QRTZ_CRON_TRIGGERS
delete from QRTZ_SIMPLE_TRIGGERS
delete from QRTZ_TRIGGERS
delete from QRTZ_JOB_LISTENERS
delete from QRTZ_JOB_DETAILS
Not sure yet what caused this but the only event i know of was a vCenter restart 2 days ago. Will update this post if i find the root cause.
Importing VCSA 5.5 into vCD catalog fails with error Duplicate element ‘AnnotationSection’
To get around this error you need to edit the OVF file.
Disclaimer: I’m pretty sure that manually editing the OVF is not supported by VMware!
I had a VCSA ova so i first extracted the OVF using 7zip. Once extracted open the .ovf file in a text editor and look for the AnnotationSection
Highlight the section and delete it. Save the file. Because the manifest file is a checksum validation will fail so the quickest solution is to delete the .mf manifest file.
The OVF should then import to vCD successfully!