No, the "noimage" image should NOT be deleted.  I said in the previous
post that if you had deleted it that it needs to be added back.  I've
seen this done before.

Your database entries look correct.  Please send the vcld.log output
from the reservation where the "Failed to update private IP address"
error occurred.

-Andy

On Tue, Sep 13, 2011 at 3:07 PM, Jeries, Ibrahim (Student)
<ibrahim.jeri...@student.anglia.ac.uk> wrote:
> 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 |
> +----+--------------------+------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+-------+--------------+-----------------------------------+----------------------------------------------------------------------------+--------------------+
> |  4 | noimage            | No Image   |       1 |          1 |    2 |        
> NULL |      0 |             1 |            0 |         10 |          NULL |   
>        0 |       0 |    0 | NULL                |           0 |              
> 0 | vcl     |  1450 | x86          | NULL                              | NULL 
>                                                                       |       
>            0 |
> |  7 | vmwarewinxp-xp7-v0 | xp         |       1 |          1 |   16 |        
>    6 |   1024 |             1 |         1990 |       1000 |          NULL |   
>       10 |       0 |    0 | 2011-09-10 18:39:56 |           1 |              
> 0 | vcl     | 10240 | x86          | MS Windows SP SP3 standard build. | RDP 
> cannot be used at the moment due to networking permissions. VCL admin. |      
>             4 |
> +----+--------------------+------------+---------+------------+------+-------------+--------+---------------+--------------+------------+---------------+------------+---------+------+---------------------+-------------+----------------+---------+-------+--------------+-----------------------------------+----------------------------------------------------------------------------+--------------------+
> 2 rows in set (0.00 sec)
>
> mysql>
> mysql> SELECT * FROM imagerevision;
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+--------------------+
> | id | imageid | revision | userid | datecreated         | deleted | 
> datedeleted | production | comments | imagename          |
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+--------------------+
> |  4 |       4 |        0 |      1 | 1980-01-01 00:00:00 |       0 | NULL     
>    |          1 | NULL     | noimage            |
> |  7 |       7 |        0 |      1 | 2011-09-10 18:39:56 |       0 | NULL     
>    |          1 | NULL     | vmwarewinxp-xp7-v0 |
> +----+---------+----------+--------+---------------------+---------+-------------+------------+----------+--------------------+
> 2 rows in set (0.00 sec)
> mysql>
>
>
> ________________________________________
> From: Andy Kurth [andy_ku...@ncsu.edu]
> Sent: 13 September 2011 17:19
> To: vcl-user@incubator.apache.org
> Subject: Re: Error at 473 in /var/www/html/vcl/.ht-inc/computers.php
>
> 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
>
>
>

Reply via email to