I am doing something wrong in my attempts to use this feature to setup two system-wide training aliases.
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" dspam.conf Home /var/dspam StorageDriver /usr/local/lib/libmysql_drv.so DeliveryHost 127.0.0.1 DeliveryPort 10025 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=message" # '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 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 **** ClamAVHost 127.0.0.1 ClamAVResponse accept ServerPort **** ServerQueueSize 32 ServerPID /var/run/dspam.pid ServerMode standard ServerParameters "--deliver=innocent" ServerIdent "localhost.localdomain" ServerDomainSocketPath "/var/spool/postfix/tmp/dspam.sock" ProcessorBias on The problem as shown in /var/dspam/log/sql.errors: [12/03/2007 13:33:07] 1724: Column 'uid' cannot be null: insert into dspam_virtu al_uids (uid, username) values(NULL, '[EMAIL PROTECTED]') It shouldn't be trying to create that user. It should pick it up from the signature. Here's the dspam signature for that particular email message: !DSPAM:2,47543d5317241952294243! The "2," is the inserted uid I would presume? Here's what's in dspam_virtual_uids: +-----+---------------------+ | uid | username | +-----+---------------------+ | 1 | globaluser | | 2 | [EMAIL PROTECTED] | +-----+---------------------+ Globaluser is a merged group I trained with some corpi and a big batch of our own ham and spam: globaluser:merged:* I'm just stumped. Michael D. Lemon Director of Information Technology Americal Corporation Phone: 252-762-2000 x2142 Fax: 252-762-0176
