Hello, The problem is due to you having multiple computers in the database with identical hostnames and one of the computers is flagged as deleted. There is a minor bug which isn't catching this condition. I'll fix that for the next release. In the meantime, start by changing the computer.hostname value for the deleted computer with id = 3:
mysql -e "UPDATE computer set hostname = "flake-deleted" WHERE id = 3;" vcl This should allow you to proceed. I would recommend formulating a VM naming scheme. Computer id = 4 looks correct at first glance, but you may run into other problems with identically named computers. On Tue, Apr 15, 2014 at 10:04 AM, zvclproject zvclproject < [email protected]> wrote: > hello Andy, > > please check the attachment that contain the select statements results. > > regards > > > > On Tue, Apr 15, 2014 at 9:10 AM, Andy Kurth <[email protected]> wrote: > >> Hello, >> Something isn't right in the database. Please send the output from the >> following: >> mysql -e 'SELECT * FROM computer;' vcl >> mysql -e 'SELECT * FROM vmhost;' vcl >> mysql -e 'SELECT * FROM image;' vcl >> mysql -e 'SELECT * FROM imagerevision;' vcl >> >> Regards, >> Andy >> >> >> On Sun, Apr 13, 2014 at 2:18 PM, zvclproject zvclproject < >> [email protected]> wrote: >> >>> also more logs >>> >>> 2014-04-13 14:09:40|29814|utils.pm:get_management_node_info(5456)|retrieving >>> current management node info for 'mgmt' from database, cached data is >>> stale: 7159 seconds old >>> 2014-04-13 14:09:40|29814|utils.pm:get_management_node_info(5603)|retrieved >>> management node info: 'mgmt' (mgmt) >>> 2014-04-13 14:09:40|29814|utils.pm:get_user_info(7540)|UID value is not >>> configured for user vclsystem, setting UID to VCL user ID: vclsystem, >>> standalone: 1 >>> 2014-04-13 14:09:40|29814|utils.pm:get_user_info(7540)|UID value is not >>> configured for user umroot, setting UID to VCL user ID: umroot, standalone: >>> 1 >>> 2014-04-13 14:09:40|29814|utils.pm:get_user_info(7540)|UID value is not >>> configured for user tariq, setting UID to VCL user ID: tariq, standalone: 1 >>> 2014-04-13 14:09:40|29814|utils.pm:get_user_info(7540)|UID value is not >>> configured for user root, setting UID to VCL user ID: root, standalone: 1 >>> 2014-04-13 14:09:40|29814|utils.pm:get_local_user_info(7678)|retrieved >>> local user info: >>> |29814| : { >>> |29814| : 1 => { >>> |29814| : "IMid" => "", >>> |29814| : "IMtype" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "IMtypeid" => 1, >>> |29814| : "STANDALONE" => 1, >>> |29814| : "adminlevel" => { >>> |29814| : "name" => "developer" >>> |29814| : }, >>> |29814| : "adminlevelid" => 3, >>> |29814| : "affiliation" => { >>> |29814| : "dataUpdateText" => "", >>> |29814| : "helpaddress" => "nobody\@example.com", >>> |29814| : "name" => "Local", >>> |29814| : "shibname" => undef, >>> |29814| : "shibonly" => 0, >>> |29814| : "sitewwwaddress" => "http://cwiki.apache.org/VCL"; >>> |29814| : }, >>> |29814| : "affiliationid" => 1, >>> |29814| : "audiomode" => "local", >>> |29814| : "bpp" => 16, >>> |29814| : "email" => "root\@localhost", >>> |29814| : "emailnotices" => 0, >>> |29814| : "firstname" => "vcl", >>> |29814| : "height" => 768, >>> |29814| : "id" => 1, >>> |29814| : "lastname" => "admin", >>> |29814| : "lastupdated" => "2007-05-17 09:58:39", >>> |29814| : "localauth" => { >>> |29814| : "lastupdated" => "2007-05-17 09:56:01", >>> |29814| : "lockedout" => 0, >>> |29814| : "passhash" => "151832fc316463884b0e0c0665edcd5c1ad934d6", >>> |29814| : "salt" => "QwkCHLpY" >>> |29814| : }, >>> |29814| : "mapdrives" => 1, >>> |29814| : "mapprinters" => 1, >>> |29814| : "mapserial" => 1, >>> |29814| : "preferredname" => "admin", >>> |29814| : "showallgroups" => 1, >>> |29814| : "uid" => 101, >>> |29814| : "unityid" => "admin", >>> |29814| : "validated" => 1, >>> |29814| : "width" => 1024 >>> |29814| : }, >>> |29814| : 3 => { >>> |29814| : "IMid" => "", >>> |29814| : "IMtype" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "IMtypeid" => 1, >>> |29814| : "STANDALONE" => 1, >>> |29814| : "adminlevel" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "adminlevelid" => 1, >>> |29814| : "affiliation" => { >>> |29814| : "dataUpdateText" => "", >>> |29814| : "helpaddress" => "nobody\@example.com", >>> |29814| : "name" => "Local", >>> |29814| : "shibname" => undef, >>> |29814| : "shibonly" => 0, >>> |29814| : "sitewwwaddress" => "http://cwiki.apache.org/VCL"; >>> |29814| : }, >>> |29814| : "affiliationid" => 1, >>> |29814| : "audiomode" => "local", >>> |29814| : "bpp" => 16, >>> |29814| : "email" => "", >>> |29814| : "emailnotices" => 0, >>> |29814| : "firstname" => "vcl", >>> |29814| : "height" => 768, >>> |29814| : "id" => 3, >>> |29814| : "lastname" => "system", >>> |29814| : "lastupdated" => "2014-04-12 13:18:28", >>> |29814| : "localauth" => { >>> |29814| : "lastupdated" => "2007-05-17 09:56:01", >>> |29814| : "lockedout" => 0, >>> |29814| : "passhash" => "d3f60da09d7a04cb8f3a7e39874fff98e3a4ec19", >>> |29814| : "salt" => "WHfXDYgn" >>> |29814| : }, >>> |29814| : "mapdrives" => 1, >>> |29814| : "mapprinters" => 1, >>> |29814| : "mapserial" => 0, >>> |29814| : "preferredname" => "vcl", >>> |29814| : "showallgroups" => 0, >>> |29814| : "uid" => 3, >>> |29814| : "unityid" => "vclsystem", >>> |29814| : "validated" => 1, >>> |29814| : "width" => 1024 >>> |29814| : }, >>> |29814| : 4 => { >>> |29814| : "IMid" => "", >>> |29814| : "IMtype" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "IMtypeid" => 1, >>> |29814| : "STANDALONE" => 1, >>> |29814| : "adminlevel" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "adminlevelid" => 1, >>> |29814| : "affiliation" => { >>> |29814| : "dataUpdateText" => "", >>> |29814| : "helpaddress" => "nobody\@example.com", >>> |29814| : "name" => "Local", >>> |29814| : "shibname" => undef, >>> |29814| : "shibonly" => 0, >>> |29814| : "sitewwwaddress" => "http://cwiki.apache.org/VCL"; >>> |29814| : }, >>> |29814| : "affiliationid" => 1, >>> |29814| : "audiomode" => "local", >>> |29814| : "bpp" => 16, >>> |29814| : "email" => "tariqghd\@yahoo.com", >>> |29814| : "emailnotices" => 1, >>> |29814| : "firstname" => "umroot", >>> |29814| : "height" => 768, >>> |29814| : "id" => 4, >>> |29814| : "lastname" => "umroot", >>> |29814| : "lastupdated" => "2014-04-01 22:29:59", >>> |29814| : "localauth" => { >>> |29814| : "lastupdated" => "2014-04-01 22:29:59", >>> |29814| : "lockedout" => 0, >>> |29814| : "passhash" => "d4f67b59362d8cca865daba5e5a0f430c4fa1fa3", >>> |29814| : "salt" => "CtWFcR1a" >>> |29814| : }, >>> |29814| : "mapdrives" => 1, >>> |29814| : "mapprinters" => 1, >>> |29814| : "mapserial" => 0, >>> |29814| : "preferredname" => "umroot", >>> |29814| : "showallgroups" => 0, >>> |29814| : "uid" => 4, >>> |29814| : "unityid" => "umroot", >>> |29814| : "validated" => 1, >>> |29814| : "width" => 1024 >>> |29814| : }, >>> |29814| : 5 => { >>> |29814| : "IMid" => "", >>> |29814| : "IMtype" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "IMtypeid" => 1, >>> |29814| : "STANDALONE" => 1, >>> |29814| : "adminlevel" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "adminlevelid" => 1, >>> |29814| : "affiliation" => { >>> |29814| : "dataUpdateText" => "", >>> |29814| : "helpaddress" => "nobody\@example.com", >>> |29814| : "name" => "Local", >>> |29814| : "shibname" => undef, >>> |29814| : "shibonly" => 0, >>> |29814| : "sitewwwaddress" => "http://cwiki.apache.org/VCL"; >>> |29814| : }, >>> |29814| : "affiliationid" => 1, >>> |29814| : "audiomode" => "local", >>> |29814| : "bpp" => 16, >>> |29814| : "email" => "tariqghd\@gmail.com", >>> |29814| : "emailnotices" => 1, >>> |29814| : "firstname" => "Tariq", >>> |29814| : "height" => 768, >>> |29814| : "id" => 5, >>> |29814| : "lastname" => "Daradkeh", >>> |29814| : "lastupdated" => "2014-04-12 14:41:11", >>> |29814| : "localauth" => { >>> |29814| : "lastupdated" => "2014-04-12 14:41:11", >>> |29814| : "lockedout" => 0, >>> |29814| : "passhash" => "a2e06181a02ad4f9eb504f1dbcfde2b211a72402", >>> |29814| : "salt" => "UJWmYUUD" >>> |29814| : }, >>> |29814| : "mapdrives" => 1, >>> |29814| : "mapprinters" => 1, >>> |29814| : "mapserial" => 0, >>> |29814| : "preferredname" => "Tariq", >>> |29814| : "showallgroups" => 0, >>> |29814| : "uid" => 5, >>> |29814| : "unityid" => "tariq", >>> |29814| : "validated" => 1, >>> |29814| : "width" => 1024 >>> |29814| : }, >>> |29814| : 6 => { >>> |29814| : "IMid" => "", >>> |29814| : "IMtype" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "IMtypeid" => 1, >>> |29814| : "STANDALONE" => 1, >>> |29814| : "adminlevel" => { >>> |29814| : "name" => "none" >>> |29814| : }, >>> |29814| : "adminlevelid" => 1, >>> |29814| : "affiliation" => { >>> |29814| : "dataUpdateText" => "", >>> |29814| : "helpaddress" => "nobody\@example.com", >>> |29814| : "name" => "Local", >>> |29814| : "shibname" => undef, >>> |29814| : "shibonly" => 0, >>> |29814| : "sitewwwaddress" => "http://cwiki.apache.org/VCL"; >>> |29814| : }, >>> |29814| : "affiliationid" => 1, >>> |29814| : "audiomode" => "local", >>> |29814| : "bpp" => 16, >>> |29814| : "email" => "tariqghd\@gmail.com", >>> |29814| : "emailnotices" => 1, >>> |29814| : "firstname" => "root", >>> |29814| : "height" => 768, >>> |29814| : "id" => 6, >>> |29814| : "lastname" => "root", >>> |29814| : "lastupdated" => "2014-04-12 14:44:00", >>> |29814| : "localauth" => { >>> |29814| : "lastupdated" => "2014-04-12 14:44:00", >>> |29814| : "lockedout" => 0, >>> |29814| : "passhash" => "46a9f186dd08f87470efff0de09d7e3e718d47e6", >>> |29814| : "salt" => "psCFCFtX" >>> |29814| : }, >>> |29814| : "mapdrives" => 1, >>> |29814| : "mapprinters" => 1, >>> |29814| : "mapserial" => 0, >>> |29814| : "preferredname" => "root", >>> |29814| : "showallgroups" => 0, >>> |29814| : "uid" => 6, >>> |29814| : "unityid" => "root", >>> |29814| : "validated" => 1, >>> |29814| : "width" => 1024 >>> |29814| : } >>> |29814| : } >>> 2014-04-13 14:09:40|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| admin >>> |29814| root >>> |29814| tariq >>> |29814| umroot >>> |29814| vclsystem >>> 2014-04-13 14:09:43|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| Add Local VCL User Account >>> |29814| Set Local VCL User Account Password >>> |29814| Test RPC-XML Access >>> 2014-04-13 14:09:44|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| VCL Base Module >>> |29814| VCL Image State Module >>> |29814| Windows OS Module >>> 2014-04-13 14:09:44|31067|vcld:main(167)|lastcheckin time updated for >>> management node 1: 2014-04-13 14:09:44 >>> 2014-04-13 14:09:45|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| Capture Base Image >>> 2014-04-13 >>> 14:09:46|29814|utils.pm:get_management_node_id(8364)|management_node_id >>> environment variable not set >>> 2014-04-13 >>> 14:09:46|29814|utils.pm:get_management_node_id(8370)|get_managementnode_info(): >>> 1 >>> 2014-04-13 14:09:49|31067|vcld:main(167)|lastcheckin time updated for >>> management node 1: 2014-04-13 14:09:49 >>> 2014-04-13 14:09:51|29814|utils.pm:get_computer_ids(7962)|found >>> computers matching identifier: flake, IDs: 3 4 >>> >>> >>> |29814| ---- WARNING ---- >>> |29814| 2014-04-13 14:09:51|29814|utils.pm:get_computer_info(7819)|zero >>> rows were returned from database select statement: >>> |29814| SELECT DISTINCT >>> |29814| computer.id AS 'computer-id', >>> |29814| computer.stateid AS 'computer-stateid', >>> |29814| computer.ownerid AS 'computer-ownerid', >>> |29814| computer.platformid AS 'computer-platformid', >>> |29814| computer.scheduleid AS 'computer-scheduleid', >>> |29814| computer.currentimageid AS 'computer-currentimageid', >>> |29814| computer.nextimageid AS 'computer-nextimageid', >>> |29814| computer.imagerevisionid AS 'computer-imagerevisionid', >>> |29814| computer.RAM AS 'computer-RAM', >>> |29814| computer.procnumber AS 'computer-procnumber', >>> |29814| computer.procspeed AS 'computer-procspeed', >>> |29814| computer.network AS 'computer-network', >>> |29814| computer.hostname AS 'computer-hostname', >>> |29814| computer.IPaddress AS 'computer-IPaddress', >>> |29814| computer.privateIPaddress AS 'computer-privateIPaddress', >>> |29814| computer.eth0macaddress AS 'computer-eth0macaddress', >>> |29814| computer.eth1macaddress AS 'computer-eth1macaddress', >>> |29814| computer.type AS 'computer-type', >>> |29814| computer.provisioningid AS 'computer-provisioningid', >>> |29814| computer.drivetype AS 'computer-drivetype', >>> |29814| computer.deleted AS 'computer-deleted', >>> |29814| computer.datedeleted AS 'computer-datedeleted', >>> |29814| computer.notes AS 'computer-notes', >>> |29814| computer.lastcheck AS 'computer-lastcheck', >>> |29814| computer.location AS 'computer-location', >>> |29814| computer.dsa AS 'computer-dsa', >>> |29814| computer.dsapub AS 'computer-dsapub', >>> |29814| computer.rsa AS 'computer-rsa', >>> |29814| computer.rsapub AS 'computer-rsapub', >>> |29814| computer.host AS 'computer-host', >>> |29814| computer.hostpub AS 'computer-hostpub', >>> |29814| computer.vmhostid AS 'computer-vmhostid', >>> |29814| computer.vmtypeid AS 'computer-vmtypeid', >>> |29814| state.id AS 'state-id', >>> |29814| state.name AS 'state-name', >>> |29814| provisioning.id AS 'provisioning-id', >>> |29814| provisioning.name AS 'provisioning-name', >>> |29814| provisioning.prettyname AS 'provisioning-prettyname', >>> |29814| provisioning.moduleid AS 'provisioning-moduleid', >>> |29814| module.id AS 'module-id', >>> |29814| module.name AS 'module-name', >>> |29814| module.prettyname AS 'module-prettyname', >>> |29814| module.description AS 'module-description', >>> |29814| module.perlpackage AS 'module-perlpackage', >>> |29814| schedule.id AS 'schedule-id', >>> |29814| schedule.name AS 'schedule-name', >>> |29814| schedule.ownerid AS 'schedule-ownerid', >>> |29814| platform.id AS 'platform-id', >>> |29814| platform.name AS 'platform-name' >>> |29814| FROM >>> |29814| computer >>> |29814| LEFT JOIN (state) ON (state.id = computer.stateid) >>> |29814| LEFT JOIN (platform) ON (platform.id = computer.platformid) >>> |29814| LEFT JOIN ( >>> |29814| provisioning, >>> |29814| module >>> |29814| ) >>> |29814| ON ( >>> |29814| provisioning.id = computer.provisioningid >>> |29814| AND module.id = provisioning.moduleid >>> |29814| ) >>> |29814| LEFT JOIN (schedule) ON (schedule.id = computer.scheduleid) >>> |29814| WHERE >>> |29814| computer.deleted != '1' >>> |29814| AND >>> |29814| computer.id = '3' >>> |29814| ( 0) utils.pm, get_computer_info (line: 7819) >>> |29814| (-1) image.pm, setup_capture_base_image (line: 566) >>> |29814| (-2) image.pm, setup (line: 498) >>> |29814| (-3) vcld, setup_management_node (line: 890) >>> >>> 2014-04-13 14:09:51|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| Capture Base Image >>> 2014-04-13 14:09:54|31067|vcld:main(167)|lastcheckin time updated for >>> management node 1: 2014-04-13 14:09:54 >>> 2014-04-13 14:09:59|31067|vcld:main(167)|lastcheckin time updated for >>> management node 1: 2014-04-13 14:09:59 >>> ^C >>> [root@mgmt vcl]# tail -f /var/log/vcld.log >>> >>> |29814| (-3) vcld, setup_management_node (line: 890) >>> >>> 2014-04-13 14:09:51|29814|utils.pm:setup_get_array_choice(9769)|choices >>> argument: >>> |29814| Capture Base Image >>> >>> >>> >>> On Sun, Apr 13, 2014 at 2:15 PM, zvclproject zvclproject < >>> [email protected]> wrote: >>> >>>> hello, >>>> i still can't capture an image i'm using the KVM hypervisor and i make >>>> a widows server 2003 VM on a computation node (VM host) and i have the >>>> management node with its components installed but i get following error >>>> User who will own the image: admin (ID: 1) >>>> >>>> Enter the hostname or IP address of the computer to be captured: ('c' >>>> to cancel): flake >>>> ERROR: unable to retrieve information for computer ID: 3 >>>> >>>> and below the logs for that error >>>> >>>> thank you >>>> tariq >>>> >>>> >>>> 29814| ---- WARNING ---- >>>> |29814| 2014-04-13 14:09:51|29814|utils.pm:get_computer_info(7819)|zero >>>> rows were returned from database select statement: >>>> |29814| SELECT DISTINCT >>>> |29814| computer.id AS 'computer-id', >>>> |29814| computer.stateid AS 'computer-stateid', >>>> |29814| computer.ownerid AS 'computer-ownerid', >>>> |29814| computer.platformid AS 'computer-platformid', >>>> |29814| computer.scheduleid AS 'computer-scheduleid', >>>> |29814| computer.currentimageid AS 'computer-currentimageid', >>>> |29814| computer.nextimageid AS 'computer-nextimageid', >>>> |29814| computer.imagerevisionid AS 'computer-imagerevisionid', >>>> |29814| computer.RAM AS 'computer-RAM', >>>> |29814| computer.procnumber AS 'computer-procnumber', >>>> |29814| computer.procspeed AS 'computer-procspeed', >>>> |29814| computer.network AS 'computer-network', >>>> |29814| computer.hostname AS 'computer-hostname', >>>> |29814| computer.IPaddress AS 'computer-IPaddress', >>>> |29814| computer.privateIPaddress AS 'computer-privateIPaddress', >>>> |29814| computer.eth0macaddress AS 'computer-eth0macaddress', >>>> |29814| computer.eth1macaddress AS 'computer-eth1macaddress', >>>> |29814| computer.type AS 'computer-type', >>>> |29814| computer.provisioningid AS 'computer-provisioningid', >>>> |29814| computer.drivetype AS 'computer-drivetype', >>>> |29814| computer.deleted AS 'computer-deleted', >>>> |29814| computer.datedeleted AS 'computer-datedeleted', >>>> |29814| computer.notes AS 'computer-notes', >>>> |29814| computer.lastcheck AS 'computer-lastcheck', >>>> |29814| computer.location AS 'computer-location', >>>> |29814| computer.dsa AS 'computer-dsa', >>>> |29814| computer.dsapub AS 'computer-dsapub', >>>> |29814| computer.rsa AS 'computer-rsa', >>>> |29814| computer.rsapub AS 'computer-rsapub', >>>> |29814| computer.host AS 'computer-host', >>>> |29814| computer.hostpub AS 'computer-hostpub', >>>> |29814| computer.vmhostid AS 'computer-vmhostid', >>>> |29814| computer.vmtypeid AS 'computer-vmtypeid', >>>> |29814| state.id AS 'state-id', >>>> |29814| state.name AS 'state-name', >>>> |29814| provisioning.id AS 'provisioning-id', >>>> |29814| provisioning.name AS 'provisioning-name', >>>> |29814| provisioning.prettyname AS 'provisioning-prettyname', >>>> |29814| provisioning.moduleid AS 'provisioning-moduleid', >>>> |29814| module.id AS 'module-id', >>>> |29814| module.name AS 'module-name', >>>> |29814| module.prettyname AS 'module-prettyname', >>>> |29814| module.description AS 'module-description', >>>> |29814| module.perlpackage AS 'module-perlpackage', >>>> |29814| schedule.id AS 'schedule-id', >>>> |29814| schedule.name AS 'schedule-name', >>>> |29814| schedule.ownerid AS 'schedule-ownerid', >>>> |29814| platform.id AS 'platform-id', >>>> |29814| platform.name AS 'platform-name' >>>> |29814| FROM >>>> |29814| computer >>>> |29814| LEFT JOIN (state) ON (state.id = computer.stateid) >>>> |29814| LEFT JOIN (platform) ON (platform.id = computer.platformid) >>>> |29814| LEFT JOIN ( >>>> |29814| provisioning, >>>> |29814| module >>>> |29814| ) >>>> |29814| ON ( >>>> |29814| provisioning.id = computer.provisioningid >>>> |29814| AND module.id = provisioning.moduleid >>>> |29814| ) >>>> |29814| LEFT JOIN (schedule) ON (schedule.id = computer.scheduleid) >>>> |29814| WHERE >>>> |29814| computer.deleted != '1' >>>> |29814| AND >>>> |29814| computer.id = '3' >>>> |29814| ( 0) utils.pm, get_computer_info (line: 7819) >>>> |29814| (-1) image.pm, setup_capture_base_image (line: 566) >>>> |29814| (-2) image.pm, setup (line: 498) >>>> |29814| (-3) vcld, setup_management_node (line: 890) >>>> >>>> 2014-04-13 14:09:51|29814|utils.pm:setup_get_array_choice(9769)|choices >>>> argument: >>>> |29814| Capture Base Image >>>> >>>> >>> >> >
