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 >> >> >
