The DSPAM signature data is not being written to the database (dspam_signature_data). All other data is written to the database. The signature is written to into the message headers. DSPAM logs also confirm that the message is being scanned and given a signature.
One thing is missing. The sql.errors log. I don't see where to turn that on in dspam.conf. Enabling this logging would probably help me out..
Here are configuration files and other information:
Code:
$ dspam --version
DSPAM Anti-Spam Suite 3.8.0 (agent/library)
Copyright (c) 2002-2006 Jonathan A. Zdziarski
http://dspam.nuclearelephant.com
DSPAM may be copied only under the terms of the GNU General Public License,
a copy of which can be found with the DSPAM distribution kit.
Configuration parameters: '--prefix=/usr' '--host=i686-pc-linux-gnu' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--datadir=/usr/share' '--sysconfdir=/etc' '--localstatedir=/var/lib' '--with-storage-driver=hash_drv,mysql_drv' '--with-dspam-home=/var/spool/dspam' '--sysconfdir=/etc/mail/dspam' '--enable-daemon' '--disable-ldap' '--enable-clamav' '--enable-large-scale' '--disable-domain-scale' '--disable-syslog' '--enable-debug' '--enable-bnr-debug' '--enable-long-usernames' '--with-dspam-group=dspam' '--with-dspam-home-group=dspam' '--with-dspam-mode=2511' '--with-logdir=/var/log/dspam' '--enable-virtual-users' '--enable-preferences-extension' '--disable-homedir' '--with-mysql-includes=/usr/include/mysql' '--with-mysql-libraries=/usr/lib/mysql' '--build=i686-pc-linux-gnu' 'build_alias=i686-pc-linux-gnu' 'host_alias=i686-pc-linux-gnu' 'CFLAGS=-march=prescott -O2 -pipe -fomit-frame-pointer -Wl,-z,now' 'CXXFLAGS=-march=prescott -O2 -pipe -fomit-frame-pointer -Wl,-z,now'
File: /etc/postfix/main.cf
Code:
smtpd_recipient_restrictions =
permit_mynetworks,
permit_sasl_authenticated,
...
reject_invalid_hostname,
check_policy_service inet:127.0.0.1:666,
check_recipient_access pcre:/etc/postfix/maps/dspam_incoming,
permit
File: /etc/postfix/master.cf
Code:
dspam unix - - n - 10 lmtp
127.0.0.1:667 inet n - n - - smtpd
-o smtpd_authorized_xforward_hosts=127.0.0.0/8
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
-o receive_override_options=no_unknown_recipient_checks
File: /etc/postfix/maps/dspam_incoming
Code:
/./ FILTER dspam:unix:/var/run/dspam/dspam.sock
File: /etc/mail/dspam/dspam.conf
Code:
Home /var/spool/dspam
StorageDriver /usr/lib/dspam/libmysql_drv.so
TrustedDeliveryAgent "/usr/sbin/sendmail"
UntrustedDeliveryAgent "/usr/sbin/sendmail"
DeliveryHost 127.0.0.1
DeliveryPort 667
DeliveryIdent dspam.mydomain.net
DeliveryProto SMTP
OnFail error
Trust root
Trust dspam
Trust apache
Trust mail
Trust smmsp
Trust daemon
Trust filter
Trust postfix
Debug *
TrainingMode toe
TestConditionalTraining on
Feature noise
Feature whitelist
Feature tb=5
Algorithm burton graham naive
Tokenizer osb
PValue bcr
WebStats on
ImprobabilityDrive on
Preference "trainingMode=TOE" # TEFT, TUM, TOE
Preference "spamAction=tag" # tag, quarantine, deliver
Preference "signatureLocation=headers" # 'message' or 'headers'
Preference "spamSubject="
Preference "statisticalSedation=5" # 0 to 9
Preference "enableBNR=on" # on, off
Preference "showFactors=off" # on, off
Preference "enableWhitelist=on" # on, off
Preference "whitelistThreshold=5"
AllowOverride trainingMode
AllowOverride spamAction spamSubject
AllowOverride statisticalSedation
AllowOverride enableBNR
AllowOverride enableWhitelist
AllowOverride signatureLocation
AllowOverride showFactors
AllowOverride optIn optOut
AllowOverride whitelistThreshold
MySQLServer /var/run/mysqld/mysqld.sock
MySQLUser __db_username__
MySQLPass __db_password__
MySQLDb dspamdb
MySQLCompress true
MySQLConnectionCache 10
MySQLVirtualTable dspam_virtual_uids
MySQLVirtualUIDField uid
MySQLVirtualUsernameField username
MySQLUIDInSignature on
HashRecMax 98317
HashAutoExtend on
HashMaxExtents 0
HashExtentSize 49157
HashPctIncrease 10
HashMaxSeek 10
HashConnectionCache 10
Notifications off
PurgeSignature off # Specified in purge.sql
PurgeNeutral 90
PurgeUnused off # Specified in purge.sql
PurgeHapaxes off # Specified in purge.sql
PurgeHits1S off # Specified in purge.sql
PurgeHits1I off # Specified in purge.sql
LocalMX 127.0.0.1 192.168.4.245
SystemLog on
UserLog on
TrainPristine on
Opt out
TrackSources spam nonspam
ParseToHeaders on
ChangeModeOnParse on
ChangeUserOnParse off
Broken case
Broken lineStripping
MaxMessageSize 102400
ServerQueueSize 32
ServerPID /var/run/dspam/dspam.pid
ServerMode auto
ServerParameters "--deliver=innocent,spam"
ServerIdent "dspam.mydomain.net"
ServerDomainSocketPath "/var/run/dspam/dspam.sock"
ClientHost "/var/run/dspam/dspam.sock"
ProcessorURLContext on
ProcessorBias on
File: /var/spool/dspam/group
DB Table: dspam_virtual_uids
Code:
uid username
===================
10 global
## END OF LIST
DB Table: dspam_preferences
Code:
uid preference value
=======================================
10 trainingMode TOE
10 statisticalSedation 5
10 spamSubject
10 spamAction tag
10 signatureLocation header
10 showFactors off
10 optOut on
10 optIn off
10 enableWhitelist on
10 enableBNR on
## END OF LIST
Please note that I am letting DSPAM learn as mail comes in. I'm not doing any mass training as policyd-weight rejects spam very nicely.
Any ideas?
Thanks