summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKam Nasim <kam.nasim@windriver.com>2018-05-22 17:40:51 -0400
committerJack Ding <jack.ding@windriver.com>2018-07-31 09:26:34 -0400
commit032fb050390f59c41177d1d49e21626b54320a11 (patch)
tree0034546e0fcb70bb6d5b361d3ad0e40ad73c5910
parenta1a492908b8d654c4365846756a0af00b4e4388d (diff)
Configure DC Orch Identity Proxy SM service
This is part of Distributed Keystone for Distributed Cloud feature. Story: 2002842 Task: 22785 Change-Id: I0d0e60cc7482a451ba231066b4a470166238a3a7 Signed-off-by: Jack Ding <jack.ding@windriver.com>
Notes
Notes (review): Code-Review+2: John Kung <john.kung@windriver.com> Workflow+1: Jack Ding <Jack.Ding@windriver.com> Verified+2: Zuul Submitted-by: Zuul Submitted-at: Tue, 31 Jul 2018 21:26:42 +0000 Reviewed-on: https://review.openstack.org/587426 Project: openstack/stx-ha Branch: refs/heads/master
-rw-r--r--service-mgmt/sm-db-1.0.0/database/create_sm_db.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/service-mgmt/sm-db-1.0.0/database/create_sm_db.sql b/service-mgmt/sm-db-1.0.0/database/create_sm_db.sql
index 5eba529..4522f5f 100644
--- a/service-mgmt/sm-db-1.0.0/database/create_sm_db.sql
+++ b/service-mgmt/sm-db-1.0.0/database/create_sm_db.sql
@@ -125,6 +125,7 @@ INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(94,'no','distributed-cloud-services',
125INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(95,'no','controller-services','drbd-patch-vault','critical'); 125INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(95,'no','controller-services','drbd-patch-vault','critical');
126INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(96,'no','controller-services','patch-vault-fs','critical'); 126INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(96,'no','controller-services','patch-vault-fs','critical');
127INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(97,'no','distributed-cloud-services','dcorch-patch-api-proxy','critical'); 127INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(97,'no','distributed-cloud-services','dcorch-patch-api-proxy','critical');
128INSERT INTO "SERVICE_GROUP_MEMBERS" VALUES(98,'no','distributed-cloud-services','dcorch-identity-api-proxy','critical');
128CREATE TABLE SERVICES ( ID INTEGER PRIMARY KEY AUTOINCREMENT, PROVISIONED CHAR(32), NAME CHAR(32), DESIRED_STATE CHAR(32), STATE CHAR(32), STATUS CHAR(32), CONDITION CHAR(32), MAX_FAILURES INT, FAIL_COUNTDOWN INT, FAIL_COUNTDOWN_INTERVAL INT, MAX_ACTION_FAILURES INT, MAX_TRANSITION_FAILURES INT, PID_FILE CHAR(256) ); 129CREATE TABLE SERVICES ( ID INTEGER PRIMARY KEY AUTOINCREMENT, PROVISIONED CHAR(32), NAME CHAR(32), DESIRED_STATE CHAR(32), STATE CHAR(32), STATUS CHAR(32), CONDITION CHAR(32), MAX_FAILURES INT, FAIL_COUNTDOWN INT, FAIL_COUNTDOWN_INTERVAL INT, MAX_ACTION_FAILURES INT, MAX_TRANSITION_FAILURES INT, PID_FILE CHAR(256) );
129INSERT INTO "SERVICES" VALUES(1,'yes','oam-ip','initial','initial','none','none',2,1,90000,4,16,''); 130INSERT INTO "SERVICES" VALUES(1,'yes','oam-ip','initial','initial','none','none',2,1,90000,4,16,'');
130INSERT INTO "SERVICES" VALUES(2,'yes','management-ip','initial','initial','none','none',2,1,90000,4,16,''); 131INSERT INTO "SERVICES" VALUES(2,'yes','management-ip','initial','initial','none','none',2,1,90000,4,16,'');
@@ -218,6 +219,7 @@ INSERT INTO "SERVICES" VALUES(94,'no','dcorch-cinder-api-proxy','initial','initi
218INSERT INTO "SERVICES" VALUES(95,'no','drbd-patch-vault','initial','initial','none','none',2,1,90000,4,16,''); 219INSERT INTO "SERVICES" VALUES(95,'no','drbd-patch-vault','initial','initial','none','none',2,1,90000,4,16,'');
219INSERT INTO "SERVICES" VALUES(96,'no','patch-vault-fs','initial','initial','none','none',2,1,90000,4,16,''); 220INSERT INTO "SERVICES" VALUES(96,'no','patch-vault-fs','initial','initial','none','none',2,1,90000,4,16,'');
220INSERT INTO "SERVICES" VALUES(97,'no','dcorch-patch-api-proxy','initial','initial','none','none',2,1,90000,4,16,'/var/run/resource-agents/dcorch-patch-api-proxy.pid'); 221INSERT INTO "SERVICES" VALUES(97,'no','dcorch-patch-api-proxy','initial','initial','none','none',2,1,90000,4,16,'/var/run/resource-agents/dcorch-patch-api-proxy.pid');
222INSERT INTO "SERVICES" VALUES(98,'no','dcorch-identity-api-proxy','initial','initial','none','none',2,1,90000,4,16,'/var/run/resource-agents/dcorch-identity-api-proxy.pid');
221CREATE TABLE SERVICE_HEARTBEAT ( ID INTEGER PRIMARY KEY AUTOINCREMENT, PROVISIONED CHAR(32), NAME CHAR(32), TYPE CHAR(32), SRC_ADDRESS CHAR(256), SRC_PORT INT, DST_ADDRESS CHAR(256), DST_PORT INT, MESSAGE CHAR(256), INTERVAL_IN_MS INT, MISSED_WARN INT, MISSED_DEGRADE INT, MISSED_FAIL INT, STATE CHAR(32), MISSED INT, HEARTBEAT_TIMER_ID INT, HEARTBEAT_SOCKET INT ); 223CREATE TABLE SERVICE_HEARTBEAT ( ID INTEGER PRIMARY KEY AUTOINCREMENT, PROVISIONED CHAR(32), NAME CHAR(32), TYPE CHAR(32), SRC_ADDRESS CHAR(256), SRC_PORT INT, DST_ADDRESS CHAR(256), DST_PORT INT, MESSAGE CHAR(256), INTERVAL_IN_MS INT, MISSED_WARN INT, MISSED_DEGRADE INT, MISSED_FAIL INT, STATE CHAR(32), MISSED INT, HEARTBEAT_TIMER_ID INT, HEARTBEAT_SOCKET INT );
222CREATE TABLE SERVICE_DEPENDENCY ( DEPENDENCY_TYPE CHAR(32), SERVICE_NAME CHAR(32), STATE CHAR(32), ACTION CHAR(32), DEPENDENT CHAR(32), DEPENDENT_STATE CHAR(32), PRIMARY KEY (DEPENDENCY_TYPE, SERVICE_NAME, STATE, ACTION, DEPENDENT)); 224CREATE TABLE SERVICE_DEPENDENCY ( DEPENDENCY_TYPE CHAR(32), SERVICE_NAME CHAR(32), STATE CHAR(32), ACTION CHAR(32), DEPENDENT CHAR(32), DEPENDENT_STATE CHAR(32), PRIMARY KEY (DEPENDENCY_TYPE, SERVICE_NAME, STATE, ACTION, DEPENDENT));
223INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','oam-ip','not-applicable','enable','management-ip','enabled-active'); 225INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','oam-ip','not-applicable','enable','management-ip','enabled-active');
@@ -468,6 +470,10 @@ INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-sysinv-api-proxy','not-
468INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-sysinv-api-proxy','not-applicable','enable','dcorch-engine','enabled-active'); 470INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-sysinv-api-proxy','not-applicable','enable','dcorch-engine','enabled-active');
469INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','sysinv-inv','not-applicable','disable','dcorch-sysinv-api-proxy','disabled'); 471INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','sysinv-inv','not-applicable','disable','dcorch-sysinv-api-proxy','disabled');
470INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-engine','not-applicable','disable','dcorch-sysinv-api-proxy','disabled'); 472INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-engine','not-applicable','disable','dcorch-sysinv-api-proxy','disabled');
473INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-identity-api-proxy','not-applicable','enable','keystone','enabled-active');
474INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-identity-api-proxy','not-applicable','enable','dcorch-engine','enabled-active');
475INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','keystone','not-applicable','disable','dcorch-identity-api-proxy','disabled');
476INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-engine','not-applicable','disable','dcorch-identity-api-proxy','disabled');
471INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-nova-api-proxy','not-applicable','enable','nova-api','enabled-active'); 477INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-nova-api-proxy','not-applicable','enable','nova-api','enabled-active');
472INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-nova-api-proxy','not-applicable','enable','dcorch-engine','enabled-active'); 478INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','dcorch-nova-api-proxy','not-applicable','enable','dcorch-engine','enabled-active');
473INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','nova-api','not-applicable','disable','dcorch-nova-api-proxy','disabled'); 479INSERT INTO "SERVICE_DEPENDENCY" VALUES('action','nova-api','not-applicable','disable','dcorch-nova-api-proxy','disabled');
@@ -855,6 +861,10 @@ INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','enable','ocf-scr
855INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','disable','ocf-script','openstack','dcorch-sysinv-api-proxy','stop','',1,1,1,20,''); 861INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','disable','ocf-script','openstack','dcorch-sysinv-api-proxy','stop','',1,1,1,20,'');
856INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','audit-enabled','ocf-script','openstack','dcorch-sysinv-api-proxy','monitor','',2,2,2,20,5); 862INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','audit-enabled','ocf-script','openstack','dcorch-sysinv-api-proxy','monitor','',2,2,2,20,5);
857INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','audit-disabled','ocf-script','openstack','dcorch-sysinv-api-proxy','monitor','',0,0,0,20,5); 863INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-sysinv-api-proxy','audit-disabled','ocf-script','openstack','dcorch-sysinv-api-proxy','monitor','',0,0,0,20,5);
864INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-identity-api-proxy','enable','ocf-script','openstack','dcorch-identity-api-proxy','start','',2,2,2,20,'');
865INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-identity-api-proxy','disable','ocf-script','openstack','dcorch-identity-api-proxy','stop','',1,1,1,20,'');
866INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-identity-api-proxy','audit-enabled','ocf-script','openstack','dcorch-identity-api-proxy','monitor','',2,2,2,20,5);
867INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-identity-api-proxy','audit-disabled','ocf-script','openstack','dcorch-identity-api-proxy','monitor','',0,0,0,20,5);
858INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','enable','ocf-script','openstack','dcorch-nova-api-proxy','start','',2,2,2,20,''); 868INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','enable','ocf-script','openstack','dcorch-nova-api-proxy','start','',2,2,2,20,'');
859INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','disable','ocf-script','openstack','dcorch-nova-api-proxy','stop','',1,1,1,20,''); 869INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','disable','ocf-script','openstack','dcorch-nova-api-proxy','stop','',1,1,1,20,'');
860INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','audit-enabled','ocf-script','openstack','dcorch-nova-api-proxy','monitor','',2,2,2,20,5); 870INSERT INTO "SERVICE_ACTIONS" VALUES('dcorch-nova-api-proxy','audit-enabled','ocf-script','openstack','dcorch-nova-api-proxy','monitor','',2,2,2,20,5);