Technote

(troubleshooting)
WebSphere Commerce cannot connect to the database
Problem(Abstract)
You update the database user password through the Configuration Manager. Then WebSphere Commerce is unable to connect to the database using the new password. You see the following error in the SystemOut.log:

com.ibm.websphere.ce.cm.StaleConnectionException: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Cause A failure occurred when updating the password by the Configuration Manager. The WebSphere Commerce configuration might have been updated correctly, but the configuration of the application might not have been updated. Resolving the problem

  1. Verify that the Commerce configuration has picked up this new password.

    1. Generate the encrypted-string version of your database user password:
      WC_installdir/bin/wcs_encrypt database_user_password

    2. Record the "ASCII encrypted string output", and verify it matches the value set in the config/InstanceProperties/Database/DB/DBUserPwd field in your WebSphere Commerce configuration file located in one of the following directories:

      WC_installdir/instances/instance/xml/instance.xml
      WC_userdir/instances/instance/xml/instance.xml

    3. If the encrypted strings do not match, replace the DBUserPwd value with the encrypted string generated by the wcs_encrypt command.

  2. Run the UpdateEAR ANT target for your WebSphere Commerce instance (for WebSphere Commerce 6.0 only).

  3. Configure the application to use the new database user password by completing the following steps:

    1. Open your WAS Administrative Console

    2. Navigate to Security > Global Security.

    3. Under Authentication, click JAAS Configuration.

    4. Click J2C Authentication Data and click the entry WC_instance - authDataAlias.

    5. Enter the new password and click Apply. Save your changes.

    6. Exit the WAS Administrative Console.

  4. Restart your WebSphere Commerce server, and verify that the 'SQL30082N' error does not show up in the SystemOut.log file.

Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Business Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4 Business Edition
Commerce WebSphere Commerce Professional Edition Configuration AIX, i5/OS, Linux, Solaris, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4, 5.6.1.4 Professional Edition
Commerce WebSphere Commerce - Express Configuration i5/OS, Linux, Windows 5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3, 5.6.1.4, 6.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4 Express
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21302798