Nothing obvious is jumping out at me here. I'm running out of ideas, perhaps 
someone else can chime in.

The only other thing I can think of is to verify that your virtual machines are 
in the 'available' state.

Mike Waldron
Systems Specialist
ITS Research Computing
University of North Carolina at Chapel Hill
CB #3420, ITS Manning, Rm 2509
919-962-9778


-----Original Message-----
From: My LinuxHAList [mailto:mylinuxhal...@gmail.com]
Sent: Wednesday, June 09, 2010 9:41 AM
To: vcl-dev@incubator.apache.org
Subject: Re: showTimeTable function

Thanks again Mike for helping with this.

mysql> select resourcegroup.name,resourcetype.name,type,privnode.name
from resourcegroup,resourcetype,resourcepriv,privnode where
resourcegroupid=resourcegroup.id and resourcetypeid=resourcetype.id
and privnodeid=privnode.id;;
+--------------------+----------------+-------------+-----------+
| name               | name           | type        | name      |
+--------------------+----------------+-------------+-----------+
| allComputers       | computer       | available   | VCL       |
| allComputers       | computer       | administer  | VCL       |
| allComputers       | computer       | manageGroup | VCL       |
| allComputers       | computer       | available   | admin     |
| allComputers       | computer       | administer  | admin     |
| allComputers       | computer       | manageGroup | admin     |
| allComputers       | computer       | available   | newimages |
| allComputers       | computer       | administer  | newimages |
| allComputers       | computer       | manageGroup | newimages |
| newimages          | computer       | available   | VCL       |
| newimages          | computer       | administer  | VCL       |
| newimages          | computer       | manageGroup | VCL       |
| newimages          | computer       | available   | admin     |
| newimages          | computer       | administer  | admin     |
| newimages          | computer       | manageGroup | admin     |
| newimages          | computer       | available   | newimages |
| newimages          | computer       | administer  | newimages |
| newimages          | computer       | manageGroup | newimages |
| newvmimages        | computer       | available   | VCL       |
| newvmimages        | computer       | administer  | VCL       |
| newvmimages        | computer       | manageGroup | VCL       |
| newvmimages        | computer       | available   | admin     |
| newvmimages        | computer       | administer  | admin     |
| newvmimages        | computer       | manageGroup | admin     |
| newvmimages        | computer       | available   | newimages |
| newvmimages        | computer       | administer  | newimages |
| newvmimages        | computer       | manageGroup | newimages |
| allImages          | image          | available   | VCL       |
| allImages          | image          | administer  | VCL       |
| allImages          | image          | manageGroup | VCL       |
| allImages          | image          | available   | admin     |
| allImages          | image          | administer  | admin     |
| allImages          | image          | manageGroup | admin     |
| allImages          | image          | available   | newimages |
| allImages          | image          | administer  | newimages |
| allImages          | image          | manageGroup | newimages |
| allVMimages        | image          | available   | VCL       |
| allVMimages        | image          | administer  | VCL       |
| allVMimages        | image          | manageGroup | VCL       |
| allVMimages        | image          | available   | admin     |
| allVMimages        | image          | administer  | admin     |
| allVMimages        | image          | manageGroup | admin     |
| allVMimages        | image          | available   | newimages |
| allVMimages        | image          | administer  | newimages |
| allVMimages        | image          | manageGroup | newimages |
| allSchedules       | schedule       | available   | VCL       |
| allSchedules       | schedule       | administer  | VCL       |
| allSchedules       | schedule       | manageGroup | VCL       |
| allSchedules       | schedule       | available   | admin     |
| allSchedules       | schedule       | administer  | admin     |
| allSchedules       | schedule       | manageGroup | admin     |
| allSchedules       | schedule       | available   | newimages |
| allSchedules       | schedule       | administer  | newimages |
| allSchedules       | schedule       | manageGroup | newimages |
| allManagementNodes | managementnode | available   | VCL       |
| allManagementNodes | managementnode | administer  | VCL       |
| allManagementNodes | managementnode | manageGroup | VCL       |
| allManagementNodes | managementnode | available   | admin     |
| allManagementNodes | managementnode | administer  | admin     |
| allManagementNodes | managementnode | manageGroup | admin     |
| allManagementNodes | managementnode | available   | newimages |
| allManagementNodes | managementnode | administer  | newimages |
| allManagementNodes | managementnode | manageGroup | newimages |
+--------------------+----------------+-------------+-----------+
63 rows in set (0.00 sec)



On Wed, Jun 9, 2010 at 8:53 AM, Waldron, Michael H
<mwald...@email.unc.edu> wrote:
> I think the list is scrubbing attachments. That error message still sounds 
> like the privileges aren't right yet.
>
> Run this query and paste the output into the email, it will list the 
> privileges.
>
> select resourcegroup.name,resourcetype.name,type,privnode.name  from 
> resourcegroup,resourcetype,resourcepriv,privnode where 
> resourcegroupid=resourcegroup.id and resourcetypeid=resourcetype.id and 
> privnodeid=privnode.id;
>
> Mike Waldron
> Systems Specialist
> ITS Research Computing
> University of North Carolina at Chapel Hill
> CB #3420, ITS Manning, Rm 2509
> 919-962-9778
>
>
> -----Original Message-----
> From: My LinuxHAList [mailto:mylinuxhal...@gmail.com]
> Sent: Tuesday, June 08, 2010 4:52 PM
> To: vcl-dev@incubator.apache.org
> Subject: Re: showTimeTable function
>
> Hi Mike, List,
>
> On Tue, Jun 8, 2010 at 3:49 PM, Waldron, Michael H
> <mwald...@email.unc.edu> wrote:
>> Your privilege screen attachments didn't make it to the list.
>
> Ooops. Re-attached it. I made sure that things that can be added to
> the Resources are added and marked available, etc.
> Probably, the current setup is not clean; but it's the shot gun
> approach to ensure that all things are available.
>
>> Make sure for the Resources section on the Privileges screen that the 
>> computer groups and the image groups are listed as available.
>>
>> You shouldn't have to fill in the currentimageid, preferredimageid, 
>> nextimageid, imagerevisionid fields in the computer table.
>
> OK.
>
>> If you ever use "bare-metal" or "full blade" images in the future, as 
>> opposed to vmware images, you'll want to separate your computer and image 
>> group assignments. The reason being that "bare-metal" installs use a 
>> different provisioning engine (xCAT), bare-metal images can't be provisioned 
>> on vmware computers and vmware images can't be provisioned on bare-metal 
>> servers. In your case it doesn't matter since you only have vmware image.
>> For example:
>> allComputers,newimages,allImages  used for bare-metal
>> allVMComputers, newvmimages, allVMImages  used for vmware
>
> Thanks again for the explanation. All these labels are now more
> meaningful to me now.
>
> I see. So, in a cleanly-separated. My vm-spawn-1 belongs to only
> newvmimages, allVMImages, allVMComputers.
> In an attempt to make this work, I just make a lot of things belonging
> to a whole lot of other things.
>
> I'm still at this point getting "Selection not currently available".
>
> How should I troubleshoot this further ?
>
>>
>>
>> Mike Waldron
>> Systems Specialist
>> ITS Research Computing
>> University of North Carolina at Chapel Hill
>> CB #3420, ITS Manning, Rm 2509
>> 919-962-9778
>>
>>
>> -----Original Message-----
>> From: My LinuxHAList [mailto:mylinuxhal...@gmail.com]
>> Sent: Tuesday, June 08, 2010 3:01 PM
>> To: vcl-dev@incubator.apache.org
>> Subject: Re: showTimeTable function
>>
>>> I don't know how the View Time Table plays into things, I've never looked 
>>> at that before, mine is currently blank.
>>> Unless I'm not understanding the setup, you have to have as many computers 
>>> defined as you want to have instances of your image running. For each 
>>> computer you define you assign a unique mac address. To make a reservation 
>>> for the image, there has to be an available computer for the reservation to 
>>> run on. If you want to have 10 concurrent reservations, you have to have 10 
>>> computers available.
>>>
>>> The image also must be assigned to an image group, and that image group has 
>>> to be mapped to a computer group which contains the computers the image can 
>>> run on. There is good explanation of this at the Documentation link on the 
>>> VCL home page.
>>
>> Thanks. I've been trying to follow the documentation on the "Images
>> and Privileges" documentation.
>> The documentation did not mention about creation of each machine like
>> you described; now I understand that it's needed.
>>
>> I added "vm-spawn-1"; with Mac address, etc.
>>
>> Do you mean the following grouping, etc. I've got (I'm logged in as
>> user 'admin'):
>> 1) "No Apps (Linux) - image.id=10" belongs to {allImages,allVMImages}
>> 2) allImages belongs to {allComputers,newimages,newvmimages}
>> 3) allVMImages belongs to {allComputers,newimages,newvmimages}
>> 4) vmnode2.local (ESXi host) and vm-spawn-1 belong to
>> {allComputers,newimages,newvmimages}
>> 5) Attached are my Privileges screens.
>>
>> Do I need to set currentimageid, preferredimageid or nextimageid,
>> imagerevisionid for vm-spawn-1 ?
>>
>> I still can't get reservation on "No Apps (Linux)", when I select
>> "Now" it still says "Selection currently not available".
>>
>> Thanks
>>
>>
>>
>>
>> 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 |      20 |       1 |          1 |          1 |              4 |
>>              0 |           0 |               0 | 4096 |          2 |
>>    3200 |     100 | vmnode2.local | 192.168.88.5  | NULL
>> | NULL              | NULL              | blade          |
>>  4 | hda       |       0 | NULL  | NULL      | NULL     | NULL | NULL
>>  | NULL | NULL   | NULL | NULL    |     NULL |     NULL |
>> |  2 |       2 |       1 |          1 |          1 |              4 |
>>              0 |           0 |               0 |  512 |          1 |
>>    1000 |     100 | vm-base10-v1  | 192.168.88.10 | NULL
>> | NULL              | NULL              | virtualmachine |
>>  4 | hda       |       0 |       | NULL      | NULL     | NULL | NULL
>>  | NULL | NULL   | NULL | NULL    |        1 |     NULL |
>> |  3 |       2 |       1 |          1 |          1 |              4 |
>>              0 |           0 |               0 |  512 |          1 |
>>    1000 |     100 | vm-spawn-1    | 192.168.88.11 | NULL
>> | 00:50:56:c0:00:08 | 00:50:56:c0:00:09 | virtualmachine |
>>  4 | hda       |       0 |       | NULL      | NULL     | NULL | NULL
>>  | NULL | NULL   | NULL | NULL    |        1 |     NULL |
>> +----+---------+---------+------------+------------+----------------+------------------+-------------+-----------------+------+------------+-----------+---------+---------------+---------------+------------------+-------------------+-------------------+----------------+----------------+-----------+---------+-------+-----------+----------+------+--------+------+--------+------+---------+----------+----------+
>>
>> mysql> select * from vmhost;
>> +----+------------+---------+-------------+-------------+-------------+
>> | id | computerid | vmlimit | vmprofileid | vmkernalnic | vmwaredisk  |
>> +----+------------+---------+-------------+-------------+-------------+
>> |  1 |          1 |       5 |           6 | NULL        | networkdisk |
>> +----+------------+---------+-------------+-------------+-------------+
>> 1 row in set (0.00 sec)
>>
>>
>>
>>>
>>>
>>> Mike Waldron
>>> Systems Specialist
>>> ITS Research Computing
>>> University of North Carolina at Chapel Hill
>>> CB #3420, ITS Manning, Rm 2509
>>> 919-962-9778
>>>
>>>
>>> -----Original Message-----
>>> From: My LinuxHAList [mailto:mylinuxhal...@gmail.com]
>>> Sent: Tuesday, June 08, 2010 12:15 PM
>>> To: vcl-dev@incubator.apache.org
>>> Subject: Re: showTimeTable function
>>>
>>> Hi Mike, List,
>>>
>>> Apparently, my understanding is still a bit off.
>>>
>>> Since I've captured the image successfully "No Apps (Linux)", name:
>>> vmwarelinux-base10-v1, with the appropriate files copied over to
>>> $DATASTORE/golden/vmwarelinux-base10-v1/
>>>
>>> I'm thinking that I'll be able to spawn as many "instance" of the "No
>>> Apps (Linux)" as I configure the ESXi to handle.
>>> That was the idea behind capturing an image right ?  How would I be
>>> able to achieve that ?
>>>
>>> I create another computer called "vm-tospawn", populate the mac
>>> addresses field and assign it to my only ESXi host.
>>> Nothing shows up on the "View Time Table". What are the fields that
>>> say "vm-tospawn" is associated with the "No Apps (Linux)" image I
>>> captured ? If I populate the mac address fields, if I spawn 2 version
>>> of it, wouldn't I cause conflicts on the Mac address ?
>>>
>>> I still need some guidance on how to go from successful image capture
>>> to launch multiple of them on ESXi host.
>>>
>>> What am I missing ?
>>>
>>> Thanks
>>>
>>>
>>> On Tue, Jun 8, 2010 at 10:59 AM, Waldron, Michael H
>>> <mwald...@email.unc.edu> wrote:
>>>> The ESXi host won't directly run your image, you have to define virtual 
>>>> machines and assign them to the ESXi host, which will then spin these up 
>>>> to run the image.
>>>>
>>>> Basic steps:
>>>> - Click Manage Computers, Edit Computer Information, Submit
>>>> - Add
>>>> - Fill in hostname, IP address, RAM, Proc Speed, Network Speed, select 
>>>> 'virtual machine' under Type, VMWare provisioning engine, and appropriate 
>>>> computer group.
>>>> - Assign mac addresses for public and private network interfaces of the 
>>>> virtual machine.
>>>> - Update the computer table in the database with this info for the virtual 
>>>> machine and assign the values to the fields eth0macaddress, eth1macaddress.
>>>> - Click Virtual Hosts
>>>> - Select your ESXi host
>>>> - Click Configure Host
>>>> - Select the virtual machine(s) in the Unassigned VMs column and click Add.
>>>>
>>>> Hopefully I didn't leave out any steps.
>>>>
>>>>
>>>> Mike Waldron
>>>> Systems Specialist
>>>> ITS Research Computing
>>>> University of North Carolina at Chapel Hill
>>>> CB #3420, ITS Manning, Rm 2509
>>>> 919-962-9778
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: My LinuxHAList [mailto:mylinuxhal...@gmail.com]
>>>> Sent: Monday, June 07, 2010 11:54 PM
>>>> To: vcl-u...@incubator.apache.org; vcl-dev@incubator.apache.org
>>>> Cc: My LinuxHAList
>>>> Subject: showTimeTable function
>>>>
>>>> Hi,
>>>>
>>>> I have a ESXi host (computer.id=1); I have an image [ No Apps(Linux) ]
>>>> which was successfully captured (I think).
>>>> I tried to make Reservation using the "now" button, it says "Selection
>>>> currently not available"; then I clicked the "View Time Table", no
>>>> computers show up.
>>>>
>>>> The ESXi host is in vmhostinuse state (which is state.id=20) -- which
>>>> ESXi host needs to be in.
>>>>
>>>> I'm assuming that my ESXi host is supposed to show up on I hit the
>>>> "View Time Table" if I intend it to be able to run "No Apps (Linux)".
>>>> Is this true ?
>>>>
>>>> With ESXi host in the state of vmhostinuse, I don't think it will ever
>>>> show up, because the state.id=20.
>>>> Here are the code snippets:
>>>>                        if($computer_platformids[$id] != $platformid ||
>>>>                           ($computerData[$id]["stateid"] != 2 &&
>>>>                                $computerData[$id]["stateid"] != 3 &&
>>>>                                $computerData[$id]["stateid"] != 6 &&
>>>>                                $computerData[$id]["stateid"] != 8) ||
>>>>                           $computerData[$id]["ram"] <
>>>> $imageData[$imageid]["minram"] ||
>>>>                           $computerData[$id]["procnumber"] <
>>>> $imageData[$imageid]["minprocnumber"] ||
>>>>                           $computerData[$id]["procspeed"] <
>>>> $imageData[$imageid]["minprocspeed"] ||
>>>>                           $computerData[$id]["network"] <
>>>> $imageData[$imageid]["minnetwork"] ||
>>>>                           ! in_array($id, $mappedcomputers)) {
>>>>                                continue;
>>>>                        }
>>>>
>>>> I could have completely misunderstood what "View Time Table" should show.
>>>> I'm expecting the time tables to show ESXi host(s) that are able to
>>>> run "No Apps (Linux)".
>>>>
>>>> If I'm wrong, what is "View Time Table" designed to show ?
>>>>
>>>> Thanks
>>>>
>>>
>>
>

Reply via email to