The continuing saga of trying to get MySQLUIDInSignature to work. No go.
It's like Dspam just totally ignores the user id in the signature. 2 is
the correct user id.
/etc/dspam.conf:
Home /var/dspam
StorageDriver /usr/local/lib/libmysql_drv.so
DeliveryHost 127.0.0.1
DeliveryPort *****
DeliveryIdent localhost
DeliveryProto SMTP
OnFail error
Trust root
Trust mail
Trust mailnull
Trust smmsp
Trust daemon
Trust nobody
TrainingMode toe
TestConditionalTraining on
Feature chained
Feature whitelist
Algorithm graham burton
PValue graham
Preference "signatureLocation=headers" # 'message' or 'headers'
Preference "showFactors=on"
Preference "spamAction=tag"
Preference "spamSubject=[SPAM]"
AllowOverride trainingMode
AllowOverride spamAction spamSubject
AllowOverride statisticalSedation
AllowOverride enableBNR
AllowOverride enableWhitelist
AllowOverride signatureLocation
AllowOverride showFactors
AllowOverride optIn optOut
AllowOverride whitelistThreshold
MySQLServer /var/run/mysql/mysql.sock
MySQLPort *******
MySQLUser dspam
MySQLPass ******************
MySQLDb dspam
MySQLCompress true
MySQLConnectionCache 10
MySQLUIDInSignature on
HashRecMax 98317
HashAutoExtend on
HashMaxExtents 0
HashExtentSize 49157
HashMaxSeek 100
HashConnectionCache 10
Notifications off
PurgeSignatures 14 # Stale signatures
PurgeNeutral 90 # Tokens with neutralish probabilities
PurgeUnused 90 # Unused tokens
PurgeHapaxes 30 # Tokens with less than 5 hits (hapaxes)
PurgeHits1S 15 # Tokens with only 1 spam hit
PurgeHits1I 15 # Tokens with only 1 innocent hit
LocalMX 127.0.0.1
SystemLog on
UserLog on
Opt out
ClamAVPort 3310
ClamAVHost 127.0.0.1
ClamAVResponse accept
ServerPort 24
ServerQueueSize 32
ServerPID /var/run/dspam.pid
ServerMode standard
ServerParameters "--deliver=innocent"
ServerIdent "localhost.localdomain"
ServerDomainSocketPath "/var/spool/postfix/tmp/dspam.sock"
ProcessorBias on
Here's the headers from an email I just tried to re-train as ham. It
rejected while trying to create a user for my ham alias.
X-DSPAM-Processed: Fri Dec 7 14:03:27 2007
X-DSPAM-Confidence: 0.5184
X-DSPAM-Probability: 1.0000
X-DSPAM-Signature: 2,475998ff17247722847132
X-DSPAM-Factors: 15,
X-Spam-Status*999, 0.99871,
X-Spam-Status*HTML_MESSAGE=0.001, 0.99849,
Received*ameripeds.com>+Fri, 0.99537,
size=2>Thanks, 0.00899,
face=Arial+size=2>Thanks, 0.01000,
6000+16525", 0.99000,
X-Spam-Status*SUBJ_ALL_CAPS=2.077], 0.99000,
I+created, 0.01000,
16525", 0.99000,
Received*Fri+7, 0.99000,
Date*Fri+7, 0.99000,
Nick, 0.01000,
16525"+name=GENERATOR>, 0.99000,
X-Spam-Status*tests=[BAYES_00=+2.599, 0.98611,
X-Spam-Status*2.599, 0.98233
Maillog (OpenBSD 4.1)
Dec 10 09:39:42 mail1 dspam[1724]: query error: Column 'uid' cannot be
null: see sql.errors for more details
Dec 10 09:39:42 mail1 dspam[1724]: process_message returned error -2.
delivering.
Dec 10 09:39:47 mail1 postfix/smtpd[16540]: connect from
localhost[127.0.0.1]
Dec 10 09:39:48 mail1 postfix/smtpd[16540]: 56DEE1FC6A4:
client=localhost[127.0.0.1]
Dec 10 09:39:48 mail1 postfix/cleanup[22357]: 56DEE1FC6A4:
message-id=<[EMAIL PROTECTED]>
Dec 10 09:39:48 mail1 postfix/qmgr[10091]: 56DEE1FC6A4:
from=<[EMAIL PROTECTED]>, size=805, nrcpt=1 (queue active)
Dec 10 09:39:48 mail1 postfix/smtpd[16540]: disconnect from
localhost[127.0.0.1]
Dec 10 09:39:48 mail1 postfix/lmtp[27911]: 98AD01FC6A3:
to=<[EMAIL PROTECTED]>,
relay=mail1.ameripeds.com[/tmp/dspam.sock], delay=6.9,
delays=0.64/0/0/6.3, dsn=2.6.0, status=sent (250 2.6.0
<[EMAIL PROTECTED]> Message accepted for delivery)
Dec 10 09:39:48 mail1 postfix/qmgr[10091]: 98AD01FC6A3: removed
Dec 10 09:39:51 mail1 dspam[25864]: Unable to open file for writing:
/var/dspam/data/[EMAIL PROTECTED]/[EMAIL PROTECTED]: Permission
denied
Dec 10 09:39:51 mail1 postfix/local[30621]: 56DEE1FC6A4:
to=<[EMAIL PROTECTED]>, relay=local, delay=3.4,
delays=0.61/0.09/0/2.7, dsn=2.0.0, status=sent (delivered to command:
/usr/local/bin/dspam --user globaluser --class=innocent --source=error)
I'm pretty sure I read that dspam is being run as nobody when called
through a Postfix alias. nobody is a trusted user for dspam.
My postfix aliases:
train-spam: "|/usr/local/bin/dspam --user globaluser --class=spam
--source=error"
train-ham: "|/usr/local/bin/dspam --user globaluser --class=innocent
--source=error"
Global user is a merged group in /var/dspam/group:
globaluser:merged:*
Versions:
DSPAM Anti-Spam Suite 3.6.8 (agent/library)
Postfix 2.3.7
Michael D. Lemon
Director of Information Technology
Americal Corporation
Phone: 252-762-2000 x2142
Fax: 252-762-0176
