Hello Tina, I just ran one more time, a fresh 4.4 and see no issues at least in getting the simulator up and even created a data center. The state field was added in 4.3 version, error "unknown column of state ..", signifies that your DB version is not 4.4. Can we please check version table in cloud db?
Just to confirm, you are using 4.4 a fresh or upgraded to 4.4 from other versions and if yes, may be we just wanted to check whether your upgrade is successful? Santhosh ________________________________________ From: Konstantina Chremmou [konstantina.chrem...@citrix.com] Sent: Monday, April 07, 2014 8:24 AM To: dev@cloudstack.apache.org Subject: RE: can't get the simulator running on 4.4 The first two commands of Step 1 run ok. The third one gives me errors, e.g. the first one was: Unable to execute C:\CLOUD\cloudstack\developer/target/db/templates.simulator.sql: Unknown column 'state' in 'field list' I fixed this and the others after it (perhaps incorrectly?) with the following patch: diff --git a/setup/db/hypervisor_capabilities.simulator.sql b/setup/db/hypervisor_capabilities.simulator.sql index 32f9aaa..5deed87 100755 --- a/setup/db/hypervisor_capabilities.simulator.sql +++ b/setup/db/hypervisor_capabilities.simulator.sql @@ -16,4 +16,4 @@ -- under the License. -INSERT INTO `cloud`.`hypervisor_capabilities` (uuid, hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit, max_hosts_per_cluster, storage_motion_supported, vm_snapshot_enabled) values (UUID(), 'Simulator', 'default', 50, 1, 6, NULL, 0, 1); +INSERT INTO `cloud`.`hypervisor_capabilities` (uuid, hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_data_volumes_limit) values (UUID(), 'Simulator', 'default', 50, 1, 6); diff --git a/setup/db/templates.simulator.sql b/setup/db/templates.simulator.sql index 25e91bd..bbad091 100755 --- a/setup/db/templates.simulator.sql +++ b/setup/db/templates.simulator.sql @@ -16,7 +16,7 @@ -- under the License. -INSERT INTO `cloud`.`vm_template` (id, uuid, unique_name, name, public, created, type, hvm, bits, account_id, url, checksum, enable_password, display_text, format, guest_os_id, featured, cross_zones, hypervisor_type, state) - VALUES (100, UUID(), 'simulator-domR', 'SystemVM Template (simulator)', 0, now(), 'SYSTEM', 0, 64, 1, 'http://nfs1.lab.vmops.com/templates/routing/debian/latest/systemvm.vhd.bz2', '', 0, 'SystemVM Template (simulator)', 'VHD', 15, 0, 1, 'Simulator','Active'); -INSERT INTO `cloud`.`vm_template` (id, uuid, unique_name, name, public, created, type, hvm, bits, account_id, url, checksum, enable_password, display_text, format, guest_os_id, featured, cross_zones, hypervisor_type,state) - VALUES (111, UUID(), 'simulator-Centos', 'CentOS 5.3(64-bit) no GUI (Simulator)', 1, now(), 'BUILTIN', 0, 64, 1, 'http://nfs1.lab.vmops.com/templates/centos53-x86_64/latest/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2', '', 0, 'CentOS 5.3(64-bit) no GUI (Simulator)', 'VHD', 11, 1, 1, 'Simulator','Active'); +INSERT INTO `cloud`.`vm_template` (id, uuid, unique_name, name, public, created, type, hvm, bits, account_id, url, checksum, enable_password, display_text, format, guest_os_id, featured, cross_zones, hypervisor_type) + VALUES (500, UUID(), 'simulator-domR', 'SystemVM Template (simulator)', 0, now(), 'SYSTEM', 0, 64, 1, 'http://nfs1.lab.vmops.com/templates/routing/debian/latest/systemvm.vhd.bz2', '', 0, 'SystemVM Template (simulator)', 'VHD', 15, 0, 1, 'Simulator'); +INSERT INTO `cloud`.`vm_template` (id, uuid, unique_name, name, public, created, type, hvm, bits, account_id, url, checksum, enable_password, display_text, format, guest_os_id, featured, cross_zones, hypervisor_type) + VALUES (511, UUID(), 'simulator-Centos', 'CentOS 5.3(64-bit) no GUI (Simulator)', 1, now(), 'BUILTIN', 0, 64, 1, 'http://nfs1.lab.vmops.com/templates/centos53-x86_64/latest/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2', '', 0, 'CentOS 5.3(64-bit) no GUI (Simulator)', 'VHD', 11, 1, 1, 'Simulator'); -- After that running the simulator fails, please see here for the stack trace: http://pastebin.com/dHi39RiL I don't have any of these issues on master. > -----Original Message----- > From: Santhosh Edukulla [mailto:santhosh.eduku...@citrix.com] > Sent: 07 April 2014 12:17 PM > To: dev@cloudstack.apache.org > Subject: RE: can't get the simulator running on 4.4 > > Hello Tina, > > I just pulled the latest 4.4 code and ran to get the simulator up as per > instructions, i was able to get the simulator up with no issues and login as > well, It was a fresh install. > > I didn't ran the test cases though ,but there should not be any issues with it > as well. > > Thanks! > Santhosh > ________________________________________ > From: Konstantina Chremmou [konstantina.chrem...@citrix.com] > Sent: Monday, April 07, 2014 6:20 AM > To: dev@cloudstack.apache.org > Subject: can't get the simulator running on 4.4 > > Hi all, > > I've tried the instructions on > https://cwiki.apache.org/confluence/display/CLOUDSTACK/Validating+check > -ins+for+your+local+changes%2C+using+Simulator > > They work ok on master, but not on 4.4. I can't deploy the simulator database > without making changes to the files > setup\db\hypervisor_capabilities.simulator.sql and templates.simulator.sql > (complains about unknown columns), and even when this command > succeeds I see more errors when trying to start the simulator. > > Any suggestions? Could it be a case of missing patches that have been > applied to master but not to 4.4? > > Thanks, > Tina
