Good morning,
> Job 3h6fb91P4GzGp6B at mx0.roessner-net.de (size 1349)
> received via 194.126.158.139 at Mon Jul 7 23:11:19 2014
> from domain = 'sys4.de'
> ATPS not checked
> Spam: not spam
> Signature 1 from sys4.de
> PASSED
> signed bytes: (whole message)
> Signature properties:
> Key properties:
> DNSSEC status: SECURE
> Extension data: rcpts=1
> Extension data: senderid=-1
> Extension data: spf=1
> Extension data: spam=1
I am missing some MySQL statements to get opendkim-importstats working correctly. It seems the provided schemas are outdated or I am missing it from somewhere in the docs (might be that I have not found it)
I have best guessed the statements:
alter table messages add rcpts int unsigned not null default 0;
alter table messages add senderid int not null default -1;
alter table messages add spf int not null default -1;
At least it is importing data right now. Are these tweaks ok?
Kind regards
-Christian Rößner
--
[*] sys4 AG
http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstraße 15, 81669 München
Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer
Aufsichtsratsvorsitzender: Florian Kirstein
Received on Tue Jul 08 2014 - 07:01:52 PST