Index of /rddmarc

 Name                    Last modified      Size  Description
 Parent Directory                             -   
 mkdmarc.sql             2024-08-06 15:08  5.3K  
 dmarcagg.py             2024-08-06 12:02   12K  
 dmarcfail.py            2017-10-20 10:24  4.3K  
 rddmarc                 2016-05-01 17:44  8.2K  
 mkdmarc-update          2016-05-01 17:44  1.8K  
 mysql_ip6.c             2011-05-15 11:48  2.9K  

These are little scripts to parse DMARC reports.

The first, dmarcagg.py, is a python script that take an incoming DMARC summary report email, extracts and unpacks the gzip or ZIP file, parses the XML, and puts the parts about received mail into a MySQL database. The database is set up to handle reports about multiple domains from multiple reporters. It's handling reports from Google, Yahoo, xs4all and Netease.

It takes filenames on the command line, each of which contains a mail message, or reads the message from stdin if there are no names.

It works great on FreeBSD, can probably be made to work on linux with modest effort, no clue about other systems.

The second is a python script to parse failure reports. It expects file names on the command line, or if no arguments, it reads stdin. It needs the usual MySQLdb module. It handles reports from Netease, which are currently the only ones I'm getting.

UPDATE: Thanks to John Bieling for some updates to rddmarc to log the policy_published and policy_evaluated fields

• mkdmarc.sql - SQL to create the tables
• mkdmarc-update - SQL to add new policy fields to the old schema
• dmarcagg.py - the script to parse summary reports (python)
• dmarcfail.py - the script to parse failure reports (python)
• mysql_ip6.c - C language source for MySQL plugin for IPv6 formatting functions, not needed in MySQL 8.x
• rddmarc - the old script to parse summary reports (Perl)