[BAM-21564] LAST_AUTH_TIMESTAMP column is not being updated

Type: Bug
Resolution: Unresolved
Priority: Low
Fix Version/s: None
Affects Version/s: 8.0.0, 8.0.1, 8.0.2, 8.0.3, 8.1.1, 8.0.4, 8.0.5
Component/s: Database (MS SQL), Database (MySQL), Database (Oracle), Database (Postgresql)
Labels:
None

The LAST_AUTH_TIMESTAMP column from the AUTH_ATTEMPT_INFO table is not being updated with the latest attempt of a user to log in into Bamboo.

Try to authenticate to Bamboo with any user using an incorrect password multiple times;

Check the value of the column LAST_AUTH_TIMESTAMP.AUTH_ATTEMPT_INFO by running this SQL query:

SELECT USER_NAME, LAST_AUTH_TIMESTAMP
FROM AUTH_ATTEMPT_INFO
WHERE USER_NAME = 'usernameUsedToLogIn';

The column should be updated with the latest authentication attempt timestamp.

The column does not get updated with the latest authentication attempt timestamp.

There is no workaround for this.

is caused by

CWD-4562 Store last login dates in a per-application basis

There are no comments yet on this issue.