Bugzilla Bug 184194

There are two related problems.

Firstly, the execution of the sqlite purge script (${DSPAM_SQLite_PURGE_SQL} or
${DSPAM_SQLite3_PURGE_SQL}) will only occur for the first database found by the
find command since the SQL file is being redirected to the find command and not
the sqlite/sqlite3 command.

Secondly, the execution of the "vacuum;" is being echoed to the console (and
will thus be redirected to the administrator's email by cron) rather than being
executed.

Reproducible: Always

Steps to Reproduce:
1. Allow the dspam.cron to be run daily
2. Watch for the email from the cron daemon with the body "vacuum; |
/usr/bin/sqlite3 /var/spool/dspam/data/local/<username>/<username>.sdb", for
each user, which will happen every day
Actual Results:  
The purge script will only run for the first user database found, and the
vacuum will not be run for any database.

Expected Results:  
The purge script should run for each user database found, as should the vacuum.

I have patched my copy to fix the problem.  While the fix I propose is for both
sqlite and sqlite3, I have only tested it on sqlite3, since that is what I have
installed.  Please find the patch for dspam-3.8.0.cron (in
/usr/portage/mail-filter/dspam/files) attached.

Output from emerge --info follows:

Portage 2.1.2.9 (default-linux/x86/2007.0, gcc-4.1.2, glibc-2.5-r3, 2.6.18.6
i686)
=================================================================
System uname: 2.6.18.6 i686 Intel(R) Xeon(TM) CPU 2.40GHz
Gentoo Base System release 1.12.9
Timestamp of tree: Sun, 01 Jul 2007 01:00:10 +0000
ccache version 2.4 [enabled]
dev-java/java-config: 1.3.7, 2.0.33-r1
dev-lang/python:     2.4.4-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r7
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.17
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.23b
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=pentium3 -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo
/etc/texmf/web2c"
CXXFLAGS="-march=pentium3 -O2 -pipe"
DISTDIR="/usr/local/distfiles"
FEATURES="ccache distlocks fixpackages metadata-transfer sandbox sfperms
strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US.UTF-8"
LC_ALL="en_US.UTF-8"
MAKEOPTS="-j3"
PKGDIR="/usr/local/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180
--exclude=/distfiles --exclude=/local --exclude=/packages
--filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/xeffects
/usr/portage/local/layman/sunrise /usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X acl alsa apache2 arts audiofile berkdb bitmap-fonts bonobo bzip2 cdr cli
cracklib crypt cups curl dbus dri dvdr encode exif fam ffmpeg flac foomaticdb
gdbm gif gimpprint glut gmp gpm gstreamer gtk gtk2 gtkhtml guile iconv idn
imagemagick imap imlib immqt-bc ipv6 isdnlog jack joystick jpeg lcms libg++
lirc logrotate mad matroska midi mikmod mng mozilla moznocompose moznoirc
moznomail mozsvg mp3 mpeg mudflap ncurses nls nptl nptlonly ogg opengl openmp
oss pam pcre perl png postgres ppds pppd python qt3 qt4 quicktime readline real
reflection ruby ruby18 scanner sdl session slang speex spell spl sse ssl
startup-notification svg svga tcl tcltk tcpd tetex tiff tk truetype
truetype-fonts type1-fonts unicode usb vorbis x86 xml xorg xprint xv zlib
zsh-completion" ALSA_CARDS="emu10k1" ALSA_PCM_PLUGINS="adpcm alaw asym copy
dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear
meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc"
INPUT_DEVICES="evdev keyboard mouse wacom" KERNEL="linux" LCD_DEVICES="bayrad
cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text"
LIRC_DEVICES="livedrive_midi" USERLAND="GNU" VIDEO_CARDS="nvidia vesa vga"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, LINGUAS,
PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

Created an attachment (id=123877) [edit]
Patch to files/dspam-3.8.0.cron that allows the sqlite purge script and vacuum
to run properly

Fixed in -r2. Thanks!