<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Ok, this fixed it.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div class="">I opted to change this line in opendmarc-expire to</div><div class=""><br class=""></div><div class=""><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">$dbi_s = $dbi_h->prepare("DELETE FROM requests WHERE lastsent <= DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL ? DAY) AND NOT lastsent = <b class="">'1970-01-01 00:00:00'”)</b>;</span></div><div class=""><span class="" style="font-variant-ligatures: no-common-ligatures;"> </span></div></div></div><div class="">It was </div><div class=""><br class=""></div><div class=""><span style="font-family: Menlo; font-size: 11px;" class="">$dbi_s = $dbi_h->prepare("DELETE FROM requests WHERE lastsent <= DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL ? DAY) AND NOT lastsent = '</span><b class="">0000-00-00 00:00:00</b><span style="font-family: Menlo; font-size: 11px;" class="">'”);</span></div><div class=""><span style="font-family: Menlo; font-size: 11px;" class=""><br class=""></span></div><div class=""><span style="font-family: Menlo; font-size: 11px;" class=""><br class=""></span></div><div class=""><span style="font-family: Menlo; font-size: 11px;" class="">This </span>0000-00-00 00:00:00 in the code meant that MySQL threw an error before it even got to the database because MySQL is set to No_ZERO_DATE and simply won’t allow it. When the perl script ran, MySql refused it. </div><div class=""> So I changed that line in the script, and also changed the db structure and made sure that the requests -> lastsent field in the database was defaulting to <span style="font-family: Menlo; font-size: 11px;" class="">1970-01-01 00:00:00 - a non-zero date. and now</span><b style="font-family: Menlo; font-size: 11px;" class=""> </b><span style="font-family: Menlo; font-size: 11px;" class="">all is well.</span><b style="font-family: Menlo; font-size: 11px;" class=""> As mentioned previously.</b></div><div class=""><b style="font-family: Menlo; font-size: 11px;" class=""><br class=""></b></div><div class=""><b style="font-family: Menlo; font-size: 11px;" class=""><br class=""></b></div><div class=""><b style="font-family: Menlo; font-size: 11px;" class=""><br class=""></b></div><div class=""><span style="font-family: Menlo; font-size: 11px;" class="">The endo of the</span><b class=""><font face="Menlo" class=""><span style="font-size: 11px;" class=""> run from last night’s cron job. All is now well.</span></font></b></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><font face="Menlo" class=""><span style="font-size: 11px;" class=""><b class="">…</b></span></font></div><div class=""><font face="Menlo" class=""><span style="font-size: 11px;" class=""><b class="">…</b></span></font></div><div class=""><b class=""><font face="Menlo" class=""><span style="font-size: 11px;" class="">… </span></font></b></div><div class="">opendmarc-import: updating at line 817<br class="">opendmarc-import: terminating at Sat Jun 25 00:00:02 2016<br class="">opendmarc-reports: started at Sat Jun 25 00:00:04 2016<br class="">opendmarc-reports: selected 196 domain(s)<br class="">opendmarc-reports: sent report for <a href="http://andreasschulze.de" class="">andreasschulze.de</a> to <a href="mailto:rua@dmarc.andreasschulze.de" class="">rua@dmarc.andreasschulze.de</a> (2.0.0 Ok: queued as 1FD44376F737)<br class="">opendmarc-reports: sent report for <a href="http://andreasschulze.de" class="">andreasschulze.de</a> to <a href="mailto:d@rua.agari.com" class="">d@rua.agari.com</a> (2.0.0 Ok: queued as 719B9376F73A)<br class="">opendmarc-reports: sent report for <a href="http://quantum-radio.net" class="">quantum-radio.net</a> to <a href="mailto:eclq31iz@ag.dmarcian.com" class="">eclq31iz@ag.dmarcian.com</a> (2.0.0 Ok: queued as 8E11C376F77E)<br class="">opendmarc-reports: sent report for <a href="http://sapienti-sat.org" class="">sapienti-sat.org</a> to <a href="mailto:rua@dmarc.sapienti-sat.org" class="">rua@dmarc.sapienti-sat.org</a> (2.0.0 Ok: queued as 4A148376F7B6)<br class="">opendmarc-reports: sent report for <a href="http://sapienti-sat.org" class="">sapienti-sat.org</a> to <a href="mailto:pbozavy3@ag.dmarcian.com" class="">pbozavy3@ag.dmarcian.com</a> (2.0.0 Ok: queued as 6CFD4376F7B7)<br class="">opendmarc-reports: sent report for <a href="http://coinbase.com" class="">coinbase.com</a> to <a href="mailto:jpohmdhp@ag.dmarcian.com" class="">jpohmdhp@ag.dmarcian.com</a> (2.0.0 Ok: queued as B5C57376F7C5)<br class="">opendmarc-reports: sent report for avc.su to <a href="mailto:hisnb7cu@ag.dmarcian-eu.com" class="">hisnb7cu@ag.dmarcian-eu.com</a> (2.0.0 Ok: queued as 51AAD376F7E4)<br class="">opendmarc-reports: terminating at Sat Jun 25 00:00:09 2016<br class="">opendmarc-expire: started at Sat Jun 25 00:00:09 2016<br class="">opendmarc-expire: connected to database<br class="">opendmarc-expire: expiring messages older than 180 day(s)<br class="">opendmarc-expire: expiring signatures on expired messages (id < 56)<br class="">opendmarc-expire: expiring request data older than 180 days<br class="">opendmarc-expire: terminating at Sat Jun 25 00:00:09 2016<br class="">opendmarc-expire: 29 row(s) deleted<br class="">opendmarc-expire: no rows deleted<br class="">opendmarc-expire: 1 row(s) deleted<br class="">/tmp/opendmarc.11864<br class="">/tmp/opendmarc.18088<br class="">/tmp/opendmarc.39908<br class="">/tmp/opendmarc.62399<br class="">/tmp/opendmarc.89241</div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On 24 Jun 2016, at 21:55, Benny Pedersen <<a href="mailto:me@junc.eu" class="">me@junc.eu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">On 2016-06-24 21:50, A. Schulze wrote:<br class=""><br class=""><blockquote type="cite" class="">Anyway: I noticed some messages ago the default of opendmarc-epire set<br class=""> to 180 days.<br class="">I only store two days or so. That keep the database significant smaller.<br class=""></blockquote><br class="">i have made it to 8 days, and just report weekly, so opendmarc-report takes data from 7 days backlog<br class=""><br class="">works well here<br class="">_______________________________________________<br class="">opendmarc-users mailing list<br class=""><a href="mailto:opendmarc-users@trusteddomain.org" class="">opendmarc-users@trusteddomain.org</a><br class="">http://www.trusteddomain.org/mailman/listinfo/opendmarc-users<br class=""></div></div></blockquote></div><br class=""></body></html>