Re: Reservation always in Pending-state

2010-12-03 Thread Andy Kurth 

Hello,
Sorry for the delay.  I believe the problem is caused by the 
imagerevision ID.  The value set for the request is 7 but there is no 
entry in the imagerevision table with ID=7.  The imagerevision entry for 
your new image is 5.  Change reservation.imagerevisionid to 5.  This 
should allow the imaging reservation to proceed.


Hope this helps,
Andy

On 11/24/2010 11:16 AM, Mauricio Cesar Ramirez Torres wrote:

This is the content in my database.


Last login: Tue Nov 23 18:42:53 2010
[r...@vcl ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66394
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql use vcl;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql select * from request;
++-++-+---++--+-+-+-+-+--+---+
| id | stateid | userid | laststateid | logid | forimaging | test |
preload | start | end | daterequested | datemodified | checkuser |
++-++-+---++--+-+-+-+-+--+---+
| 1 | 16 | 1 | 16 | 0 | 1 | 0 | 0 | 2010-11-12 17:10:06 | 2010-11-12
19:10:06 | 2010-11-12 17:10:06 | NULL | 1 |
| 10 | 14 | 1 | 13 | 3 | 0 | 0 | 0 | 2010-11-16 16:45:00 | 2010-11-16
18:00:00 | 2010-11-16 16:54:44 | NULL | 1 |
| 12 | 14 | 1 | 13 | 4 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
19:15:00 | 2010-11-16 18:01:36 | NULL | 1 |
| 13 | 14 | 2 | 19 | 0 | 0 | 0 | 0 | 2010-11-16 18:45:00 | 2010-11-16
19:05:00 | 2010-11-16 18:52:07 | NULL | 1 |
| 14 | 14 | 1 | 13 | 5 | 0 | 0 | 0 | 2010-11-17 17:15:00 | 2010-11-17
18:00:00 | 2010-11-17 17:22:47 | NULL | 1 |
| 15 | 14 | 1 | 13 | 6 | 0 | 0 | 0 | 2010-11-17 18:15:00 | 2010-11-17
19:00:00 | 2010-11-17 18:26:02 | NULL | 1 |
| 16 | 14 | 1 | 13 | 7 | 0 | 0 | 0 | 2010-11-18 13:30:00 | 2010-11-18
14:15:00 | 2010-11-18 13:32:22 | NULL | 1 |
| 17 | 14 | 1 | 13 | 8 | 0 | 0 | 0 | 2010-11-18 16:30:00 | 2010-11-18
17:15:00 | 2010-11-18 16:32:26 | NULL | 1 |
| 18 | 14 | 1 | 13 | 10 | 0 | 0 | 0 | 2010-11-18 17:30:00 | 2010-11-18
18:00:00 | 2010-11-18 17:01:08 | NULL | 1 |
| 19 | 14 | 1 | 13 | 11 | 0 | 0 | 0 | 2010-11-18 18:15:00 | 2010-11-18
18:45:00 | 2010-11-18 18:09:18 | NULL | 1 |
| 20 | 14 | 1 | 13 | 12 | 0 | 0 | 0 | 2010-11-18 19:00:00 | 2010-11-18
19:45:00 | 2010-11-18 19:09:35 | NULL | 1 |
| 21 | 14 | 1 | 13 | 13 | 0 | 0 | 0 | 2010-11-19 08:30:00 | 2010-11-19
09:15:00 | 2010-11-19 08:38:46 | NULL | 1 |
++-++-+---++--+-+-+-+-+--+---+
12 rows in set (0.00 sec)

mysql select * from reservation;
++---++-+-+--+--+-+--+
| id | requestid | computerid | imageid | imagerevisionid |
managementnodeid | remoteIP | lastcheck | pw |
++---++-+-+--+--+-+--+
| 2 | 1 | 2 | 7 | 7 | 1 | NULL | NULL | NULL |
| 11 | 10 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 13 | 12 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 14 | 13 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 15 | 14 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 16 | 15 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 17 | 16 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 18 | 17 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 19 | 18 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 20 | 19 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 21 | 20 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
| 22 | 21 | 2 | 7 | 5 | 1 | NULL | -00-00 00:00:00 | NULL |
++---++-+-+--+--+-+--+
12 rows in set (0.00 sec)

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 |

Re: VCL installation issues

2010-12-03 Thread Nikhil Talpallikar 
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 |
++-+---+-++--+-++---+--++---++-+--+-+-++-+--+--+-+---++
|  1 | centos5image-centos | centos_base_1 |   1 |  1 |   29 |
1 | 64 | 2 |  500 | 10 |
1 | 10 |   0 |0 | 2010-11-24 21:36:34 |   1 |
   0 | vcl | 1450 | x86  | NULL| NULL  |
 0 |
|  2 | centos_vm_1 | centos_vm |   1 |  1 |   36 |
1 |   1024 | 1 | 1000 |   1000 |
1 | 10 |   0 |0 | 2010-11-24 21:39:32 |   1 |
   0 | vcl | 1450 | x86  | NULL| NULL  |
 0 |
|  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 |
++-+---+-++--+-++---+--++---++-+--+-+-++-+--+--+-+---++
3 rows in set (0.00 sec)

mysql select * from imagerevision;
++-+--++-+-+-++--+-+
| id | imageid | revision | userid | datecreated | deleted |
datedeleted | production | comments | imagename   |
++-+--++-+-+-++--+-+
|  1 |   1 |1 |  1 | 2010-11-24 21:37:22 |   0 | NULL
 |  1 | NULL | centos5image-centos |
|  2 |   2 |1 |  1 | 2010-11-24 21:40:08 |   0 | NULL
 |  1 | NULL | centos_vm_1 |
|  4 |   4 |0 |  1 | 1980-01-01 00:00:00 |   0 | NULL
 |  1 | NULL | noimage |
++-+--++-+-+-++--+-+
3 rows in set (0.00 sec)

mysql select * from resource;
+++---+
| id | resourcetypeid | subid |
+++---+
| 10 | 12 | 1 |
| 11 | 12 | 2 |
| 12 | 12 | 3 |
|  4 | 13 | 4 |
|  8 | 15 | 1 |
|  9 | 16 | 1 |
+++---+
6 rows in set (0.00 sec)

mysql select * from resourcegroup;
+++--++
| id | name   | ownerusergroupid | resourcetypeid |
+++--++
|  1 | allComputers   |3 | 12 |
|  2 | allImages  |3 | 13 |
|  3 | allManagementNodes |3 | 16 |
|  4 | allSchedules   |3 | 15 |
|  5 | All VM Computers   |3 | 12 |
|  8 | newimages  |3 | 12 |
|  9 | newvmimages|3 | 12 |
| 10 | allVMimages|3 | 13 |
| 11 | allvmhosts |3 | 12 |
| 12 | allvmguests|3 | 12 |
+++--++
10 rows in set (0.00 sec)

mysql select * from resourcegroupmembers;
++-+
| resourceid | resourcegroupid |
++-+
| 10 |   1 |
|  9 |   3 |
|  8 |   4 |
| 11 |   5 |
| 12 |   5 |
| 10 |   8 |
| 11 |   9 |
| 12 |   9 |
| 10 |  11 |
| 11 |  12 |
| 12 |  12 |