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 >>>> >>> >> >
