userjack6880 / Open-Report-Parser

A Perl based tool to parse DMARC reports from an IMAP mailbox or from the filesystem, and insert the information into a database. Derived from Techsneeze's dmarcts-report-parser
GNU General Public License v3.0
33 stars 9 forks source link

[Bug]: Potential Duplicate ReportIDs possible #15

Open userjack6880 opened 1 year ago

userjack6880 commented 1 year ago

Per Issue #112 on the pre-fork version, it's been pointed out that Duplicate ReportIDs are possible. It is possible to fix, and a solution is provided, though the implementation is not quite what we need. Adapt the solution to this project and include a check to automatically update the index in both Maria and PostgreSQL (index checks would be different for the two versions). Perhaps introduce an update script instead?