[opendmarc-users] opendmarc-import: throwing errors. Something is wrong!

[Robert Chalmers]

The reporting script is exactly as used on many sites.


I use MySQL
Server version: 5.6.25

Perl version p5.22

OSX 10.10.2


This morning after the cron run - The output log looks like the following.
So this morning I opened the db and altered it.

mysql> show tables;
+---------------------+
| Tables_in_opendmarc |
+---------------------+
| domains             |
| ipaddr              |
| messages            |
| reporters           |
| requests            |
| signatures          |
+---------------------+
6 rows in set (0.00 sec)

mysql> update requests set locked='0';
Query OK, 25 rows affected (0.01 sec)
Rows matched: 27  Changed: 25  Warnings: 0

mysql> quit

Now tomorrow morning I will see what happens.

I don’t want to do a test run, because it will only regenerate more email reports that will effectively be ‘spamming’ the reported hosts.

This is the Cron job run output. Each one of those errors is a JOB: NUMBER in the created dat file. See end of this list….

opendmarc-import: started at Fri Dec 11 00:00:04 2015
opendmarc-import: connected to database
opendmarc-import: updating at line 19
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 19.
opendmarc-import: updating at line 37
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 37.
opendmarc-import: updating at line 55
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 55.
opendmarc-import: updating at line 73
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 73.
opendmarc-import: updating at line 91
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 91.
opendmarc-import: updating at line 110
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 110.
opendmarc-import: updating at line 129
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 129.
opendmarc-import: updating at line 147
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 147.
opendmarc-import: updating at line 165
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 165.
opendmarc-import: updating at line 183
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 183.
opendmarc-import: updating at line 201
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 201.
opendmarc-import: updating at line 219
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 219.
opendmarc-import: updating at line 237
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 237.
opendmarc-import: updating at line 255
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 255.
opendmarc-import: updating at line 273
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 273.
opendmarc-import: updating at line 291
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 291.
opendmarc-import: updating at line 309
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 309.
opendmarc-import: updating at line 327
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 327.
opendmarc-import: updating at line 345
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 345.
opendmarc-import: updating at line 364
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 364.
opendmarc-import: updating at line 383
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 383.
opendmarc-import: updating at line 402
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 402.
opendmarc-import: updating at line 420
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 420.
opendmarc-import: updating at line 438
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 438.
opendmarc-import: updating at line 457
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 457.
opendmarc-import: updating at line 475
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 475.
opendmarc-import: updating at line 493
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 493.
opendmarc-import: updating at line 511
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 511.
opendmarc-import: updating at line 529
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 529.
opendmarc-import: updating at line 547
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 547.
opendmarc-import: updating at line 565
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 565.
opendmarc-import: updating at line 582
Use of uninitialized value in numeric ne (!=) at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 582.
opendmarc-import: terminating at Fri Dec 11 00:00:09 2015
opendmarc-reports: started at Fri Dec 11 00:00:13 2015
opendmarc-reports: selected 10 domain(s)
opendmarc-reports: sent report for zimbra.com to dmarc at zimbra.com (2.0.0 Ok: queued as B5C8219458BB)
opendmarc-reports: sent report for swid.co.uk to dmarc-rua at swid.co.uk (2.0.0 Ok: queued as 3B1FA19458BF)
opendmarc-reports: sent report for andreasschulze.de to rua at dmarc.andreasschulze.de (2.0.0 Ok: queued as AE9D419458C4)
opendmarc-reports: sent report for andreasschulze.de to d at rua.agari.com (2.0.0 Ok: queued as E9DE819458C8)
opendmarc-reports: sent report for prime.gushi.org to dmarcfail2014 at gushi.org (2.0.0 Ok: queued as 680B619458D5)
opendmarc-reports: sent report for wordpress.com to 0bqp2jnw at ag.dmarcian.com (2.0.0 Ok: queued as 9D15B19458D9)
opendmarc-reports: terminating at Fri Dec 11 00:00:16 2015
opendmarc-expire: started at Fri Dec 11 00:00:17 2015
opendmarc-expire: connected to database
opendmarc-expire: expiring messages older than 180 day(s)
opendmarc-expire: expiring signatures on expired messages (id < 1)
opendmarc-expire: expiring request data older than 180 days
opendmarc-expire: terminating at Fri Dec 11 00:00:17 2015
opendmarc-expire: no rows deleted
opendmarc-expire: no rows deleted
opendmarc-expire: no rows deleted



The error does NOT occur on this first line, but starts at line 19 ???? the next job number
job 1602918D5FDA <————————————— This is the number and line where the above error is reported
reporter zeus.chalmers.com.au
received 1449768976
ipaddr 127.0.0.1
from chalmers.com.au
mfrom chalmers.com.au
spf 0
pdomain chalmers.com.au
policy 15
rua mailto:eclq31iz at ag.dmarcian.com
pct 100
adkim 114
aspf 114
p 114
sp 0
align_dkim 5
align_spf 4
action 2
job F39B118FDBC4 <————————————— This is the number and line where the above error is reported
reporter zeus.chalmers.com.au
received 1449771505
ipaddr 217.169.24.114
from swid.co.uk
mfrom swid.co.uk
spf 0
pdomain swid.co.uk
policy 15
rua mailto:dmarc-rua at swid.co.uk
pct 100
adkim 114
aspf 114
p 114
sp 0
align_dkim 5
align_spf 4
action 2
job 2BEE918FDDF5


> On 10 Dec 2015, at 22:29, A. Schulze <sca at andreasschulze.de> wrote:
> 
> Am 10.12.2015 um 23:12 schrieb Robert Chalmers:
>> The field is initialised with NULL, it isn’t set up with “0” as it comes from the opendmarc.mysql database set up.
> which db do you use?
> 
>> 
>> So I will check and enter 0 in all the records?
> that may help

Robert Chalmers
robert at chalmers.com.au  Quantum Radio: http://tinyurl.com/lwwddov
Mac mini 6.2 - 2012, Intel Core i7,2.3 GHz, Memory:16 GB. El-Capitan 10.11. 2TB Storage made up of - 
Drive 0:HGST HTS721010A9E630. Upper bay. Drive 1:ST1000LM024 HN-M101MBB. Lower Bay