Skip to content

Commit ce390e9

Browse files
author
Marcus Sorensen
committed
update devcloud-kvm sql file for easier dev deployment
1 parent ad051e8 commit ce390e9

1 file changed

Lines changed: 5 additions & 24 deletions

File tree

‎tools/devcloud-kvm/devcloud-kvm.sql‎

Lines changed: 5 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -15,27 +15,8 @@
1515
-- specific language governing permissions and limitations
1616
-- under the License.
1717

18-
19-
INSERT INTO `cloud`.`disk_offering` (id, name, uuid, display_text, created, use_local_storage, type, disk_size) VALUES (17, 'tinyOffering', UUID(), 'tinyOffering', NOW(), 1, 'Service', 0);
20-
INSERT INTO `cloud`.`service_offering` (id, cpu, speed, ram_size) VALUES (17, 1, 100, 128);
21-
INSERT INTO `cloud`.`disk_offering` (id, name, uuid, display_text, created, type, disk_size) VALUES (18, 'tinyDiskOffering', UUID(), 'tinyDiskOffering', NOW(), 'Disk', 1073741824);
22-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','router.ram.size', '100');
23-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','router.cpu.mhz','100');
24-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','console.ram.size','100');
25-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','console.cpu.mhz', '100');
26-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','ssvm.ram.size','100');
27-
INSERT INTO `cloud`.`configuration` (instance, name,value) VALUE('DEFAULT','ssvm.cpu.mhz','100');
28-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'system.vm.use.local.storage', 'true');
29-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.workers', '3');
30-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.delay', '60');
31-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'expunge.interval', '60');
32-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.ec2.api', 'true');
33-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'enable.s3.api', 'true');
34-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'host', '192.168.100.10');
35-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'management.network.cidr', '192.168.100.0/24');
36-
INSERT INTO `cloud`.`configuration` (instance, name, value) VALUE('DEFAULT', 'secstorage.allowed.internal.sites', '192.168.0.0/8');
37-
UPDATE `cloud`.`configuration` SET value='10' where name = 'storage.overprovisioning.factor';
38-
UPDATE `cloud`.`configuration` SET value='10' where name = 'cpu.overprovisioning.factor';
39-
UPDATE `cloud`.`configuration` SET value='10' where name = 'mem.overprovisioning.factor';
40-
UPDATE `cloud`.`vm_template` SET unique_name="tiny CentOS 6.3",name="tiny CentOS 6.3",url="http://marcus.mlsorensen.com/cloudstack-extras/tiny-centos-63.qcow2",checksum="4bbb806aa8570f4dfac13b4c38ea1603",display_text="tiny CentOS 6.3",format='QCOW2',hypervisor_type='KVM' where id=5;
41-
UPDATE `cloud`.`vm_template` SET url="http://dontdownloadthistemplate" where id=4;
18+
UPDATE cloud.configuration SET value=8096 WHERE name='integration.api.port';
19+
UPDATE cloud.configuration SET value='true' WHERE name='system.vm.use.local.storage';
20+
UPDATE cloud.configuration SET value='false' WHERE name='consoleproxy.restart';
21+
UPDATE cloud.configuration SET value='172.17.10.10' WHERE name='host';
22+
UPDATE cloud.vm_template SET unique_name="tiny CentOS 6.3",name="tiny CentOS 6.3",url="http://marcus.mlsorensen.com/cloudstack-extras/tiny-centos-63.qcow2",checksum="4bbb806aa8570f4dfac13b4c38ea1603",display_text="tiny CentOS 6.3",format='QCOW2',hypervisor_type='KVM' WHERE id=4;

0 commit comments

Comments
 (0)