Hi There, I'm trying to setup DSPAM in combination with Postfix and Dovcot. It is working not yet trained yet but that will be done as soon as everything works.
I want DSPAM to store it result in a MySQL database but for some reason it's not even connecting to the MySQL Server. Hereby some more informations: Dspam version: DSPAM Anti-Spam Suite 3.10.1 (agent/library) Copyright (C) 2002-2011 DSPAM Project http://dspam.sourceforge.net. DSPAM may be copied only under the terms of the GNU Affero General Public License, a copy of which can be found with the DSPAM distribution kit. Configuration parameters: '--enable-daemon' '--enable-debug' '--enable-split-configuration' '--enable-syslog' '--enable-clamav' '--enable-preferences-extension' '--enable-domain-scale' '--with-dspam-home-owner=dspam' '--with-dspam-home-group=dspam' '--with-dspam-owner=dspam' '--with-dspam-group=dspam' '--with-storage-driver=mysql_drv' '--prefix=/usr/local/dspam' '--sysconfdir=/etc/dspam' '--mandir=/usr/share/man' '--bindir=/usr/local/sbin' '--sbindir=/usr/local/sbin' '--libdir=/usr/lib' '--includedir=/usr/include' '--with-mysql-includes=/usr/include/mysql' '--with-mysql-libraries=/usr/lib64/mysql' '--with-logdir=/var/log/dspam' Configuration file: Home /var/spool/dspam StorageDriver /usr/lib/dspam/libmysql_drv.so TrustedDeliveryAgent "/usr/bin/procmail" OnFail error Trust root Trust dspam Trust apache Trust mail Trust mailnull Trust smmsp Trust daemon TrainingMode teft TestConditionalTraining on Feature whitelist Algorithm graham burton Tokenizer chain PValue bcr WebStats on Preference "trainingMode=TEFT" # { TOE | TUM | TEFT | NOTRAIN } -> default:teft Preference "spamAction=quarantine" # { quarantine | tag | deliver } -> default:quarantine Preference "spamSubject=[SPAM]" # { string } -> default:[SPAM] Preference "statisticalSedation=5" # { 0 - 10 } -> default:0 Preference "enableBNR=on" # { on | off } -> default:off Preference "enableWhitelist=on" # { on | off } -> default:on Preference "signatureLocation=message" # { message | headers } -> default:message Preference "tagSpam=off" # { on | off } Preference "tagNonspam=off" # { on | off } Preference "showFactors=off" # { on | off } -> default:off Preference "optIn=off" # { on | off } Preference "optOut=off" # { on | off } Preference "whitelistThreshold=10" # { Integer } -> default:10 Preference "makeCorpus=off" # { on | off } -> default:off Preference "storeFragments=off" # { on | off } -> default:off Preference "localStore=" # { on | off } -> default:username Preference "processorBias=on" # { on | off } -> default:on Preference "fallbackDomain=off" # { on | off } -> default:off Preference "trainPristine=off" # { on | off } -> default:off Preference "optOutClamAV=off" # { on | off } -> default:off Preference "ignoreRBLLookups=off" # { on | off } -> default:off Preference "RBLInoculate=off" # { on | off } -> default:off Preference "notifications=off" # { on | off } -> default:off AllowOverride enableBNR AllowOverride enableWhitelist AllowOverride fallbackDomain AllowOverride ignoreGroups AllowOverride ignoreRBLLookups AllowOverride localStore AllowOverride makeCorpus AllowOverride optIn AllowOverride optOut AllowOverride optOutClamAV AllowOverride processorBias AllowOverride RBLInoculate AllowOverride showFactors AllowOverride signatureLocation AllowOverride spamAction AllowOverride spamSubject AllowOverride statisticalSedation AllowOverride storeFragments AllowOverride tagNonspam AllowOverride tagSpam AllowOverride trainPristine AllowOverride trainingMode AllowOverride whitelistThreshold AllowOverride dailyQuarantineSummary AllowOverride notifications MySQLServer <ipaddress> MySQLPort 3306 MySQLUser user MySQLPass password MySQLDb mail MySQLCompress true MySQLReconnect true MySQLReadSignaturesFromWriteDb on MySQLConnectionCache 50 MySQLVirtualTable mailboxes MySQLVirtualUIDField id MySQLVirtualUsernameField emailaddress MySQLUIDInSignature on HashRecMax 98317 HashAutoExtend on HashMaxExtents 0 HashExtentSize 49157 HashPctIncrease 10 HashMaxSeek 10 HashConnectionCache 10 # 'strict' enforces both verify and map # There are plans to support both MySQL and Postgres. # an executable lookup program and its arguments. # and ExtLookupMode 'map' or 'strict' 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 ServerMode standard ServerDomainSocketPath "/tmp/dspam.sock" ProcessorURLContext on ProcessorBias on StripRcptDomain off Debug output: 16963: [09/14/2011 13:01:46] No QuarantineAgent option found. Using standard quarantine. 16963: [09/14/2011 13:01:46] using database handle id 4 16963: [09/14/2011 13:01:46] handle locked 16963: [09/14/2011 13:01:46] DSPAM Instance Startup 16963: [09/14/2011 13:01:46] input args: dspam 16963: [09/14/2011 13:01:46] pass-thru args: 16963: [09/14/2011 13:01:46] processing user t...@example.com 16963: [09/14/2011 13:01:46] uid = 0, euid = 0, gid = 0, egid = 102 16963: [09/14/2011 13:01:46] loading preferences for user t...@example.com 16963: [09/14/2011 13:01:46] default preferences empty. reverting to dspam.conf preferences. 16963: [09/14/2011 13:01:46] Loading preferences from dspam.conf 16963: [09/14/2011 13:01:46] using /var/spool/dspam/opt-in/t...@example.com.dspam as path 16963: [09/14/2011 13:01:46] using /var/spool/dspam/opt-out/t...@example.com.nodspam as path 16963: [09/14/2011 13:01:46] sedation level set to: 5 16963: [09/14/2011 13:01:46] creating directory '/var/spool/dspam/data' 16963: [09/14/2011 13:01:46] creating directory '/var/spool/dspam/data/t...@example.com' 16963: [09/14/2011 13:01:46] Loading 2 BNR patterns 16963: [09/14/2011 13:01:46] Whitelist threshold: 10 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*(mail+ey0 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*(mail+ey0 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*[192.168.2.56]+([86.89.160.116]) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*[192.168.2.56]+([86.89.160.116]) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Mime-Version*Message (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Mime-Version*Message (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Message-Id*B6CF1D881E4F+bizworx (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Message-Id*B6CF1D881E4F+bizworx (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Date*Sep+2011 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Date*Sep+2011 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] From*bizworx (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] From*bizworx (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*14+Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*14+Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*14+Sep (4frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*it.nl+(Postfix) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*it.nl+(Postfix) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*BD15F1B5206 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*BD15F1B5206 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Message-Id*it.nl> (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Message-Id*it.nl> (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Message-Id*4A86 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Message-Id*4A86 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*ESMTP (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*ESMTP (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Message-Id*76B5 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Message-Id*76B5 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [graham] [0.400000] Received*10.213.29.74+with (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*10.213.29.74+with (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] X-Mailer*(2.1244.3) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*id+w19sm8210479eeh.6.2011.09.14.04.01.44 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*10.213.29.74 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*([86.89.160.116]) (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Date*14 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Date*13+01 (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*001.bizworx (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*eye4+with (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*[192.168.2.56] (1frq, 0s, 0i) 16963: [09/14/2011 13:01:46] [burton] [0.400000] Received*ey0+f172.google.com (2frq, 0s, 0i) 16963: [09/14/2011 13:01:46] Graham-Bayesian Probability: 0.002278 Samples: 15 16963: [09/14/2011 13:01:46] Burton-Bayesian Probability: 0.000018 Samples: 27 16963: [09/14/2011 13:01:46] no factors specified; using default 16963: [09/14/2011 13:01:46] Result Confidence: 1.00 16963: [09/14/2011 13:01:46] total processing time: 0.00293s 16963: [09/14/2011 13:01:46] saving signature as 4e70899a169639253112433 16963: [09/14/2011 13:01:46] creating directory '/var/spool/dspam/data/t...@example.com/t...@example.com.sig' 16963: [09/14/2011 13:01:46] libdspam returned probability of 0.002278 16963: [09/14/2011 13:01:46] message result: NOT SPAM 16963: [09/14/2011 13:01:46] DSPAM Instance Shutdown. Exit Code: 0 16963: [09/14/2011 13:01:46] checking trusted user list for root(0) So please help me how to proper set this up so I can use a second mailserver as well with the same mysql source. Best regards, Jeroen Grusewski ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerry® mobile platform with sessions, labs & more. See new tools and technologies. Register for BlackBerry® DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
