On Thu, Nov 20, 2014 at 03:38:09PM -0600, Sparr wrote: > On Thu, Nov 20, 2014 at 2:56 PM, k...@rice.edu <k...@rice.edu> wrote: > > On Thu, Nov 20, 2014 at 02:14:15PM -0600, Sparr wrote: > >> I've enabled debugging and in my debug log I can see a db error: > >> > >> _ds_get_signature: mysql_fetch_row() failed > >> > >> I've checked the dspam_signature_data table and it has about 14k rows > >> in it, *far* fewer than the number of emails I've ever received. It > >> does not have a row with the signature of the email I tried to > >> reclassify to produce that error. > >> > > > > Hi, > > > > If the signature is not in the DB, you need to figure out why not > > and fix that. Obviously, there was a signature but was it from your > > dspam or did you use a mode that does not save a signature to process > > it initially? Once you find and fix that, it sounds like you will be > > good to go. > > > > Regards, > > Ken > > Here's the debug log for the arrival of an email whose signature does > not end up in the dspam_signature_data table (this behavior is not > unique to this email): > > 5398: [11/20/2014 13:34:09] connection id 35 from 123.45.67.62. > 5398: [11/20/2014 13:34:09] checking trusted user list for dspam(108) > 5398: [11/20/2014 13:34:09] No QuarantineAgent option found. Using > standard quarantine. > 5398: [11/20/2014 13:34:09] using database handle id 5 > 5398: [11/20/2014 13:34:09] handle locked > 5398: [11/20/2014 13:34:09] DSPAM Instance Startup > 5398: [11/20/2014 13:34:09] input args: dspam --deliver=innocent > 5398: [11/20/2014 13:34:09] pass-thru args: > 5398: [11/20/2014 13:34:09] processing user u...@domain.com > 5398: [11/20/2014 13:34:09] uid = 108, euid = 108, gid = 115, egid = 115 > 5398: [11/20/2014 13:34:09] loading preferences for user u...@domain.com > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam: successful returning > struct for name: u...@domain.com > 5398: [11/20/2014 13:34:09] Loading preferences for uid 3 > 5398: [11/20/2014 13:34:09] Loading preferences for uid 0 > 5398: [11/20/2014 13:34:09] loaded default preferences externally > 5398: [11/20/2014 13:34:09] using > /var/spool/dspam/opt-in/domain.com/user.dspam as path > 5398: [11/20/2014 13:34:09] using > /var/spool/dspam/opt-out/domain.com/user.nodspam as path > 5398: [11/20/2014 13:34:09] sedation level set to: 1 > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam: successful returning > struct for name: u...@domain.com > 5398: [11/20/2014 13:34:09] Connecting to 127.0.0.1:3310 for virus check > 5398: [11/20/2014 13:34:09] Connecting to 127.0.0.1:1223 for virus > stream transmission > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name > u...@domain.com. > 5398: [11/20/2014 13:34:09] Loading 52 BNR patterns > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name > u...@domain.com. > 5398: [11/20/2014 13:34:09] Whitelist threshold: 10 > 5398: [11/20/2014 13:34:09] [graham] [0.000310] > From*r...@web01.domain.com (Cron Daemon) (1frq, 0s, 19221i) > 5398: [11/20/2014 13:34:09] [burton] [0.000310] > From*r...@web01.domain.com (Cron Daemon) (1frq, 0s, 19221i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > Subject*RAILS_ENV=production (1frq, 0s, 51i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Subject*RAILS_ENV=production (1frq, 0s, 51i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] your+locale (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] your+locale (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > Received*web01.domain.com+(Postfix (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*web01.domain.com+(Postfix (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] will+default (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] will+default (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > enforce_available_locales+= (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > enforce_available_locales+= (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > Subject*/var/web/appname/current (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Subject*/var/web/appname/current (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > Received*(web01.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*(web01.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > X-Cron-Env*<PATH=/home/deploy/.rbenv/shims (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > X-Cron-Env*<PATH=/home/deploy/.rbenv/shims (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > Received*from+web01.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*from+web01.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > DKIM-Signature*to+subject (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > DKIM-Signature*to+subject (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] Subject*sync (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] Subject*sync (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] skip+validation (1frq, 0s, > 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] skip+validation (1frq, 0s, > 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > X-Cron-Env*/home/deploy/.rbenv/bin (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > X-Cron-Env*/home/deploy/.rbenv/bin (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [graham] [0.010000] > X-Cron-Env*<LOGNAME=deploy> (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > X-Cron-Env*<LOGNAME=deploy> (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*from+mail02.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > DKIM-Signature*c=simple (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] Subject*&& (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*web01.domain.com+(web01.domain.com (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] Subject*Cron+<deploy > (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] From*web01.domain.com > (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*web01.domain.com (2frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] > Received*web01.domain.com (2frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] DomainKey-Signature*to > (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] avoid+this (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] to+skip (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] [burton] [0.010000] set+I18n (1frq, 0s, 50i) > 5398: [11/20/2014 13:34:09] Graham-Bayesian Probability: 0.000000 Samples: 15 > 5398: [11/20/2014 13:34:09] Burton-Bayesian Probability: 0.000000 Samples: 27 > 5398: [11/20/2014 13:34:09] no factors specified; using default > 5398: [11/20/2014 13:34:09] Result Confidence: 0.99 > 5398: [11/20/2014 13:34:09] auto-whitelisting this message > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name > u...@domain.com. > 5398: [11/20/2014 13:34:09] Control: [10 10] [10 11] Delta: [0 1] > 5398: [11/20/2014 13:34:09] total processing time: 0.03335s > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name > u...@domain.com. > 5398: [11/20/2014 13:34:09] saving signature as 546e423153989760964788 > 5398: [11/20/2014 13:34:09] libdspam returned probability of 0.000000 > 5398: [11/20/2014 13:34:09] message result: NOT SPAM > 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name > u...@domain.com. > 5398: [11/20/2014 13:34:09] delivering message > 5398: [11/20/2014 13:34:09] Establishing connection to 127.0.0.1:10035 > 5398: [11/20/2014 13:34:09] Connection established > 5398: [11/20/2014 13:34:09] DSPAM Instance Shutdown. Exit Code: 0 > 5398: [11/20/2014 13:34:09] checking trusted user list for dspam(108) >
Well, it looks like the signature is saved. Can you try a manual select of the signature from your DB. Also, what process do you have for cleaning the signature DB, otherwise it grows without bound? Maybe the signature was removed by that cleanup process before you had a chance to use it. That timing is alway a space vs. time retained trade-off. Regards, Ken ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
