Re: showTimeTable function

2010-06-09 Thread My LinuxHAList
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 
 

RE: showTimeTable function

2010-06-09 Thread Waldron, Michael H
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 | 

Reservation time-out

2010-06-09 Thread Roger Herling
I am working on a pilot that is going to require a blade to stay imaged 
for a week at a time.  I have extended the time to 166hours but the image 
times out if not logged on.  How do I prevent this from happening?


Roger Herling
Sr. Desktop Administrator
Marist College
PH: 845-575-3347

Re: showTimeTable function

2010-06-09 Thread Josh Thompson
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mike has already mentioned some of these items, but I'll list them all out 
together to make it easier to check.

- -put No Apps(Linux) in the allVMimages group
- -create a new computer group named All VMs
- -map the allVMimages image group to the All VMs computer group
- -put vm-spawn-1 and any other VMs you've created in the All VMs computer 
group
- -add All VMs to the VCL node on the privilege tree with the available 
attribute
- -map the AllManagementNodes management node group to the All VMs computer 
group
- -make sure the computer specs for vm-spawn-1 are greater than or equal to the 
image specs for No Apps(Linux)
- -make sure vm-spawn-1 is in the available state
- -make sure vm-spawn-1 is assigned to ESXi host in the Virtual Hosts part of 
the site
- -make sure vcld is running on your management node and is regularly checking 
in to the database
- -make sure your management node is in the AllManagementNodes group
- -make sure the schedule associated with vm-spawn-1 is available during the 
time you've selected for your reservation (if you haven't messed with your 
schedules, this shouldn't be an issue)

I think I covered everything.  Let us know what you find.

Josh

On Wednesday June 09, 2010, Waldron, Michael H wrote:
 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  

Re: Reg: JIRA issue VCL-202

2010-06-09 Thread Kiran N
Josh,
Are there any updates on setting up 2 desktops/laptops/blades so that i can
set up the VCL for testing.
Also, as suggested by Aaron the perl code has been changed to some extent so
has anyone incorporated Milen's changes to new version for connecting to
Derby database.
Please let me know since I am willing to test the VCL code with derby and I
need the updated perl modules.


On Wed, Jun 2, 2010 at 1:49 PM, Josh Thompson josh_thomp...@ncsu.eduwrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Really, just about all of the web code could be tested using two desktops
 or
 even laptops.  You would just need to install the web, database, and
 management node software on one, and vmware free server and some VMs on the
 other.  That would at least be easier than finding and setting up blade
 servers.

 Josh

 On Wednesday June 02, 2010, Kiran N wrote:
  Thanks Josh for your suggestion !
  Even I am wondering about  the best possible way to get it tested.
  In case there is no other option then I would be needing a set of blades
   and some pool of computers rite?
  Meanwhile, in case anyone else has known of a better option pls suggest.
 
  On Wed, Jun 2, 2010 at 12:37 PM, Josh Thompson
 josh_thomp...@ncsu.eduwrote:
   -BEGIN PGP SIGNED MESSAGE-
   Hash: SHA1
  
   Kiran,
  
   Unfortunately, we don't actually have a default set of images
 available.
The
   entries that come in the image table are there as examples for when
   people are
   creating their own base images.  We probably should remove them and put
   examples online somewhere instead.  What do others on the list think
   about this?
  
   We don't currently have a good solution for the fact that you really
 need
   a full VCL install to do much useful development, and doing a full
   install isn't
   a simple thing.
  
   Josh
  
   On Tuesday June 01, 2010, Kiran N wrote:
Thank you Josh!
The plan sounds good to me since there are actually lot of code
 changes
  
   and
  
its important we document that correctly.
   
I have a suggestion that while we are waiting for that , there are
 few
things I need access to:
There are some set of default images in database image table. I
 wanted
to initiate the process of making a reservation on any one of those
images. I needed that to test New reservation, Block reservation. So,
in case
  
   there
  
is any captured image which is used by VCL for testing purposes
 please
  
   let
  
me know.This would in turn also need some computer table entries too.
Overall, I would be needing some additional test data for me to test
all the php files.
Please let me know what can be done on that!
   
Also I have submitted the ICLA form
http://www.apache.org/licenses/#clas
  
   .
  
Please let me know if there is anything else I am supposed to do!
Any suggestions are welcome!
   
On Tue, Jun 1, 2010 at 11:27 AM, Josh Thompson
  
   josh_thomp...@ncsu.eduwrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Kiran,

 Wow - that's a lot of changes.  We're in need of more committers,
 and
  
   it
  
 sounds like you've done a lot of work already.  So, this could be
 very beneficial.

 As I read this, I realized we (the Apache VCL community) don't have
 any guidelines in place for contributing modifications that affect
 large portions
 of the code.  I just composed another message to this list titled
 guidelines
 for contributing large modifications to establish some guidelines.

 Before discussing your contributions further, lets wait on that
 process to get
 worked out so that this can be contributed in a way that most
 benefits the community.

 Thanks,
 Josh

 On Friday May 28, 2010, Kiran N wrote:
  Hello All,
  I have been studying VCL code and I want to be a contributor to
 the
  
   VCL
  
  development. I will identify my work as related to JIRA issue
  VCL-202(in database) started by Milen Paskov. There are few
 things
  I have been

 working

  on and would like to share here.
 
 - Modified vcl.sql script to connect to Apache derby database
  and

 create

 the database with the tables and data as in mysql. Please find
  the vcl-derby.sql attached with this email.
 - I have been working on the PHP front end code so that it can
  connect to both mysql and Apache derby database. I am not sure if
 I
  need to contibute to this by creating a new JIRA issue number.
  Please advise on this. - Regarding changes to the PHP front end,
 I
  have
  
   coded
  
  a new 'param.php' file which changes the database data fetch or
  
   update
  
  statements based on the type of database. I also assigns/creates
  some global variables. As stated in JIRA issue VCL-202 , there
 are
  certain keywords ('user', 'end', 

Re: showTimeTable function

2010-06-09 Thread My LinuxHAList
 Mike has already mentioned some of these items, but I'll list them all out
 together to make it easier to check.

 - -put No Apps(Linux) in the allVMimages group

It belong to allVMImages (and nothing else)

 - -create a new computer group named All VMs
 - -map the allVMimages image group to the All VMs computer group

allVMImags maps to AllVMs and nothing else.

 - -put vm-spawn-1 and any other VMs you've created in the All VMs computer
 group

vm-spawn-1 and vm-base10-v1 are grouped to AllVMs
vmnode2.local (my ESXi host) is mapped to allComputers (and nothing else).

 - -add All VMs to the VCL node on the privilege tree with the available
 attribute

Completed this one.

 - -map the AllManagementNodes management node group to the All VMs computer
 group

allManagementNodes is mapped to AllVMs and nothing else.

 - -make sure the computer specs for vm-spawn-1 are greater than or equal to 
 the
 image specs for No Apps(Linux)

They are equal.

 - -make sure vm-spawn-1 is in the available state

Yes.

 - -make sure vm-spawn-1 is assigned to ESXi host in the Virtual Hosts part of
 the site

Yes.

 - -make sure vcld is running on your management node and is regularly checking
 in to the database
Yes.

 - -make sure your management node is in the AllManagementNodes group

Yes.

 - -make sure the schedule associated with vm-spawn-1 is available during the
 time you've selected for your reservation (if you haven't messed with your
 schedules, this shouldn't be an issue)

Did not mess with this. I think it's 24x7.

And now when I select No Apps (Linux) it says Estimated Load Time 
5 Minutes.

Thanks Mike, Josh, List.

I see My Reservation eventually failed. It is a progress.

Thanks


 I think I covered everything.  Let us know what you find.

 Josh

 On Wednesday June 09, 2010, Waldron, Michael H wrote:
 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          | 

RE: Reservation time-out

2010-06-09 Thread Roger Herling
thanks Mike

Roger Herling
Sr. Desktop Administrator
Marist College
PH: 845-575-3347



From:
Waldron, Michael H mwald...@email.unc.edu
To:
'vcl-dev@incubator.apache.org' vcl-dev@incubator.apache.org
Date:
06/09/2010 10:07 AM
Subject:
RE: Reservation time-out



Roger,

Got to Manage Images and Edit Image Profiles. Edit the image and expand 
the Advanced Options list. Change the setting for 'Check for logged in 
user' to No.


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: Roger Herling [mailto:roger.herl...@marist.edu] 
Sent: Wednesday, June 09, 2010 10:04 AM
To: vcl-dev@incubator.apache.org
Cc: vcl-u...@incubator.apache.org
Subject: Reservation time-out

I am working on a pilot that is going to require a blade to stay imaged 
for a week at a time.  I have extended the time to 166hours but the image 
times out if not logged on.  How do I prevent this from happening?


Roger Herling
Sr. Desktop Administrator
Marist College
PH: 845-575-3347