[opendmarc-users] Reporting: can't create report files for domains.

[Philip]

Hi there,

I've installed everything nicely and it seems to be working as expected 
other than the reporting stuff.  I've tried changing the permissions but 
not happening... I'm sure it's something simple I've over looked.

My report script is as follows...

#!/bin/bash

DB_SERVER='localhost'
DB_USER='opendmarc'
DB_PASS='(redacted)'
DB_NAME='opendmarc'
WORK_DIR='/var/run/opendmarc'
REPORT_EMAIL='no-reply at dmarc.(redacted).com'
REPORT_ORG='orion.(redacted).com'

mv ${WORK_DIR}/opendmarc.dat ${WORK_DIR}/opendmarc_import.dat -f
cat /dev/null > ${WORK_DIR}/opendmarc.dat

/usr/sbin/opendmarc-import --dbhost=${DB_SERVER} --dbuser=${DB_USER} 
--dbpasswd=${DB_PASS} --dbname=${DB_NAME} --verbose < 
${WORK_DIR}/opendmarc_import.dat
/usr/sbin/opendmarc-reports --dbhost=${DB_SERVER} --dbuser=${DB_USER} 
--dbpasswd=${DB_PASS} --dbname=${DB_NAME} --verbose --interval=86400 
--report-email $REPORT_EMAIL --report-org $REPORT_ORG
/usr/sbin/opendmarc-expire --dbhost=${DB_SERVER} --dbuser=${DB_USER} 
--dbpasswd=${DB_PASS} --dbname=${DB_NAME} --verbose

I have a cron that runs a bash once a day. It runs fine it's not 
creating the reporting.

philip at orion:~# su -c "/etc/opendmarc/report-script" -s /bin/bash opendmarc

opendmarc-import: started at Thu Jan  4 13:14:40 2018
opendmarc-import: connected to database
opendmarc-import: updating at line 18
opendmarc-import: terminating at Thu Jan  4 13:14:40 2018
opendmarc-reports: started at Thu Jan  4 13:14:40 2018
opendmarc-reports: selected 7 domain(s)
opendmarc-reports: can't create report file for domain (redacted).com
opendmarc-reports: can't create report file for domain (redacted).co.nz
opendmarc-reports: can't create report file for domain (redacted).com
opendmarc-reports: can't create report file for domain (redacted).com
opendmarc-reports: can't create report file for domain (redacted).com
opendmarc-reports: can't create report file for domain (redacted).nz
opendmarc-reports: terminating at Thu Jan  4 13:14:40 2018
opendmarc-expire: started at Thu Jan  4 13:14:40 2018
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 Thu Jan  4 13:14:40 2018

Any Suggestions that will help make it work appreciated.

Phil