Bug #22952
closedAccount for different datetime format in Suse errata
Description
Suse uses a different datetime format than what Katello currently expects. Instead of a formatted data and time, they use seconds since Epoch. This is preventing Katello from correctly parsing the date, leading to a blank entry.
Further, it looks like the issue happens during or before the values are stored in the katello_errata table.
id | uuid | errata_id | created_at | updated_at | issued | updated | errata_type | severity |
1 | 003a57f6-48e7-4752-aa07-7c62ac288d17 | openSUSE-2017-1284 | 2018-03-19 13:54:40.547011 | 2018-03-19 13:54:40.552124 | | | recommended | moderate |
Example: <issued date="1519129773" />
Suse's documentation on their updateinfo metadata: https://en.opensuse.org/openSUSE:Standards_Rpm_Metadata_UpdateInfo
Verification steps:
1. Sync a suse repository that contains errata.
- http://download.opensuse.org/update/openSUSE-stable/
2. Check that the issued and updated dates (if applicable) show up correctly in the UI/CLI/API
Updated by Justin Sherrill almost 7 years ago
- Target version set to 245
- Translation missing: en.field_release set to 284
- Difficulty set to easy
Updated by The Foreman Bot over 6 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/7255 added
Updated by John Mitsch over 6 years ago
- Translation missing: en.field_release changed from 284 to 352
Updated by John Mitsch over 6 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|2e718b8bc247bf7cb3a1b0efac97b5b5c17b130e.