Symantec IGA

Expand all | Collapse all

Update DB details in Provision Manager

  • 1.  Update DB details in Provision Manager

    Posted 07-29-2021 03:19 AM
    Hello Community,

    We are using DB connectors for end points. DB updated in one endpoint now we need to change new DB details in provisioning manager.
    We are unable to open endpoint details in provisioning manager. Getting error like JDBC:Cannont createPoolableConnectionFactory(IO Error:The Network Adapter could not establish the connection). For other applications details are coming, only for one not showing.


    Please help us to solve this issue, so that we can update new details in place of old DB details.

    Regards,
    Girish Chandra


  • 2.  RE: Update DB details in Provision Manager

    Posted 07-29-2021 03:38 AM
    Hello,

    We are not able to open one of the end point in provisioning manager which DB got crashed.
    Now we are not able to update new DB details.

    Please need help on this.

    Regards,
    Girish


  • 3.  RE: Update DB details in Provision Manager

    Posted 07-30-2021 08:08 AM
    Hi Girish,

    Its possible to update this via Proviosing Directory via Jexplorer we did the same salesforce endpoint


  • 4.  RE: Update DB details in Provision Manager

    Posted 07-31-2021 06:09 AM
    Hi Bhanu Sudheer,

    My endpoint works with DB connector. If yours also same, Please explain process in JXplorer how and where we need to update DB details.

    Regards,
    Girish


  • 5.  RE: Update DB details in Provision Manager

    Posted 08-02-2021 06:06 AM
    Hi Bhanu,

    We tried to open endpoint in provision directory via Jxplorer. But we are not able to open endpoint details in that also.

    Please need help on this, how to update new DB details in place of crashed old DB.

    Regards,
    Girish


  • 6.  RE: Update DB details in Provision Manager

    Broadcom Employee
    Posted 08-02-2021 07:34 AM

    Hi Girish,

     

    You cannot access to your Endpoint via JXplorer if you connect to the prov server (20389). You could via the prov dir (20391) and make the change but it won't work either after when you will try to display your endpoint

     

    What do you need to change in this endpoint definition? The JDBC URL? Or/and something else? Is it vApp?

     

    Thanks,

    Joffrey.


    This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.





  • 7.  RE: Update DB details in Provision Manager

    Posted 08-03-2021 04:55 AM
    Hello Joffrey Lemoigne,

    We need to update User name, Password and Connection URI for endpoint. We tried to open endpoint in provisioning directory(20389) via Jxplorer, but not opened.

    How can we update DB details, Please need help on this.

    Regards,
    Girish


  • 8.  RE: Update DB details in Provision Manager

    Broadcom Employee
    Posted 08-03-2021 05:57 AM

    Hi Girish,

     

    Assuming your connector is a JDBC one deployed via ConXpress, you can try 2 ways:

     

    1. via etautil:

     

    • Create a file with the values to be updated, change them accordingly e.g.

     

    update 'eTNamespaceName=WUTANGDB MSSQL2014' eTDYNDirectory eTDYNDirectoryName='wutangdb - mssql2014' to eTDYNPassword=dbuserpwd_changeme eTDYNUser=dbuser_changeme eTDYNConnectionURL="jdbc:sqlserver://;serverName=sqlserver2014.ca.local;portNumber=1433;databaseName=wutangdb"

     

    • run

     

    etautil -DYN -u etaadmin -p apassword -f filename

     

     

    1. via ldapmodify:

     

    • Create a file with the values to be updated, change them accordingly e.g.

     

    dn: eTDYNDirectoryName=wutangdb - mssql2014,eTNamespaceName=WUTANGDB MSSQL2014,dc=im,dc=eta

    replace: eTDYNConnectionURL

    eTDYNConnectionURL: jdbc:sqlserver://;serverName=sqlserver2014.ca.local;portNumber=1433;databaseName=wutangdb

    eTDYNPassword: dbuserpwd_changeme

    eTDYNUser: dbuser_changeme

     

    ·         Run

     

    ldapmodify -x -H "LDAP://localhost:20389" -D "eTGlobalUserName=etaadmin,eTGlobalUserContainerName=Global Users,eTNamespaceName=CommonObjects,dc=im,dc=eta" -W -f filename

     

     

    Both etautil and ldapmodify can be found on the provisioning server, bin folder. The ldapmodify way can be used if your password has some special characters that break etautil command parsing algo. If it's the case, worth to base64 encode the password and set it in the ldif file (need to specify :: in this case e.g. eTDYNPassword:: base64encodedpwd)

     

    Please validate your command in a lower environment 1st.

     

    HTH,

    Joffrey.

     

     

     


    This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.





  • 9.  RE: Update DB details in Provision Manager

    Posted 08-04-2021 06:32 AM
    Hello,

    Thanks for your advise.

    We need to create one new endpoint in provisioning manager same like old one with JDBC URI.

    Please help us to create new endpoint, and mapping with that in IDM for user provisioning.

    Regards,
    Girish