Updating DB connections post install

[jburns80]

So we had UA 4.6.2 running just fine, upgraded to 4.7 and no issue. However after upgrading to 4.7.2 per MF request we are now having a logon issue for our Oracle 12c DB. I'm assuming the install corrupted the credentials somewhere as Everything was working fine until the 4.7.2 install. Does anyone know the way to update these credentials? MF support keeps giving me generic answers and pointing me to documentation that doesn't have anything to do with this. I've tried also searching the web and haven't found anything, I know in the old way you could actually edit an xml file. Any help is greatly appreciated.

[Alex McHugh]

jburns80 <jburns80@no-mx.forums.microfocus.com> wrote:
>
So we had UA 4.6.2 running just fine, upgraded to 4.7 and no issue.
However after upgrading to 4.7.2 per MF request we are now having a
logon issue for our Oracle 12c DB. I'm assuming the install corrupted
the credentials somewhere as Everything was working fine until the 4.7.2
install. Does anyone know the way to update these credentials? MF
support keeps giving me generic answers and pointing me to documentation
that doesn't have anything to do with this. I've tried also searching
the web and haven't found anything, I know in the old way you could
actually edit an xml file. Any help is greatly appreciated.


Yes. Have done this recently on 4.7.1. (Not oracle though but same
principle)
It is sorta documented.
https://www.netiq.com/documentation/identity-manager-47/identity_apps_admin_472/data/netiq-update-password-for-database-user-tomcat.html

There is a jar that will convert your password into the hashed version that
is expected.

Note each time you run this, it will give you a different hash even with
same input password. This is normal.

[geoffc]

On 1/17/2019 2:57 PM, Alex McHugh wrote:
> jburns80 <jburns80@no-mx.forums.microfocus.com> wrote:
>>
> So we had UA 4.6.2 running just fine, upgraded to 4.7 and no issue.
> However after upgrading to 4.7.2 per MF request we are now having a
> logon issue for our Oracle 12c DB. I'm assuming the install corrupted
> the credentials somewhere as Everything was working fine until the 4.7.2
> install. Does anyone know the way to update these credentials? MF
> support keeps giving me generic answers and pointing me to documentation
> that doesn't have anything to do with this. I've tried also searching
> the web and haven't found anything, I know in the old way you could
> actually edit an xml file. Any help is greatly appreciated.
>
>
> Yes. Have done this recently on 4.7.1. (Not oracle though but same
> principle)
> It is sorta documented.
> https://www.netiq.com/documentation/identity-manager-47/identity_apps_admin_472/data/netiq-update-password-for-database-user-tomcat.html
>
> There is a jar that will convert your password into the hashed version that
> is expected.
>
> Note each time you run this, it will give you a different hash even with
> same input password. This is normal.

The passwords in the ism-configuration.properties hashed passwords can
be generated with the bin/encrypt-password.sh in Identity Governance,
and I think is there in Identity Apps as well.

The DB password should be in Tomcat server.xml and use the same format.

The OSP adminusers.txt file uses a different encrypt format and there is
a JAR for it noted in the docs.