[Pkg-dspam-misc] Bug#514498: Reproduction

[Colin Putney]

Hi,

I ran into this bug on an Ubuntu system. It's triggered when the sqlite 
data file for the specified user isn't writable by the user that dspam 
is running as.

Using the reproduction technique suggested by Patrick, I get the following:

#cat <<EOF >/tmp/testmail
 > From: some at spammer.com
 > To: cputney at wiresong.ca
 > Subject: Test
 >
 > This is a test mail
 > EOF
# chown root /var/spool/dspam/data/local/colin/colin.sdb
# ls -l /var/spool/dspam/data/local/colin
total 119748
-rw-rw---- 1 dspam dspam   1822334 May 29 09:11 colin.log
-rw-r----- 1 root  dspam 120668160 May 29 09:11 colin.sdb
-rw-rw---- 1 dspam dspam        20 May 29 09:11 colin.stats
#sudo -u dspam /usr/bin/dspam --deliver=spam,innocent --user colin 
--stdout < /tmp/testmail
*** crash similar to what Nicol reported ***

#chown dspam /var/spool/dspam/data/local/colin/colin.sdb
#ls -l /var/spool/dspam/data/local/colin
total 119748
-rw-rw---- 1 dspam dspam   1822334 May 29 09:11 colin.log
-rw-r----- 1 dspam dspam 120668160 May 29 09:11 colin.sdb
-rw-rw---- 1 dspam dspam        20 May 29 09:11 colin.stats
#sudo -u dspam /usr/bin/dspam --deliver=spam,innocent --user colin 
--stdout < /tmp/testmail
From: some at spammer.com
To: cputney at wiresong.ca
Subject: Test
X-DSPAM-Result: Innocent
X-DSPAM-Processed: Fri May 29 09:22:22 2009
X-DSPAM-Confidence: 1.0000
X-DSPAM-Probability: 0.0055
X-DSPAM-Signature: 4a1fa94e15612612618147

This is a test mail

I got into this situation while I was training dspam from the command 
line. I ran the training script as root, so when 
/var/spool/dspam/data/local/colin was created, it was owned by root. 
Then when postfix tried to run dspam as the user "dspam," it couldn't 
write to /var/spool/dspam/data/local/colin/colin.sdb and crashed. Fixing 
the file ownership makes the problem go away.

Colin