Hi Andy,
I followed through every step in esx.README and still not successful in
capturing an image:
I can SSH to the hypervisor and the VMhost through the management node with
the/etc/vcl/vcl.key etc etc ..everything else looks okay; below I also have the
query's that I used to create this image and reservation.
Please advise.....
2010-03-22 13:55:11|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:11
2010-03-22
13:55:11|14001|2:3|image|utils.pm:reservation_being_processed(9634)|computerloadlog
'begin' entry does NOT exist for reservation 3
2010-03-22
13:55:11|14001|2:3|image|utils.pm:reservation_being_processed(9686)|reservation
is NOT currently being processed
2010-03-22 13:55:11|14001|2:3|image|vcld:main(276)|reservation 3 is NOT already
being processed
|14001|2:3|image| ---- WARNING ----
|14001|2:3|image| 2010-03-22
13:55:11|14001|2:3|image|utils.pm:get_request_info(5218)|preferredimageid is
not set for computer id=3
|14001|2:3|image| ( 0) utils.pm, notify (line: 737)
|14001|2:3|image| (-1) utils.pm, get_request_info (line: 5218)
|14001|2:3|image| (-2) vcld, main (line: 280)
2010-03-22 13:55:11|14001|2:3|image|utils.pm:get_request_info(5354)|standalone
affiliation found: Local
2010-03-22
13:55:11|14001|2:3|image|utils.pm:get_management_node_info(6815)|management
node info retrieved from database for colbert
2010-03-22 13:55:11|14001|2:3|image|vcld:main(281)|retrieved request
information from database
2010-03-22
13:55:11|14001|2:3|image|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 3
2010-03-22 13:55:11|14001|2:3|image|utils.pm:update_request_state(2186)|request
2 state updated to: pending, laststate to: image
2010-03-22 13:55:11|14001|2:3|image|utils.pm:insertloadlog(4710)|inserted
computer=3, begin, beginning to process, state is image
2010-03-22 13:55:11|14001|2:3|image|vcld:make_new_child(509)|loaded VCL::image
module
2010-03-22 13:55:11|14061|2:3|image|vcld:make_new_child(582)|vcld environment
variable set to 0 for this process
2010-03-22 13:55:11|14061|2:3|image|Module.pm:new(132)|constructor called,
class=VCL::image
2010-03-22 13:55:11|14061|2:3|image|Module.pm:new(154)|VCL::image object created
2010-03-22 13:55:11|14001|2:3|image|vcld:make_new_child(566)|current number of
forked kids: 1
2010-03-22 13:55:11|14061|2:3|image|State.pm:initialize(85)|obtained a database
handle for this state process, stored as $ENV{dbh}
2010-03-22 13:55:11|14061|2:3|image|State.pm:check_image_os(839)|no corrections
need to be made to image OS: esx35
2010-03-22
13:55:11|14061|2:3|image|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 3
2010-03-22
13:55:11|14061|2:3|image|utils.pm:rename_vcld_process(7863)|reservation count: 1
2010-03-22
13:55:11|14061|2:3|image|utils.pm:rename_vcld_process(7882)|PARENTIMAGE: 1
2010-03-22
13:55:11|14061|2:3|image|utils.pm:rename_vcld_process(7883)|SUBIMAGE: 0
2010-03-22 13:55:11|14061|2:3|image|utils.pm:rename_vcld_process(7901)|renamed
process to 'vcld VCL::image 2:3 image imaging'
2010-03-22
13:55:11|14061|2:3|image|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 3
2010-03-22
13:55:11|14061|2:3|image|DataStructure.pm:is_parent_reservation(854)|returning
true: parent reservation ID for this request: 3
2010-03-22 13:55:11|14061|2:3|image|State.pm:initialize(121)|attempting to load
provisioning module: VCL::Module::Provisioning::esx
2010-03-22 13:55:11|14061|2:3|image|esx.pm:initialize(138)|esx vmware toolkit
root path found: /usr/lib/vmware-vcli/apps
2010-03-22 13:55:11|14061|2:3|image|esx.pm:initialize(140)|vmware ESX module
initialized
2010-03-22
13:55:11|14061|2:3|image|State.pm:initialize(127)|VCL::Module::Provisioning::esx
module loaded
2010-03-22 13:55:11|14061|2:3|image|Module.pm:new(132)|constructor called,
class=VCL::Module::Provisioning::esx
2010-03-22
13:55:11|14061|2:3|image|Module.pm:new(154)|VCL::Module::Provisioning::esx
object created
2010-03-22 13:55:11|14061|2:3|image|esx.pm:initialize(138)|esx vmware toolkit
root path found: /usr/lib/vmware-vcli/apps
2010-03-22 13:55:11|14061|2:3|image|esx.pm:initialize(140)|vmware ESX module
initialized
2010-03-22
13:55:11|14061|2:3|image|State.pm:initialize(131)|VCL::Module::Provisioning::esx
provisioner object created
2010-03-22 13:55:11|14061|2:3|image|State.pm:initialize(145)|attempting to load
OS module: VCL::Module::OS::Linux
2010-03-22
13:55:11|14061|2:3|image|State.pm:initialize(151)|VCL::Module::OS::Linux module
loaded
2010-03-22 13:55:11|14061|2:3|image|Module.pm:new(132)|constructor called,
class=VCL::Module::OS::Linux
2010-03-22 13:55:11|14061|2:3|image|Module.pm:new(154)|VCL::Module::OS::Linux
object created
2010-03-22
13:55:11|14061|2:3|image|State.pm:initialize(154)|VCL::Module::OS::Linux OS
object created
2010-03-22 13:55:11|14061|2:3|image|State.pm:initialize(169)|returning 1
2010-03-22 13:55:11|14061|2:3|image|vcld:make_new_child(591)|VCL::image object
created and initialized
No recipient addresses found in header
2010-03-22 13:55:11|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: , VCL IMAGE Creation Started: esx3-basewinxp-v0
2010-03-22 13:55:11|14061|2:3|image|utils.pm:run_ssh_command(6180)|executing
SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//golden 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:12|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 1/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//golden 2>&1, exit status: 255, SSH exits with
the exit status of the remote command or with 255 if an error occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): esx3-basewinxp-v0
#>>> Here it sees the image But I don't understand why it fails to create it.
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, does_image_exist (line: 910)
|14061|2:3|image| (-3) image.pm, process (line: 135)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
2010-03-22 13:55:12|14061|2:3|image|utils.pm:run_ssh_command(6172)|sleeping for
2 seconds before making next SSH attempt
2010-03-22 13:55:14|14061|2:3|image|utils.pm:run_ssh_command(6184)|attempt 2/3:
executing SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//golden 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:14|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 2/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//golden 2>&1, exit status: 255, SSH exits with
the exit status of the remote command or with 255 if an error occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): esx3-basewinxp-v0
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, does_image_exist (line: 910)
|14061|2:3|image| (-3) image.pm, process (line: 135)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
2010-03-22 13:55:14|14061|2:3|image|utils.pm:run_ssh_command(6172)|sleeping for
15 seconds before making next SSH attempt
2010-03-22 13:55:16|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:16
2010-03-22 13:55:21|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:21
2010-03-22 13:55:26|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:26
2010-03-22 13:55:29|14061|2:3|image|utils.pm:run_ssh_command(6184)|attempt 3/3:
executing SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//golden 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:29|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 3/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//golden 2>&1, exit status: 255, SSH exits with
the exit status of the remote command or with 255 if an error occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): esx3-basewinxp-v0
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, does_image_exist (line: 910)
|14061|2:3|image| (-3) image.pm, process (line: 135)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:29|14061|2:3|image|utils.pm:run_ssh_command(6285)|failed to run SSH
command after 3 attempts, command: /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p
22 -x 128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//golden 2>&1' 2>&1,
exit status: 255, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): esx3-basewinxp-v0
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6285)
|14061|2:3|image| (-2) esx.pm, does_image_exist (line: 910)
|14061|2:3|image| (-3) image.pm, process (line: 135)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
No recipient addresses found in header
2010-03-22 13:55:29|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: , PROBLEM -- esx.pm
|14061|2:3|image| ---- CRITICAL ----
|14061|2:3|image| 2010-03-22
13:55:29|14061|2:3|image|esx.pm:does_image_exist(922)|LS failed
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) esx.pm, does_image_exist (line: 922)
|14061|2:3|image| (-2) image.pm, process (line: 135)
|14061|2:3|image| (-3) vcld, make_new_child (line: 594)
|14061|2:3|image| (-4) vcld, main (line: 341)
2010-03-22 13:55:29|14061|2:3|image|image.pm:process(145)|image
esx3-basewinxp-v0 does not exist in the repository
2010-03-22 13:55:29|14061|2:3|image|DataStructure.pm:_automethod(697)|data
structure updated: $self->request_data->{reservation}{3}{image}{lastupdate}
|14061|2:3|image| image_lastupdate = 2010-03-22 13:55:29
2010-03-22 13:55:29|14061|2:3|image|DataStructure.pm:_automethod(697)|data
structure updated:
$self->request_data->{reservation}{3}{imagerevision}{datecreated}
|14061|2:3|image| imagerevision_date_created = 2010-03-22 13:55:29
2010-03-22 13:55:29|14061|2:3|image|image.pm:process(161)|calling provisioning
module's capture() subroutine
2010-03-22
13:55:29|14061|2:3|image|esx.pm:capture(593)|**********************************************************
2010-03-22 13:55:29|14061|2:3|image|esx.pm:capture(594)|Entering ESX Capture
routine
2010-03-22 13:55:29|14061|2:3|image|utils.pm:run_ssh_command(6180)|executing
SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:30|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 1/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1, exit status: 255, SSH
exits with the exit status of the remote command or with 255 if an error
occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): ls:
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000: No such file or directory
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, capture (line: 632)
|14061|2:3|image| (-3) image.pm, process (line: 162)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
2010-03-22 13:55:30|14061|2:3|image|utils.pm:run_ssh_command(6172)|sleeping for
2 seconds before making next SSH attempt
2010-03-22 13:55:31|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:31
2010-03-22 13:55:32|14061|2:3|image|utils.pm:run_ssh_command(6184)|attempt 2/3:
executing SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:32|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 2/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1, exit status: 255, SSH
exits with the exit status of the remote command or with 255 if an error
occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): ls:
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000: No such file or directory
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, capture (line: 632)
|14061|2:3|image| (-3) image.pm, process (line: 162)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
2010-03-22 13:55:32|14061|2:3|image|utils.pm:run_ssh_command(6172)|sleeping for
15 seconds before making next SSH attempt
2010-03-22 13:55:36|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:36
2010-03-22 13:55:41|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:41
2010-03-22 13:55:46|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:46
2010-03-22 13:55:47|14061|2:3|image|utils.pm:run_ssh_command(6184)|attempt 3/3:
executing SSH command on 128.82.128.252:
|14061|2:3|image| /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p 22 -x
128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1' 2>&1
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:47|14061|2:3|image|utils.pm:run_ssh_command(6252)|attempt 3/3: failed to
execute SSH command on 128.82.128.252: ls -1
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000 2>&1, exit status: 255, SSH
exits with the exit status of the remote command or with 255 if an error
occurred, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): ls:
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000: No such file or directory
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6252)
|14061|2:3|image| (-2) esx.pm, capture (line: 632)
|14061|2:3|image| (-3) image.pm, process (line: 162)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:47|14061|2:3|image|utils.pm:run_ssh_command(6285)|failed to run SSH
command after 3 attempts, command: /usr/bin/ssh -i /etc/vcl/vcl.key -l root -p
22 -x 128.82.128.252 'ls -1 /vmfs/volumes/15a5e041-86bf33de//inuse/resxi000
2>&1' 2>&1, exit status: 255, output:
|14061|2:3|image| ssh output (ls -1 /vmf...): ls:
/vmfs/volumes/15a5e041-86bf33de//inuse/resxi000: No such file or directory
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) utils.pm, run_ssh_command (line: 6285)
|14061|2:3|image| (-2) esx.pm, capture (line: 632)
|14061|2:3|image| (-3) image.pm, process (line: 162)
|14061|2:3|image| (-4) vcld, make_new_child (line: 594)
|14061|2:3|image| (-5) vcld, main (line: 341)
No recipient addresses found in header
2010-03-22 13:55:47|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: , PROBLEM -- esx.pm
|14061|2:3|image| ---- CRITICAL ----
|14061|2:3|image| 2010-03-22 13:55:47|14061|2:3|image|esx.pm:capture(643)|LS
failed
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) esx.pm, capture (line: 643)
|14061|2:3|image| (-2) image.pm, process (line: 162)
|14061|2:3|image| (-3) vcld, make_new_child (line: 594)
|14061|2:3|image| (-4) vcld, main (line: 341)
|14061|2:3|image| ---- WARNING ----
|14061|2:3|image| 2010-03-22
13:55:47|14061|2:3|image|image.pm:process(166)|esx3-basewinxp-v0 image failed
to be captured by provisioning module
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) image.pm, process (line: 166)
|14061|2:3|image| (-2) vcld, make_new_child (line: 594)
|14061|2:3|image| (-3) vcld, main (line: 341)
No recipient addresses found in header
2010-03-22 13:55:48|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: , PROBLEM -- image.pm
|14061|2:3|image| ---- CRITICAL ----
|14061|2:3|image| 2010-03-22
13:55:47|14061|2:3|image|image.pm:reservation_failed(390)|esx3-basewinxp-v0
image creation failed
|14061|2:3|image| ( 0) utils.pm, notify (line: 737)
|14061|2:3|image| (-1) image.pm, reservation_failed (line: 390)
|14061|2:3|image| (-2) image.pm, process (line: 167)
|14061|2:3|image| (-3) vcld, make_new_child (line: 594)
|14061|2:3|image| (-4) vcld, main (line: 341)
2010-03-22 13:55:48|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: r...@localhost, VCL -- NOTICE DELAY Image Creation No Apps (ESXi WinXP)
No recipient addresses found in header
2010-03-22 13:55:48|14061|2:3|image|utils.pm:mail(1348)|SUCCESS -- Sending mail
To: , VCL -- NOTICE FAILED Image Creation No Apps (ESXi WinXP)
2010-03-22 13:55:48|14061|2:3|image|utils.pm:update_request_state(2186)|request
2 state updated to: maintenance, laststate to: image
2010-03-22 13:55:48|14061|2:3|image|image.pm:reservation_failed(442)|request
state set to maintenance, laststate to image
2010-03-22
13:55:48|14061|2:3|image|utils.pm:update_computer_state(2228)|computer 3 state
updated to: maintenance
2010-03-22 13:55:48|14061|2:3|image|image.pm:reservation_failed(450)|resxi000
state set to maintenance
2010-03-22 13:55:48|14061|2:3|image|image.pm:reservation_failed(457)|exiting
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(905)|destructor called,
ref($self)=VCL::image
2010-03-22
13:55:48|14061|2:3|image|utils.pm:delete_computerloadlog_reservation(7551)|removing
computerloadlog entries matching loadstate = begin
2010-03-22
13:55:48|14061|2:3|image|utils.pm:delete_computerloadlog_reservation(7598)|deleted
rows from computerloadlog for reservation id=3
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(912)|removed
computerloadlog rows with loadstate=begin for reservation
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(924)|number of database
handles state process created: 1
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(933)|process has a
database handle stored in $ENV{dbh}, attempting disconnect
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(935)|$ENV{dbh}: database
disconnect successful
2010-03-22 13:55:48|14061|2:3|image|State.pm:DESTROY(949)|VCL::image process
14061 exiting
2010-03-22 13:55:48|14001|vcld:REAPER(744)|VCL process exited for reservation 3
2010-03-22 13:55:48|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:48
2010-03-22 13:55:53|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:53
2010-03-22 13:55:58|14001|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-03-22 13:55:58
==========================****************************************================================================
Here is how I inserted these images and created reservation: I have made sure I
have chosen appropriate computer id and image id.
INSERT INTO `vcl`.`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`
)
VALUES (
'10' , 'esx3-basewinxp-v0', 'No Apps (ESXi WinXP)', '1', '1', '20', NULL,
'512', '1', '1024', '100', NULL , '9', '0', '0', NOW(), '1', '0', 'vcl', '1450',
'x86', NULL , NULL , '0'
);
INSERT INTO `vcl`.`imagerevision` (
`id` ,
`imageid` ,
`revision` ,
`userid` ,
`datecreated` ,
`deleted` ,
`datedeleted` ,
`production` ,
`comments` ,
`imagename`
)
VALUES (
NULL , '10', '0', '1', NOW(), '0', NULL , '1', NULL , 'esx3-basewinxp-v0'
);
INSERT INTO `vcl`.`resource` (
`id` ,
`resourcetypeid` ,
`subid`
)
VALUES (
NULL , '13', '10'
)
INSERT INTO `vcl`.`request` (
`id` ,
`stateid` ,
`userid` ,
`laststateid` ,
`logid` ,
`forimaging` ,
`test` ,
`preload` ,
`start` ,
`end` ,
`daterequested` ,
`datemodified`
)
VALUES (
'2' , '16', '1', '16', '', '1', '0', '0', NOW( ) , TIMESTAMPADD(MINUTE, 120,
NOW()), NOW( ) , NULL
);
INSERT INTO `vcl`.`reservation` (
`id` ,
`requestid` ,
`computerid` ,
`imageid` ,
`imagerevisionid` ,
`managementnodeid` ,
`remoteIP` ,
`lastcheck` ,
`pw`
)
VALUES (
NULL , '2', '3', '10', '11', '1', NULL , NULL , NULL
);
Please advise!!!
Thank you,
Amit
