Hello,
Please help, I’m trying to get a dspam relay running with Postfix on Debian
Wheezy using the packaged version but I’m stuck and I don’t know how to proceed…
So I’ve got as far as being able to send a test message from the relay host,
which dspam tries to process but doesn’t, the mail is then sent to and received
correctly by my mail server proper which then delivers it to it’s rightful
destination.
dspam.debug:
21184: [09/02/2013 14:11:41] checking trusted user list for dspam(105)
21184: [09/02/2013 14:11:41] No QuarantineAgent option found. Using standard
quarantine.
21184: [09/02/2013 14:11:41] using database handle id 2
21184: [09/02/2013 14:11:41] handle locked
21184: [09/02/2013 14:11:41] DSPAM Instance Startup
21184: [09/02/2013 14:11:41] input args: dspam --deliver=innocent -d %u
21184: [09/02/2013 14:11:41] pass-thru args: -d %u
21184: [09/02/2013 14:11:41] processing user u...@domain.com
21184: [09/02/2013 14:11:41] uid = 105, euid = 105, gid = 109, egid = 109
21184: [09/02/2013 14:11:41] loading preferences for user u...@domain.com
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: successful returning struct
for name: u...@domain.com
21184: [09/02/2013 14:11:41] Loading preferences for uid 1
21184: [09/02/2013 14:11:41] Loading preferences for uid 0
21184: [09/02/2013 14:11:41] default preferences empty. reverting to dspam.conf
preferences.
21184: [09/02/2013 14:11:41] Loading preferences from dspam.conf
21184: [09/02/2013 14:11:41] using /var/spool/dspam/opt-in/local/1.dspam as path
21184: [09/02/2013 14:11:41] using /var/spool/dspam/opt-out/local/1.nodspam as
path
21184: [09/02/2013 14:11:41] adding user to merged group groupuser
21184: [09/02/2013 14:11:41] sedation level set to: 5
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: successful returning struct
for name: u...@domain.com
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: setting, then returning
passed name: groupuser
21184: [09/02/2013 14:11:41] _mysql_drv_setpwnam: verified_user is 1
21184: [09/02/2013 14:11:41] _mysql_drv_setpwnam: unable to run query: INSERT
INTO dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
21184: [09/02/2013 14:11:41] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam(groupuser)
21184: [09/02/2013 14:11:41] _ds_init_storage: unable to load totals. Using
zero values.
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: successful returning struct
for name: u...@domain.com
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: setting, then returning
passed name: groupuser
21184: [09/02/2013 14:11:41] _mysql_drv_setpwnam: verified_user is 1
21184: [09/02/2013 14:11:41] _mysql_drv_setpwnam: unable to run query: INSERT
INTO dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
21184: [09/02/2013 14:11:41] _ds_getall_spamrecords: unable to
_mysql_drv_getpwnam(groupuser)
21184: [09/02/2013 14:11:41] _ds_getall_spamrecords() failed
21184: [09/02/2013 14:11:41] total processing time: 0.00409s
21184: [09/02/2013 14:11:41] _mysql_drv_getpwnam: successful returning struct
for name: u...@domain.com
21184: [09/02/2013 14:11:41] delivering message
21184: [09/02/2013 14:11:41] Establishing connection to 10.1.75.24:10025
21184: [09/02/2013 14:11:41] Connection established
21184: [09/02/2013 14:11:41] DSPAM Instance Shutdown. Exit Code: 0
21184: [09/02/2013 14:11:41] checking trusted user list for dspam(105)
sql.errors:
[09/02/2013 14:11:41] 21184: Column 'uid' cannot be null: INSERT INTO
dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
[09/02/2013 14:11:41] 21184: Column 'uid' cannot be null: INSERT INTO
dspam_virtual_uids (uid,username) VALUES (NULL,'groupuser')
dspam.conf:
Home /var/spool/dspam
StorageDriver /usr/lib/i386-linux-gnu/dspam/libmysql_drv.so
DeliveryHost <IP>
DeliveryPort 10025
DeliveryIdent <domain.name>
DeliveryProto SMTP
OnFail error
Trust root
Trust dspam
Trust www-data
Trust mail
Trust daemon
Trust amavis
Debug *
DebugOpt process spam fp inoculation corpus
TrainingMode teft
TestConditionalTraining on
Feature whitelist
Algorithm graham burton
Tokenizer word
PValue bcr
WebStats on
ImprobabilityDrive on
Preference "trainingMode=TEFT" # { TOE | TUM | TEFT | NOTRAIN } ->
default:teft
Preference "spamAction=tag" # { 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
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
ParseToHeaders on
ChangeModeOnParse on
ChangeUserOnParse off
ServerQueueSize 32
ServerPID /var/run/dspam/dspam.pid
ServerMode auto
ServerParameters "--deliver=innocent"
ServerIdent "localhost.localdomain"
ServerDomainSocketPath "/var/run/dspam/dspam.sock"
ProcessorURLContext on
ProcessorBias on
StripRcptDomain off
Include /etc/dspam/dspam.d/
Hugh
[http://www.diversusgroup.com/images/dg_signature_with_campaign.png]
Hugh Badini
Consultant
hugh.bad...@diversusgroup.com<mailto:hugh.bad...@diversusgroup.com>
t: +61 4 33 101 333 | f: +61 2 8080 8210
www.diversusgroup.com<http://www.diversusgroup.com>
[FlexPod. Flexible and Scalable future-ready IT. Click
here.]<http://www.netappgrid.com/flexpod/DiversusGroup/index.html>
This message contains confidential information and is intended only for the
intended recipients. If you are not an intended recipient you should not
disseminate, distribute or copy this e-mail. Please notify Hugh Badini
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. Diversus Group Pty Ltd therefore does not
accept liability for any errors or omissions in the contents of this message,
which arise as a result of e-mail transmission. If verification is required
please request a hard-copy version.
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
