Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-21564

LAST_AUTH_TIMESTAMP column is not being updated

XMLWordPrintable

      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.

            [BAM-21564] LAST_AUTH_TIMESTAMP column is not being updated

            Zaro made changes -
            Link New: This issue is caused by CWD-4562 [ CWD-4562 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 2
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS New: 1
            Jan Majkutewicz (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            Karel Miranda made changes -
            Component/s Original: Security [ 11226 ]
            Component/s New: Database (Postgresql) [ 12170 ]
            Component/s New: Database (Oracle) [ 12661 ]
            Component/s New: Database (MySQL) [ 12662 ]
            Component/s New: Database (MS SQL) [ 12660 ]
            Bugfix Automation Bot made changes -
            Support reference count New: 1
            Karel Miranda made changes -
            Description Original: h3. 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.

            h3. Steps to Reproduce
            # Try to authenticate to Bamboo with any user using an incorrect password;
            # Check the

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

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

            h3. Workaround
            There is no workaround for this.             		New: h3. 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.

            h3. Steps to Reproduce
            # 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:
            {code:sql}
            SELECT USER_NAME, LAST_AUTH_TIMESTAMP
            FROM AUTH_ATTEMPT_INFO
            WHERE USER_NAME = 'usernameUsedToLogIn';
            {code}

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

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

            h3. Workaround
            There is no workaround for this.
            Karel Miranda made changes -
            Summary Original: LAST_AUTH_TIMESTAMP is not being updated with the latest timestamp every time a user tries to login with an incorrect password New: LAST_AUTH_TIMESTAMP column is not being updated
            Karel Miranda created issue -

              Unassigned Unassigned
              kmiranda Karel Miranda
              Affected customers:
              0 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated: