Versions Compared

Old Version 14

changes.mady.by.user Frank Peeler

Saved on

compared with

New Version 15

changes.mady.by.user Frank Peeler

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
 INSERT INTO `vcl`.`imagerevision` (
`id` ,
`imageid` ,
`revision` ,
`userid` ,
`datecreated` ,
`deleted` ,
`datedeleted` ,
`production` ,
`comments` ,
`imagename`
)
VALUES (
NULL '9', '8', '1', '1', NOW(), '0', NULL , '1', NULL , 'vmwarelinux-base8-v1'
)

...

Code Block
 INSERT INTO `vcl`.`resource` (
`id` ,
`resourcetypeid` ,
`subid`
)
VALUES (
NULL , '13', '8'
)

Insert an Imaging Reservation into the VCL Database

An imaging request needs to be manually inserted into the VCL database to begin the automated imaging process.  The imaging process performs several steps to prepare the VCL image to be captured and then initiates the capture.

You will need to know the management node ID and computer ID of the VM guest you are using.  The following SQL statements assume the following: 

  • Computer ID: 2 
  • Management node ID: 1
  • Image ID: 8
  • Image Revision ID: 7
Code Block

INSERT INTO `vcl`.`request` (
`id` ,
`stateid` ,
`userid` ,
`laststateid` ,
`logid` ,
`forimaging` ,
`test` ,
`preload` ,
`start` ,
`end` ,
`daterequested` ,
`datemodified`
)
VALUES (
'1' , '16', '1', '16', '', '1', '0', '0', NOW( ) , TIMESTAMPADD(MINUTE, 120, NOW()), NOW( ) , NULL
);
Code Block

 INSERT INTO `vcl`.`reservation` (
`id` ,
`requestid` ,
`computerid` ,
`imageid` ,
`imagerevisionid` ,
`managementnodeid` ,
`remoteIP` ,
`lastcheck` ,
`pw`
)
VALUES (
NULL , '1', '2', '8', '8', '1', NULL , NULL , NULL
);

 Start vcld:

Panel

service vcld start

Monitor the vcld.log file:

Panel

tail -f /var/log/vcld.log