Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-3049

The SQL query to expire old tokens truncates the date

XMLWordPrintable

      When Crowd issues a SQL query to expire old tokens (older than a certain reference timestamp), it is truncating the timestamp to a date, i.e., it ignores hours, minutes, seconds.

      This is the query as seen in the PostgreSQL logs:

      delete from cwd_token where last_accessed_date<$1

with parameter $1='2013-01-08 00:00:00'

      Consequently, tokens that should be expired are not being expired if the default session duration is in the range of hours or less.

            [CWD-3049] The SQL query to expire old tokens truncates the date

            There are no comments yet on this issue.

              dberrueta Diego Berrueta
              dberrueta Diego Berrueta
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: