Package: opendmarc
Version: 1.4.2-2+b1
Severity: normal
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
-- System Information:
Debian Release: 12.13
APT prefers oldstable-updates
APT policy: (500, 'oldstable-updates'), (500, 'oldstable-security'), (500,
'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 6.1.0-45-amd64 (SMP w/4 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/bash
Init: systemd (via /run/systemd/system)
Versions of packages opendmarc depends on:
ii adduser 3.134
ii dbconfig-mysql 2.0.24
ii debconf [debconf-2.0] 1.5.82
ii init-system-helpers 1.65.2+deb12u1
ii libbsd0 0.11.7-2
ii libc6 2.36-9+deb12u13
ii libmilter1.0.1 8.17.1.9-2+deb12u2
ii libopendmarc2 1.4.2-2+b1
ii publicsuffix 20230209.2326-1
ii sysvinit-utils [lsb-base] 3.06-4
Versions of packages opendmarc recommends:
ii libdbd-mysql-perl 4.050-5+b1
ii libdbi-perl 1.643-4
ii libhttp-message-perl 6.44-1
ii libjson-perl 4.10000-1
ii libopendbx1 1.4.6-16+b1
pn libopendbx1-mysql <none>
ii libswitch-perl 2.17-3
ii perl 5.36.0-7+deb12u3
Versions of packages opendmarc suggests:
ii libmime-tools-perl 5.510-1
pn libxml-simple-perl <none>
pn python <none>
pn python-mysqldb <none>
-- Configuration Files:
/etc/opendmarc.conf changed [not included]
-- debconf information excluded
