If you have a requirement to use CA signed SSL certificate for your vRO server cluster, you can use following steps to get your CA signed SSL certificate. You need to delete existing self signed vRO certificate. keytool -delete -alias dunes -keystore “/etc/vco/app-server/security/jssecacerts” -storepass “dunesdunes” Note: With vRO 7 password for the certificate store has… Continue reading Generate CA Signed Certificate for vRO cluster
Run the workflow provided in the vRO “Execute a custom query on a database” Select the database and input the query you want to execute on the database. INSERT INTO LinuxVMs (VMName,RequestNumber,OSType,OwnerName) VALUES(‘linux001′,’12345′,’RHEL’,’admin’); Above query inserts values in table named LinuxVMs. First define the column names (VMName,RequestNumber,OSType,OwnerName) and then define values (‘linux001′,’12345′,’RHEL’,’admin’); These simple workflows… Continue reading vRO Execute a custom query on database
If you want to retrieve some information from database, you can run a workflow which is provided with default vRO plugin. The name of the workflow is “Read a custom query from a database” System.log(“Executing query ” + query + ” on database ” + database.name ); resultRecords = database.readCustomQuery(query); System.log(resultRecords.getProperty(“Number”)); System.log(resultRecords.getFieldNames()); First two lines… Continue reading vRO Read a custom query from a database
I find this useful in some operations to retrieve all vRA VMs to get the VM names / vCAC:VirtualMachine.
You can use following code in scriptable task to retrieve vCAC:VirtualMachines.
var vRAVMs = Server.findAllForType("vCAC:VirtualMachine");
for each (i in vRAVMs)
if (i.VirtualMachineName == "mm130")
System.log("Found Virtual Machine you are looking for " +i.VirtualMachineName);
You might end up in a situation where you wanted to change the vRO self signed certificate and while doing so it got into a corrupt state. In such case you can simply regenerate the self signed certificate and get your vRO server up again and then proceed with CA signed certificate. Stop vRO Server… Continue reading Replace vRO self Signed Certificate with new Self Signed Certificate