[Dspam-user] web interface and command line dspam apparently failing to reclassify emails

classic Classic list List threaded Threaded
13 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
When I click "As Innocent" or "As Spam" in the web frontend, the page
appears to simply reload, with no change in status for the email in
question. I picked apart the cgi and got it to tell me what command
it's running, which is as follows:

/usr/bin/dspam --source=error --class=spam --signature=22hexdigits
--user me\@mydomain\.com

When I run that command manually, it has no output and an exit code of
0. The email in question does not appear to have changed
classification, when I view the History in the web interface.

Is there some other way I should be checking the success of this
process, other than looking for the classification to change in the
web interface? If not, how can I find out what's going wrong here?

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
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.

On Thu, Nov 20, 2014 at 12:01 PM, Sparr <[hidden email]> wrote:

> When I click "As Innocent" or "As Spam" in the web frontend, the page
> appears to simply reload, with no change in status for the email in
> question. I picked apart the cgi and got it to tell me what command
> it's running, which is as follows:
>
> /usr/bin/dspam --source=error --class=spam --signature=22hexdigits
> --user me\@mydomain\.com
>
> When I run that command manually, it has no output and an exit code of
> 0. The email in question does not appear to have changed
> classification, when I view the History in the web interface.
>
> Is there some other way I should be checking the success of this
> process, other than looking for the classification to change in the
> web interface? If not, how can I find out what's going wrong here?

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Reindl Harald
maybe time to switch to a different solution

i considered dspam months ago but by lack of upstream developemnt over
years as well as a open mail from a developer that there is no real
maintainance i happily used postscreen/clamav-milter/spamass-milter
without any webui and it's just working perfect with no need for a db
server at all

Am 20.11.2014 um 21:14 schrieb Sparr:

> 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.
>
> On Thu, Nov 20, 2014 at 12:01 PM, Sparr <[hidden email]> wrote:
>> When I click "As Innocent" or "As Spam" in the web frontend, the page
>> appears to simply reload, with no change in status for the email in
>> question. I picked apart the cgi and got it to tell me what command
>> it's running, which is as follows:
>>
>> /usr/bin/dspam --source=error --class=spam --signature=22hexdigits
>> --user me\@mydomain\.com
>>
>> When I run that command manually, it has no output and an exit code of
>> 0. The email in question does not appear to have changed
>> classification, when I view the History in the web interface.
>>
>> Is there some other way I should be checking the success of this
>> process, other than looking for the classification to change in the
>> web interface? If not, how can I find out what's going wrong here?

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user

signature.asc (188 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

ktm@rice.edu
In reply to this post by Sparr
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

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

ktm@rice.edu
In reply to this post by Reindl Harald
On Thu, Nov 20, 2014 at 09:22:12PM +0100, Reindl Harald wrote:
> maybe time to switch to a different solution
>
> i considered dspam months ago but by lack of upstream developemnt
> over years as well as a open mail from a developer that there is no
> real maintainance i happily used
> postscreen/clamav-milter/spamass-milter without any webui and it's
> just working perfect with no need for a db server at all
>

Hi,

DSPAM was not the right choice for you and its development has been
stagnant, but it still works quite nicely when configured correctly.
I do recommend a multi-stage approach including things like postscreen
and clamav.

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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
In reply to this post by ktm@rice.edu
On Thu, Nov 20, 2014 at 2:56 PM, [hidden email] <[hidden email]> 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 [hidden email]
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 [hidden email]
5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam: successful returning
struct for name: [hidden email]
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: [hidden email]
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
[hidden email].
5398: [11/20/2014 13:34:09] Loading 52 BNR patterns
5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name
[hidden email].
5398: [11/20/2014 13:34:09] Whitelist threshold: 10
5398: [11/20/2014 13:34:09] [graham] [0.000310]
From*[hidden email] (Cron Daemon) (1frq, 0s, 19221i)
5398: [11/20/2014 13:34:09] [burton] [0.000310]
From*[hidden email] (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
[hidden email].
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
[hidden email].
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
[hidden email].
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)

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

ktm@rice.edu
On Thu, Nov 20, 2014 at 03:38:09PM -0600, Sparr wrote:

> On Thu, Nov 20, 2014 at 2:56 PM, [hidden email] <[hidden email]> 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 [hidden email]
> 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 [hidden email]
> 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam: successful returning
> struct for name: [hidden email]
> 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: [hidden email]
> 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
> [hidden email].
> 5398: [11/20/2014 13:34:09] Loading 52 BNR patterns
> 5398: [11/20/2014 13:34:09] _mysql_drv_getpwnam returning cached name
> [hidden email].
> 5398: [11/20/2014 13:34:09] Whitelist threshold: 10
> 5398: [11/20/2014 13:34:09] [graham] [0.000310]
> From*[hidden email] (Cron Daemon) (1frq, 0s, 19221i)
> 5398: [11/20/2014 13:34:09] [burton] [0.000310]
> From*[hidden email] (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
> [hidden email].
> 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
> [hidden email].
> 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
> [hidden email].
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
On Thu, Nov 20, 2014 at 3:48 PM, [hidden email] <[hidden email]> wrote:

>> 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
>> [hidden email].
>> 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.

A manual select of the signature from my DB is the only way I know to check:

SELECT * from dspam_signature_data where signature = "546e423153989760964788";

I ran dspam_maintenance and dspam_clean once yesterday, but haven't
since, and probably never before.

To be clear, *none* of the emails I am seeing in my dspam.debug log
are showing up in the dspam_signature_data table.

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
On Thu, Nov 20, 2014 at 4:32 PM, Sparr <[hidden email]> wrote:

> On Thu, Nov 20, 2014 at 3:48 PM, [hidden email] <[hidden email]> wrote:
>>> 5398: [11/20/2014 13:34:09] saving signature as 546e423153989760964788
>>
>> 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.
>
> A manual select of the signature from my DB is the only way I know to check:
>
> SELECT * from dspam_signature_data where signature = "546e423153989760964788";
>
> I ran dspam_maintenance and dspam_clean once yesterday, but haven't
> since, and probably never before.
>
> To be clear, *none* of the emails I am seeing in my dspam.debug log
> are showing up in the dspam_signature_data table.

Additional info: At about the same time as dspam.debug says "saving
signature as xxx", my mysql general query log shows this query:

SELECT signature FROM dspam_signature_data WHERE uid=nnn AND signature="xxx"

That query has zero results, as near as I can tell. There is no INSERT query.

I am seeing INSERT queries from another dspam server that's working
correctly, so this must be a configuration problem.

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Tom Hendrikx
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 21-11-14 00:00, Sparr wrote:

> On Thu, Nov 20, 2014 at 4:32 PM, Sparr <[hidden email]> wrote:
>> On Thu, Nov 20, 2014 at 3:48 PM, [hidden email] <[hidden email]>
>> wrote:
>>>> 5398: [11/20/2014 13:34:09] saving signature as
>>>> 546e423153989760964788
>>>
>>> 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.
>>
>> A manual select of the signature from my DB is the only way I
>> know to check:
>>
>> SELECT * from dspam_signature_data where signature =
>> "546e423153989760964788";
>>
>> I ran dspam_maintenance and dspam_clean once yesterday, but
>> haven't since, and probably never before.
>>
>> To be clear, *none* of the emails I am seeing in my dspam.debug
>> log are showing up in the dspam_signature_data table.
>
> Additional info: At about the same time as dspam.debug says
> "saving signature as xxx", my mysql general query log shows this
> query:
>
> SELECT signature FROM dspam_signature_data WHERE uid=nnn AND
> signature="xxx"
>
> That query has zero results, as near as I can tell. There is no
> INSERT query.
>
> I am seeing INSERT queries from another dspam server that's
> working correctly, so this must be a configuration problem.
>

Or are you using train on error / TOE ?

Tom

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCAAGBQJUbndxAAoJEJPfMZ19VO/1voEQAIluvpWXtBficVemF82YuowF
TpbJ0NfWICD3ZZvQULw9Nl7DlNHEgqFcrK4cEP9xWmk5I6cgHSmIZibRhh24FUuR
Ofh9tPXW/aF8724j1vPxWo2G+lNnARJ2fjHrXbpAyMCqMfekWndx+wLkJeJ2rjR6
VtJxbMprsDbva2dJDsphbR5hqLIL/NC2uTbShHTYtxg2nK6DKQ26ioVTZF0K1xxH
LVcxZIgABSoYxkVrHxUF6r+pAm4Yo5PPka+GFMO4ft2bHoFWOPo8fYjiaQsRRUr0
p8tTbIPtVEeQHoq5Llk/SS9DdUm0Edd+F8j0zJ7SQOgfS3xsuevQ32j6pAcEh/cw
e3Xacdotp3H7BvJUNLDPO/v0CDNxmYFEugk80hTh7oHKYpqpiyK2Y/PlCTcFFr4q
nNsVZjw/fc67IPBuf/39GPEEqUFptfI0vACwAEjz07CHlBwgZMSnyGT1bbSnvGe4
Mx5ECTN3MI0HVLPzBYPbQ1t2P3Y09BA7OXvgQEZjfPwJJkW6e5L1nnAaFsAt2nrZ
p9k6MWaKJmjvjehmGzzMX8cdyH0sVDfvDSu8z3HTxdH+byAjacab3EzpVSprjeBe
JGtlOrgbcLCf9+FoVkQfDxe1Hr53n8CdGOZtw7uVnt8rO5JOmaqdvzZYOUpGu96y
tBI9rHR1QL1X1a56uuDt
=sB/G
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

Sparr
On Thu, Nov 20, 2014 at 5:21 PM, Tom Hendrikx <[hidden email]> wrote:
> Or are you using train on error / TOE ?

Problem solved! "TrainPristine on" was preventing writes of signature
data to the db, which causes all sorts of things that rely on the
dspam_signature_data table to fail.

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

ktm@rice.edu
In reply to this post by Sparr
On Thu, Nov 20, 2014 at 05:00:23PM -0600, Sparr wrote:

> On Thu, Nov 20, 2014 at 4:32 PM, Sparr <[hidden email]> wrote:
> > On Thu, Nov 20, 2014 at 3:48 PM, [hidden email] <[hidden email]> wrote:
> >>> 5398: [11/20/2014 13:34:09] saving signature as 546e423153989760964788
> >>
> >> 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.
> >
> > A manual select of the signature from my DB is the only way I know to check:
> >
> > SELECT * from dspam_signature_data where signature = "546e423153989760964788";
> >
> > I ran dspam_maintenance and dspam_clean once yesterday, but haven't
> > since, and probably never before.
> >
> > To be clear, *none* of the emails I am seeing in my dspam.debug log
> > are showing up in the dspam_signature_data table.
>
> Additional info: At about the same time as dspam.debug says "saving
> signature as xxx", my mysql general query log shows this query:
>
> SELECT signature FROM dspam_signature_data WHERE uid=nnn AND signature="xxx"
>
> That query has zero results, as near as I can tell. There is no INSERT query.
>
> I am seeing INSERT queries from another dspam server that's working
> correctly, so this must be a configuration problem.
>

Hi,

That was going to be my next suggestion, to check the DB logs. :)
If you aren't getting errors from DSPAM, maybe you are not using the
DB that you think you are. In any event, it definitely sounds like a
config issue.

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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Dspam-user] web interface and command line dspam apparently failing to reclassify emails

ktm@rice.edu
In reply to this post by Sparr
On Thu, Nov 20, 2014 at 05:48:37PM -0600, Sparr wrote:
> On Thu, Nov 20, 2014 at 5:21 PM, Tom Hendrikx <[hidden email]> wrote:
> > Or are you using train on error / TOE ?
>
> Problem solved! "TrainPristine on" was preventing writes of signature
> data to the db, which causes all sorts of things that rely on the
> dspam_signature_data table to fail.
>

Great!

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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dspam-user
Loading...