Virtualisation Tips & Tricks

I managed to contact the manufacturer’s technical support about the problem when there are many disks with the status “error” in the database. VMware support confirmed that it is safe to delete disks with status “ERROR” from the database. Connect to the DB:sudo -i -u postgres psql vcloud We find…

Sometimes there is a situation where vCloud Director can no longer delete the organization, vdc or network after some actions. There is a reference in the VCD database The solution is to find the required network in the DB and delete it. Connect to the DB:sudo -i -u postgres psql…

Sometimes a situation is possible that when performing some actions, the vCloud Director task can “hang” and show the status “pending” all the time. This may block further operation with vCloud Director. The solution is to find the required task in the DB and set the status “failed”. Always make…

Unfortunately, the new Cloud Director version does not have an automated backup option. Only manual option to press button in appliance UI or execute command.  So we have to create one ourselves using scripts! We will use internal command /opt/vmware/appliance/bin/create-db-backup. On the NFS shared transfer service storage backup file is created. The .tgz file…

Hack. Grant the user rights to all organisations. Example, new user vcav. It has to been done on source replicator.

VMware Cloud Director has secret not well known API only feature that allows to move vApps across Org VDCs while they are running. This feature has been purposefully made for the NSX-V to NSX-T Migration Tool, but can be used for other use cases hence the reason here to shed more lights…

If you have symptoms like the Cloud Director UI is slow to load or tasks will finish relatively quickly, but loading information is slow, then this could be your case. Slow UI performance can usually be attributed to a large growth of the audit_trail table in the database. The audit_trail table will capture activity…

Metrics are not displaying anymore, but using API you can query and see them fine. Connect to primary DB cell and execute command below. Check after a few minutes if metrics are coming back or not. If the issue still persists, move to the next step.

VMware Cloud Director UI and tasks are slow to load and complete.The Artemis message bus communication is not working and when you trigger operations from the UI, they can take up to 5 minutes to complete or might time out. The performance issues can affect operations such as powering on…

This is fastest method using Postgres repmgr to clone DB from primary cell. Detailed explanation is here https://blog.raveland.tech/post/postgresql_repmgr_pgbouncer_en/ Stop Postgres DB: Remove the content of the pgdata on the standby nodes: Copy the pgdata content form the primary node to the standby nodes: Make sure that the vpostgres service is running…

This SQL function helps you to find anything in the database. Example of syntax for using this function.

Install Using a Cloudsmith Mirror Yum Repository​ A Yum repository with RabbitMQ packages is available from Cloudsmith and a mirror of the repositories there. Install RabbitMQ and Cloudsmith Signing Keys​ Yum will verify signatures of any packages it installs, therefore the first step in the process is to import the…

Navigate to the database directory as mentioned below path and Copy README file. # cd  /opt/vmware/appliance/etc/pg_hba.d# cp README pg_access Append the file with below shown entry. (You can allow access only from specific IP addresses as needed.) #TYPE  DATABASE  USER    ADDRESS           METHODhost   vcloud    vcloud  0.0.0.0/0  md5 Now change the permissions and…