Re: Error at 473 in /var/www/html/vcl/.ht-inc/computers.php

2011-09-13 Thread Andy Kurth
This looks like it may be a problem in the database.  The line in
computers.php where error is occurring is attempting to print out the
name of the current image loaded on the computer.  The ID of the image
is 4 -- which should be the noimage image: Unkown error type: [8]
Undefined index: 4

By chance delete the noimage image from the database?  If so, you'll
need to add it back.  If not, please include the output from:
SELECT * FROM computer
SELECT * FROM image
SELECT * FROM imagerevision

Regards,
Andy



On Mon, Sep 12, 2011 at 2:25 PM, Jeries, Ibrahim (Student)
ibrahim.jeri...@student.anglia.ac.uk wrote:
 Dear all,



 Can anyone help with following issue?

 The network consist of:

 A CentOS 6.0 x64 server housing VCL 2.2.1 Management node, Web components
 and MySQL db. It is also a DHCP server serving both, the LAN (private) and
 WAN (public) networks.

 An ESXi 4.1 hypervisor housing 2 Virtual Machines (VMs) at the moment, 1 VM
 is an XP SP3, standard build with Cygwin fully functional. The 2nd VM is
 a BackTrack 5 r1 (Debian/Ubuntu based) with SSH enabled.

 Each machine have have 2 NICs, a public NIC connecting to the internet and a
 private NIC for the VCL management traffic as well as LAN connectivity.



 VCL was fully functional and allowed me to successfully create a base image
 of the XP VM. I then added the XP base image to a group (allVMImage) via the
 web interface using the default “admin” account.

 I then requested a “New reservation” of that XP image. 2 mins later while
 processing the reservation, it failed with error “Confirming image exists
 (22) Failed to update private IP address”.



 Since, the “New Reservation” page displays the normal reservation options
 but with a line of red text “Selection not currently available” and the
 “View Time Table” button instead of the “Reserve/submit” button.

 Clicking the “View time table” button shows a blank page with a single line:
 “There are currently no computers available that can run the application you
 selected.”

 I am unable to follow this mail archive suggestion:
 http://www.mail-archive.com/vcl-dev@incubator.apache.org/msg01706.html
 because if I navigate to Mange Computers - All VM Computers, or
 allComputers, or newvmimages (Edit computer information) I get the following
 error:

 Computers

 Error encountered
 Unkown error type: [8] Undefined index: 4
 Error at 473 in /var/www/html/vcl/.ht-inc/computers.php



 And if I try commenting out line 3720 through 3734 in utils.php as per:
 http://www.mail-archive.com/vcl-dev@incubator.apache.org/msg01588.html
 the VCL web portal does not load up (blank browser page), tested in FireFox
 6.0, IE 8 and Chrome 4.1.249..



 All of the above was setup according to VCL docs:
 https://cwiki.apache.org/VCL/vcl-221-installation.html.

 What I would really like, is to:

 1)   Be able to place new reservation again

 2)   Create a base image of the Backtrack VM and make it an available
 image for users to reserve and use.



 One last thing, I had to crate an additional ESXi profile to point to the
 correct Datastore should this matter.



 Any help/pointers are greatly appreciated.



 Kind regards,



 Ibrahim


RE: Error at 473 in /var/www/html/vcl/.ht-inc/computers.php

2011-09-13 Thread Jeries, Ibrahim (Student)
Andy, 
Many thanks. 
I can confirm that id 4 in the image table is the “no image” as you explained. 
However, I am unable to delete it when issuing the DELETE command while using 
the VCL database.
mysql DELETE FROM image WHERE id=4;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key 
constraint fails (`vcl_db`.`computer`, CONSTRAINT `computer_ibfk_36` FOREIGN 
KEY (`currentimageid`) REFERENCES `image` (`id`) ON UPDATE CASCADE)
If attempted using phpMyAdmin, the following is displayed: 
Error
SQL query:
DELETE FROM `vcl_db`.`image` WHERE `image`.`id` =4
MySQL said: Documentation
#1451 - Cannot delete or update a parent row: a foreign key constraint fails 
(`vcl_db`.`computer`, CONSTRAINT `computer_ibfk_36` FOREIGN KEY 
(`currentimageid`) REFERENCES `image` (`id`) ON UPDATE CASCADE)
Please note, the self created ESXi profile “image” field is currently pointing 
to the XP base image for some reason should this make a difference? 
Please see table’s info below as requested. 

Regards,
Ibrahim

Database changed
mysql SELECT * FROM computer;
++-+-++++-+-+---++---+-+--++--+---+---+++---+-+---+---+--+--++--++--+-+--+--+
| id | stateid | ownerid | platformid | scheduleid | currentimageid | 
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 |   
4 |   4 | 12285 |  4 |  1990 |1000 | esxi | 
172.16.20.20   | NULL | NULL  | NULL  | 
blade  |  6 | hda   |   0 |   | NULL  | 
NULL | NULL | NULL   | NULL | NULL   | NULL | NULL| NULL | NULL 
|
|  3 |  10 |   1 |  1 |  1 |  4 |   
4 |   4 |  1024 |  1 |  1990 |1000 | vm1  | 
123.456.789.01 | 172.16.20.100| 00:50:56:00:00:03 | 00:50:56:00:00:04 | 
virtualmachine |  7 | hda   |   0 |   | NULL  | 
NULL | NULL | NULL   | NULL | NULL   | NULL | NULL|1 | NULL 
|
|  4 |   5 |   1 |  1 |  1 |  7 |   
7 |   7 |  1024 |  1 |  1990 |1000 | vm2  | 
123.456.789.02 | 172.16.20.101| 00:50:56:00:00:05 | 00:50:56:00:00:06 | 
virtualmachine |  7 | hda   |   0 |   | NULL  | 
NULL | NULL | NULL   | NULL | NULL   | NULL | NULL|1 | NULL 
|
++-+-++++-+-+---++---+-+--++--+---+---+++---+-+---+---+--+--++--++--+-+--+--+
3 rows in set (0.00 sec)

mysql SELECT * FROM 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 |