Update DB details in Provision Manager

[Girish Chandra]

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

[Girish Chandra]

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

[bhanu sudheer]

Hi Girish,

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

[Girish Chandra]

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

[Girish Chandra]

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

[Joffrey Lemoigne]

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.

[Girish Chandra]

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

[Joffrey Lemoigne]

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

 

 

2. 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 1^st.

 

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.

[Girish Chandra]

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