Hide Forgot
Description of problem: I migrated satellite 5.7 from oracle to postgresql. I followed documentation [1] step by step. I compared outputs of spacewalk-report before and after migration. The data is different in date: >> diff report/users.cvs report.old/users.cvs < 2,Org 1,21,org1,Localhost,Test,,root@localhost,Organization Administrator,2016-03-23 08:38:15,,enabled > 2,Org 1,21,org1,Localhost,Test,,root@localhost,Organization Administrator,2016-03-23 12:38:15,,enabled Problem exists in following outputs: .. system-history-channels, system-history-entitlements, system-history, splice-export, inventory, inactive-systems, audit-users, audit-servers, activation-keys I suppose that problem is timezone, because shift is exactly 4 hour. [1] https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Migrating_from_an_External_Oracle_Database_to_an_External_PostgreSQL_Database.html Version-Release number of selected component (if applicable): spacewalk-java-2.3.8-128.el6sat.noarch spacewalk-schema-2.3.2-24.el6sat.noarch How reproducible: always Steps to Reproduce: 1. Install satellite 5.7 oracle 2. Run spacewalk-report .. 3. Migrate to satellite 5.7 with postgresql 4. Compare spacewalk-report Actual results: different date in results Expected results: correct date in result
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog. This is a low priority bug and has no currently open customer cases. While this bug may still valid, we do not see it being implemented prior to the EOL of the Satellite 5.x product. As such, this is being CLOSED DEFERRED. Closing now to help set customer expectations as early as possible. You are welcome to re-open this bug if needed.