Skip to main content

Mounting remote governance registry

Let's say we have AS instance and G-reg instance, both instance have pointed their governance registry to MySql database.

Now I want to mount the AS's governance registry to G-reg's /_system/as/governance path

1. Shutdown both instances

2. Configurations to be done in G-reg side (in registry.xml file)

mount G-reg governance registry as

<mount path="/_system/governance" overwrite="true">
        <instanceId>greggov</instanceId>
        <targetPath>/_system/governance</targetPath>
    </mount>

mount AS governance registry as

<mount path="/_system/as/governance" overwrite="true">
        <instanceId>asgov</instanceId>
        <targetPath>/_system/as/governance</targetPath>
    </mount>

3. Configuration to be done in AS side (in registry.xml file)

mount AS governance registry

<mount path="/_system/governance" overwrite="true">
        <instanceId>asgov</instanceId>
        <targetPath>/_system/as/governance</targetPath>
    </mount>

4. Now we need to do a data migration as follows
Use AS database and execute following sql commands

Update REG_PATH Set REG_PATH_VALUE = REPLACE(REG_PATH_VALUE, '/_system/governance', '/_system/as/governance') where REG_PATH_VALUE like '/_system/governance%';

Update REG_LOG Set REG_PATH = REPLACE(REG_PATH, '/_system/governance', '/_system/as/governance') where REG_PATH like '/_system/governance%';

Update REG_LOG Set REG_ACTION_DATA = REPLACE(REG_ACTION_DATA, '/_system/governance', '/_system/as/governance') where REG_ACTION_DATA like '%/_system/governance%';

Update REG_ASSOCIATION Set REG_SOURCEPATH = REPLACE(REG_SOURCEPATH, '/_system/governance', '/_system/as/governance'), REG_TARGETPATH = REPLACE(REG_TARGETPATH, '/_system/governance', '/_system/as/governance') where REG_SOURCEPATH like '/_system/governance%' or REG_TARGETPATH like '/_system/governance%';

5. Restart the both instances.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to generate random unique number in SOAP UI request

eg 1: ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} eg 2: ${=java.util.UUID.randomUUID()} ${=java.util.UUID.randomUUID()} ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf ${=System.currentTimeMillis() + ((int)(Math.random()*10000))} - See more at: http://tryitnw.blogspot.com/2014/03/generating-random-unique-number-in-soap.html#sthash.m2S4tUFu.dpuf
Post a Comment
Read more

Create Application in WSO2 App Cloud via REST API

This blog post gives you some examples on how to use createApplication REST API correctly in WSO2 App Cloud  https://docs.wso2.com/display/AppCloud/Published+APIs Before invoke createApplication API, you need to login to the WSO2 App Cloud and get the session cookie. curl -c cookies -v -k -X POST -k https://apps.cloud.wso2.com/appmgt/site/blocks/user/login/ajax/login.jag -d 'action=login&userName=amalka.wso2.com@<tenant>&password=<password>’ This are some basic example to create applications in WSO2 App Cloud. Create application via upload from file system curl -v -k -b cookies -X POST https://apps.cloud.wso2.com/appmgt/site/blocks/application/application.jag -F action=createApplication -F applicationName=SampleFile -F applicationDescription=desc -F runtime=1 -F appTypeName=war -F applicationRevision=1.0.0 -F uploadedFileName=sample.war -F runtimeProperties=[] -F tags=[]  -F fileupload=@/home/amalka/Downloads/sample.war -F isFileAttached=t...
Post a Comment
Read more

Send email via WSO2 ESB with several attachments

WSO2 ESB Mail transport allows you to send a email only with 1 attachment. If you want to send number of attachments here's the solution. Scenario: Here I want to extract some content from the input message and attach to the email as two different attachment. Solution:  You can achieve this requirement using Gmail connector. Steps:  Add the Gmail connector to the ESB and enable it. You can download the esb connector here https://storepreview.wso2.com/store/assets/esbconnector/a1fba975-89fb-4bb0-a1b9-9f9d061fb31c Add it to the ESB and enable it https://docs.wso2.com/display/ESB481/Managing+Connectors+in+Your+ESB+Instance Gmail connector documentation https://docs.wso2.com/display/ESBCONNECTORS/Gmail+Connector Setup the scenario: split the input message and send it with an email using two different attachments. Input message I used <email>         <username>sender@gmail.com<...
2 comments
Read more