OK. That makes sense. I had a symlink between /home/vm/vmware and
/images/vmware. I have removed it.

My original vm image is in /home/vm/vmware and the cloned image should be in
/images/vmware. Do I set datastorepath to /home/vm/vmware and vmpath to
/images/vmware?

Mark

On Mon, Apr 26, 2010 at 12:21 PM, Aaron Peeler <aaron_pee...@ncsu.edu>wrote:

> 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
>
>


-- 
Mark Gardner
--

Reply via email to