On 2014-04-07 Mon 13:01 PM |, Craig R. Skinner wrote:
> Hello OpenBSD porters,
>
> Attached here is a new port of spamdba - pf spamd database assistant
>
>
> spamdba assists postmasters to routinely manipulate the spamd(8)
> database. This tool is a wrapper for spamdb(8), simplifying common
> tasks, such as:-
>
> o Adding/deleting of all, or a pattern matched subset of entries.
>
> o Dumping & loading of dumps - for OS upgrades, database format
> changes, sharing data between different architecture/OS machines, etc
>
Machine dump, wipe disks & reinstall after time_t 64 bit changes:
<postmaster@palm:~ 0>$ uname -a
OpenBSD palm.britvault.co.uk 5.4 GENERIC#37 i386
<postmaster@palm:~ 0>$ spamdba dump
Dump: /var/tmp/spamdba.dump.aFViL4d
<postmaster@palm:~ 0>$ mv /var/tmp/spamdba.dump.aFViL4d /home/postmaster
spamdb reload after clean install:
$ uname -a
OpenBSD palm.britvault.co.uk 5.5 GENERIC#276 i386
$ ls -l /var/db/spamdb
ls: /var/db/spamdb: No such file or directory
$ sudo touch /var/db/spamd
$ ls -l /var/db/spamd
-rw-r--r-- 1 root wheel 0 Jul 12 13:32 /var/db/spamd
$ sudo chown _spamd:postmasters /var/db/spamd
$ sudo chmod 660 /var/db/spamd
$ ls -l /var/db/spamd
-rw-rw---- 1 _spamd postmasters 0 Jul 12 13:32 /var/db/spamd
$ sube postmaster
<postmaster@palm:~ 0>$ ls -l spamdba.dump.aFViL4d
-rw-r----- 1 postmaster postmasters 49502 Jul 10 13:04 spamdba.dump.aFViL4d
<postmaster@palm:~ 0>$ spamdba load -f spamdba.dump.aFViL4d
spamdb: cannot open /var/db/spamd for reading: Inappropriate file type or format
Processed: 535
Log: /var/tmp/spamdba_add_SPAMTRAP.log.s8J7nph
Processed: 307
Log: /var/tmp/spamdba_add_TRAPPED.log.i6QITng
Processed: 253
Log: /var/tmp/spamdba_add_WHITE.log.zdVooOc
<postmaster@palm:~ 0>$ ls -l /var/db/spamd
-rw-rw---- 1 _spamd postmasters 131072 Jul 12 13:34 /var/db/spamd
<postmaster@palm:~ 0>$ spamdb | wc -l
1095
http://web.britvault.co.uk/products/spamdba/
