Symantec IGA

 View Only
  • 1.  Unable to edit ca-standalone-full-ha.xml for adding datasource

    Posted Jul 22, 2020 08:59 AM
    After upgrade of vApp, IM from 14.1->14.3, the file /opt/CA/wildfly-idm/standalone/configuration/ca-standalone-full-ha.xml has been updated.

    We had below piece of extra code in the file and got removed after upgrade and hence broke the functionality using this datasource.

    <datasource jndi-name="java:jboss/datasources/jdbc/ext-ds" pool-name="ext-ds" enabled="true">
    <connection-url>jdbc:oracle:thin:@xxxxxxxxxxxxx:xxxxx</connection-url>
    <driver>ojdbc</driver>
    <security>
    <security-domain>ext-ds</security-domain>
    </security>
    </datasource>

    Also the file added under /opt/CA/VirtualAppliance/custom/IdentityManager/dataSources/ext-ds.prop  has DB details as well.

    IMAG_PACKAGE=IM
    DB_TYPE=ORACLE
    DATASOURCE_NAME=ext-ds
    DB_URL=jdbc:oracle:thin:@xxxxxxxxxxxxx:xxxxx
    DB_USER=im_user

    I'm tried to update file "ca-standalone-full-ha.xml" which is not editable in vApp with config user and hence I connected with jboss admin user

    /opt/CA/wildfly-idm/bin/jboss-cli.sh --connect --user=jbosscli --password=xxxxxxxx --command=:take-snapshot

    after this I need to add new data source with below details and I'm unaware how to add using /subsystem=datasources command

    <datasource jndi-name="java:jboss/datasources/jdbc/ext-ds" pool-name="ext-ds" enabled="true">
    <connection-url>jdbc:oracle:thin:@xxxxxxxxxxxxx:xxxxx</connection-url>
    <driver>ojdbc</driver>
    <security>
    <security-domain>ext-ds</security-domain>
    </security>
    </datasource>

    Could you please help me with similar command or how can I edit the file any other possible way.
    Link I found but it has some differences. https://knowledge.broadcom.com/external/article/133305/can-i-modify-wildfly-standalone-xml-conf.html


  • 2.  RE: Unable to edit ca-standalone-full-ha.xml for adding datasource

    Broadcom Employee
    Posted Jul 22, 2020 09:16 AM
    In 14.2 CP1 the addJBossDatasource alias was added.  Any issue using the alias?

    addJBossDatasource

    Adds a defined custom data source that is referenced as an argument pointing to a property file (normally at "/opt/CA/VirtualAppliance/custom/<APP>/ dataSources") across all nodes running either the CA Identity Portal or CA Identity Manager applications.

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-suite/14-3/virtual-appliance/administering-virtual-appliance/using-the-login-shell.html

    Please also review the following:

    Create Datasource

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-suite/14-2/virtual-appliance/configuring-virtual-appliance.html

    Thank you.



    ------------------------------
    Best regards,

    Scott Owens
    Sr Support Engineer

    ------------------------------
    And, as always Perhaps there are others in the communities who have experience in doing this and we invite them to comment here also.

    Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at enterprisestudio@hcl.com. https://www.hcltech.com/enterprise-studio
    ------------------------------
    ------------------------------