#1136674 opendmarc-reports fails with SQL query (GROUP BY)

Package:
opendmarc
Source:
opendmarc
Description:
Domain-based Message Authentication, Reporting and Conformance (DMARC) milter
Submitter:
Daniel Moreda Garcia
Date:
2026-05-14 17:05:03 UTC
Severity:
normal
#1136674#5
Date:
2026-05-14 16:57:23 UTC
From:
To:
Dear all,

on Debian 12 there is a bug on the file:

    /usr/sbin/opendmarc-reports

whith the following SQL query:

$dbi_s = $dbi_h->prepare("SELECT repuri, adkim, aspf, requests.policy, spolicy, pct, UNIX_TIMESTAMP(lastsent), domains.name FROM requests JOIN messages ON messages.from_domain=requests.domain LEFT JOIN domains ON messages.policy_domain = domains.id WHERE domain = ? GROUP BY policy_domain,repuri,adkim,aspf,requests.policy,spolicy,pct,domains.name,lastsent");

More info here:
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html

On the Github source code is fixed:

$dbi_s = $dbi_h->prepare("SELECT repuri, adkim, aspf, policy, spolicy, pct, UNIX_TIMESTAMP(lastsent) FROM requests WHERE domain = ?");

Do you plan to update oldstable version?

Many thanks in advance,
Dani