Hi Ryan, List,

I've changed it to 5, as you suggested. Thanks. The change seems to help.
(I thought that it had to be 10, since I was using esxi 3.5).

I've installed webnode, managementnode, vmware server (computer id=1),
esxi3.5 (computer id=2)
I'm trying to make a linux base image esx3-vmlinux-v1 for the VCL.

I think I'm making a small step of progress now.

I delete everything from request and reservation, and re-insert the
request and reservation.
I'm not sure what other fields I'm getting it wrong.

I'm now getting:

2010-05-22 13:35:52|18387|6:5|image|State.pm:initialize(169)|returning 1
2010-05-22 13:35:52|18387|6:5|image|vcld:make_new_child(591)|VCL::image
object created and initialized
No recipient addresses found in header
2010-05-22 13:35:52|18387|6:5|image|utils.pm:mail(1348)|SUCCESS --
Sending mail To: , VCL IMAGE Creation Started: esx3-vmlinux-v1

|18387|6:5|image| ---- WARNING ----
|18387|6:5|image| 2010-05-22
13:35:52|18387|6:5|image|DataStructure.pm:_automethod(675)|corresponding
data has not been initialized for get_vmhost_profile_datastore_path:
$self->request_data->{reservation}{5}{computer}{vmhost}
{vmprofile}{datastorepath}
|18387|6:5|image| ( 0) utils.pm, notify (line: 737)
|18387|6:5|image| (-1) DataStructure.pm, _automethod (line: 675)
|18387|6:5|image| (-2) Autoload.pm, __ANON__ (line: 80)
|18387|6:5|image| (-3) esx.pm, does_image_exist (line: 900)
|18387|6:5|image| (-4) image.pm, process (line: 135)
|18387|6:5|image| (-5) vcld, make_new_child (line: 594)
|18387|6:5|image| (-6) vcld, main (line: 341)

Use of uninitialized value in split at
        /usr/local/vcl/bin/../lib/VCL/Module/Provisioning/esx.pm line 900 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl tells you what operation
    you used the undefined value in.  Note, however, that perl optimizes your
    program and the operation displayed in the warning may not necessarily
    appear literally in your program.  For example, "that $foo" is
    usually optimized into "that " . $foo, and the warning will refer to
    the concatenation (.) operator, even though there is no . in your
    program.


|18387|6:5|image| ---- WARNING ----
|18387|6:5|image| 2010-05-22
13:35:52|18387|6:5|image|vcld:warning_handler(636)|Use of
uninitialized value in split at
/usr/local/vcl/bin/../lib/VCL/Module/Provisioning/esx.pm line 900.
|18387|6:5|image| ( 0) utils.pm, notify (line: 737)
|18387|6:5|image| (-1) vcld, warning_handler (line: 636)
|18387|6:5|image| (-2) esx.pm, does_image_exist (line: 900)
|18387|6:5|image| (-3) image.pm, process (line: 135)
|18387|6:5|image| (-4) vcld, make_new_child (line: 594)
|18387|6:5|image| (-5) vcld, main (line: 341)


|18387|6:5|image| ---- WARNING ----
|18387|6:5|image| 2010-05-22
13:35:52|18387|6:5|image|vcld:warning_handler(636)|Use of
uninitialized value in concatenation (.) or string at
/usr/local/vcl/bin/../lib/VCL/Module/Provisioning/esx.pm line 907.
|18387|6:5|image| ( 0) utils.pm, notify (line: 737)
|18387|6:5|image| (-1) vcld, warning_handler (line: 636)
|18387|6:5|image| (-2) esx.pm, does_image_exist (line: 907)
|18387|6:5|image| (-3) image.pm, process (line: 135)
|18387|6:5|image| (-4) vcld, make_new_child (line: 594)
|18387|6:5|image| (-5) vcld, main (line: 341)


|18387|6:5|image| ---- WARNING ----
|18387|6:5|image| 2010-05-22
13:35:52|18387|6:5|image|utils.pm:run_ssh_command(6092)|computer node
was not specified
|18387|6:5|image| ( 0) utils.pm, notify (line: 737)
|18387|6:5|image| (-1) utils.pm, run_ssh_command (line: 6092)
|18387|6:5|image| (-2) esx.pm, does_image_exist (line: 910)
|18387|6:5|image| (-3) image.pm, process (line: 135)
|18387|6:5|image| (-4) vcld, make_new_child (line: 594)
|18387|6:5|image| (-5) vcld, main (line: 341)

No recipient addresses found in header
2010-05-22 13:35:52|18387|6:5|image|utils.pm:mail(1348)|SUCCESS --
Sending mail To: , PROBLEM -- vcld

|18387|6:5|image| ---- CRITICAL ----
|18387|6:5|image| 2010-05-22
13:35:52|18387|6:5|image|vcld:die_handler(662)|Can't use an undefined
value as an ARRAY reference at
/usr/local/vcl/bin/../lib/VCL/Module/Provisioning/esx.pm line 911.
|18387|6:5|image| ( 0) utils.pm, notify (line: 737)
|18387|6:5|image| (-1) vcld, die_handler (line: 662)
|18387|6:5|image| (-2) esx.pm, does_image_exist (line: 911)
|18387|6:5|image| (-3) image.pm, process (line: 135)
|18387|6:5|image| (-4) vcld, make_new_child (line: 594)
|18387|6:5|image| (-5) vcld, main (line: 341)

2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(905)|destructor
called, ref($self)=VCL::image
2010-05-22 
13:35:52|18387|6:5|image|utils.pm:delete_computerloadlog_reservation(7551)|removing
computerloadlog entries matching loadstate = begin
2010-05-22 
13:35:52|18387|6:5|image|utils.pm:delete_computerloadlog_reservation(7598)|deleted
rows from computerloadlog for reservation id=5
2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(912)|removed
computerloadlog rows with loadstate=begin for reservation
2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(924)|number of
database handles state process created: 1
2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(933)|process has
a database handle stored in $ENV{dbh}, attempting disconnect
2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(935)|$ENV{dbh}:
database disconnect successful
2010-05-22 13:35:52|18387|6:5|image|State.pm:DESTROY(949)|VCL::image
process 18387 exiting
2010-05-22 13:35:52|18385|vcld:REAPER(744)|VCL process exited for reservation 5
2010-05-22 13:35:52|18385|vcld:main(165)|lastcheckin time updated for
management node 1: 2010-05-22 13:35:52

Re-inserted request and reservation:
mysql> select * from request;
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
| id | stateid | userid | laststateid | logid | forimaging | test |
preload | start               | end                 | daterequested
   | datemodified |
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
|  6 |      14 |      1 |          16 |     0 |          1 |    0 |
   0 | 2010-05-22 13:38:34 | 2010-05-22 15:38:34 | 2010-05-22 13:38:34
| NULL         |
+----+---------+--------+-------------+-------+------------+------+---------+---------------------+---------------------+---------------------+--------------+
1 row in set (0.00 sec)

mysql> select * from reservation;
+----+-----------+------------+---------+-----------------+------------------+----------+-----------+------+
| id | requestid | computerid | imageid | imagerevisionid |
managementnodeid | remoteIP | lastcheck | pw   |
+----+-----------+------------+---------+-----------------+------------------+----------+-----------+------+
|  5 |         6 |          2 |      10 |              10 |
    1 | NULL     | NULL      | NULL |
+----+-----------+------------+---------+-----------------+------------------+----------+-----------+------+
1 row in set (0.00 sec)


Thanks.



On Sat, May 22, 2010 at 1:03 PM, Ryan Johnson <rjoh...@gwmail.gwu.edu> wrote:
> What scenario are you trying to accomplish here?  You specified Module 10
> which is an ESX provisioning module rather than an OS module.  It does not
> implement set_provisioner.  Try using module id 5.
>
> On Sat, May 22, 2010 at 9:27 AM, My LinuxHAList <mylinuxhal...@gmail.com>
> wrote:
>>
>> Hi Ryan, List,
>>
>> After reading Ryan's commments, I updated my OS tables and update the
>> moduleid=10 (which is esx).
>>
>> | id | name           | prettyname                          | type
>> | installtype | sourcepath      | moduleid |
>>
>> +----+----------------+--------------------------------------------+---------+-------------+---------------------------+----------+
>> | 34 | vmwarelinux    | VMware Generic Linux     | linux   | vmware
>>  | vmware_images |       10 |
>>
>> I delete everything reservation and request and re-inserted the request.
>>
>> INSERT INTO vcl.request (
>> \`id\` ,
>> \`stateid\` ,
>> \`userid\` ,
>> \`laststateid\` ,
>> \`logid\` ,
>> \`forimaging\` ,
>> \`test\` ,
>> \`preload\` ,
>> \`start\` ,
>> \`end\` ,
>> \`daterequested\` ,
>> \`datemodified\`
>> )
>> VALUES (
>> NULL , '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 , LAST_INSERT_ID(),2, 10, 10, '1',
>> NULL , NULL , NULL );
>>
>>
>> Here is my module table:
>> mysql> select * from module;
>>
>> +----+-------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------+
>> | id | name                    | prettyname                        |
>> description
>>
>>                             | perlpackage
>>   |
>>
>> +----+-------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------+
>> |  1 | provisioning_xcat_13    | xCAT 1.3 Provisioning Module      |
>>
>>
>>                           | VCL::Module::Provisioning::xCAT
>>  |
>> |  2 | provisioning_vmware_gsx | VMware GSX Provisioning Module    |
>>
>>
>>                           | VCL::Module::Provisioning::vmware
>>  |
>> |  3 | provisioning_lab        | Computing Lab Provisioning Module |
>>
>>
>>                           | VCL::Module::Provisioning::Lab
>>  |
>> |  4 | os_windows              | Windows OS Module                 |
>>
>>
>>                           | VCL::Module::OS::Windows
>>  |
>> |  5 | os_linux                | Linux OS Module                   |
>>
>>
>>                           | VCL::Module::OS::Linux
>>  |
>> |  6 | os_unix                 | Unix OS Module                    |
>>
>>
>>                           | VCL::Module::OS
>>  |
>> |  7 | os_winvista             | Windows Vista OS Module           |
>>
>>
>>                           |
>> VCL::Module::OS::Windows::Version_6::Vista |
>> |  8 | predictive_level_0      | Predictive Loading Module Level 0 |
>> Selects an image to load based on upcoming reservations.
>>
>>                             | VCL::Module::Predictive::Level_0
>>   |
>> |  9 | predictive_level_1      | Predictive Loading Module Level 1 |
>> Selects an image to load based on historical data. Loads the most
>> popular image that can be run on the machine that is not currently
>> loaded and available on another node. |
>> VCL::Module::Predictive::Level_1           |
>> | 10 | provisioning_vmware_esx | VMware ESX Provisioning Module    |
>>
>>
>>                           | VCL::Module::Provisioning::esx
>>  |
>> | 11 | provisioning_xcat_21    | xCAT 2.1 Provisioning Module      |
>>
>>
>>                           | VCL::Module::Provisioning::xCAT21
>>  |
>> | 12 | os_winxp                | Windows XP OS Module              |
>>
>>
>>                           | VCL::Module::OS::Windows::Version_5::XP
>>  |
>> | 13 | os_win2003              | Windows Server 2003 OS Module     |
>>
>>
>>                           | VCL::Module::OS::Windows::Version_5::2003
>>  |
>> | 14 | os_linux_ubuntu         | Ubuntu Linux OS Module            |
>>
>>
>>                           | VCL::Module::OS::Linux::Ubuntu
>>  |
>> | 15 | os_unix_lab             | Unix Lab Module                   |
>> Unix Lab OS support module
>>
>>                             | VCL::Module::OS::Linux::UnixLab
>>   |
>> | 16 | os_win2008              | Windows Server 2008 OS Module     |
>>
>>
>>                           | VCL::Module::OS::Windows::Version_6::2008
>>  |
>>
>> +----+-------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------+
>> 16 rows in set (0.00 sec)
>>
>> I'm getting close to the same thing:
>> 1) get_request_info(5218)|preferredimageid is not set for computer id=2
>>    What's that preferredimageid field ? Do I need to set it to anything ?
>>    I don't know what this field is about.
>>
>> 2) 2010-05-22 09:14:10|17725|3:3|image|vcld:die_handler(665)|Can't
>> locate object method "set_provisioner" via package
>> "VCL::Module::Provisioning::esx" at
>> /usr/local/vcl/bin/../lib/VCL/Module/State.pm line 167.
>>
>>
>> Here are the logs from vcld.log
>> 15598|3:3|image| ---- WARNING ----
>> |15598|3:3|image| 2010-05-22
>> 09:14:10|15598|3:3|image|utils.pm:get_request_info(5218)|preferredimageid
>> is not set for computer id=2
>> |15598|3:3|image| ( 0) utils.pm, notify (line: 737)
>> |15598|3:3|image| (-1) utils.pm, get_request_info (line: 5218)
>> |15598|3:3|image| (-2) vcld, main (line: 283)
>>
>> 2010-05-22
>> 09:14:10|15598|3:3|image|utils.pm:get_request_info(5354)|standalone
>> affiliation found: Local
>> 2010-05-22
>> 09:14:10|15598|3:3|image|utils.pm:get_management_node_info(6815)|management
>> node info retrieved from database for managementnode
>> 2010-05-22 09:14:10|15598|3:3|image|vcld:main(284)|retrieved request
>> information from database
>> 2010-05-22
>> 09:14:10|15598|3:3|image|DataStructure.pm:is_parent_reservation(854)|returning
>> true: parent reservation ID for this request: 3
>> 2010-05-22
>> 09:14:10|15598|3:3|image|utils.pm:update_request_state(2186)|request
>> 3 state updated to: pending, laststate to: image
>> 2010-05-22 09:14:10|15598|3:3|image|utils.pm:insertloadlog(4710)|inserted
>> computer=2, begin, beginning to process, state is image
>> 2010-05-22 09:14:10|15598|3:3|image|vcld:make_new_child(512)|loaded
>> VCL::image module
>> 2010-05-22 09:14:10|17725|3:3|image|vcld:make_new_child(585)|vcld
>> environment variable set to 0 for this process
>> 2010-05-22 09:14:10|15598|3:3|image|vcld:make_new_child(569)|current
>> number of forked kids: 1
>> 2010-05-22 09:14:10|17725|3:3|image|Module.pm:new(132)|constructor
>> called, class=VCL::image
>> 2010-05-22 09:14:10|17725|3:3|image|Module.pm:new(154)|VCL::image object
>> created
>> 2010-05-22 09:14:10|17725|3:3|image|State.pm:initialize(85)|obtained a
>> database handle for this state process, stored as $ENV{dbh}
>> 2010-05-22 09:14:10|17725|3:3|image|State.pm:check_image_os(839)|no
>> corrections need to be made to image OS: vmwarelinux
>> 2010-05-22
>> 09:14:10|17725|3:3|image|DataStructure.pm:is_parent_reservation(854)|returning
>> true: parent reservation ID for this request: 3
>> 2010-05-22
>> 09:14:10|17725|3:3|image|utils.pm:rename_vcld_process(7863)|reservation
>> count: 1
>> 2010-05-22
>> 09:14:10|17725|3:3|image|utils.pm:rename_vcld_process(7882)|PARENTIMAGE:
>> 1
>> 2010-05-22
>> 09:14:10|17725|3:3|image|utils.pm:rename_vcld_process(7883)|SUBIMAGE:
>> 0
>> 2010-05-22
>> 09:14:10|17725|3:3|image|utils.pm:rename_vcld_process(7901)|renamed
>> process to 'vcld VCL::image 3:3 image imaging'
>> 2010-05-22
>> 09:14:10|17725|3:3|image|DataStructure.pm:is_parent_reservation(854)|returning
>> true: parent reservation ID for this request: 3
>> 2010-05-22
>> 09:14:10|17725|3:3|image|DataStructure.pm:is_parent_reservation(854)|returning
>> true: parent reservation ID for this request: 3
>> 2010-05-22 09:14:10|17725|3:3|image|State.pm:initialize(121)|attempting
>> to load provisioning module: VCL::Module::Provisioning::esx
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(138)|esx vmware
>> toolkit root path found: /usr/lib/vmware-vcli/apps
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(140)|vmware ESX
>> module initialized
>> 2010-05-22
>> 09:14:10|17725|3:3|image|State.pm:initialize(127)|VCL::Module::Provisioning::esx
>> module loaded
>> 2010-05-22 09:14:10|17725|3:3|image|Module.pm:new(132)|constructor
>> called, class=VCL::Module::Provisioning::esx
>> 2010-05-22
>> 09:14:10|17725|3:3|image|Module.pm:new(154)|VCL::Module::Provisioning::esx
>> object created
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(138)|esx vmware
>> toolkit root path found: /usr/lib/vmware-vcli/apps
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(140)|vmware ESX
>> module initialized
>> 2010-05-22
>> 09:14:10|17725|3:3|image|State.pm:initialize(131)|VCL::Module::Provisioning::esx
>> provisioner object created
>> 2010-05-22 09:14:10|17725|3:3|image|State.pm:initialize(145)|attempting
>> to load OS module: VCL::Module::Provisioning::esx
>> 2010-05-22
>> 09:14:10|17725|3:3|image|State.pm:initialize(151)|VCL::Module::Provisioning::esx
>> module loaded
>> 2010-05-22 09:14:10|17725|3:3|image|Module.pm:new(132)|constructor
>> called, class=VCL::Module::Provisioning::esx
>> 2010-05-22
>> 09:14:10|17725|3:3|image|Module.pm:new(154)|VCL::Module::Provisioning::esx
>> object created
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(138)|esx vmware
>> toolkit root path found: /usr/lib/vmware-vcli/apps
>> 2010-05-22 09:14:10|17725|3:3|image|esx.pm:initialize(140)|vmware ESX
>> module initialized
>> 2010-05-22
>> 09:14:10|17725|3:3|image|State.pm:initialize(154)|VCL::Module::Provisioning::esx
>> OS object created
>> No recipient addresses found in header
>> 2010-05-22 09:14:11|17725|3:3|image|utils.pm:mail(1348)|SUCCESS --
>> Sending mail To: , PROBLEM -- vcld
>>
>> |17725|3:3|image| ---- CRITICAL ----
>> |17725|3:3|image| 2010-05-22
>> 09:14:10|17725|3:3|image|vcld:die_handler(665)|Can't locate object
>> method "set_provisioner" via package "VCL::Module::Provisioning::esx"
>> at /usr/local/vcl/bin/../lib/VCL/Module/State.pm line 167.
>> |17725|3:3|image| ( 0) utils.pm, notify (line: 737)
>> |17725|3:3|image| (-1) vcld, die_handler (line: 665)
>> |17725|3:3|image| (-2) State.pm, initialize (line: 167)
>> |17725|3:3|image| (-3) Module.pm, new (line: 157)
>> |17725|3:3|image| (-4) vcld, make_new_child (line: 593)
>> |17725|3:3|image| (-5) vcld, main (line: 344)
>>
>> Thanks again.
>>
>>
>> On Fri, May 21, 2010 at 8:36 PM, Ryan Johnson <rjoh...@gwmail.gwu.edu>
>> wrote:
>> > Could you include the output from your module table too? My guess is
>> > that
>> > the module ID you specified in your OS row is referring to a vmware
>> > module
>> > rather than an OS module.  Try changing the module ID to an OS module.
>> >
>> > On Fri, May 21, 2010 at 7:20 PM, My LinuxHAList
>> > <mylinuxhal...@gmail.com>
>> > wrote:
>> >>
>> >> Hi,
>> >>
>> >> I've installed ESXi 3.5 (added it as computer, with computer id =2).
>> >>
>> >> The management node can get to the my esxi host via the ssh key from
>> >> /etc/vcl/vcl.key{.pub}
>> >>
>> >> Then, after modelling the request on creating base linux image, I did:
>> >>
>> >> INSERT INTO vcl.request (
>> >> `id` ,
>> >> `stateid` ,
>> >> `userid` ,
>> >> `laststateid` ,
>> >> `logid` ,
>> >> `forimaging` ,
>> >> `test` ,
>> >> `preload` ,
>> >> `start` ,
>> >> `end` ,
>> >> `daterequested` ,
>> >> `datemodified`
>> >> )
>> >> VALUES (
>> >> NULL , '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 , LAST_INSERT_ID(), 2, 10, 10, '1', NULL , NULL , NULL
>> >> );
>> >>
>> >>
>> >> I'm getting this following error from vcld.log:
>> >> ----
>> >> |15670|2:2|image| ---- CRITICAL ----
>> >> |15670|2:2|image| 2010-05-21
>> >> 18:56:22|15670|2:2|image|vcld:die_handler(665)|Can't locate object
>> >> method "set_provisioner" via package
>> >> "VCL::Module::Provisioning::vmware" at
>> >> /usr/local/vcl/bin/../lib/VCL/Module/State.pm line 167.
>> >> |15670|2:2|image| ( 0) utils.pm, notify (line: 737)
>> >> |15670|2:2|image| (-1) vcld, die_handler (line: 665)
>> >> |15670|2:2|image| (-2) State.pm, initialize (line: 167)
>> >> |15670|2:2|image| (-3) Module.pm, new (line: 157)
>> >> |15670|2:2|image| (-4) vcld, make_new_child (line: 593)
>> >> |15670|2:2|image| (-5) vcld, main (line: 344)
>> >> ---
>> >>
>> >> Could the list help me diagnosing what mistakes I made ?
>> >>
>> >> I was reading through esx.readme. The table vmhost has the field
>> >> "vmkernalnic", where should I get the value for that field ?
>> >> Currently, vmhost.vmkernalnic is set to NULL.
>> >>
>> >> Thanks
>> >>
>> >> Here are the database information prior to the reservation request:
>> >>
>> >> mysql> select * from computer where id=2;
>> >>
>> >>
>> >> +----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+---------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>> >> | 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 |
>> >>
>> >>
>> >> +----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+---------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>> >> |  2 |       2 |       1 |          1 |          1 |              4 |
>> >>              0 |           0 |               0 | 4096 |          2 |
>> >>    3200 |     100 | vmnode2.local | 192.168.88.5 | NULL             |
>> >> NULL           | NULL           | virtualmachine |              4 |
>> >> hda       |       0 |       | NULL      | NULL     | NULL | NULL   |
>> >> NULL | NULL   | NULL | NULL    |     NULL |     NULL |
>> >>
>> >>
>> >> +----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+---------------+--------------+------------------+----------------+----------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>> >> 1 row in set (0.00 sec)
>> >>
>> >> mysql> select * from vmhost;
>> >> +----+------------+---------+-------------+-------------+------------+
>> >> | id | computerid | vmlimit | vmprofileid | vmkernalnic | vmwaredisk |
>> >> +----+------------+---------+-------------+-------------+------------+
>> >> |  1 |          2 |       5 |           6 | NULL        | localdisk  |
>> >> +----+------------+---------+-------------+-------------+------------+
>> >> 1 row in set (0.00 sec)
>> >>
>> >>
>> >> mysql> select * from vmprofile where id=6;
>> >>
>> >>
>> >> +----+--------------+----------+---------+----------+--------------------------+--------------------------+----------------+-------------------------+-----------+----------+----------------+
>> >> | id | profilename  | vmtypeid | imageid | nasshare | datastorepath
>> >>        | vmpath                   | virtualswitch0 | virtualswitch1
>> >>       | vmdisk    | username | password       |
>> >>
>> >>
>> >> +----+--------------+----------+---------+----------+--------------------------+--------------------------+----------------+-------------------------+-----------+----------+----------------+
>> >> |  6 | ESXi vmnode2 |        5 |      10 | NULL     |
>> >> /vmfs/volumes/datastore1 | /vmfs/volumes/datastore1 | VM Network     |
>> >> Virtual Machine Network | localdisk | root     | notmyrootpassword |
>> >>
>> >>
>> >> +----+--------------+----------+---------+----------+--------------------------+--------------------------+----------------+-------------------------+-----------+----------+----------------+
>> >> 1 row in set (0.00 sec)
>> >>
>> >> mysql> select * from image where id=10;
>> >>
>> >>
>> >> +----+-----------------+-------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>> >> | id | name            | prettyname  | ownerid | platformid | OSid |
>> >> imagemetaid | minram | minprocnumber | minprocspeed | minnetwork |
>> >> maxconcurrent | reloadtime | deleted | test | lastupdate          |
>> >> forcheckout | maxinitialtime | project | size | architecture |
>> >> description | usage | basedoffrevisionid |
>> >>
>> >>
>> >> +----+-----------------+-------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>> >> | 10 | esx3-vmlinux-v1 | NoAppsLinux |       1 |          1 |   34 |
>> >>     NULL |    512 |             1 |         1024 |        100 |
>> >>   NULL |          5 |       0 |    0 | 2010-05-18 19:08:02 |
>> >>  1 |              0 | vcl     | 1500 | x86          | NULL        |
>> >> NULL  |                  0 |
>> >>
>> >>
>> >> +----+-----------------+-------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+------+--------------+-------------+-------+--------------------+
>> >> 1 row in set (0.00 sec)
>> >>
>> >>
>> >>
>> >> --- Modeled after the web instruction --
>> >> INSERT INTO OS (
>> >> `id`, `name`, `prettyname`,
>> >> `type`, `installtype`, `sourcepath`, `moduleid`) VALUES
>> >> (34, 'vmwarelinux', 'VMware Generic Linux',
>> >> 'linux', 'vmware','vmware_images', 2);
>> >>
>> >>
>> >> 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-vmlinux-v1', 'NoAppsLinux', '1', '1', '34', NULL,
>> >> '512', '1', '1024', '100', NULL , '5', '0', '0', NOW(), '1', '0',
>> >> 'vcl',
>> >> '1500',
>> >> 'x86', NULL , NULL , '0'
>> >> );
>> >>
>> >> INSERT INTO vcl.imagerevision (
>> >> `id` ,
>> >> `imageid` ,
>> >> `revision` ,
>> >> `userid` ,
>> >> `datecreated` ,
>> >> `deleted` ,
>> >> `datedeleted` ,
>> >> `production` ,
>> >> `comments` ,
>> >> `imagename`
>> >> )
>> >> VALUES (
>> >> 10, 10, '0', '1', NOW(), '0', NULL , '1', NULL , 'esx3-vmlinux-v1'
>> >> );
>> >>
>> >> INSERT INTO vcl.resource (
>> >> `id` ,
>> >> `resourcetypeid` ,
>> >> `subid`
>> >> )
>> >> VALUES (
>> >> NULL , '13', 10
>> >> );
>> >
>> >
>
>

Reply via email to