Skip to content

Instantly share code, notes, and snippets.

View tharikaGitHub's full-sized avatar

Tharika Madurapperuma tharikaGitHub

10 followers · 0 following
View GitHub Profile
@tharikaGitHub
tharikaGitHub / exportPublicCert.txt
Created April 26, 2018 05:03
keytool -export -keystore wso2carbon.jks -alias wso2carbon -file wso2carbon.cer
@tharikaGitHub
tharikaGitHub / importPublicCert.txt
Last active April 26, 2018 05:10
keytool -import -alias wso2carbon1 -file wso2carbon.cer -keystore client-truststore.jks -storepass wso2carbon
@tharikaGitHub
tharikaGitHub / UserStorePasswordEncrypt.sh
Last active September 13, 2019 05:25
#!/bin/bash
echo " "
echo "Password encryption started .. !"
export WSO2_SERVER_HOME="/home/user/wso2am-2.6.0"
cp -RL data/* $WSO2_SERVER_HOME/
sleep 2
rm -rf data/*
PRODUCT_HOME=${WSO2_SERVER_HOME}
CRYPTO_TOOL_HOME="$PRODUCT_HOME/bin/crypto-tool"
USERSTORE_FILE="$PRODUCT_HOME/repository/deployment/server/userstores/xyz_com.xml"
@tharikaGitHub
tharikaGitHub / ServerStartupListener.java
Created October 20, 2019 15:14
/*
* Copyright (c) 2019, WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
*
* WSO2 Inc. licenses this file to you under the Apache License,
* Version 2.0 (the "License"); you may not use this file except
* in compliance with the License.
* You may obtain a copy of the License at
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
@tharikaGitHub
tharikaGitHub / StartupServiceComponent.java
Created October 20, 2019 15:16
/*
* Copyright (c) 2019 WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
*
* WSO2 Inc. licenses this file to you under the Apache License,
* Version 2.0 (the "License"); you may not use this file except
* in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
@tharikaGitHub
tharikaGitHub / reg_log_cleanup.sql
Created February 11, 2020 10:10
REG_LOG Table Cleanup Script
CREATE TABLE REG_LOG_IDS_TO_KEEP (
REG_LOG_ID INTEGER,
REG_TENANT_ID INTEGER
);
INSERT INTO REG_LOG_IDS_TO_KEEP (REG_LOG_ID, REG_TENANT_ID)
SELECT MAX(REG_LOG_ID) AS REG_LOG_ID, REG_TENANT_ID FROM REG_LOG GROUP BY REG_PATH, REG_TENANT_ID;
DELETE FROM REG_LOG WHERE REG_LOG_ID NOT IN (SELECT REG_LOG_ID FROM REG_LOG_IDS_TO_KEEP);
DROP TABLE REG_LOG_IDS_TO_KEEP;
@tharikaGitHub
tharikaGitHub / reg_tag_cleanup_type2.sql
Created February 11, 2020 15:33
REG_TAG and REG_RESOURCE_TAG Table Cleanup Scripts Type 2
CREATE TABLE TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID INTEGER);
-- Extract resource tag (ID) created when versioning is disabled --
INSERT INTO TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID)
SELECT REG_TAG_ID
FROM REG_RESOURCE_TAG
WHERE REG_PATH_ID IN
(SELECT REG_PATH_ID
FROM REG_RESOURCE);
@tharikaGitHub
tharikaGitHub / reg_tag_cleanup_type3.sql
Created February 11, 2020 15:35
REG_TAG and REG_RESOURCE_TAG Table Cleanup Scripts Type 3
CREATE TABLE TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID INTEGER);
-- Extract resource tag (ID) created when versioning is disabled --
INSERT INTO TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID)
SELECT REG_TAG_ID
FROM REG_RESOURCE_TAG
WHERE REG_PATH_ID IN
(SELECT REG_PATH_ID
FROM REG_RESOURCE);
@tharikaGitHub
tharikaGitHub / reg_tag_cleanup_type1.sql
Last active February 11, 2020 15:35
REG_TAG and REG_RESOURCE_TAG Table Cleanup Scripts Type 1
CREATE TABLE TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID INTEGER);
-- Extract resource tag (ID) created when versioning is disabled --
INSERT INTO TEMP_REG_RESOURCE_TAG_ID(REG_TAG_ID)
SELECT REG_TAG_ID
FROM REG_RESOURCE_TAG
WHERE REG_PATH_ID IN
(SELECT REG_PATH_ID
FROM REG_RESOURCE);
@tharikaGitHub
tharikaGitHub / reg_property_cleanup_type2.sql
Created February 11, 2020 15:38
REG_PROPERTY and REG_RESOURCE_PROPERTY Table Cleanup Scripts Type 2
CREATE TABLE TEMP_REG_RESOURCE_PROPERTY_ID(REG_PROPERTY_ID INTEGER);
-- Extract resource property (ID) created when versioning is disabled --
INSERT INTO TEMP_REG_RESOURCE_PROPERTY_ID(REG_PROPERTY_ID)
SELECT REG_PROPERTY_ID
FROM REG_RESOURCE_PROPERTY
WHERE REG_PATH_ID IN
(SELECT REG_PATH_ID
FROM REG_RESOURCE);