IBM Support

Database user 'maximo' user password change

Troubleshooting


Problem

Some difficulty may arise when using the chpwd-tivsam.sh script (provided in ISDM 724 level) to change the database user 'maximo' password.

Symptom

Using the chpwd-tivsam script you find that the script cannot complete and reports an error.
ISDM0029I Changing maximo password in maximo.properties files... FAILED

Cause

This has been identified as a product defect under APAR IV51687

Resolving The Problem

summary of items to check:

1. Ensure that the umask in your root user profile is set at 022 or lower. A restrictive umask will (eg, 077) will update the properties.jar file with a resulting file mode that is too restrictive for WebSphere to unpack the jar file during MXServer startup.

2. Check for any files under /opt/IBM/WebSphere/AppServer/profiles/ctgAppSrv01 directory which are not owned by tioadmin user. eg,
find /opt/IBM/WebSphere/AppServer/profiles/ctgAppSrv01 -user root
If this returns any entries, please change the ownership (chown) to be tioadmin:tioadmin
In a typical ISDM environment we require file permissions as tioadmin. If any security hardening has taken place then the script may fail.

3. Check the /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties file. Is it configured with the db user as 'ctginst1' rather than 'maximo'? if yes, then change the file so that it is configured with 'maximo'
mxe.db.user=maximo

4. The file /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties should have only 1 single entry for the plaintext mxe.db.password value defined. If it has 2 entries delete one. If it does not have any mxe.db.password value defined then define one.

5. run the chpwd-tivsam.sh to change the 'maximo' password and verify that the resulting file /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties has been updated correctly:
- mxe.encrypted=true
- file ends with the encrypted data buffer
- there is no plaintext mxe.db.password value defined

If the file is not being encrypted correctly, then review and run this step:

6. Run the /opt/IBM/SMP/maximo/tools/maximo/encryptproperties.sh to encrypt the plaintext mxe.db.password value. Check the resulting /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties has been updated correctly:
- mxe.encrypted=true
- file ends with the encrypted data buffer
- there is no plaintext mxe.db.password value defined

7. Check the resulting /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties
and ensure it has 644 permissions.

8. Insert the updated /opt/IBM/SMP/maximo/applications/maximo/properties/maximo.properties
file into the /opt/IBM/WebSphere/AppServer/profiles/ctgAppSrv01/installedApps/ctgCell01/MAXIMO.ear/properties.jar

[{"Product":{"code":"SSBH2C","label":"IBM Service Delivery Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"7.2.4","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFG5E","label":"Tivoli Service Automation Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"7.2.4;7.2.4.1;7.2.4.2;7.2.4.3;7.2.4.4","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
IBM Service Delivery Manager

Software version:
7.2.4

Operating system(s):
AIX, Linux

Document number:
501773

Modified date:
17 June 2018

UID

swg21655693

Manage My Notification Subscriptions