LAST_AUTH_TIMESTAMP column is not being updated

XMLWordPrintable

    • 1
    • Severity 3 - Minor
    • 0

      Issue Summary

      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.

      Steps to Reproduce

      1. Try to authenticate to Bamboo with any user using an incorrect password multiple times;
      2. 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';
        

      Expected Results

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

      Actual Results

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

      Workaround

      There is no workaround for this.

            Assignee:
            Unassigned
            Reporter:
            Karel Miranda
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: