Running into this issue.
/opt/dmarc/dmarcts-report-parser.pl -i -d
Adding missing table <rptrecord> to the database.
CREATE TABLE rptrecord (
id int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
serial int(10) unsigned NOT NULL,
ip int(10) unsigned,
ip6 binary(16),
rcount int(10) unsigned NOT NULL,
disposition enum('none','quarantine','reject'),
reason varchar(255),
dkimdomain varchar(255),
dkimresult enum('none','pass','fail','neutral','policy','temperror','permerror'),
spfdomain varchar(255),
spfresult enum('none','neutral','pass','fail','softfail','temperror','permerror','unknown'),
spf_align enum('fail','pass','unknown') NOT NULL,
dkim_align enum('fail','pass','unknown') NOT NULL,
identifier_hfrom varchar(255),
PRIMARY KEY (id), KEY serial (serial,ip), KEY serial6 (serial,ip6)) ;
DBD::mysql::db do failed: Multiple primary key defined at /opt/dmarc/dmarcts-report-parser.pl line 840.