Create DMARC-Reports 1

After the DMARC Records checks in DMARC check on Debian Wheezy, I show how reports can be created and sent. First, we need a mysql database and a user to save the DMARC checks. Invoke mysql and run: CREATE DATABASE opendmarc; CREATE USER ‘opendmarc’@’127.0.0.1’ IDENTFIED BY ‘top_secret’; GRANT ALL PRIVILEGES […]


mysqldump –ignore-databases 2

With mysqldump it is not possible by the parameters to exclude individual databases. However, the database can be easily queried from the information_schema and this makes an exclude. mysqldump –databases `mysql –skip-column-names -e “SELECT GROUP_CONCAT(schema_name SEPARATOR ‘ ‘) FROM information_schema.schemata WHERE schema_name NOT IN (‘mysql’,’performance_schema’,’information_schema’, ‘db_test’);”` >/dump.sql Thanks to Ronald […]


ISPConfig – resync extended

Update 02/14/2015 Full translation Additionl options for resyncs Full or partial resync per server Hide Servers / Services with no corrresponing data The patch at git.schaal-24.de/ispconfig/resync extends the resync tool from ISPConfig. You can now use some more settings to resync and also select the server(s) where the resync will […]


DKIM-Patch 1.1.6 4

A new version of the DKIM-Patch for ISPConfig is available now. Download: DKIM-Patch Changes to 1.1.5: allow the admin to change txt-records for dkim, dmarc and spf directly fixed fr-language for the resync-tool fixed regex for spf-includes


DMARC check on Debian Wheezy 16

I have already described in DMARC Record (Domain-based Message Authentication, Reporting & Conformance), how to set up a DMARC record and why this makes sense. Now we need to pay attention to such DMARC record in the delivery of mail. The verification of a DMARC Records requires valid SPF and […]


Merry X-Mas

I wish you a merry christmas and a happy new year 2015.


DKIM-Patch 1.1.5 24

A new version of the DKIM-Patch for ISPConfig is available now. Download: DKIM-Patch Changes to 1.1.4: create dkim-path during install DMARC requieres SPF and DKIM (this breaks the current draft but DMARC is useless if you use spf OR dkim) fixed an error if the dkim-path does not exists add […]


Report Spam comments from WordPress to blocklist.de

The script wp-spamreport.php (as a download here in my git) reports at any time the spam comments of the last 48 hours to blocklist.de. It does not matter when a comment was marked as spam (manually or automatically by example Antispam Bee), but only that the comments are posted in […]