View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 332 | RackTables | default | public | 2010-05-06 14:55 | 2010-11-29 13:24 |
| Reporter | infrastation | Assigned To | |||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.17.0 | ||||
| Target Version | 0.17.11 | Fixed in Version | 0.17.11 | ||
| Summary | 332: LDAP cache expires earlier, than configured | ||||
| Description | SQL constructs used in functions acquireLDAPCache() and discardLDAPCache() are incorrect: "now() - first_success as success_age" >= real success_age "now() - last_retry as retry_age" >= real retry_age This happens because of timestamps being converted into strings and then to integers before subtraction (difference between 2000-01-01 18:00:00 and 2000-01-01 19:00:00 this way becomes 10000, not 3600). The correct way to find number of seconds between ts1 and ts2 (where ts2 > ts1) is: TIMESTAMPDIFF(SECOND, ts1, ts2) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-05-06 14:55 | infrastation | New Issue | |
| 2010-05-06 14:56 | infrastation | Status | new => confirmed |
| 2010-05-06 14:56 | infrastation | Target Version | => 0.17.11 |
| 2010-05-09 19:07 |
|
Status | confirmed => assigned |
| 2010-05-09 19:07 |
|
Assigned To | => user145 |
| 2010-05-09 19:11 |
|
Note Added: 0000066 | |
| 2010-05-09 19:11 |
|
Status | assigned => resolved |
| 2010-05-09 19:11 |
|
Fixed in Version | => 0.17.11 |
| 2010-05-09 19:11 |
|
Resolution | open => fixed |
| 2010-11-29 13:24 | infrastation | Status | resolved => closed |
