LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 11-16-2007, 12:15 PM   #1
Ateo
Member
 
Registered: Sep 2004
Location: http://longbeach.ca.u$
Distribution: Ubuntu,Gentoo, OSX
Posts: 136

Rep: Reputation: 15
DSPAM not writing signature to database


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
Code:
global:merged:*
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
 
  


Reply

Tags
sql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dspam Authentication bobcatch Linux - Newbie 0 10-08-2005 06:29 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
Dspam karunesh Linux - General 2 07-27-2004 10:44 AM
Dspam ekoome Red Hat 4 10-03-2003 10:19 AM
xfstt - not writing to font database gnomeslayer Linux - Software 1 03-20-2003 11:05 AM


All times are GMT -5. The time now is 12:58 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration