Looks like I got that backwards. datastorepath should be /images/vmware and vmpath should be /home/vm/vmware. At least the master image is being copied...
Mark On Wed, Apr 28, 2010 at 9:38 AM, Mark Gardner <lil.lis...@gmail.com> wrote: > 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 > -- > -- Mark Gardner --
