Fix (APAR): PK86137 Status: Fix Release: 7.0.0.5,7.0.0.3 Operating System: AIX,Linux,Solaris,Windows Supersedes Fixes: CMVC Defect: PK86137 Byte size of APAR: 17297 Date: 2009-07-28 Abstract: Database User Password is printed in FFDC log in cleartext. Description/symptom of problem: PK86137 resolves the following problem: ERROR DESCRIPTION: WebSphere Application Server 7.0.0.1 ND When the Database user and password are set using the wsadmin scripts while configuring the JAAS-J2C Authentication Data, the password value appears in clear text in the FFDC logs. The following entry in the FFDC log could be observed to determine the above problem. com.ibm.db2.jcc.DB2PooledConnection::password_:my_password "my_password" appears in clear text which should not be the case. LOCAL FIX: N/A PROBLEM SUMMARY USERS AFFECTED: All users of IBM WebSphere Application Server V6.1 & V7.0 PROBLEM DESCRIPTION: Database User Password is printed in FFDC log in cleartext. RECOMMENDATION: None When JAAS - J2C authentication data is set and there is a failure in execution of interaction represented by InteractionSpec ,FFDC is generated. The FFDC has a password defined in plain text. The FFDC : [6/15/09 2:19:12:921 SGT] FFDC Exception:javax.resource.ResourceException SourceId:com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute ProbeId:139 Reporter:com.ibm.ws.rsadapter.cci.WSInteractionImpl@2c132c13 javax.resource.ResourceException at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteraction Impl.java:457) at com.ibm.wsspi.ejbpersistence.WSEJBToRAAdapter.executeFinder(WSEJ BToRAAdapter.java:212) at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSR elationalRAAdapter.java:433) at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execu teOneRowFBPK(DataAccessRequestImpl.java:576) at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulIns tanceExtensionImpl.fetchRecordFromDataStore(ConcreteBeanStateful InstanceExtensionImpl.java:910) at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulIns tanceExtensionImpl.hydrateRecordForLoad(ConcreteBeanStatefulInst anceExtensionImpl.java:839) In the FFDC the password would printed : com.ibm.db2.jcc.DB2PooledConnection::password_:my_password PROBLEM CONCLUSION: Added the FFDC introspectself to the class which is printing the password. This would be automaticaly called to print only relevant FFDC information excluding sensitive information formatted as a String array. The fix for this APAR is currently targeted for inclusion in fix packs 6.1.0.29 and 7.0.0.7 Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980 Directions to apply fix: Fix applies to Editions: Release 7.0 __ Application Server (Express or BASE) X __ Network Deployment (ND) X Install Fix to all WebSphere installations unless special instructions are included below. Special Instructions: None NOTE: The user must: * Logged in with the same authority level when unpacking a fix, fix pack or refresh pack. * Be at V6.1.0.13 or newer of the Update Installer. Certain iFixes may require a newer version of the Update Installer and the Update Installer will inform you during the installation process if a newer version is required. This can be checked by reviewing the level of the Update Installer in file /updateinstaller/version.txt. The Update Installer can be downloaded from the following link: http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991 1) If your iFix is delivered as a single file with a .pak extension, Copy the .pak file directly to the maintenance directory. If your iFix is delivered as a single file with a .zip extension, unzip the file into the maintenance directory. 2) Shutdown WebSphere Manually execute setupCmdLine.bat in Windows or . ./setupCmdLine.sh in Unix from the WebSphere instance that maintenance is being applied to. 3) For IBM i users, use the update command to install and uninstall the interim fix. The IBM Information Center can provide additional details, if needed, on the use of this command. http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-iseries&topic=rins_update. For non-IBM i users, launch the Update Installer and click the Next button on the Welcome page. 4) Enter the directory path of the installation location of the WebSphere product you want to update, and click the Next button. 5) Select the "Install maintenance package" operation and click the Next button. 6) Enter the directory path of your maintenance directory where you have the maintenance packages (.pak files) and click the Next button. 7) The Available Maintenance Package to Install page should list all maintenance packages (.pak files) that it finds in the directory path provided in the previous step. The Update Installer will select the correct maintenance packages based on your system configuration and will not allow an invalid combination to be installed. Please keep the Update Installer recommendations and click the Next button and continue with the installation of the maintenance package. To determine why some maintenance packages have been identified as not applicable, see description in log found in /logs/tmp*/updatelogs.txt 8) For all platforms except Windows. In pre-install summary panel, use the "verify permission" feature to verify the user has permissions to apply updates to files associated with the selected maintenance. Correct any file permissions before clicking next to start the install. 9) Restart WebSphere Directions to remove fix: NOTE: * The user must have Administrative rights in Windows, or be the Actual Root User in a UNIX environments. * FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED * DO NOT REMOVE A FIX UNLESS ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED * YOU MAY REAPPLY ANY REMOVED FIX Example: If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be removed, fix3 must be removed first, fix2 removed, and fix3 re-applied. 1) Shutdown WebSphere Manually execute setupCmdLine.bat in Windows or . ./setupCmdLine.sh in Unix from the WebSphere instance that uninstall is being run against. 2) Start Update Installer 3) Enter the installation location of the WebSphere product you want to remove the fix. 4) Select "Uninstall maintenance package" operation. 5) Enter the file name of the maintenance package to uninstall (PKxxxxx.pak). 6) UnInstall maintenance package. 7) Restart WebSphere Directions to re-apply fix: 1) Shutdown WebSphere. 2) Follow the Fix instructions to apply the fix. 3) Restart WebSphere. Additional Information: