hferch | Knowledge Base

hferch has written 76 articles

icons openhab

Posted on November 7, 2018 by hferch

https://fontawesome.com/icons?d=gallery&m=free

SSH Zugang ssh pi@10.10.10.56 Passwort: anharo11012005 su root Passwort: bananapi HFERCH-MAC:~ hferch$ ssh pi@10.10.10.56 pi@10.10.10.56’s password: The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable…

Reset root password

Posted on September 11, 2018 by hferch

vRealize Orchestrator 7.# – Unlocking vRO Root Account after too many failed login attempts Recently I tried to access one of my many vRO Server and noticed the root account was locked out due to too many tries. If you are here because of root account lockout, this post will walk you through unlocking root…

vRA 7.x custom property hostname not working

Posted on August 29, 2018 by hferch

If you want to set the self generated Hostname during the Clone Event you must set so properties as follow: The DnsName is optional, but Hostname and Name must be set var machine = payload.get(„machine“); virtualMachineAddOrUpdateProperties = new Properties (); virtualMachineAddOrUpdateProperties.put(‚Name‘, Your_hostname); virtualMachineAddOrUpdateProperties.put(‚Hostname‘, Your_hostname); virtualMachineAddOrUpdateProperties.put(‚DnsName‘, Your_hostname);

Get Attribute from vRO Configuration Element

Posted on August 2, 2018August 2, 2018 by hferch

var category = Server.getConfigurationElementCategoryWithPath(categoryPath);

if (category == null)
{
  throw("Configuration element path '" + categoryPath + "' not found!!");
}

var cfgElements = category.configurationElements.filter(function(element) {  
	return element.name == cfgName;  
});

//Get attribute names
if(cfgElements != null && cfgElements.length == 1){
for (attribute in cfgElements[0].attributes)
{
	if(cfgElements[0].attributes[attribute].name == attributeName){
		return cfgElements[0].attributes[attribute];
	}
}
}else{
	throw("Configuration name '" + cfgName + "' not found or not unique!!");
}
return null;

var category = Server.getConfigurationElementCategoryWithPath(categoryPath);

if (category == null)

{

throw("Configuration element path '" + categoryPath + "' not found!!");

}

var cfgElements = category.configurationElements.filter(function(element) {

return element.name == cfgName;

});

//Get attribute names

if(cfgElements != null && cfgElements.length == 1){

for (attribute in cfgElements[0].attributes)

{

if(cfgElements[0].attributes[attribute].name == attributeName){

return cfgElements[0].attributes[attribute];

}

}else{

throw("Configuration name '" + cfgName + "' not found or not unique!!");

}

return null;

Call

var attribute = System.getModule("com.vmware.pso.util").getConfigElementAttribute("Demo","demo2 General","vCenter") ;
System.log("Attribute Name: " + attribute.name);
System.log("Attribute Value: " + attribute.value);

var attribute = System.getModule("com.vmware.pso.util").getConfigElementAttribute("Demo","demo2 General","vCenter") ;

System.log("Attribute Name: " + attribute.name);

System.log("Attribute Value: " + attribute.value);

vRO Package with Example com.vmware.pso.util.getAttributeFromConfigurationElement Only the Action getConfigElementAttribute

Change next number in vRA machine prefix

Posted on August 2, 2018 by hferch

// Get a specific (LAB) machine prefixes from vRA
var searchMachinePrefix = "LAB";
var machinePrefixes = vCACCAFEEntitiesFinder.findMachinePrefixes(cafeHost, searchMachinePrefix);
System.log(machinePrefix)
for (var machinePrefix in machinePrefixes){
	if(machinePrefixes[machinePrefix].name == searchMachinePrefix){
		var foundMachinePrefix = machinePrefixes[machinePrefix];		
		System.log("ID: " + foundMachinePrefix.id);
		var machinePrefixId = foundMachinePrefix.id;
		var nextNumber = foundMachinePrefix.nextNumber;
		var newNumber = nextNumber + 1 // increase the nextNumber field in machine prefix 
		var modelName = 'ManagementModelEntities.svc'; // The model name 
		var entitySetName = 'HostNamePrefixes';  // The IaaS MSSQL DB table nacme
		var links = null;  
		var headers = null;  
		// Create entityId Property to get the right column from HostNamePrefixes table in IaaqS MSSQL DB
		var entityId = new Properties();
		entityId.put("HostnamePrefixID", machinePrefixId.toString())
		var entity = vCACEntityManager.readModelEntity(iaasHost.id, modelName, entitySetName, entityId, headers);
		var entityIdString = entity.keyString
		System.log("Machine Prefix Entity: " + entity)
		System.log ("Updating prefix entity with new next number " + newNumber)  
		// Create properties variable  
		var updateProperties = {  
		  NextMachineNo:newNumber
		  }  
		// Update the next number in existing prefix  
		System.getModule("com.vmware.library.vcac").updateVCACEntity(iaasHost.id, modelName, entitySetName, entityIdString, updateProperties, links, headers);
		}
	
}
if(!foundMachinePrefix){

	throw("No machine prefix with name: " + searchMachinePrefix + " found!");
}

// Get a specific (LAB) machine prefixes from vRA

var searchMachinePrefix = "LAB";

var machinePrefixes = vCACCAFEEntitiesFinder.findMachinePrefixes(cafeHost, searchMachinePrefix);

System.log(machinePrefix)

for (var machinePrefix in machinePrefixes){

if(machinePrefixes[machinePrefix].name == searchMachinePrefix){

var foundMachinePrefix = machinePrefixes[machinePrefix];

System.log("ID: " + foundMachinePrefix.id);

var machinePrefixId = foundMachinePrefix.id;

var nextNumber = foundMachinePrefix.nextNumber;

var newNumber = nextNumber + 1 // increase the nextNumber field in machine prefix

var modelName = 'ManagementModelEntities.svc'; // The model name

var entitySetName = 'HostNamePrefixes'; // The IaaS MSSQL DB table nacme

var links = null;

var headers = null;

// Create entityId Property to get the right column from HostNamePrefixes table in IaaqS MSSQL DB

var entityId = new Properties();

entityId.put("HostnamePrefixID", machinePrefixId.toString())

var entity = vCACEntityManager.readModelEntity(iaasHost.id, modelName, entitySetName, entityId, headers);

var entityIdString = entity.keyString

System.log("Machine Prefix Entity: " + entity)

System.log ("Updating prefix entity with new next number " + newNumber)

// Create properties variable

var updateProperties = {

NextMachineNo:newNumber

}

// Update the next number in existing prefix

System.getModule("com.vmware.library.vcac").updateVCACEntity(iaasHost.id, modelName, entitySetName, entityIdString, updateProperties, links, headers);

}

if(!foundMachinePrefix){

throw("No machine prefix with name: " + searchMachinePrefix + " found!");

}

Scriptable Task Inputs / Outputs Workflow Attributes Workflow package com.vmware.pso.vra.updatenextmachineprefixnumber

Enabling access to vPostgres Database:

Posted on Juli 26, 2018 by hferch

First, log into the vRA appliance or SSH to it using root account. Next edit pg_hba.conf file

vi /storage/db/pgdata/pg_hba.conf

1	vi /storage/db/pgdata/pg_hba.conf

Check for the presence of the line

local      all              postgres                            trust

1	local all postgres trust

What this enables, is using the local machine you can use vcac user to login to the database. Since I wanted to access it remotely, I added the following…

Author: hferch

hferch has written 76 articles

icons openhab

banana pi

Reset root password

vRA 7.x custom property hostname not working

Get Attribute from vRO Configuration Element

Change next number in vRA machine prefix

Enabling access to vPostgres Database:

Reactivate Windows KMS

Run Script in guest with vRO login credentials

Bad Gateway error 502 in vRA