Security fixes

Issue-ID: PORTAL-136, PORTAL-155, PORTAL-210,PORTAL-217

Includes JUNITS and docker changes, music integration and security fixes

Change-Id: Ib4ad7fbe28a3be9e159c4ab1f7818783c1ed5319
Signed-off-by: Kishore Reddy, Gujja (kg811t) <kg811t@research.att.com>

diff --git a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index fd3828a..5c9e9b5 100644 (file)
--- a/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -11,7 +11,7 @@
 -- -----------------------------------------------------------------------------------------------------------------
 set foreign_key_checks=1; 
 
-create database portal;
+create database portal_os;
 
 use portal;
 

diff --git a/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql b/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql
index 6461b13..eb1564e 100644 (file)
--- a/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql
+++ b/ecomp-portal-DB-os/PortalDMLMySql_2_1_OS.sql
@@ -127,27 +127,27 @@ insert into ep_app_role_function (id, app_id, role_id, function_cd, role_app_id)
 (4, 1, 1, 'menu|menu_logout|*', null),
 (5, 1, 16, 'url|login|*', null),
 (6, 1, 16, 'menu|menu_home|*', null),
-(7, 1, 16, 'menu|menu_logout|*',       null),
+(7, 1, 16, 'menu|menu_logout|*', null),
 (8, 1, 950, 'url|edit_notification|*', null),
 (9, 1, 950, 'url|getAdminNotifications|*', null),
 (10,1, 950, 'url|saveNotification|*', null),
-(11,1, 999,'url|userAppRoles|*','userAppRoles', null),
+(11,1, 999,'url|userAppRoles|*', null),
 (12,1, 999, 'url|getAdminNotifications|*', null),
-(13,1, 999,'url|userApps|*','User Apps'),
+(13,1, 999,'url|userApps|*', null),
 (14,1, 1010, 'menu|menu_web_analytics|*', null),
 (15, 1, 2115, 'menu|menu_web_analytics|*', null),
 (16, 1 , 1, 'menu|menu_acc_admin|*' , null),
-(17, 1 , 999 ,'menu|menu_acc_admin|*', null);
-(18,1,999,'url|centralizedApps|*','Centralized Apps', null),
-(19,1,999,'url|getAllWebAnalytics|*','Get All Web Analytics', null),
-(20,1,999,'url|getFunctionalMenuRole|*','Get Functional Menu Role', null),
-(21,1,999,'url|getNotificationAppRoles|*','Get Notification App Roles', null),
-(22,1,999,'url|getUserAppsWebAnalytics|*','Get User Apps Web Analytics', null),
-(23,1,999,'url|getUserJourneyAnalyticsReport|*','Get User Journey Report', null),
-(24,1,999,'url|get_roles%2f%2a|*','getRolesOfApp', null),
-(25,1,999,'url|get_role_functions%2f%2a|*','Get Role Functions', null),
-(26,1,999,'url|notification_code|*','Notification Code', null),
-(27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*','Save Role Function', null),
-(28,1,999,'url|syncRoles|*','SyncRoles', null);
+(17, 1 , 999 ,'menu|menu_acc_admin|*', null),
+(18,1,999,'url|centralizedApps|*', null),
+(19,1,999,'url|getAllWebAnalytics|*', null),
+(20,1,999,'url|getFunctionalMenuRole|*', null),
+(21,1,999,'url|getNotificationAppRoles|*', null),
+(22,1,999,'url|getUserAppsWebAnalytics|*', null),
+(23,1,999,'url|getUserJourneyAnalyticsReport|*', null),
+(24,1,999,'url|get_roles%2f%2a|*', null),
+(25,1,999,'url|get_role_functions%2f%2a|*', null),
+(26,1,999,'url|notification_code|*', null),
+(27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*', null),
+(28,1,999,'url|syncRoles|*', null);
 
 commit;    
\ No newline at end of file