Mar 14, 2023

How do I resolve issue with:
"{"error":"sql: no rows in result set"}"

This is what I get in log:

root@vmdsc [ /home/vmdsc/logs ]# tail vmdsc.log -f
Checking for privileges:
VirtualMachine.Interact.PowerOff, VirtualMachine.Interact.PowerOn, VirtualMachine.Interact.Reset, VirtualMachine.Config.CPUCount, VirtualMachine.Config.Memory, VirtualMachine.Config.AdvancedConfig, VirtualMachine.Config.Settings

INFO[Tue Mar 14 11:51:29 UTC 2023] main.(*VcConnect).HasPrivileges-fm Session has privileges on root folder
INFO[Tue Mar 14 11:51:29 UTC 2023] main.(*App).CheckSessionIsPriviliged-fm Session is Priviliged...
TRAC[Tue Mar 14 11:51:29 UTC 2023] main.(*Configurator).GetConfig-fm - Fetching Config for UUID: 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
ERRO[Tue Mar 14 11:51:29 UTC 2023] main.(*App).getConfigs-fmsql: no rows in result set
TRAC[Tue Mar 14 11:51:29 UTC 2023] main.(*Configurator).UpdateConfig-fm - Updating Config for UUID: 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
INFO[Tue Mar 14 11:51:29 UTC 2023] Inside model, updating config: &{422fa8bd-ee9c-8ed7-edce-fc38190a5fb5 4 16384 1 }
ERRO[Tue Mar 14 11:51:29 UTC 2023] main.(*Configurator).UpdateConfig-fmsql: no rows in result set
TRAC[Tue Mar 14 11:51:35 UTC 2023] main.(*App).CheckSessionIsPriviliged-fm Found UUID, checking for privileges on resources denoted by UUID... 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
INFO[Tue Mar 14 11:51:35 UTC 2023] main.(*VcConnect).HasPrivileges-fm - Checking for privileges on Entity with UUID: 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
INFO[Tue Mar 14 11:51:35 UTC 2023] main.(*VcConnect).HasPrivileges-fm

Checking for privileges:
VirtualMachine.Interact.PowerOff, VirtualMachine.Interact.PowerOn, VirtualMachine.Interact.Reset, VirtualMachine.Config.CPUCount, VirtualMachine.Config.Memory, VirtualMachine.Config.AdvancedConfig, VirtualMachine.Config.Settings

INFO[Tue Mar 14 11:51:35 UTC 2023] main.(*VcConnect).HasPrivileges-fm Session has privileges on root folder
INFO[Tue Mar 14 11:51:35 UTC 2023] main.(*App).CheckSessionIsPriviliged-fm Session is Priviliged...
TRAC[Tue Mar 14 11:51:35 UTC 2023] main.(*Configurator).GetConfig-fm - Fetching Config for UUID: 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
ERRO[Tue Mar 14 11:51:35 UTC 2023] main.(*App).getConfigs-fmsql: no rows in result set
TRAC[Tue Mar 14 11:51:36 UTC 2023] main.(*Configurator).UpdateConfig-fm - Updating Config for UUID: 422fa8bd-ee9c-8ed7-edce-fc38190a5fb5
INFO[Tue Mar 14 11:51:36 UTC 2023] Inside model, updating config: &{422fa8bd-ee9c-8ed7-edce-fc38190a5fb5 4 16384 1 }
ERRO[Tue Mar 14 11:51:36 UTC 2023] main.(*Configurator).UpdateConfig-fmsql: no rows in result set

Mar 14, 2023

Ok, looks like I've been using Set-VMDSC instead of Add-VMDSC which corresponds to PUT and POST requests.
Set-VMDSC fails with PUT request since record does not yet exists.

Feb 25, 2023

Will there by any updates to VMDSC or will this be integrated into Aria Operations for vCenter?

Feb 08, 2023

This is great...hopefully one day it will be available directly in vSphere without additional appliance

+1 also for cpu/memory hot add enable/disable

Thank you

Jan 23, 2023

Our vCenter uses internally signed CAs. I've tried following the suggestions here in the comments, and a curl to the vCenter IP from the VMDSC appliance is now successful:

SSL certificate verify ok.

but the docker logs show:

panic: open /home/vmdsc/app/config/ca-cert.pem: permission denied

I confirmed the ca-cert.pem file exists and contains our intermediate and root certificates.

Jan 23, 2023

I figured it out -- permissions on the newly created ca-cert.pem file

was:
-rw-r----- 1 root root 3014 Jan 23 22:51 ca-cert.pem

now:
-rw-r----- 1 vmdsc root 3014 Jan 23 22:51 ca-cert.pem