Ensuring system user has password set.
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/a964d785 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/a964d785 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/a964d785 Branch: refs/heads/javelin Commit: a964d7859e556583b70414f1e7634ab47c9b4599 Parents: 831ca08 Author: John Kinsella <[email protected]> Authored: Sun Oct 7 12:51:52 2012 -0700 Committer: John Kinsella <[email protected]> Committed: Sun Oct 7 12:51:52 2012 -0700 ---------------------------------------------------------------------- setup/db/db/schema-301to302.sql | 2 ++ setup/db/db/schema-302to40.sql | 2 ++ setup/db/db/schema-30to301.sql | 2 ++ 3 files changed, 6 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/a964d785/setup/db/db/schema-301to302.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-301to302.sql b/setup/db/db/schema-301to302.sql index 595ce19..f33fcb4 100755 --- a/setup/db/db/schema-301to302.sql +++ b/setup/db/db/schema-301to302.sql @@ -60,3 +60,5 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'manag INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'vmware.reserve.mem', 'false', 'Specify whether or not to reserve memory based on memory overprovisioning factor'); UPDATE `cloud`.`storage_pool` SET removed=now() WHERE path='lvm' AND id NOT IN (select pool_id from storage_pool_host_ref); + +UPDATE `cloud`.`user` SET PASSWORD=RAND() WHERE id=1; http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/a964d785/setup/db/db/schema-302to40.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-302to40.sql b/setup/db/db/schema-302to40.sql index 130203d..0c4efa3 100644 --- a/setup/db/db/schema-302to40.sql +++ b/setup/db/db/schema-302to40.sql @@ -475,3 +475,5 @@ INSERT IGNORE INTO `cloud`.`guest_os_category` VALUES ('11','None',NULL); ALTER TABLE `cloud`.`user` ADD COLUMN `incorrect_login_attempts` integer unsigned NOT NULL DEFAULT '0'; INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'incorrect.login.attempts.allowed', '5', 'Incorrect login attempts allowed before the user is disabled'); UPDATE `cloud`.`configuration` set description ='Uuid of the service offering used by console proxy; if NULL - system offering will be used' where name ='consoleproxy.service.offering'; + +UPDATE `cloud`.`user` SET PASSWORD=RAND() WHERE id=1; http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/a964d785/setup/db/db/schema-30to301.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-30to301.sql b/setup/db/db/schema-30to301.sql index 615d793..0cc51e7 100755 --- a/setup/db/db/schema-30to301.sql +++ b/setup/db/db/schema-30to301.sql @@ -33,3 +33,5 @@ ALTER TABLE `cloud_usage`.`account` ADD CONSTRAINT `uc_account__uuid` UNIQUE (`u ALTER TABLE `cloud`.`host` ALTER COLUMN `resource_state` SET DEFAULT 'Enabled'; ALTER TABLE `cloud`.`physical_network_service_providers` ADD COLUMN `removed` datetime COMMENT 'date removed if not null'; + +UPDATE `cloud`.`user` SET PASSWORD=RAND() WHERE id=1;
