Eli Mesika has uploaded a new change for review.
Change subject: db: refactoring upgrade process
......................................................................
db: refactoring upgrade process
Up to now, each version, I had squashed (version - 3) upgrade scripts into the
base database
manually.
For example in 3.4 , I had squashed 3.1 upgrade scripts and in 3.5 I had
squashed 3.2 upgrade scripts.
The squashing was done by creating a new schema including all the
squashed version changes and applying all inserts into the
insert_data.sql and insert_pre_defined_roles.sql manually
This was a time consuming and error-prone process that leads sometimes
to regressions since it was not easy to compare databases data using
pg_dump because PG does not guarantee the order in which data is dumped
even if the databases compared are identical.
This patch introduce a new approach when all data up to the squashed
version, is auto generated per table by using pg_dump under the data
directory
Another complementary tool (not part of this patch) enables to dump PG
databases and forcing the data being ordered by table PK, the tool also
compares databases schema and data and make it very easy to check if
databases are identical.
Since some entities like DC & Cluster need a new generated UUID per
installation, I wrote a uuidgen.sh script that does exactly that and
generates new UUIDs for each installation for those entities on the data
before it is inserted to the database.
The process of squashing, from now on, will be :
1) creating a git branch with only the squashed version upgrade scripts
2) generating schema and insert files (automatically by pg_dump)
3) restoring all deleted upgrade files with version > squashed version
that were deleted in 1)
4) creating a database based on 1) to 3)
5) creating a database on master
6) using the database comparison tool to verify both databases are identical
(except some generated UUIDs)
Change-Id: I89b8ecc31ca3a179886d84ae7f725282c5571c37
Signed-off-by: emesika <emes...@redhat.com>
---
A packaging/dbscripts/data/0010_insert_users.sql
A packaging/dbscripts/data/0020_insert_ad_groups.sql
A packaging/dbscripts/data/0030_insert_storage_pool.sql
A packaging/dbscripts/data/0040_insert_vds_groups.sql
A packaging/dbscripts/data/0050_insert_roles.sql
A packaging/dbscripts/data/0060_insert_permissions.sql
A packaging/dbscripts/data/0070_insert_roles_groups.sql
A packaging/dbscripts/data/0080_insert_images.sql
A packaging/dbscripts/data/0090_insert_network.sql
A packaging/dbscripts/data/0100_insert_network_cluster.sql
A packaging/dbscripts/data/0110_insert_vm_static.sql
A packaging/dbscripts/data/0120_insert_vm_device.sql
A packaging/dbscripts/data/0130_insert_vm_ovf_generations.sql
A packaging/dbscripts/data/0140_insert_action_version_map.sql
A packaging/dbscripts/data/0150_insert_event_map.sql
A packaging/dbscripts/data/0160_insert_dwh_history_timekeeping.sql
M packaging/dbscripts/dbfunc-custom.sh
D packaging/dbscripts/insert_data.sql
D packaging/dbscripts/insert_predefined_roles.sql
A packaging/dbscripts/uuidgen.sh
20 files changed, 749 insertions(+), 913 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/56/37256/1
diff --git a/packaging/dbscripts/data/0010_insert_users.sql
b/packaging/dbscripts/data/0010_insert_users.sql
new file mode 100644
index 0000000..aef0a40
--- /dev/null
+++ b/packaging/dbscripts/data/0010_insert_users.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO users (user_id, name, surname, domain, username, groups,
department, role, user_icon_path, desktop_device, email, note, status,
session_count, last_admin_check_status, group_ids) VALUES
('fdfc627c-d875-11e0-90f0-83df133b58cc', 'admin', NULL, 'internal',
'admin@internal', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, false, NULL);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0020_insert_ad_groups.sql
b/packaging/dbscripts/data/0020_insert_ad_groups.sql
new file mode 100644
index 0000000..aa51f3d
--- /dev/null
+++ b/packaging/dbscripts/data/0020_insert_ad_groups.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: ad_groups; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO ad_groups (id, name, status, domain, distinguishedname) VALUES
('eee00000-0000-0000-0000-123456789eee', 'Everyone', 1, '', '');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0030_insert_storage_pool.sql
b/packaging/dbscripts/data/0030_insert_storage_pool.sql
new file mode 100644
index 0000000..9eccdff
--- /dev/null
+++ b/packaging/dbscripts/data/0030_insert_storage_pool.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: storage_pool; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO storage_pool (id, name, description, storage_pool_type,
storage_pool_format_type, status, master_domain_version, spm_vds_id,
compatibility_version, _create_date, _update_date, quota_enforcement_type)
VALUES ('00000002-0002-0002-0002-00000000021c', 'Default', 'The default Data
Center', 1, NULL, 0, 0, NULL, '3.6', '2015-01-21 15:14:26.872109+02', NULL,
NULL);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0040_insert_vds_groups.sql
b/packaging/dbscripts/data/0040_insert_vds_groups.sql
new file mode 100644
index 0000000..d436cfb
--- /dev/null
+++ b/packaging/dbscripts/data/0040_insert_vds_groups.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: vds_groups; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO vds_groups (vds_group_id, name, description, cpu_name,
_create_date, _update_date, selection_algorithm, high_utilization,
low_utilization, cpu_over_commit_duration_minutes, storage_pool_id,
max_vds_memory_over_commit, compatibility_version, transparent_hugepages,
migrate_on_error, virt_service, gluster_service, count_threads_as_cores) VALUES
('00000001-0001-0001-0001-0000000000d6', 'Default', 'The default server
cluster', NULL, '2015-01-21 15:14:26.872109+02', NULL, 0, 75, 0, 2,
'00000002-0002-0002-0002-00000000021c', 100, '3.6', true, 1, true, false,
false);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0050_insert_roles.sql
b/packaging/dbscripts/data/0050_insert_roles.sql
new file mode 100644
index 0000000..c53ce2f
--- /dev/null
+++ b/packaging/dbscripts/data/0050_insert_roles.sql
@@ -0,0 +1,44 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('00000000-0000-0000-0000-000000000001',
'SuperUser', 'Roles management administrator', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('00000000-0000-0000-0001-000000000001',
'UserRole', 'Standard User Role', true, 2, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('00000000-0000-0000-0001-000000000002',
'PowerUserRole', 'User Role, allowed to create VMs, Templates and Disks', true,
2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00001-0000-0000-0000-def000000001',
'ClusterAdmin', 'Administrator Role, permission for all the objects underneath
a specific Cluster', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00002-0000-0000-0000-def000000002',
'DataCenterAdmin', 'Administrator Role, permission for all the objects
underneath a specific Data Center, except Storage', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00003-0000-0000-0000-def000000003',
'StorageAdmin', 'Administrator Role, permission for all operations on a
specific Storage Domain', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00004-0000-0000-0000-def000000004',
'HostAdmin', 'Administrator Role, permission for all operations on a specific
Host', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00005-0000-0000-0000-def000000005',
'NetworkAdmin', 'Administrator Role, permission for all operations on a
specific Logical Network', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00006-0000-0000-0000-def000000006',
'UserVmManager', 'User Role, with permission for any operation on Vms', true,
2, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00007-0000-0000-0000-def000000007',
'VmPoolAdmin', 'Administrator Role, permission for all operations on a specific
VM Pool', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00008-0000-0000-0000-def000000008',
'TemplateAdmin', 'Administrator Role, permission for all operations on a
specific Template', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def00009-0000-0000-0000-def000000009',
'TemplateUser', 'Template User', true, 2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000a',
'QuotaConsumer', 'User Role, permissions to consume the Quota resources', true,
2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000b',
'DiskOperator', 'User Role, permissions for all operations on a specific disk',
true, 2, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000c',
'DiskCreator', 'User Role, permission to create Disks', true, 2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000b-0000-0000-0000-def00000000b',
'GlusterAdmin', 'Administrator Role, permissions for operations on Gluster
objects', true, 1, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000d',
'VmCreator', 'User Role, permission to create VMs', true, 2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000e',
'TemplateCreator', 'User Role, permission to create Templates', true, 2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000f',
'TemplateOwner', 'User Role, permissions for all operations on Templates',
true, 2, true);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def000000010',
'NetworkUser', 'Network User', true, 2, false);
+INSERT INTO roles (id, name, description, is_readonly, role_type,
allows_viewing_children) VALUES ('def0000c-0000-0000-0000-def000000000',
'ExternalEventsCreator', 'External Events Creator', true, 2, false);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0060_insert_permissions.sql
b/packaging/dbscripts/data/0060_insert_permissions.sql
new file mode 100644
index 0000000..2c025bc
--- /dev/null
+++ b/packaging/dbscripts/data/0060_insert_permissions.sql
@@ -0,0 +1,27 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO permissions (id, role_id, ad_element_id, object_id,
object_type_id) VALUES ('00000003-0003-0003-0003-000000000016',
'00000000-0000-0000-0000-000000000001', 'fdfc627c-d875-11e0-90f0-83df133b58cc',
'aaa00000-0000-0000-0000-123456789aaa', 1);
+INSERT INTO permissions (id, role_id, ad_element_id, object_id,
object_type_id) VALUES ('00000004-0004-0004-0004-000000000355',
'def00009-0000-0000-0000-def000000009', 'eee00000-0000-0000-0000-123456789eee',
'00000000-0000-0000-0000-000000000000', 4);
+INSERT INTO permissions (id, role_id, ad_element_id, object_id,
object_type_id) VALUES ('00000005-0005-0005-0005-000000000090',
'def0000a-0000-0000-0000-def000000010', 'eee00000-0000-0000-0000-123456789eee',
'00000000-0000-0000-0000-000000000009', 20);
+INSERT INTO permissions (id, role_id, ad_element_id, object_id,
object_type_id) VALUES ('00000006-0006-0006-0006-00000000016d',
'00000000-0000-0000-0001-000000000002', 'fdfc627c-d875-11e0-90f0-83df133b58cc',
'aaa00000-0000-0000-0000-123456789aaa', 1);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0070_insert_roles_groups.sql
b/packaging/dbscripts/data/0070_insert_roles_groups.sql
new file mode 100644
index 0000000..e2830fa
--- /dev/null
+++ b/packaging/dbscripts/data/0070_insert_roles_groups.sql
@@ -0,0 +1,259 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: roles_groups; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 2);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 3);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 4);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 5);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 6);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 7);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 8);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 10);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 11);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 12);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 201);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 202);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 203);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 301);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 302);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 303);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 400);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 401);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 402);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 403);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 500);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 501);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 600);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 601);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 602);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 603);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 700);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 701);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 702);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 703);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 704);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 705);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 800);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000001', 4);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000001', 5);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000001', 7);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000001', 303);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000002', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000002', 200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 2);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 3);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 4);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 5);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 6);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 7);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 8);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 10);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 11);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 12);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 301);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 302);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 303);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 400);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 401);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 402);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 403);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 2);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 3);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 4);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 5);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 6);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 7);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 8);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 10);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 11);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 12);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 201);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 202);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 203);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 301);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 302);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 303);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 400);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 401);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 402);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 403);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 700);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 701);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 702);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 703);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 704);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 705);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 600);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 601);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 602);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 603);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 600);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 601);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 602);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 603);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 403);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 2);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 3);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 4);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 5);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 7);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 10);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 12);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 301);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 302);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 303);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 201);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 202);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 203);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00009-0000-0000-0000-def000000009', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 900);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 900);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 901);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 901);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 13);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000002', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1103);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 1101);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 1102);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 1104);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000c', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1000);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1001);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1002);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000b-0000-0000-0000-def00000000b', 1000);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000b-0000-0000-0000-def00000000b', 1001);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000b-0000-0000-0000-def00000000b', 1002);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000d', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000e', 200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 201);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 202);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 203);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 14);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 14);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 14);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000d', 1100);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000f', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 502);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 1);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000002', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000c', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000e', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00008-0000-0000-0000-def000000008', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00003-0000-0000-0000-def000000003', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00006-0000-0000-0000-def000000006', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000d', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000b', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00001-0000-0000-0000-def000000001', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0001-000000000001', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00004-0000-0000-0000-def000000004', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00007-0000-0000-0000-def000000007', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000b-0000-0000-0000-def00000000b', 1300);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 404);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00002-0000-0000-0000-def000000002', 404);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 404);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 1200);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 703);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 704);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 705);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def00005-0000-0000-0000-def000000005', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def000000010', 9);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def000000010', 204);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('00000000-0000-0000-0000-000000000001', 1500);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000c-0000-0000-0000-def000000000', 1500);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def00000000a', 901);
+INSERT INTO roles_groups (role_id, action_group_id) VALUES
('def0000a-0000-0000-0000-def000000010', 1300);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0080_insert_images.sql
b/packaging/dbscripts/data/0080_insert_images.sql
new file mode 100644
index 0000000..50d95c4
--- /dev/null
+++ b/packaging/dbscripts/data/0080_insert_images.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO images (image_guid, creation_date, size, it_guid, parentid,
imagestatus, lastmodified, vm_snapshot_id, volume_type, volume_format,
image_group_id, _create_date, _update_date, quota_id, active) VALUES
('00000000-0000-0000-0000-000000000000', '2008-04-01 00:00:00+03', 85899345920,
'00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL, 2, 4, NULL,
'2013-12-25 15:31:57.219114+02', NULL, NULL, true);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0090_insert_network.sql
b/packaging/dbscripts/data/0090_insert_network.sql
new file mode 100644
index 0000000..89c34d4
--- /dev/null
+++ b/packaging/dbscripts/data/0090_insert_network.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: network; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO network (id, name, description, type, addr, subnet, gateway,
vlan_id, stp, storage_pool_id, mtu, vm_network) VALUES
('00000000-0000-0000-0000-000000000009', 'ovirtmgmt', 'Management Network',
NULL, NULL, NULL, NULL, NULL, false, '00000002-0002-0002-0002-00000000021c',
NULL, true);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0100_insert_network_cluster.sql
b/packaging/dbscripts/data/0100_insert_network_cluster.sql
new file mode 100644
index 0000000..74ea8bc
--- /dev/null
+++ b/packaging/dbscripts/data/0100_insert_network_cluster.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: network_cluster; Type: TABLE DATA; Schema: public; Owner:
engine
+--
+
+INSERT INTO network_cluster (network_id, cluster_id, status, is_display,
required) VALUES ('00000000-0000-0000-0000-000000000009',
'00000001-0001-0001-0001-0000000000d6', 1, false, true);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0110_insert_vm_static.sql
b/packaging/dbscripts/data/0110_insert_vm_static.sql
new file mode 100644
index 0000000..9776ede
--- /dev/null
+++ b/packaging/dbscripts/data/0110_insert_vm_static.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: vm_static; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO vm_static (vm_guid, vm_name, mem_size_mb, vmt_guid, os,
description, vds_group_id, domain, creation_date, num_of_monitors,
is_initialized, is_auto_suspend, num_of_sockets, cpu_per_socket, usb_policy,
time_zone, is_stateless, fail_back, _create_date, _update_date,
dedicated_vm_for_vds, auto_startup, vm_type, nice_level, default_boot_sequence,
default_display_type, priority, iso_path, origin, initrd_url, kernel_url,
kernel_params, migration_support, userdefined_properties,
predefined_properties, min_allocated_mem, entity_type, child_count,
template_status, quota_id, allow_console_reconnect, cpu_pinning,
is_smartcard_enabled, host_cpu_flags, db_generation, is_delete_protected,
is_disabled) VALUES ('00000000-0000-0000-0000-000000000000', 'Blank', 1024,
'00000000-0000-0000-0000-000000000000', 0, 'Blank template',
'00000001-0001-0001-0001-0000000000d6', '', '2008-04-01 00:00:00+03', 1, NULL,
false, 1, 1, 1, NULL, NULL, false, '2013-12-25 15:31:54.367179+02', '2013-12-!
25 15:31:53.239308+02', NULL, NULL, 0, 0, 0, 0, 0, '', 0, NULL, NULL, NULL, 0,
NULL, NULL, 0, 'TEMPLATE', 0, 0, NULL, false, NULL, false, false, 1, false,
false);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0120_insert_vm_device.sql
b/packaging/dbscripts/data/0120_insert_vm_device.sql
new file mode 100644
index 0000000..99ea525
--- /dev/null
+++ b/packaging/dbscripts/data/0120_insert_vm_device.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: vm_device; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO vm_device (device_id, vm_id, type, device, address, boot_order,
spec_params, is_managed, is_plugged, is_readonly, _create_date, _update_date,
alias) VALUES ('00000006-0006-0006-0006-000000000006',
'00000000-0000-0000-0000-000000000000', 'video', 'cirrus', '', NULL, '{ "vram"
: "65536" }', true, NULL, false, '2013-12-25 22:54:23.416857+02', NULL, '');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0130_insert_vm_ovf_generations.sql
b/packaging/dbscripts/data/0130_insert_vm_ovf_generations.sql
new file mode 100644
index 0000000..fb52332
--- /dev/null
+++ b/packaging/dbscripts/data/0130_insert_vm_ovf_generations.sql
@@ -0,0 +1,24 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: vm_ovf_generations; Type: TABLE DATA; Schema: public; Owner:
engine
+--
+
+INSERT INTO vm_ovf_generations (vm_guid, storage_pool_id, ovf_generation)
VALUES ('00000000-0000-0000-0000-000000000000',
'00000002-0002-0002-0002-00000000021c', 1);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0140_insert_action_version_map.sql
b/packaging/dbscripts/data/0140_insert_action_version_map.sql
new file mode 100644
index 0000000..092f016
--- /dev/null
+++ b/packaging/dbscripts/data/0140_insert_action_version_map.sql
@@ -0,0 +1,42 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: action_version_map; Type: TABLE DATA; Schema: public; Owner:
engine
+--
+
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (41, '3.1', '3.1');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (158, '3.1', '3.0');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (52, '3.1', '3.1');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1009, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1400, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1401, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1402, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1403, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1404, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1405, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1406, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1407, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1408, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1409, '3.1', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1410, '3.2', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1411, '3.2', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1412, '3.2', '*');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1010, '3.2', '3.2');
+INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version) VALUES (1011, '3.2', '3.2');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0150_insert_event_map.sql
b/packaging/dbscripts/data/0150_insert_event_map.sql
new file mode 100644
index 0000000..e0009d3
--- /dev/null
+++ b/packaging/dbscripts/data/0150_insert_event_map.sql
@@ -0,0 +1,89 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: event_map; Type: TABLE DATA; Schema: public; Owner: engine
+--
+
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDC_STOP',
'VDC_START');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('IRS_FAILURE',
'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('IRS_DISK_SPACE_LOW', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('IRS_DISK_SPACE_LOW_ERROR', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDS_FAILURE',
'VDS_ACTIVATE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('USER_VDS_MAINTENANCE', 'VDS_ACTIVATE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('USER_VDS_MAINTENANCE_MIGRATION_FAILED', 'USER_VDS_MAINTENANCE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_ACTIVATE_FAILED', 'VDS_ACTIVATE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_RECOVER_FAILED', 'VDS_RECOVER');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_SLOW_STORAGE_RESPONSE_TIME', 'VDS_ACTIVATE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_APPROVE_FAILED', 'VDS_APPROVE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_INSTALL_FAILED', 'VDS_INSTALL');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VM_FAILURE',
'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VM_MIGRATION_START', 'VM_MIGRATION_DONE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VM_MIGRATION_FAILED', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VM_MIGRATION_FAILED_FROM_TO', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VM_NOT_RESPONDING', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('DWH_STOPPED',
'DWH_STARTED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('DWH_ERROR',
'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_TIME_DRIFT_ALERT', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_CREATE', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_CREATE_FAILED', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_START', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_START_FAILED', 'GLUSTER_VOLUME_START');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_STOP', 'GLUSTER_VOLUME_START');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_STOP_FAILED', 'GLUSTER_VOLUME_STOP');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTION_SET', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTION_SET_FAILED', 'GLUSTER_VOLUME_OPTION_SET');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTIONS_RESET', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTIONS_RESET_FAILED', 'GLUSTER_VOLUME_OPTIONS_RESET');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_DELETE', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_DELETE_FAILED', 'GLUSTER_VOLUME_DELETE');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REBALANCE_START', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REBALANCE_START_FAILED', 'GLUSTER_VOLUME_REBALANCE_START');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REMOVE_BRICKS', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REMOVE_BRICKS_FAILED', 'GLUSTER_VOLUME_REMOVE_BRICKS');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REPLACE_BRICK_FAILED', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REPLACE_BRICK_START', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_REPLACE_BRICK_START_FAILED',
'GLUSTER_VOLUME_REPLACE_BRICK_START');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_ADD_BRICK', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_ADD_BRICK_FAILED', 'GLUSTER_VOLUME_ADD_BRICK');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_SERVER_REMOVE_FAILED', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_SERVER_ADD_FAILED', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_CREATED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_DELETED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTION_SET_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTION_RESET_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_PROPERTIES_CHANGED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_BRICK_ADDED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_BRICK_REMOVED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_SERVER_REMOVED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('HA_VM_RESTART_FAILED', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('HA_VM_FAILED',
'');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('SYSTEM_DEACTIVATED_STORAGE_DOMAIN', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_SET_NONOPERATIONAL', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_SET_NONOPERATIONAL_IFACE_DOWN', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_SET_NONOPERATIONAL_DOMAIN', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('SYSTEM_CHANGE_STORAGE_POOL_STATUS_NO_HOST_FOR_SPM', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_STARTED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_STOPPED_FROM_CLI', 'UNASSIGNED');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_HIGH_MEM_USE', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_HIGH_NETWORK_USE', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_HIGH_CPU_USE', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('VDS_HIGH_SWAP_USE', '');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDS_LOW_SWAP',
'');
+INSERT INTO event_map (event_up_name, event_down_name) VALUES
('GLUSTER_VOLUME_OPTION_CHANGED_FROM_CLI', 'UNASSIGNED');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/data/0160_insert_dwh_history_timekeeping.sql
b/packaging/dbscripts/data/0160_insert_dwh_history_timekeeping.sql
new file mode 100644
index 0000000..4e0c064
--- /dev/null
+++ b/packaging/dbscripts/data/0160_insert_dwh_history_timekeeping.sql
@@ -0,0 +1,25 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: dwh_history_timekeeping; Type: TABLE DATA; Schema: public;
Owner: engine
+--
+
+INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES
('lastSync', NULL, '2000-01-01 00:00:00+02');
+INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES
('lastFullHostCheck', NULL, '2000-01-01 00:00:00+02');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
diff --git a/packaging/dbscripts/dbfunc-custom.sh
b/packaging/dbscripts/dbfunc-custom.sh
index 3865d86..c5705f4 100644
--- a/packaging/dbscripts/dbfunc-custom.sh
+++ b/packaging/dbscripts/dbfunc-custom.sh
@@ -7,10 +7,12 @@
DBFUNC_CUSTOM_CLEAN_TASKS=
dbfunc_common_hook_init_insert_data() {
- echo "Inserting data..."
- dbfunc_psql_die --file="${DBFUNC_COMMON_DBSCRIPTS_DIR}/insert_data.sql"
> /dev/null
- echo "Inserting pre-defined roles..."
- dbfunc_psql_die
--file="${DBFUNC_COMMON_DBSCRIPTS_DIR}/insert_predefined_roles.sql" > /dev/null
+ # generate new UUIDs for default DC & Cluster
+ "${DBFUNC_COMMON_DBSCRIPTS_DIR}"/uuidgen.sh "${DBFUNC_DB_USER}"
"${DBFUNC_DB_DATABASE}" "${DBFUNC_COMMON_DBSCRIPTS_DIR}"/data
+ for script in $(ls
"${DBFUNC_COMMON_DBSCRIPTS_DIR}"/data/*insert_*.sql); do
+ echo "Inserting data from ${script} ..."
+ dbfunc_psql_die --file="${script}" > /dev/null
+ done
}
dbfunc_common_hook_pre_upgrade() {
diff --git a/packaging/dbscripts/insert_data.sql
b/packaging/dbscripts/insert_data.sql
deleted file mode 100644
index 5369d85..0000000
--- a/packaging/dbscripts/insert_data.sql
+++ /dev/null
@@ -1,157 +0,0 @@
-INSERT INTO vdc_options(option_name, option_value, version) values
('AutoRegistrationDefaultVdsGroupID', uuid_generate_v1(),'general');
-
-Create or replace FUNCTION insert_data()
-RETURNS VOID
- AS $procedure$
- DECLARE
- v_id_0000 UUID;
- v_storage_pool_id UUID;
- v_cluster_id UUID;
- v_id_0009 UUID;
-BEGIN
- v_id_0000 := '00000000-0000-0000-0000-000000000000';
- v_storage_pool_id := uuid_generate_v1();
- v_cluster_id := option_value from vdc_options where option_name =
'AutoRegistrationDefaultVdsGroupID' and version = 'general';
- v_id_0009 := '00000000-0000-0000-0000-000000000009';
-
-
--- INSERT DATA to schema_version
-INSERT INTO
schema_version(version,script,checksum,installed_by,ended_at,state,current)
- values
('03030000','upgrade/03_03_0000_set_version.sql','0','engine',now(),'INSTALLED',true);
-
--- INSERT everyone TO ad_groups
-INSERT into ad_groups (id,name,status,domain,distinguishedname)
- SELECT getGlobalIds('everyone'),
- 'Everyone',
- 1,
- '',
- ''
-where not exists (
- SELECT id from ad_groups where id = getGlobalIds('everyone'));
-
---INSERTING DATA INTO TABLE storage_pool
-
-INSERT INTO storage_pool
(id,name,description,storage_pool_type,status,master_domain_version,compatibility_version)
select v_storage_pool_id,'Default','The default Data Center',1,0,0,'3.6';
---INSERTING DATA INTO TABLE vds_groups
-
-INSERT INTO vds_groups
(vds_group_id,name,description,storage_pool_id,compatibility_version,transparent_hugepages)
select v_cluster_id,'Default','The default server
cluster',v_storage_pool_id,'3.6',true;
-
---INSERTING DATA INTO NETWORK table
-
-INSERT INTO network (id,name,description,storage_pool_id) SELECT v_id_0009,
'ovirtmgmt', 'Management Network', v_storage_pool_id;
-INSERT INTO network_cluster (network_id, cluster_id, status) SELECT
v_id_0009,v_cluster_id,1;
-
-INSERT INTO vm_static (vm_guid, vm_name, mem_size_mb, vmt_guid, os,
description, vds_group_id, domain, creation_date, num_of_monitors,
is_initialized, is_auto_suspend, num_of_sockets, cpu_per_socket, usb_policy,
time_zone, is_stateless, fail_back, _create_date, _update_date,
dedicated_vm_for_vds, auto_startup, vm_type, nice_level, default_boot_sequence,
default_display_type, priority, iso_path, origin, initrd_url, kernel_url,
kernel_params, migration_support, userdefined_properties,
predefined_properties, min_allocated_mem, entity_type, child_count,
template_status, quota_id, allow_console_reconnect, cpu_pinning,
is_smartcard_enabled) VALUES ('00000000-0000-0000-0000-000000000000', 'Blank',
1024, '00000000-0000-0000-0000-000000000000', 0, 'Blank template', v_cluster_id
, '', '2008-04-01 00:00:00+03', 1, NULL, false, 1, 1, 1, NULL, NULL, false,
'2013-12-25 15:31:54.367179+02', '2013-12-25 15:31:53.239308+02', NULL, NULL,
0, 0, 0, 0, 0, '', 0, NULL, NULL, NULL, 0, NULL, NULL,!
0, 'TEMPLATE', 0, 0, NULL, false, NULL, false);
-
-
-INSERT INTO event_map(event_up_name, event_down_name) values('VDC_STOP',
'VDC_START');
-
-INSERT INTO event_map(event_up_name, event_down_name) values('IRS_FAILURE',
'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('IRS_DISK_SPACE_LOW', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('IRS_DISK_SPACE_LOW_ERROR', 'UNASSIGNED');
-
-INSERT INTO event_map(event_up_name, event_down_name) values('VDS_FAILURE',
'VDS_ACTIVATE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('USER_VDS_MAINTENANCE', 'VDS_ACTIVATE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('USER_VDS_MAINTENANCE_MIGRATION_FAILED', 'USER_VDS_MAINTENANCE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_ACTIVATE_FAILED', 'VDS_ACTIVATE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_RECOVER_FAILED', 'VDS_RECOVER');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_SLOW_STORAGE_RESPONSE_TIME', 'VDS_ACTIVATE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_APPROVE_FAILED', 'VDS_APPROVE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_INSTALL_FAILED', 'VDS_INSTALL');
-
-INSERT INTO event_map(event_up_name, event_down_name) values('VM_FAILURE',
'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VM_MIGRATION_START', 'VM_MIGRATION_DONE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VM_MIGRATION_FAILED', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VM_MIGRATION_FAILED_FROM_TO', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VM_NOT_RESPONDING', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name) values('DWH_STOPPED',
'DWH_STARTED');
-INSERT INTO event_map(event_up_name, event_down_name) values('DWH_ERROR',
'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('VDS_TIME_DRIFT_ALERT', '');
-
-
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_CREATE', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_CREATE_FAILED', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_START', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_START_FAILED', 'GLUSTER_VOLUME_START');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_STOP', 'GLUSTER_VOLUME_START');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_STOP_FAILED', 'GLUSTER_VOLUME_STOP');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTION_SET', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTION_SET_FAILED', 'GLUSTER_VOLUME_OPTION_SET');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTIONS_RESET', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTIONS_RESET_FAILED', 'GLUSTER_VOLUME_OPTIONS_RESET');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_DELETE', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_DELETE_FAILED', 'GLUSTER_VOLUME_DELETE');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REBALANCE_START', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REBALANCE_START_FAILED',
'GLUSTER_VOLUME_REBALANCE_START');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REMOVE_BRICKS', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REMOVE_BRICKS_FAILED', 'GLUSTER_VOLUME_REMOVE_BRICKS');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REPLACE_BRICK_FAILED', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REPLACE_BRICK_START', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_REPLACE_BRICK_START_FAILED',
'GLUSTER_VOLUME_REPLACE_BRICK_START');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_ADD_BRICK', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_ADD_BRICK_FAILED', 'GLUSTER_VOLUME_ADD_BRICK');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_SERVER_REMOVE_FAILED', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_SERVER_ADD_FAILED', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_CREATED_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_DELETED_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTION_SET_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTION_RESET_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_PROPERTIES_CHANGED_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_BRICK_ADDED_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_BRICK_REMOVED_FROM_CLI', 'UNASSIGNED');
-INSERT INTO event_map(event_up_name, event_down_name)
values('GLUSTER_SERVER_REMOVED_FROM_CLI', 'UNASSIGNED');
-insert into event_map(event_up_name, event_down_name)
values('HA_VM_RESTART_FAILED', '');
-insert into event_map(event_up_name, event_down_name) values('HA_VM_FAILED',
'');
-insert into event_map(event_up_name, event_down_name)
values('SYSTEM_DEACTIVATED_STORAGE_DOMAIN', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_SET_NONOPERATIONAL', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_SET_NONOPERATIONAL_IFACE_DOWN', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_SET_NONOPERATIONAL_DOMAIN', '');
-insert into event_map(event_up_name, event_down_name)
values('SYSTEM_CHANGE_STORAGE_POOL_STATUS_NO_HOST_FOR_SPM', '');
-insert into event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_STARTED_FROM_CLI', 'UNASSIGNED');
-insert into event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_STOPPED_FROM_CLI', 'UNASSIGNED');
-insert into event_map(event_up_name, event_down_name)
values('VDS_HIGH_MEM_USE', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_HIGH_NETWORK_USE', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_HIGH_CPU_USE', '');
-insert into event_map(event_up_name, event_down_name)
values('VDS_HIGH_SWAP_USE', '');
-insert into event_map(event_up_name, event_down_name) values('VDS_LOW_SWAP',
'');
-insert into event_map(event_up_name, event_down_name)
values('GLUSTER_VOLUME_OPTION_CHANGED_FROM_CLI', 'UNASSIGNED');
-
-INSERT INTO action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- SELECT 41, '3.1', '3.1';
-
-INSERT INTO action_version_map values(158, '3.1','3.0');
-INSERT INTO action_version_map
(action_type,cluster_minimal_version,storage_pool_minimal_version) values
(52,'3.1','3.1');
-INSERT INTO action_version_map values(1009, '3.1','*');
-
-
-
-INSERT INTO images (image_guid, creation_date, size, it_guid, parentid,
imagestatus, lastmodified, vm_snapshot_id, volume_type, volume_format,
image_group_id, _create_date, _update_date, quota_id, active) VALUES
('00000000-0000-0000-0000-000000000000', '2008-04-01 00:00:00+03', 85899345920,
'00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL, 2, 4, NULL,
'2013-12-25 15:31:57.219114+02', NULL, NULL, true);
-
-INSERT INTO vm_device (device_id, vm_id, type, device, address, boot_order,
spec_params, is_managed, is_plugged, is_readonly, _create_date, _update_date,
alias) VALUES ('00000006-0006-0006-0006-000000000006',
'00000000-0000-0000-0000-000000000000', 'video', 'cirrus', '', NULL, '{ "vram"
: "65536" }', true, NULL, false, '2013-12-25 22:54:23.416857+02', NULL, '');
-
--- Inserting data to history timekeeping
-Insert into dwh_history_timekeeping
VALUES('lastSync',NULL,to_timestamp('01/01/2000', 'DD/MM/YYYY'));
-
---OVF
-INSERT INTO vm_ovf_generations
- (SELECT vm.vm_guid, sp.id, 1
- FROM vm_static vm ,storage_pool sp, vds_groups vg
- WHERE vg.storage_pool_id = sp.id AND vm.vds_group_id = vg.vds_group_id);
-
-
-RETURN;
-END; $procedure$
-LANGUAGE plpgsql;
-SELECT insert_data();
-drop function insert_data();
-
-
-/******************************************************************************************************
- DWH DATA
-******************************************************************************************************/
-
--- Inserting data to history timekeeping for host sync of slow changing data
in dynamic configuration and statistical tables.
-
-Insert into dwh_history_timekeeping SELECT
'lastFullHostCheck',NULL,to_timestamp('01/01/2000', 'DD/MM/YYYY');
-
-
diff --git a/packaging/dbscripts/insert_predefined_roles.sql
b/packaging/dbscripts/insert_predefined_roles.sql
deleted file mode 100644
index c36a346..0000000
--- a/packaging/dbscripts/insert_predefined_roles.sql
+++ /dev/null
@@ -1,752 +0,0 @@
-Create or replace FUNCTION insert_predefined_roles()
-RETURNS VOID
- AS $procedure$
- DECLARE
- --Roles
- v_SUPER_USER_ID UUID;
- v_POWER_USER_ID UUID;
- v_USER_ID UUID;
- v_CLUSTER_ADMIN_ID UUID;
- v_DATA_CENTER_ADMIN_ID UUID;
- v_STORAGE_ADMIN_ID UUID;
- v_HOST_ADMIN_ID UUID;
- v_NETWORK_ADMIN_ID UUID;
- v_VM_ADMIN_ID UUID;
- v_VM_POOL_ADMIN_ID UUID;
- v_TEMPLATE_ADMIN_ID UUID;
- v_TEMPLATE_USER_ID UUID;
- v_QUOTA_CONSUMER_USER_ID UUID;
- v_DISK_OPERATOR_USER_ID UUID;
- v_DISK_CREATOR_USER_ID UUID;
- v_GLUSTER_ADMIN_ROLE_ID UUID;
- v_VM_CREATOR_USER_ID UUID;
- v_TEMPLATE_CREATOR_USER_ID UUID;
- v_TEMPLATE_OWNER_USER_ID UUID;
- v_LOCAL_ADMIN_ID UUID;
- v_NETWORK_USER_ID UUID;
- v_EXTERNAL_EVENT_CREATOR_ID UUID;
- --Permissions
- v_CREATE_VM INTEGER;
- v_DELETE_VM INTEGER;
- v_EDIT_VM_PROPERTIES INTEGER;
- v_VM_BASIC_OPERATIONS INTEGER;
- v_CHANGE_VM_CD INTEGER;
- v_MIGRATE_VM INTEGER;
- v_CONNECT_TO_VM INTEGER;
- v_IMPORT_EXPORT_VM INTEGER;
- v_CONFIGURE_VM_NETWORK INTEGER;
- v_CONFIGURE_VM_STORAGE INTEGER;
- v_MOVE_VM INTEGER;
- v_MANIPULATE_VM_SNAPSHOTS INTEGER;
- v_FORCE_CONNECT_VM INTEGER;
- v_CUSTOM_PROPERTIES INTEGER;
- v_CREATE_HOST INTEGER;
- v_EDIT_HOST_CONFIGURATION INTEGER;
- v_DELETE_HOST INTEGER;
- v_MANIPULATE_HOST INTEGER;
- v_CONFIGURE_HOST_NETWORK INTEGER;
- v_CREATE_TEMPLATE INTEGER;
- v_EDIT_TEMPLATE_PROPERTIES INTEGER;
- v_DELETE_TEMPLATE INTEGER;
- v_COPY_TEMPLATE INTEGER;
- v_CONFIGURE_TEMPLATE_NETWORK INTEGER;
- v_CREATE_VM_POOL INTEGER;
- v_EDIT_VM_POOL_CONFIGURATION INTEGER;
- v_DELETE_VM_POOL INTEGER;
- v_VM_POOL_BASIC_OPERATIONS INTEGER;
- v_CREATE_CLUSTER INTEGER;
- v_EDIT_CLUSTER_CONFIGURATION INTEGER;
- v_DELETE_CLUSTER INTEGER;
- v_ASSIGN_CLUSTER_NETWORK INTEGER;
- v_CONFIGURE_CLUSTER_NETWORK INTEGER;
- v_MANIPULATE_USERS INTEGER;
- v_MANIPULATE_ROLES INTEGER;
- v_MANIPULATE_PERMISSIONS INTEGER;
- v_EDIT_STORAGE_DOMAIN_CONFIGURATION INTEGER;
- v_DELETE_STORAGE_DOMAIN INTEGER;
- v_MANIPULATE_STORAGE_DOMAIN INTEGER;
- v_CREATE_STORAGE_POOL INTEGER;
- v_DELETE_STORAGE_POOL INTEGER;
- v_EDIT_STORAGE_POOL_CONFIGURATION INTEGER;
- v_CONFIGURE_STORAGE_POOL_NETWORK INTEGER;
- v_CREATE_STORAGE_POOL_NETWORK INTEGER;
- v_DELETE_STORAGE_POOL_NETWORK INTEGER;
- v_CONFIGURE_ENGINE INTEGER;
- v_MANIPULATE_QUOTA INTEGER;
- v_CONSUME_QUOTA INTEGER;
- v_CREATE_GLUSTER_VOLUME INTEGER;
- v_MANIPULATE_GLUSTER_VOLUME INTEGER;
- v_DELETE_GLUSTER_VOLUME INTEGER;
- v_CREATE_STORAGE_DOMAIN INTEGER;
- v_LIVE_MIGRATE_DISK INTEGER;
- v_LIVE_MIGRATE_DISKS INTEGER;
- v_CREATE_DISK INTEGER;
- v_ATTACH_DISK INTEGER;
- v_EDIT_DISK_PROPERTIES INTEGER;
- v_CONFIGURE_DISK_STORAGE INTEGER;
- v_DELETE_DISK INTEGER;
- v_CONFIGURE_STORAGE_POOL_VM_INTERFACE INTEGER;
- v_LOGIN INTEGER;
- v_EXTERNAL_EVENT_INJECTION INTEGER;
- -- Action Types
- v_CREATE_GLUSTER_VOLUME_BRICKS INTEGER;
- v_SET_GLUSTER_VOLUME INTEGER;
- v_START_GLUSTER_VOLUME INTEGER;
- v_STOP_GLUSTER_VOLUME INTEGER;
- v_RESET_GLUSTER_VOLUME INTEGER;
- v_DELETE_GLUSTER_VOLUME_BRICKS INTEGER;
- v_REMOVE_GLUTER_VOLUME_BRICKS INTEGER;
- v_REBALANCE_GLUSTER_VOLUME INTEGER;
- v_REPLACE_GLUSTER_VOLUME_BRICKS INTEGER;
- v_ADD_GLUSTER_VOLUME_BRICKS INTEGER;
- v_START_GLUSTER_VOLUME_PROFILE INTEGER;
- v_STOP_LUSTER_VOLUME_PROFILE INTEGER;
- v_REMOVE_GLUSTER_SERVER INTEGER;
-
- --Other
- v_ADMIN_USER_ID UUID;
-
-BEGIN
- v_SUPER_USER_ID := '00000000-0000-0000-0000-000000000001';
- v_POWER_USER_ID := '00000000-0000-0000-0001-000000000002';
- v_USER_ID := '00000000-0000-0000-0001-000000000001';
- v_CLUSTER_ADMIN_ID := 'DEF00001-0000-0000-0000-DEF000000001';
- v_DATA_CENTER_ADMIN_ID := 'DEF00002-0000-0000-0000-DEF000000002';
- v_STORAGE_ADMIN_ID := 'DEF00003-0000-0000-0000-DEF000000003';
- v_HOST_ADMIN_ID := 'DEF00004-0000-0000-0000-DEF000000004';
- v_NETWORK_ADMIN_ID := 'DEF00005-0000-0000-0000-DEF000000005';
- v_VM_ADMIN_ID := 'DEF00006-0000-0000-0000-DEF000000006';
- v_VM_POOL_ADMIN_ID := 'DEF00007-0000-0000-0000-DEF000000007';
- v_TEMPLATE_ADMIN_ID := 'DEF00008-0000-0000-0000-DEF000000008';
- v_TEMPLATE_USER_ID := 'DEF00009-0000-0000-0000-DEF000000009';
- v_QUOTA_CONSUMER_USER_ID := 'DEF0000a-0000-0000-0000-DEF00000000a';
- v_DISK_OPERATOR_USER_ID := 'DEF0000A-0000-0000-0000-DEF00000000B';
- v_DISK_CREATOR_USER_ID := 'DEF0000A-0000-0000-0000-DEF00000000C';
- v_GLUSTER_ADMIN_ROLE_ID := 'DEF0000B-0000-0000-0000-DEF00000000B';
- v_VM_CREATOR_USER_ID := 'DEF0000A-0000-0000-0000-DEF00000000D';
- v_TEMPLATE_CREATOR_USER_ID := 'DEF0000A-0000-0000-0000-DEF00000000E';
- v_TEMPLATE_OWNER_USER_ID := 'DEF0000A-0000-0000-0000-DEF00000000F';
- v_LOCAL_ADMIN_ID := 'FDFC627C-D875-11E0-90F0-83DF133B58CC';
- v_NETWORK_USER_ID := 'DEF0000A-0000-0000-0000-DEF000000010';
- v_EXTERNAL_EVENT_CREATOR_ID := 'DEF0000C-0000-0000-0000-DEF000000000';
- v_CREATE_VM := 1;
- v_DELETE_VM := 2;
- v_EDIT_VM_PROPERTIES := 3;
- v_VM_BASIC_OPERATIONS := 4;
- v_CHANGE_VM_CD := 5;
- v_MIGRATE_VM := 6;
- v_CONNECT_TO_VM := 7;
- v_IMPORT_EXPORT_VM := 8;
- v_CONFIGURE_VM_NETWORK := 9;
- v_CONFIGURE_VM_STORAGE := 10;
- v_MOVE_VM := 11;
- v_MANIPULATE_VM_SNAPSHOTS := 12;
- v_FORCE_CONNECT_VM := 13;
- v_CUSTOM_PROPERTIES := 14;
- v_CREATE_HOST := 100;
- v_EDIT_HOST_CONFIGURATION := 101;
- v_DELETE_HOST := 102;
- v_MANIPULATE_HOST := 103;
- v_CONFIGURE_HOST_NETWORK := 104;
- v_CREATE_TEMPLATE := 200;
- v_EDIT_TEMPLATE_PROPERTIES := 201;
- v_DELETE_TEMPLATE := 202;
- v_COPY_TEMPLATE := 203;
- v_CONFIGURE_TEMPLATE_NETWORK := 204;
- v_CREATE_VM_POOL := 300;
- v_EDIT_VM_POOL_CONFIGURATION := 301;
- v_DELETE_VM_POOL := 302;
- v_VM_POOL_BASIC_OPERATIONS := 303;
- v_CREATE_CLUSTER := 400;
- v_EDIT_CLUSTER_CONFIGURATION := 401;
- v_DELETE_CLUSTER := 402;
- v_CONFIGURE_CLUSTER_NETWORK := 403;
- v_ASSIGN_CLUSTER_NETWORK := 404;
- v_MANIPULATE_USERS := 500;
- v_MANIPULATE_ROLES := 501;
- v_MANIPULATE_PERMISSIONS := 502;
- v_CREATE_STORAGE_DOMAIN := 600;
- v_EDIT_STORAGE_DOMAIN_CONFIGURATION := 601;
- v_DELETE_STORAGE_DOMAIN := 602;
- v_MANIPULATE_STORAGE_DOMAIN := 603;
- v_CREATE_STORAGE_POOL := 700;
- v_DELETE_STORAGE_POOL := 701;
- v_EDIT_STORAGE_POOL_CONFIGURATION := 702;
- v_CONFIGURE_STORAGE_POOL_NETWORK := 703;
- v_CREATE_STORAGE_POOL_NETWORK := 704;
- v_DELETE_STORAGE_POOL_NETWORK := 705;
- v_CONFIGURE_ENGINE := 800;
- v_MANIPULATE_QUOTA := 900;
- v_CONSUME_QUOTA := 901;
- v_CREATE_GLUSTER_VOLUME := 1000;
- v_MANIPULATE_GLUSTER_VOLUME := 1001;
- v_DELETE_GLUSTER_VOLUME := 1002;
- v_LIVE_MIGRATE_DISK := 1010;
- v_LIVE_MIGRATE_DISKS := 1011;
- v_CREATE_DISK := 1100;
- v_ATTACH_DISK := 1101;
- v_EDIT_DISK_PROPERTIES := 1102;
- v_CONFIGURE_DISK_STORAGE := 1103;
- v_DELETE_DISK := 1104;
- v_CONFIGURE_STORAGE_POOL_VM_INTERFACE := 1200;
- v_LOGIN := 1300;
- v_EXTERNAL_EVENT_INJECTION := 1500;
- -- Action Types
- v_CREATE_GLUSTER_VOLUME_BRICKS := 1400;
- v_SET_GLUSTER_VOLUME := 1401;
- v_START_GLUSTER_VOLUME := 1402;
- v_STOP_GLUSTER_VOLUME := 1403;
- v_RESET_GLUSTER_VOLUME := 1404;
- v_DELETE_GLUSTER_VOLUME_BRICKS := 1405;
- v_REMOVE_GLUTER_VOLUME_BRICKS := 1406;
- v_REBALANCE_GLUSTER_VOLUME := 1407;
- v_REPLACE_GLUSTER_VOLUME_BRICKS := 1408;
- v_ADD_GLUSTER_VOLUME_BRICKS := 1409;
- v_START_GLUSTER_VOLUME_PROFILE := 1410;
- v_STOP_LUSTER_VOLUME_PROFILE := 1411;
- v_REMOVE_GLUSTER_SERVER := 1412;
-
-
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_SUPER_USER_ID,'SuperUser','Roles management administrator',true,1,true;
-
----Vm Groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_VM_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_VM_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CHANGE_VM_CD);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MIGRATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONNECT_TO_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_IMPORT_EXPORT_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_VM_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_VM_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MOVE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_VM_SNAPSHOTS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_HOST_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_HOST_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_TEMPLATE_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_COPY_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_TEMPLATE_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_VM_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_VM_POOL_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_CLUSTER_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_CLUSTER_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_USERS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_ROLES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_PERMISSIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_STORAGE_DOMAIN_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_MANIPULATE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_STORAGE_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_STORAGE_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_STORAGE_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_STORAGE_POOL_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_STORAGE_POOL_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_STORAGE_POOL_NETWORK);
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_USER_ID,'UserRole','Standard User Role',true,2,true;
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_ENGINE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_USER_ID,v_VM_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_USER_ID,v_CHANGE_VM_CD);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_USER_ID,v_CONNECT_TO_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_USER_ID,v_VM_POOL_BASIC_OPERATIONS);
-
---PoewerUser role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_POWER_USER_ID,'PowerUserRole','User Role, allowed to create VMs, Templates
and Disks',true,2,false;
-
-
----Vm Groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_POWER_USER_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_POWER_USER_ID,v_CREATE_TEMPLATE);
-
--------------
---CLUSTER_ADMIN role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_CLUSTER_ADMIN_ID,'ClusterAdmin','Administrator Role, permission for all the
objects underneath a specific Cluster',true,1,true;
-
-
----Vm Groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_DELETE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_EDIT_VM_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_VM_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CHANGE_VM_CD);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_MIGRATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONNECT_TO_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_IMPORT_EXPORT_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONFIGURE_VM_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONFIGURE_VM_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_MOVE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_MANIPULATE_VM_SNAPSHOTS);
--- vm pools actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CREATE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_EDIT_VM_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_DELETE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_VM_POOL_BASIC_OPERATIONS);
--- host (vds) actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CREATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_EDIT_HOST_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_DELETE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_MANIPULATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONFIGURE_HOST_NETWORK);
--- clusters actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CREATE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_EDIT_CLUSTER_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_DELETE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONFIGURE_CLUSTER_NETWORK);
-
--------------
---DATA_CENTER_ADMIN role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_DATA_CENTER_ADMIN_ID,'DataCenterAdmin','Administrator Role, permission for
all the objects underneath a specific Data Center, except Storage',true,1,true;
-
----Vm Groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_VM_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_VM_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CHANGE_VM_CD);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_MIGRATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONNECT_TO_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_IMPORT_EXPORT_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_VM_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_VM_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_MOVE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_MANIPULATE_VM_SNAPSHOTS);
--- templates actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_TEMPLATE_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_COPY_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_TEMPLATE_NETWORK);
--- vm pools actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_VM_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_VM_POOL_BASIC_OPERATIONS);
--- host (vds) actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_HOST_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_MANIPULATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_HOST_NETWORK);
--- clusters actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_CLUSTER_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_CLUSTER);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_CLUSTER_NETWORK);
--- storage pool actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_STORAGE_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_STORAGE_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_STORAGE_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_STORAGE_POOL_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_STORAGE_POOL_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_STORAGE_POOL_NETWORK);
-
--------------
---STORAGE_ADMIN role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_STORAGE_ADMIN_ID,'StorageAdmin','Administrator Role, permission for all
operations on a specific Storage Domain',true,1,true;
-
--- storage domains actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_CREATE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_EDIT_STORAGE_DOMAIN_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_DELETE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_MANIPULATE_STORAGE_DOMAIN);
-
--------------
---HOST_ADMIN role
----------------
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_HOST_ADMIN_ID,'HostAdmin','Administrator Role, permission for all operations
on a specific Host',true,1,true;
-
--- host (vds) actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_CREATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_EDIT_HOST_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_DELETE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_MANIPULATE_HOST);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_CONFIGURE_HOST_NETWORK);
--- storage domains actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_CREATE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_EDIT_STORAGE_DOMAIN_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_DELETE_STORAGE_DOMAIN);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_HOST_ADMIN_ID,v_MANIPULATE_STORAGE_DOMAIN);
-
-
--------------
---NETWORK_ADMIN role
----------------
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_NETWORK_ADMIN_ID,'NetworkAdmin','Administrator Role, permission for all
operations on a specific Logical Network',true,1,true;
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_NETWORK_ADMIN_ID,v_CONFIGURE_HOST_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_NETWORK_ADMIN_ID,v_CONFIGURE_CLUSTER_NETWORK);
-
--------------
---VM_ADMIN role
----------------
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_VM_ADMIN_ID,'UserVmManager','User Role, with permission for any operation on
Vms',true,2,true;
-
--- insert local admin user to users table and assign superuser permissions
-INSERT INTO users(user_id,name,domain,username,groups,status)
- SELECT v_LOCAL_ADMIN_ID, 'admin', 'internal', 'admin@internal','',1;
-
-INSERT INTO permissions(id,role_id,ad_element_id,object_id,object_type_id)
- SELECT uuid_generate_v1(), v_SUPER_USER_ID, v_LOCAL_ADMIN_ID,
getGlobalIds('system'), 1;
-
----Vm Groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_DELETE_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_EDIT_VM_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_VM_BASIC_OPERATIONS);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CHANGE_VM_CD);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CONNECT_TO_VM);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CONFIGURE_VM_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CONFIGURE_VM_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_MANIPULATE_VM_SNAPSHOTS);
-
--------------
---VM_POOL_ADMIN role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_VM_POOL_ADMIN_ID,'VmPoolAdmin','Administrator Role, permission for all
operations on a specific VM Pool',true,1,true;
-
--- vm pools actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_POOL_ADMIN_ID,v_CREATE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_POOL_ADMIN_ID,v_EDIT_VM_POOL_CONFIGURATION);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_POOL_ADMIN_ID,v_DELETE_VM_POOL);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_POOL_ADMIN_ID,v_VM_POOL_BASIC_OPERATIONS);
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_TEMPLATE_ADMIN_ID,'TemplateAdmin','Administrator Role, permission for all
operations on a specific Template',true,1,true;
--- templates actions groups
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_ADMIN_ID,v_CREATE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_ADMIN_ID,v_EDIT_TEMPLATE_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_ADMIN_ID,v_DELETE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_ADMIN_ID,v_COPY_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_ADMIN_ID,v_CONFIGURE_TEMPLATE_NETWORK);
-
--------------
---TEMPLATE_USER role
----------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_TEMPLATE_USER_ID,'TemplateUser','Template User',true,2,false;
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_QUOTA_CONSUMER_USER_ID, 'QuotaConsumer','User Role, permissions to consume
the Quota resources',true,2,false;
-
--- MAKE BLANK TEMPLATE PUBLIC
-INSERT INTO permissions (id,role_id,ad_element_id,object_id,object_type_id)
- SELECT uuid_generate_v1(),
- v_TEMPLATE_USER_ID, -- TemplateUser
- getGlobalIds('everyone'),
- '00000000-0000-0000-0000-000000000000', -- blank template id --
- 4; -- template object type id --
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_USER_ID,v_CREATE_VM);
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_DATA_CENTER_ADMIN_ID, v_MANIPULATE_QUOTA;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_MANIPULATE_QUOTA;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_DATA_CENTER_ADMIN_ID, v_CONSUME_QUOTA;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_CONSUME_QUOTA;
-INSERT INTO roles_groups (role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_FORCE_CONNECT_VM;
-
--- Disks
-
------------------
----SuperUser role
------------------
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CREATE_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_ATTACH_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_EDIT_DISK_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_CONFIGURE_DISK_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_SUPER_USER_ID,v_DELETE_DISK);
-
-
-----------------
---PowerUser role
-----------------
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_POWER_USER_ID,v_CREATE_DISK);
-
---------------------
---CLUSTER_ADMIN role
---------------------
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CREATE_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_ATTACH_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_EDIT_DISK_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_CONFIGURE_DISK_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_CLUSTER_ADMIN_ID,v_DELETE_DISK);
-
-
-------------------------
---DATA_CENTER_ADMIN role
-------------------------
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CREATE_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_ATTACH_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_EDIT_DISK_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_CONFIGURE_DISK_STORAGE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID,v_DELETE_DISK);
-
---------------------
---STORAGE_ADMIN role
---------------------
-
--- CREATE_DISK
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_CREATE_DISK);
--- ATTACH_DISK
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_ATTACH_DISK);
--- EDIT_DISK_PROPERTIES
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_EDIT_DISK_PROPERTIES);
--- CONFIGURE_DISK_STORAGE
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_CONFIGURE_DISK_STORAGE);
--- DELETE_DISK
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_STORAGE_ADMIN_ID,v_DELETE_DISK);
-
-
----------------
---VM_ADMIN role
----------------
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_CREATE_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_ATTACH_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_EDIT_DISK_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_VM_ADMIN_ID,v_DELETE_DISK);
-
---------------------------
--- DISK_OPERATOR_USER role
---------------------------
-DELETE FROM roles_groups WHERE role_id = v_DISK_OPERATOR_USER_ID;
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_DISK_OPERATOR_USER_ID, 'DiskOperator', 'User Role, permissions for all
operations on a specific disk', true, 2, true;
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DISK_OPERATOR_USER_ID,v_CREATE_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DISK_OPERATOR_USER_ID,v_ATTACH_DISK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DISK_OPERATOR_USER_ID,v_EDIT_DISK_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DISK_OPERATOR_USER_ID,v_DELETE_DISK);
-
--------------------------
--- DISK_CREATOR_USER role
--------------------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_DISK_CREATOR_USER_ID, 'DiskCreator', 'User Role, permission to create Disks',
true, 2, false;
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_DISK_CREATOR_USER_ID,v_CREATE_DISK);
-
--- Gluster
-
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_CREATE_GLUSTER_VOLUME;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_MANIPULATE_GLUSTER_VOLUME;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_SUPER_USER_ID,
v_DELETE_GLUSTER_VOLUME;
-
---------------
--- GLUSTER_ADMIN_USER role
---------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_GLUSTER_ADMIN_ROLE_ID, 'GlusterAdmin','Administrator Role, permissions for
operations on Gluster objects',true,1,true;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_GLUSTER_ADMIN_ROLE_ID, v_CREATE_GLUSTER_VOLUME;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_GLUSTER_ADMIN_ROLE_ID, v_MANIPULATE_GLUSTER_VOLUME;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_GLUSTER_ADMIN_ROLE_ID, v_DELETE_GLUSTER_VOLUME;
-
-
--------------------------
--- VM_CREATOR_USER role
--------------------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_VM_CREATOR_USER_ID, 'VmCreator', 'User Role, permission to create VMs', true,
2, false;
-INSERT INTO roles_groups(role_id,action_group_id) VALUES(v_VM_CREATOR_USER_ID,
v_CREATE_VM);
-
-
------------------------------
--- TEMPALTE_CREATOR_USER role
------------------------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_TEMPLATE_CREATOR_USER_ID, 'TemplateCreator', 'User Role, permission to create
Templates', true, 2, false;
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_CREATOR_USER_ID, v_CREATE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id) VALUES(
v_DATA_CENTER_ADMIN_ID, v_CONFIGURE_STORAGE_POOL_VM_INTERFACE);
-INSERT INTO roles_groups(role_id,action_group_id) VALUES( v_SUPER_USER_ID,
v_CONFIGURE_STORAGE_POOL_VM_INTERFACE);
-
------------------------------
--- TEMPALTE_OWNER_USER role
------------------------------
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children) SELECT
v_TEMPLATE_OWNER_USER_ID, 'TemplateOwner', 'User Role, permissions for all
operations on Templates', true, 2, true;
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_OWNER_USER_ID, v_EDIT_TEMPLATE_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_OWNER_USER_ID, v_DELETE_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_OWNER_USER_ID, v_COPY_TEMPLATE);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_OWNER_USER_ID, v_CONFIGURE_TEMPLATE_NETWORK);
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_TEMPLATE_OWNER_USER_ID, v_LOGIN);
-
--- Custom properties
-
-INSERT INTO roles_groups (role_id, action_group_id)
values(v_SUPER_USER_ID,v_CUSTOM_PROPERTIES);
-INSERT INTO roles_groups (role_id, action_group_id) values(v_CLUSTER_ADMIN_ID,
v_CUSTOM_PROPERTIES);
-INSERT INTO roles_groups (role_id, action_group_id)
values(v_DATA_CENTER_ADMIN_ID,v_CUSTOM_PROPERTIES);
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_VM_CREATOR_USER_ID,
v_CREATE_DISK;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT v_CLUSTER_ADMIN_ID,
v_MANIPULATE_PERMISSIONS;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_DATA_CENTER_ADMIN_ID, v_MANIPULATE_PERMISSIONS;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_TEMPLATE_OWNER_USER_ID, v_MANIPULATE_PERMISSIONS;
-INSERT INTO roles_groups(role_id,action_group_id) SELECT
v_DISK_OPERATOR_USER_ID, v_MANIPULATE_PERMISSIONS;
-INSERT INTO roles_groups(role_id,action_group_id)SELECT v_VM_ADMIN_ID,
v_MANIPULATE_PERMISSIONS;
-INSERT INTO roles_groups(role_id,action_group_id)SELECT v_VM_POOL_ADMIN_ID,
v_CREATE_VM;
-
--- Login
-
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_DATA_CENTER_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES (v_POWER_USER_ID,
v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_DISK_CREATOR_USER_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_TEMPLATE_CREATOR_USER_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_TEMPLATE_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_STORAGE_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES (v_VM_ADMIN_ID,
v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES (v_SUPER_USER_ID,
v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_VM_CREATOR_USER_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_DISK_OPERATOR_USER_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_CLUSTER_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES (v_USER_ID,
v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES (v_HOST_ADMIN_ID,
v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_VM_POOL_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_NETWORK_ADMIN_ID, v_LOGIN);
-INSERT INTO roles_groups (role_id, action_group_id) VALUES
(v_GLUSTER_ADMIN_ROLE_ID, v_LOGIN);
-
--- Networking
--- Add ASSIGN_CLUSTER_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_SUPER_USER_ID,
v_ASSIGN_CLUSTER_NETWORK);
-
--- Add ASSIGN_CLUSTER_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id)
VALUES(v_DATA_CENTER_ADMIN_ID, v_ASSIGN_CLUSTER_NETWORK);
-
--- Add ASSIGN_CLUSTER_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID,
v_ASSIGN_CLUSTER_NETWORK);
-
--- Add PORT_MIRRORING
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID,
v_CONFIGURE_STORAGE_POOL_VM_INTERFACE);
-
--- Add CONFIGURE_STORAGE_POOL_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID
,v_CONFIGURE_STORAGE_POOL_NETWORK);
-
--- Add CREATE_STORAGE_POOL_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID
,v_CREATE_STORAGE_POOL_NETWORK);
-
--- Add DELETE_STORAGE_POOL_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID
,v_DELETE_STORAGE_POOL_NETWORK);
-
--- Add CONFIGURE_VM_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID
,v_CONFIGURE_VM_NETWORK);
-
--- Add CONFIGURE_TEMPLATE_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_ADMIN_ID
,v_CONFIGURE_TEMPLATE_NETWORK);
-
--- ADD NetworkUser Role
-INSERT INTO roles(id,name,description,is_readonly,role_type)
values(v_NETWORK_USER_ID, 'NetworkUser', 'Network User', true, 2);
-
--- Add CONFIGURE_VM_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_USER_ID,
v_CONFIGURE_VM_NETWORK);
-
--- Add CONFIGURE_TEMPLATE_NETWORK
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_USER_ID,
v_CONFIGURE_TEMPLATE_NETWORK);
-
-
--------------------------------------------------------
--- Grant NetworkUser role to 'everyone' on all networks
--------------------------------------------------------
-
-INSERT INTO permissions (id,role_id, ad_element_id, object_id, object_type_id)
- (SELECT uuid_generate_v1(), v_NETWORK_USER_ID, getGlobalIds('everyone'),
id, 20 FROM network);
-
--- grant admin poweruser role on system
-v_ADMIN_USER_ID := user_id from users where username = 'admin@internal';
-insert into permissions(id,role_id,ad_element_id,object_id,object_type_id)
- values (uuid_generate_v1(), v_POWER_USER_ID, v_ADMIN_USER_ID,
getGlobalIds('system'), 1);
-
--- Add External Event Injection priviledge to super user
-INSERT INTO roles_groups(role_id,action_group_id) VALUES(v_SUPER_USER_ID,
v_EXTERNAL_EVENT_INJECTION);
-
------------------------------------
--- EXTERNAL_EVENT_CREATOR_USER role
------------------------------------
-
-INSERT INTO
roles(id,name,description,is_readonly,role_type,allows_viewing_children)
- values(v_EXTERNAL_EVENT_CREATOR_ID, 'ExternalEventsCreator', 'External
Events Creator', true, 2, false);
-
-INSERT INTO roles_groups(role_id,action_group_id)
VALUES(v_EXTERNAL_EVENT_CREATOR_ID, v_EXTERNAL_EVENT_INJECTION);
-
------------------------------------
--- GLUSTER VOLUME
------------------------------------
-
--- Create gluster volume
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_CREATE_GLUSTER_VOLUME_BRICKS, '3.1', '*');
-
--- Set gluster volume option
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_SET_GLUSTER_VOLUME, '3.1', '*');
-
--- Start gluster volume
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_START_GLUSTER_VOLUME, '3.1', '*');
-
--- Stop gluster volume
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_STOP_GLUSTER_VOLUME, '3.1', '*');
-
--- Reset gluster volume options
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_RESET_GLUSTER_VOLUME, '3.1', '*');
-
--- Delete gluster volume
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_DELETE_GLUSTER_VOLUME_BRICKS, '3.1', '*');
-
--- Gluster volume remove bricks
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_REMOVE_GLUTER_VOLUME_BRICKS, '3.1', '*');
-
--- Start gluster volume rebalance
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_REBALANCE_GLUSTER_VOLUME, '3.1', '*');
-
--- Replace gluster volume bricks
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_REPLACE_GLUSTER_VOLUME_BRICKS, '3.1', '*');
-
--- Add bricks to Gluster volume
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_ADD_GLUSTER_VOLUME_BRICKS, '3.1', '*');
-
--- Start Gluster volume profile
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_START_GLUSTER_VOLUME_PROFILE, '3.2', '*');
-
--- Stop gluster volume profile
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_STOP_LUSTER_VOLUME_PROFILE, '3.2', '*');
-
--- Remove gluster server
-insert into action_version_map (action_type, cluster_minimal_version,
storage_pool_minimal_version)
- values(v_REMOVE_GLUSTER_SERVER, '3.2', '*');
-
--- QUOTA
-INSERT INTO roles_groups(role_id,action_group_id)
- values(v_QUOTA_CONSUMER_USER_ID, v_CONSUME_QUOTA);
-
--- Add Login Permission
-INSERT INTO roles_groups(role_id, action_group_id) VALUES(v_NETWORK_USER_ID,
v_LOGIN);
-
--- lsm_version_support
-insert into action_version_map values (v_LIVE_MIGRATE_DISK, '3.2', '3.2');
-insert into action_version_map values (v_LIVE_MIGRATE_DISKS, '3.2', '3.2');
-
-
- RETURN;
-END; $procedure$
-LANGUAGE plpgsql;
-
-SELECT insert_predefined_roles();
-drop function insert_predefined_roles();
-
diff --git a/packaging/dbscripts/uuidgen.sh b/packaging/dbscripts/uuidgen.sh
new file mode 100755
index 0000000..a7310074
--- /dev/null
+++ b/packaging/dbscripts/uuidgen.sh
@@ -0,0 +1,17 @@
+#!/bin/sh
+
+if [ "$#" -ne 3 ]; then
+ echo "Usage: $0 <database user> <database name> <data directory>" >&2
+ exit 1
+fi
+
+user=$1
+db=$2
+dir=$3
+
+spid="00000017-0017-0017-0017-000000000052"
+clusterid="00000018-0018-0018-0018-0000000001ba"
+newspid=$(psql -U $user -c "select uuid_generate_v1();" --tuples-only $db | tr
-d ' ')
+newclusterid=$(psql -U $user -c "select uuid_generate_v1();" --tuples-only $db
| tr -d ' ')
+sed -i "s/'${spid}'/'${newspid}'/g" "${dir}"/*.sql
+sed -i "s/'${clusterid}'/'${newclusterid}'/g" "${dir}"/*.sql
--
To view, visit http://gerrit.ovirt.org/37256
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I89b8ecc31ca3a179886d84ae7f725282c5571c37
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emes...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
