[opendmarc-users] Solved: Update to opendmarc-import errors on OSX 10.11.2. Seems Solved

[Robert Chalmers]

Previously I was having problems with this. 

opendmarc-import: updating at line 19
Use of uninitialized value in string ne at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 19.
opendmarc-import: updating at line 37
Use of uninitialized value in string ne at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 37.
opendmarc-import: updating at line 55
Use of uninitialized value in string ne at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 55.
opendmarc-import: updating at line 73
Use of uninitialized value in string ne at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 73.
opendmarc-import: updating at line 90
Use of uninitialized value in string ne at /usr/local/sbin/opendmarc-import line 278, <STDIN> line 90.
opendmarc-import: terminating at Thu Dec 10 17:36:14 2015
opendmarc-reports: started at Thu Dec 10 17:36:15 2015
opendmarc-reports: selected 8 domain(s)


So I went into the opendmarc MySql database, and looked in ‘requests’ -> ‘locked’ - which is the area of the problem. 
The setup sql file that comes with opendmarc sets all empty table fields to NULL - which it doesn’t like. It can’t compare NULL with a value.
So I set all the ‘locked’ fields to ‘0’ (zero) 

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


Now when I run the script, with reporting commented out, and expiring commented out, there are no more errors.

zeus:bin robert$ sudo /usr/local/bin/opendmarc-send-reports.sh
opendmarc-import: started at Fri Dec 11 09:17:07 2015
opendmarc-import: connected to database
opendmarc-import: updating at line 19
opendmarc-import: updating at line 37
opendmarc-import: updating at line 54
opendmarc-import: terminating at Fri Dec 11 09:17:07 2015
/tmp/opendmarc.32062

… and it tells me that the /tmp file is now actually being removed.

So next step. Run the whole thing complete - nothing commented out.

zeus:bin robert$ sudo /usr/local/bin/opendmarc-send-reports.sh
opendmarc-import: started at Fri Dec 11 09:26:37 2015
opendmarc-import: connected to database
opendmarc-import: terminating at Fri Dec 11 09:26:37 2015
opendmarc-reports: started at Fri Dec 11 09:26:38 2015
opendmarc-reports: selected 5 domain(s)
opendmarc-reports: terminating at Fri Dec 11 09:26:38 2015
opendmarc-expire: started at Fri Dec 11 09:26:38 2015
opendmarc-expire: connected to database
opendmarc-expire: expiring messages older than 180 day(s)
opendmarc-expire: no rows deleted
opendmarc-expire: expiring signatures on expired messages (id < 1)
opendmarc-expire: no rows deleted
opendmarc-expire: expiring request data older than 180 days
opendmarc-expire: no rows deleted
opendmarc-expire: terminating at Fri Dec 11 09:26:38 2015
/tmp/opendmarc.32277


and presto bumpo - it appears to be working. At least - I am not getting errors reported anymore.





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