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
