Error "Last acquisition attempt exception: java.sql.SQLException: Login failed for user 'ussdbadmin'" when starting Unified Self-Service (USS)

Document ID : KB000004717
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

The USS homepage is blank and never loads. The following error appears in liferay.year-mm-dd.log for USS when starting the USS services:

com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@42e643c9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Login failed for user 'ussdbadmin'.

 

 

Environment:
Service Desk Manager 14.1Unified Self-Service 14.1
Cause:

The USSDBADMIN account password has been set without encryption in the portal-ext.properties file, but the jdbc.default.encrypted.password setting is set to true

Resolution:

1.  Stop all Unified Self-Service (USS) services

2.  Go to USS install directory (by default, C:\Program Files\CA\Self Service\OSOP) and make a backup of the portal-ext.properties file

3.  Open portal-ext.properties with a text editor and locate the line for 'jdbc.default.encrypted.password=true' and set the value to false

(i.e. jdbc.default.encrypted.password=false)

4.  Save changes to the file.

5.  Restart the USS service