search

userjack6880 / Open-DMARC-Analyzer

Open DMARC Analyzer is an Open Source DMARC Report Analyzer to be used with DMARC reports that have been parsed by John Levine's rrdmarc script or techsneeze's dmarcts-report-parser.
GNU General Public License v3.0
214 stars 23 forks source link

[Question]: SQL #108

Open ElectricMediaUK opened 2 months ago

ElectricMediaUK commented 2 months ago

I'm trying to install Open DMARC Analyzer however I'm getting the error below, can anyone advise how to resolve this?

connecting to database... success opening file... success → CREATE VIEW IF NOT EXISTS report_stats AS ( → SELECT → report.serial, domain, rcount, disposition, reason, → policy_p, policy_pct, dkimdomain, dkimresult, dkim_align, → spfdomain, spfresult, spf_align, mindate, maxdate → FROM report RIGHT JOIN rptrecord → ON report.serial=rptrecord.serial → ); performing query... failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS report_stats AS ( SELECT report.serial, domain, rcount, disposi' at line 1

Thanks in advance!

MatthewHana commented 2 months ago

Are you running MySQL or MariaDB?