Hi Mark,

Sorry you ran into this, unfortunately this is an unexpected event of running a vcl setup in standalone mode.
https://cwiki.apache.org/VCL/configuring-a-standalone-vmware-vcl-environment.html

Do you have separate locations for your image library and your running vms? It looks like you might be using the same location /images/vmware.

This is the intended behavior of the vmware.pm module when using local disk. The idea behind this is to keep the disk on the vmware host server freed up and not have too many non-running vmware disk images residing on the remote machine. Also the same would happen if the disk usage would be close to full for the partition where the virtual machine path was defined. But since the vmware host server and the vcl management node are on the same box, I can see where this can happen if not careful. In this setup vcld(the management node) assumes that the remote localvmhost server is a different machine, etc and that the copy of the image on the vcld management node server is safe.

Looking at your logs.

The part around 10:31:53 reports the vm is on but appears could not ssh into it. Thus it returned a RELOAD flag. The the load routine calls control_VM routine to clear any possible vms running with that hostname vmguest-1
So it finds a vm running out of /home/vm/vmware and stops and removes it.
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx

I'm not sure where this is coming from, since /home/vm/vmware is not in your vmprofile table.
Could this be one you manually fired up?
Is /home/vm/vmware a symlink to /images/vmware?

Anyway, when using the standalone mode(not recommended for anything production) please make sure to have a separate directory or partition for your stored vms and your running vms.

Aaron

On 4/26/10 11:18 AM, Mark Gardner wrote:
[Still looking for help with this.]

I have obviously misconfigured something...

I have been working on a standalone system and have been systematically
fixing errors I find in the logs. On the last attempt to make a reservation,
the VMware Server virtual machine was unregistered and deleted. Needless to
say it was definitely a surprise!

I am enclosing vcld.log. The problem occurs at time 10:31:55. I am also
enclosing selects from related tables. Your help in correcting this
unexpected behavior would be greatly appreciated.

== BEGIN vcld.log ===
===========================================================
OUTPUT for vcld run on 2010-04-20 10:31:22
===========================================================
2010-04-20 10:31:22|25426|vcld:main(116)|vcld environment variable set to 1
for this process
2010-04-20 10:31:22|25426|utils.pm:rename_vcld_process(7901)|renamed process
to 'vcld vcld'
2010-04-20 10:31:22|25426|utils.pm:get_management_node_info(6815)|management
node info retrieved from database for localhost
2010-04-20 10:31:22|25426|vcld:main(127)|retrieved management node
information from database
2010-04-20 10:31:22|25426|vcld:main(140)|management_node_id environment
variable set: 1
2010-04-20 10:31:22|25426|vcld:main(148)|management node checkin interval is
5 seconds
2010-04-20 10:31:22|25426|vcld:main(149)|vcld started on localhost
2010-04-20 10:31:27|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:27
2010-04-20 10:31:32|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:32
2010-04-20 10:31:37|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:37
2010-04-20 10:31:42|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:42
2010-04-20 10:31:47|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:47
2010-04-20 10:31:52|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:52
2010-04-20 
10:31:52|25426|7:7|new|utils.pm:reservation_being_processed(9634)|computerloadlog
'begin' entry does NOT exist for reservation 7
2010-04-20 
10:31:52|25426|7:7|new|utils.pm:reservation_being_processed(9686)|reservation
is NOT currently being processed
2010-04-20 10:31:52|25426|7:7|new|vcld:main(276)|reservation 7 is NOT
already being processed
2010-04-20 10:31:52|25426|7:7|new|utils.pm:get_request_info(5354)|standalone
affiliation found: Local
2010-04-20 
10:31:52|25426|7:7|new|utils.pm:get_management_node_info(6815)|management
node info retrieved from database for localhost
2010-04-20 10:31:52|25426|7:7|new|vcld:main(281)|retrieved request
information from database
2010-04-20 
10:31:52|25426|7:7|new|utils.pm:get_management_node_info(6815)|management
node info retrieved from database for localhost
2010-04-20
10:31:52|25426|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20 10:31:52|25426|7:7|new|utils.pm:update_request_state(2186)|request
7 state updated to: pending, laststate to: new
2010-04-20 10:31:52|25426|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, begin, beginning to process, state is new
2010-04-20 10:31:52|25426|7:7|new|vcld:make_new_child(509)|loaded VCL::new
module
2010-04-20 10:31:52|25426|7:7|new|vcld:make_new_child(566)|current number of
forked kids: 1
2010-04-20 10:31:52|25440|7:7|new|vcld:make_new_child(582)|vcld environment
variable set to 0 for this process
2010-04-20 10:31:52|25440|7:7|new|Module.pm:new(132)|constructor called,
class=VCL::new
2010-04-20 10:31:52|25440|7:7|new|Module.pm:new(154)|VCL::new object created
2010-04-20 10:31:52|25440|7:7|new|State.pm:initialize(85)|obtained a
database handle for this state process, stored as $ENV{dbh}
2010-04-20 10:31:52|25440|7:7|new|State.pm:check_image_os(820)|no
corrections need to be made, not an imaging request, returning 1
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20 10:31:52|25440|7:7|new|utils.pm:rename_vcld_process(7863)|reservation
count: 1
2010-04-20 
10:31:52|25440|7:7|new|utils.pm:rename_vcld_process(7882)|PARENTIMAGE:
1
2010-04-20 10:31:52|25440|7:7|new|utils.pm:rename_vcld_process(7883)|SUBIMAGE:
0
2010-04-20 10:31:52|25440|7:7|new|utils.pm:rename_vcld_process(7901)|renamed
process to 'vcld VCL::new 7:7 new'
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20 10:31:52|25440|7:7|new|State.pm:initialize(121)|attempting to
load provisioning module: VCL::Module::Provisioning::vmware
2010-04-20
10:31:52|25440|7:7|new|State.pm:initialize(127)|VCL::Module::Provisioning::vmware
module loaded
2010-04-20 10:31:52|25440|7:7|new|Module.pm:new(132)|constructor called,
class=VCL::Module::Provisioning::vmware
2010-04-20
10:31:52|25440|7:7|new|Module.pm:new(154)|VCL::Module::Provisioning::vmware
object created
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:initialize(105)|vmware module
initialized
2010-04-20
10:31:52|25440|7:7|new|State.pm:initialize(131)|VCL::Module::Provisioning::vmware
provisioner object created
2010-04-20 10:31:52|25440|7:7|new|State.pm:initialize(145)|attempting to
load OS module: VCL::Module::OS::Linux
2010-04-20
10:31:52|25440|7:7|new|State.pm:initialize(151)|VCL::Module::OS::Linux
module loaded
2010-04-20 10:31:52|25440|7:7|new|Module.pm:new(132)|constructor called,
class=VCL::Module::OS::Linux
2010-04-20 10:31:52|25440|7:7|new|Module.pm:new(154)|VCL::Module::OS::Linux
object created
2010-04-20
10:31:52|25440|7:7|new|State.pm:initialize(154)|VCL::Module::OS::Linux OS
object created
2010-04-20 10:31:52|25440|7:7|new|State.pm:initialize(169)|returning 1
2010-04-20 10:31:52|25440|7:7|new|vcld:make_new_child(591)|VCL::new object
created and initialized
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1946)|attempting
to retrieve current state of computer vmguest-1 from the database
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1977)|retrieved
current state of computer vmguest-1 from the database: available
2010-04-20 10:31:52|25440|7:7|new|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{7}{computer}{state}{name}
|25440|7:7|new| computer_state_name = available
2010-04-20 
10:31:52|25440|7:7|new|utils.pm:get_management_node_id(9364)|environment
variable: 1
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(134)|reservation is parent
= 1
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(135)|preload only = 0
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(136)|originating request
state = new
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(137)|originating request
laststate = new
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(138)|originating computer
state = available
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(139)|originating computer
type = virtualmachine
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1946)|attempting
to retrieve current state of computer vmguest-1 from the database
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1977)|retrieved
current state of computer vmguest-1 from the database: available
2010-04-20 10:31:52|25440|7:7|new|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{7}{computer}{state}{name}
|25440|7:7|new| computer_state_name = available
2010-04-20 
10:31:52|25440|7:7|new|utils.pm:get_management_node_id(9364)|environment
variable: 1
2010-04-20 10:31:52|25440|7:7|new|new.pm:computer_not_being_used(788)|vmguest-1
state is available
2010-04-20 10:31:52|25440|7:7|new|new.pm:computer_not_being_used(798)|vmguest-1
is available, its state is available
2010-04-20 10:31:52|25440|7:7|new|new.pm:process(170)|vmguest-1 is not being
used
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 7
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1946)|attempting
to retrieve current state of computer vmguest-1 from the database
2010-04-20
10:31:52|25440|7:7|new|DataStructure.pm:get_computer_state_name(1977)|retrieved
current state of computer vmguest-1 from the database: available
2010-04-20 10:31:52|25440|7:7|new|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{7}{computer}{state}{name}
|25440|7:7|new| computer_state_name = available
2010-04-20 
10:31:52|25440|7:7|new|utils.pm:get_management_node_id(9364)|environment
variable: 1
2010-04-20 10:31:52|25440|7:7|new|new.pm:reload_image(514)|calling
VCL::Module::Provisioning::vmware->node_status()
2010-04-20 10:31:52|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, statuscheck, checking status of node
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1888)|identity_keys=
/etc/vcl/vcl.key
2010-04-20 
10:31:52|25440|7:7|new|vmware.pm:node_status(1889)|requestedimagename=
vmwarelinux-xubuntu904-v0
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1890)|image_os_type=
linux
2010-04-20 
10:31:52|25440|7:7|new|vmware.pm:node_status(1891)|request_forimaging=
0
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1892)|vmpath=
/images/vmware
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1893)|datastorepath=
/images/vmware
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1911)|checking if
vmguest-1 is pingable
2010-04-20 10:31:52|25440|7:7|new|vmware.pm:node_status(1914)|vmguest-1 is
pingable (1)
2010-04-20 10:31:52|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'vmware-cmd
/images/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
getstate' 2>&1
2010-04-20 10:31:53|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| getstate() = on
2010-04-20 10:31:53|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "getstate() = on")
2010-04-20 10:31:53|25440|7:7|new|vmware.pm:node_status(1930)|getstate() =
on
2010-04-20 10:31:53|25440|7:7|new|vmware.pm:node_status(1941)|vmguest-1
vmstate reports on
2010-04-20 10:31:53|25440|7:7|new|vmware.pm:node_status(1979)|returning node
status hash reference ($node_status->{status}=RELOAD)
2010-04-20 10:31:53|25440|7:7|new|new.pm:reload_image(529)|node_status
returned a hash reference
2010-04-20 10:31:53|25440|7:7|new|new.pm:reload_image(534)|node_status hash
reference contains key {status}=RELOAD
2010-04-20 10:31:53|25440|7:7|new|new.pm:reload_image(602)|node status is
RELOAD, vmguest-1 will be reloaded
2010-04-20 10:31:53|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, loadimageblade, vmguest-1 must be reloaded with
vmwarelinux-xubuntu904-v0
2010-04-20 10:31:53|25440|7:7|new|new.pm:reload_image(616)|calling
VCL::Module::Provisioning::vmware->does_image_exist()
2010-04-20 10:31:53|25440|7:7|new|vmware.pm:does_image_exist(2018)|image
repository path: /images/vmware
2010-04-20 10:31:53|25440|7:7|new|utils.pm:run_command(9737)|executed
command: du -c /images/vmware/*vmwarelinux-xubuntu904-v0* 2>&1 | grep total
2>&1, pid: 25451, exit status: 0, output:
|25440|7:7|new| 2701668 total
2010-04-20 
10:31:53|25440|7:7|new|vmware.pm:does_image_exist(2070)|vmwarelinux-xubuntu904-v0
exists in /images/vmware, size: 2638 MB
2010-04-20 
10:31:53|25440|7:7|new|new.pm:reload_image(619)|vmwarelinux-xubuntu904-v0
exists on this management node
2010-04-20 10:31:54|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, doesimageexists, confirmed image exists
2010-04-20 10:31:54|25440|7:7|new|utils.pm:update_computer_state(2228)|computer
2 state updated to: reloading
2010-04-20 10:31:54|25440|7:7|new|new.pm:reload_image(652)|computer
vmguest-1 state set to reloading
2010-04-20 10:31:54|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, info, computer state updated to reloading
2010-04-20 10:31:54|25440|7:7|new|new.pm:reload_image(663)|calling
VCL::Module::Provisioning::vmware->load() subroutine
2010-04-20 10:31:54|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, info, calling VCL::Module::Provisioning::vmware->load()
subroutine
2010-04-20 10:31:54|25440|7:7|new|vmware.pm:control_VM(1526)|control remove
is defined
2010-04-20 10:31:54|25440|7:7|new|vmware.pm:control_VM(1590)|checking for
base image on localvmhost /images/vmware
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'ls -1 /images/vmware' 2>&1
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| XUbuntu_LiveCD
|25440|7:7|new| vmwarelinux-xubuntu904-v0vmguest-1
|25440|7:7|new| vmwarelinux-xubuntu910-v0
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "XUbuntu_LiveCD vmwarelinux-xub...")
2010-04-20 10:31:54|25440|7:7|new|vmware.pm:control_VM(1596)|XUbuntu_LiveCD
vmwarelinux-xubuntu904-v0vmguest-1 vmwarelinux-xubuntu910-v0
2010-04-20 
10:31:54|25440|7:7|new|vmware.pm:control_VM(1618)|/images/vmware/noimagevmguest-1/noimagevmguest-1.vmx
directory structure for noimagevmguest-1 did not exist
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'vmware-cmd -l' 2>&1
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new|
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "/home/vm/vmware/vmwarelinux-xu...")
2010-04-20 10:31:54|25440|7:7|new|vmware.pm:
control_VM(1636)|/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
2010-04-20 10:31:54|25440|7:7|new|vmware.pm:control_VM(1644)|my vmx
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
2010-04-20 10:31:54|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'vmware-cmd
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
getstate' 2>&1
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| getstate() = on
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "getstate() = on")
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'vmware-cmd
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
stop hard' 2>&1
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| stop(hard) = 1
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "stop(hard) = 1")
2010-04-20 10:31:55|25440|7:7|new|vmware.pm:control_VM(1662)|turned off
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'vmware-cmd -s unregister
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
' 2>&1
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new|
unregister(/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx)
= 1
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "unregister(/home/vm/vmware/vmw...")
2010-04-20 10:31:55|25440|7:7|new|vmware.pm:control_VM(1702)|vm
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
unregistered
2010-04-20 10:31:55|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost '/bin/rm -rf /home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1'
2>&1
2010-04-20 10:31:56|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| none
2010-04-20 10:31:56|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "none")
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:control_VM(1709)|removed
/home/vm/vmware/vmwarelinux-xubuntu904-v0vmguest-1 from localvmhost
2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_private_ip_address(1442)|attempting
to retrieve private IP address for computer: vmguest-1
2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_private_ip_address(1446)|retrieved
contents of /etc/hosts on this management node, contains 13 lines
2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_private_ip_address(1479)|found
line for 'vmguest-1' in /etc/hosts:
|25440|7:7|new| 192.168.1.1     vmguest-1
2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_private_ip_address(1490)|found
IP address: 192.168.1.1
2010-04-20 10:31:56|25440|7:7|new|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{7}{computer}{privateIPaddress}
|25440|7:7|new| computer_private_ip_address = 192.168.1.1
2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, startload, vmguest-1 vmwarelinux-xubuntu904-v0
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(216)|identity file set
/etc/vcl/vcl.key vmhost imagename noimage bladekey /etc/vcl/vcl.key
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(244)|persistent= 0
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(245)|myvmdir=
vmwarelinux-xubuntu904-v0vmguest-1
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(246)|myvmx=
/images/vmware/vmwarelinux-xubuntu904-v0vmguest-1/vmwarelinux-xubuntu904-v0vmguest-1.vmx
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(247)|mybasedirname=
vmwarelinux-xubuntu904-v0
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(248)|myimagename=
vmwarelinux-xubuntu904-v0
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(251)|checking for base
image vmwarelinux-xubuntu904-v0vmguest-1 on localvmhost
2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, vmround1, checking host for requested image files
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(256)|trying to create
exclusive lock on /tmp/localvmhostvmwarelinux-xubuntu904-v0lock while
checking if image files exist on host
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(259)|owning exclusive lock
on /tmp/localvmhostvmwarelinux-xubuntu904-v0lock
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(260)|listing datestore
/images/vmware
2010-04-20 10:31:56|25440|7:7|new|utils.pm:run_ssh_command(6180)|executing
SSH command on localvmhost:
|25440|7:7|new| /usr/bin/ssh -i /etc/vcl/vcl.key  -l root -p 22 -x
localvmhost 'ls -1 /images/vmware' 2>&1
2010-04-20 10:31:56|25440|7:7|new|utils.pm:run_ssh_command(6262)|run_ssh_command
output:
|25440|7:7|new| XUbuntu_LiveCD
|25440|7:7|new| vmwarelinux-xubuntu910-v0
2010-04-20 10:31:56|25440|7:7|new|utils.pm:run_ssh_command(6276)|SSH command
executed on localvmhost, returning (0, "XUbuntu_LiveCD vmwarelinux-xub...")
2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(270)|data store contents
/images/vmware on vm host:
|25440|7:7|new| XUbuntu_LiveCD vmwarelinux-xubuntu910-v0
2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, info, image files do not exist on host server, preparing to copy
2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, failed, could not collect size of local image files
2010-04-20 10:31:56|25440|7:7|new|utils.pm:mail(1348)|SUCCESS -- Sending
mail To: m...@vt.edu, PROBLEM -- vmware.pm

|25440|7:7|new| ---- CRITICAL ----
|25440|7:7|new| 2010-04-20 10:31:56|25440|7:7|new|vmware.pm:load(349)|problem
checking local vm file size on /images/vmware/vmwarelinux-xubuntu904-v0
|25440|7:7|new| ( 0) utils.pm, notify (line: 737)
|25440|7:7|new| (-1) vmware.pm, load (line: 349)
|25440|7:7|new| (-2) new.pm, reload_image (line: 665)
|25440|7:7|new| (-3) new.pm, process (line: 266)
|25440|7:7|new| (-4) vcld, make_new_child (line: 594)
|25440|7:7|new| (-5) vcld, main (line: 341)


|25440|7:7|new| ---- WARNING ----
|25440|7:7|new| 2010-04-20
10:31:56|25440|7:7|new|new.pm:reload_image(670)|vmwarelinux-xubuntu904-v0
failed to load on vmguest-1, returning
|25440|7:7|new| ( 0) utils.pm, notify (line: 737)
|25440|7:7|new| (-1) new.pm, reload_image (line: 670)
|25440|7:7|new| (-2) new.pm, process (line: 266)
|25440|7:7|new| (-3) vcld, make_new_child (line: 594)
|25440|7:7|new| (-4) vcld, main (line: 341)

2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, loadimagefailed, vmwarelinux-xubuntu904-v0 failed to load on
vmguest-1

|25440|7:7|new| ---- WARNING ----
|25440|7:7|new| 2010-04-20 10:31:56|25440|7:7|new|new.pm:process(313)|failed
to load vmguest-1 with vmwarelinux-xubuntu904-v0
|25440|7:7|new| ( 0) utils.pm, notify (line: 737)
|25440|7:7|new| (-1) new.pm, process (line: 313)
|25440|7:7|new| (-2) vcld, make_new_child (line: 594)
|25440|7:7|new| (-3) vcld, main (line: 341)

2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_state_name(1946)|attempting
to retrieve current state of computer vmguest-1 from the database
2010-04-20
10:31:56|25440|7:7|new|DataStructure.pm:get_computer_state_name(1977)|retrieved
current state of computer vmguest-1 from the database: reloading
2010-04-20 10:31:56|25440|7:7|new|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{7}{computer}{state}{name}
|25440|7:7|new| computer_state_name = reloading
2010-04-20 10:31:56|25440|7:7|new|utils.pm:mail(1348)|SUCCESS -- Sending
mail To: m...@vt.edu, PROBLEM -- State.pm

|25440|7:7|new| ---- CRITICAL ----
|25440|7:7|new| 2010-04-20
10:31:56|25440|7:7|new|State.pm:reservation_failed(290)|reservation failed
on vmguest-1: process failed after trying to load or make available
|25440|7:7|new| ( 0) utils.pm, notify (line: 737)
|25440|7:7|new| (-1) State.pm, reservation_failed (line: 290)
|25440|7:7|new| (-2) new.pm, process (line: 316)
|25440|7:7|new| (-3) vcld, make_new_child (line: 594)
|25440|7:7|new| (-4) vcld, main (line: 341)

2010-04-20 10:31:56|25440|7:7|new|utils.pm:insertloadlog(4710)|inserted
computer=2, failed, process failed after trying to load or make available
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(293)|inserted
computerloadlog entry
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(301)|updated
log ending value to 'failed', logid=6
2010-04-20 10:31:56|25440|7:7|new|utils.pm:update_computer_state(2228)|computer
2 state updated to: failed
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(312)|computer
vmguest-1 (2) state set to failed
2010-04-20 10:31:56|25440|7:7|new|utils.pm:update_request_state(2186)|request
7 state updated to: failed, laststate to: new
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(325)|set
request state to 'failed'/'new'
2010-04-20 10:31:56|25440|7:7|new|utils.pm:is_inblockrequest(6972)|zero rows
were returned from database select
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(343)|vmguest-1
is NOT in blockcomputers table
2010-04-20 10:31:56|25440|7:7|new|State.pm:reservation_failed(346)|exiting 1
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(905)|destructor called,
ref($self)=VCL::new
2010-04-20 
10:31:56|25440|7:7|new|utils.pm:delete_computerloadlog_reservation(7551)|removing
computerloadlog entries matching loadstate = begin
2010-04-20 
10:31:56|25440|7:7|new|utils.pm:delete_computerloadlog_reservation(7598)|deleted
rows from computerloadlog for reservation id=7
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(912)|removed
computerloadlog rows with loadstate=begin for reservation
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(924)|number of database
handles state process created: 1
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(933)|process has a
database handle stored in $ENV{dbh}, attempting disconnect
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(935)|$ENV{dbh}: database
disconnect successful
2010-04-20 10:31:56|25440|7:7|new|State.pm:DESTROY(949)|VCL::new process
25440 exiting
2010-04-20 10:31:56|25426|vcld:REAPER(744)|VCL process exited for
reservation 7
2010-04-20 10:31:56|25426|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-04-20 10:31:56
=== END vcld.log ===

=== BEGIN mysql tables ===
mysql>  select * from computer;
+----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+-------------+-------------+------------------+-------------------+-------------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
| id | stateid | ownerid | platformid | scheduleid | currentimageid |
preferredimageid | nextimageid | imagerevisionid | RAM  | procnumber |
procspeed | network | hostname    | IPaddress   | privateIPaddress |
eth0macaddress    | eth1macaddress    | type           | provisioningid |
drivetype | deleted | notes | lastcheck | location | dsa  | dsapub | rsa  |
rsapub | host | hostpub | vmhostid | vmtypeid |
+----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+-------------+-------------+------------------+-------------------+-------------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
|  1 |       2 |       1 |          1 |          1 |              4 |
          0 |           0 |               0 | 2048 |          1 |      3000 |
     100 | localvmhost | 192.168.0.1 | NULL             | NULL              |
NULL              | blade          |              3 | hda       |       0 |
       | NULL      | NULL     | NULL | NULL   | NULL | NULL   | NULL | NULL
  |     NULL |     NULL |
|  2 |       2 |       1 |          1 |          1 |              4 |
         10 |           0 |               0 |  512 |          1 |      2000 |
     100 | vmguest-1   | 192.168.1.1 | NULL             | 00:50:56:1a:01:01 |
00:50:56:1a:01:02 | virtualmachine |              2 | hda       |       0 |
       | NULL      | NULL     | NULL | NULL   | NULL | NULL   | NULL | NULL
  |        1 |        3 |
+----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+-------------+-------------+------------------+-------------------+-------------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
2 rows in set (0.00 sec)

mysql>  select * from OS;
+----+----------------+-------------------------------------+---------+-------------+---------------+----------+
| id | name           | prettyname                          | type    |
installtype | sourcepath    | moduleid |
+----+----------------+-------------------------------------+---------+-------------+---------------+----------+
|  2 | sun4x_58       | Solaris 5.8                         | unix    | none
        | NULL          |       15 |
|  3 | win2k          | Windows 2000                        | windows |
partimage   | image         |        4 |
|  6 | rhel3          | Red Hat Enterprise Linux 3.0        | linux   |
kickstart   | rhas3         |        5 |
|  7 | winxp          | Windows XP                          | windows |
partimage   | image         |       12 |
|  8 | realmrhel3     | Realm Red Hat Enterprise Linux 3.0  | linux   | none
        | NULL          |       15 |
|  9 | realmrhel4     | Realm Red Hat Enterprise Linux 4.0  | linux   | none
        | NULL          |       15 |
| 10 | win2003        | Windows 2003 Server                 | windows |
partimage   | image         |       13 |
| 11 | rh3image       | RHEL 3 image                        | linux   |
partimage   | image         |        5 |
| 12 | rhel4          | Red Hat Enterprise Linux 4          | linux   |
kickstart   | rhas4         |        5 |
| 13 | rh4image       | RHEL4 image                         | linux   |
partimage   | image         |        5 |
| 14 | fc5image       | RH Fedora Core 5 image              | linux   |
partimage   | image         |        5 |
| 15 | rhfc5          | Red Hat Fedora Core 5               | linux   |
kickstart   | rhfc5         |        5 |
| 16 | vmwarewinxp    | VMware Windows XP                   | windows |
vmware      | vmware_images |       12 |
| 17 | rhfc7          | RH Fedora Core 7 KS                 | linux   |
kickstart   | rhfc7         |        5 |
| 18 | fc7image       | RH Fedora Core 7 image              | linux   |
partimage   | image         |        5 |
| 19 | rhel5          | Red Hat Enterprise Linux 5          | linux   |
kickstart   | rhas5         |        5 |
| 20 | esx35          | VMware ESX 3.5                      | linux   |
kickstart   | esx35         |        5 |
| 21 | vmwareesxwinxp | VMware ESX Windows XP               | windows |
vmware      | vmware_images |       12 |
| 22 | realmrhel5     | Realm Red Hat Enterprise Linux 5.0  | linux   | none
        | NULL          |       15 |
| 23 | sun4x_510     | Solaris 10                          | unix    | none
        | NULL          |       15 |
| 24 | centos5        | CentOS 5                            | linux   |
kickstart   | centos5       |        5 |
| 25 | rh5image       | RedHat Enterprise Linux 5 (rhel5 im | linux   |
partimage   | image         |        5 |
| 26 | rhfc9          | RedHat Fedora Core 9 kickstart      | linux   |
kickstart   | rhfc9         |        5 |
| 27 | fc9image       | RedHat Fedora Core 9 image          | linux   |
partimage   | image         |        5 |
| 28 | winvista       | Windows Vista                       | windows |
partimage   | image         |        7 |
| 29 | centos5image   | centos5image                        | linux   |
partimage   | image         |        5 |
| 30 | ubuntuimage    | Ubuntu image                        | linux   |
partimage   | image         |       14 |
| 31 | vmwarewin2008  | VMware Windows Server 2008          | windows |
vmware      | vmware_images |       16 |
| 32 | win2008        | Windows Server 2008                 | windows |
partimage   | image         |       16 |
| 33 | vmwarewinvista | VMware Windows Vista                | windows |
vmware      | vmware_images |        7 |
| 34 | vmwarelinux    | VMware Generic Linux                | linux   |
vmware      | vmware        |        5 |
+----+----------------+-------------------------------------+---------+-------------+---------------+----------+
31 rows in set (0.00 sec)

mysql>  select * from image;
+----+------------------------------------+----------------------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
| id | name                               | prettyname
       | ownerid | platformid | OSid | imagemetaid | minram | minprocnumber |
minprocspeed | minnetwork | maxconcurrent | reloadtime | deleted | test |
lastupdate          | forcheckout | maxinitialtime | project | size |
architecture | description | usage | basedoffrevisionid |
+----+------------------------------------+----------------------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
|  1 | winxp-base1-v0                     | No Apps (WinXP)
        |       1 |          1 |    7 |        NULL |      0 |             1
|            0 |         10 |          NULL |         14 |       0 |    0 |
2007-04-11 16:07:38 |           1 |              0 | vcl     | 1045 | x86
        | NULL        | NULL  |                  0 |
|  2 | rhel4-base2-v0                     | Red Hat Enterprise Linux 4.4
Base (KS) |       1 |          1 |   12 |        NULL |   1024 |
1 |         1024 |        100 |          NULL |         13 |       0 |    0
| 2007-03-02 16:33:33 |           1 |              0 | vcl     |    0 | x86
          | NULL        | NULL  |                  0 |
|  3 | rh4image-base3-v0                  | RHEL4 base (image)
       |       1 |          1 |   13 |        NULL |     10 |             1 |
         1024 |        100 |          NULL |         10 |       0 |    0 |
2007-01-24 15:02:07 |           1 |              0 | vcl     | 1450 | x86
        | NULL        | NULL  |                  0 |
|  4 | noimage                            | No Image
       |       1 |          1 |    2 |        NULL |      0 |             1 |
            0 |         10 |          NULL |          0 |       0 |    0 |
NULL                |           1 |              0 | vcl     | 1450 | x86
        | NULL        | NULL  |                  0 |
|  5 | rhfc5-fc5base5-v0                  | Red Hat Fedora Core 5 base (KS)
        |       1 |          1 |   15 |        NULL |   1024 |             1
|         1024 |        100 |          NULL |         13 |       0 |    0 |
2006-10-02 10:04:24 |           1 |              0 | vcl     | 1450 | x86
        | NULL        | NULL  |                  0 |
|  6 | fc5image-FC5baseRHFC56-v0          | FC5base(RHFC5)
       |       1 |          1 |   14 |        NULL |     64 |             1 |
          500 |         10 |          NULL |         10 |       0 |    0 |
2006-10-02 14:13:26 |           1 |              0 | vcl     |    0 | x86
        | NULL        | NULL  |                  0 |
|  7 | vmwarewinxp-base7-v1               | No Apps (WinXP vmware)
       |       1 |          1 |   16 |        NULL |    512 |             1 |
         1024 |        100 |          NULL |          5 |       0 |    0 |
2007-04-04 09:45:38 |           1 |              0 | vcl     | 3244 | x86
        | NULL        | NULL  |                  0 |
|  8 | rh4image-VMwareserverhostRHEL48-v3 | VMware server host (RHEL4)
       |       1 |          1 |   13 |        NULL |     64 |             1 |
          500 |         10 |          NULL |         10 |       0 |    0 |
2007-11-26 11:23:53 |           1 |              0 | vcl     | 1450 | x86
        | NULL        | NULL  |                  0 |
|  9 | esx35-base-v0                      | VMware ESX 3.5 standard server
       |       1 |          1 |   20 |        NULL |   2048 |             2 |
         2000 |        100 |          NULL |          9 |       0 |    0 |
2008-03-24 14:23:54 |           1 |              0 | vcl     | 1450 | x86
        | NULL        | NULL  |                  0 |
| 10 | vmwarelinux-xubuntu904-v0          | No Apps (Linux, XUbuntu 9.04)
        |       1 |          1 |   34 |        NULL |    512 |             1
|         1024 |        100 |          NULL |          5 |       0 |    0 |
2010-04-19 12:00:28 |           1 |              0 | vcl     | 1500 | x86
        | NULL        | NULL  |                  0 |
+----+------------------------------------+----------------------------------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
10 rows in set (0.00 sec)

mysql>  select * from imagerevision;
+----+---------+----------+--------+---------------------+---------+-------------+------------+----------+------------------------------------+
| id | imageid | revision | userid | datecreated         | deleted |
datedeleted | production | comments | imagename                          |
+----+---------+----------+--------+---------------------+---------+-------------+------------+----------+------------------------------------+
|  1 |       1 |        0 |      1 | 2007-03-01 14:46:26 |       0 | NULL
      |          1 | NULL     | winxp-base1-v0                     |
|  2 |       2 |        0 |      1 | 2006-09-22 16:33:24 |       0 | NULL
      |          1 | NULL     | rhel4-base2-v0                     |
|  3 |       3 |        0 |      1 | 2007-01-24 15:04:11 |       0 | NULL
      |          1 | NULL     | rh4image-base3-v0                  |
|  4 |       4 |        0 |      1 | 1980-01-01 00:00:00 |       0 | NULL
      |          1 | NULL     | noimage                            |
|  5 |       5 |        0 |      1 | 2006-10-02 10:04:24 |       0 | NULL
      |          1 | NULL     | rhfc5-fc5base5-v0                  |
|  6 |       6 |        0 |      1 | 2006-10-02 14:13:26 |       0 | NULL
      |          1 | NULL     | fc5image-FC5baseRHFC56-v0          |
|  7 |       7 |        0 |      1 | 2007-04-03 11:24:12 |       0 | NULL
      |          1 | NULL     | vmwarewinxp-base7-v0               |
|  8 |       8 |        0 |      1 | 2007-01-30 10:50:56 |       0 | NULL
      |          1 | NULL     | rh4image-VMwareserverhostRHEL48-v0 |
|  9 |       9 |        0 |      1 | 2008-03-24 14:23:54 |       0 | NULL
      |          1 | NULL     | esx35-base-v0                      |
| 10 |      10 |        1 |      1 | 2010-04-19 12:00:33 |       0 | NULL
      |          1 | NULL     | vmwarelinux-xubuntu904-v0          |
+----+---------+----------+--------+---------------------+---------+-------------+------------+----------+------------------------------------+
10 rows in set (0.00 sec)

mysql>  select * from resource;
+----+----------------+-------+
| id | resourcetypeid | subid |
+----+----------------+-------+
| 12 |             12 |     1 |
| 13 |             12 |     2 |
|  1 |             13 |     1 |
|  2 |             13 |     2 |
|  3 |             13 |     3 |
|  4 |             13 |     4 |
|  5 |             13 |     5 |
|  6 |             13 |     6 |
|  7 |             13 |     7 |
|  9 |             13 |     8 |
| 10 |             13 |     9 |
| 14 |             13 |    10 |
|  8 |             15 |     1 |
| 11 |             16 |     1 |
+----+----------------+-------+
14 rows in set (0.00 sec)

mysql>  select * from request;
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
| id | stateid | userid | laststateid | logid | forimaging | test | preload
| start               | end                 | daterequested       |
datemodified |
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
|  1 |      14 |      2 |          21 |     0 |          0 |    0 |       0
| 2010-04-16 21:15:00 | 2011-04-16 21:15:00 | 2010-04-16 21:16:29 | NULL
     |
|  2 |      14 |      1 |          16 |     0 |          1 |    0 |       0
| 2010-04-19 12:07:03 | 2010-04-19 14:07:03 | 2010-04-19 12:07:03 | NULL
     |
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
2 rows in set (0.00 sec)

mysql>  select * from reservation;
+----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
| id | requestid | computerid | imageid | imagerevisionid | managementnodeid
| remoteIP | lastcheck           | pw   |
+----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
|  1 |         1 |          1 |       8 |               8 |                1
| NULL     | 0000-00-00 00:00:00 | NULL |
|  2 |         2 |          2 |      10 |              10 |                1
| NULL     | NULL                | NULL |
+----+-----------+------------+---------+-----------------+------------------+----------+---------------------+------+
2 rows in set (0.00 sec)

mysql>  select * from vmprofile;
+----+-------------------------------------------+----------+---------+----------+------------------------+------------------------+----------------+--------------------------------+-------------+----------+----------+
| id | profilename                               | vmtypeid | imageid |
nasshare | datastorepath          | vmpath                 | virtualswitch0
| virtualswitch1                 | vmdisk      | username | password |
+----+-------------------------------------------+----------+---------+----------+------------------------+------------------------+----------------+--------------------------------+-------------+----------+----------+
|  1 | VMware GSX standard                       |        3 |       8 | NULL
     | /images/vmware         | /images/vmware         | VMnet1         |
VMnet0                         | localdisk   | NULL     | NULL     |
|  2 | Vmware ESX standard network mounted share |        5 |       9 | NULL
     | /vmfs/volumes/nfs1     | /vmfs/volumes/storage1 | VM Network     |
Virtual Machine Public Network | networkdisk | NULL     | NULL     |
|  3 | Vmware ESX standard localdisk             |        5 |       9 | NULL
     | /vmfs/volumes/storage1 | NULL                   | VM Network     |
Virtual Machine Public Network | localdisk   | NULL     | NULL     |
|  4 | Vmware ESX SAN                            |        5 |       9 | NULL
     | /vmfs/volumes/NetApp   | /vmfs/volumes/storage1 | Intranet2      |
MCNC Public                    | networkdisk | NULL     | NULL     |
+----+-------------------------------------------+----------+---------+----------+------------------------+------------------------+----------------+--------------------------------+-------------+----------+----------+
4 rows in set (0.00 sec)

mysql>  select * from resourcegroup;
+----+--------------------+------------------+----------------+
| id | name               | ownerusergroupid | resourcetypeid |
+----+--------------------+------------------+----------------+
|  1 | allComputers       |                3 |             12 |
|  2 | allImages          |                3 |             13 |
|  3 | allManagementNodes |                3 |             16 |
|  4 | allSchedules       |                3 |             15 |
|  8 | newimages          |                4 |             12 |
|  9 | newvmimages        |                4 |             12 |
| 10 | allVMimages        |                4 |             13 |
| 13 | allvmhosts         |                3 |             12 |
| 14 | allvmguests        |                3 |             12 |
+----+--------------------+------------------+----------------+
9 rows in set (0.00 sec)

mysql>  select * from resourcemap;
+------------------+-----------------+------------------+-----------------+
| resourcegroupid1 | resourcetypeid1 | resourcegroupid2 | resourcetypeid2 |
+------------------+-----------------+------------------+-----------------+
|                2 |              13 |                1 |              12 |
|                3 |              16 |                1 |              12 |
|                3 |              16 |                8 |              12 |
|                3 |              16 |                9 |              12 |
|                3 |              16 |               13 |              12 |
|                3 |              16 |               14 |              12 |
|               10 |              13 |               14 |              12 |
+------------------+-----------------+------------------+-----------------+
7 rows in set (0.00 sec)
=== END mysql tables ===

Mark


--

Aaron Peeler
Program Manager
Virtual Computing Lab
NC State University
aaron_pee...@ncsu.edu
919-513-4571

Reply via email to