On Saturday 21 April 2012 22:52:35 you wrote:
> From: Tom Fernandes <anyaddr...@gmx.net>
> >To: Steve Fatula <compconsult...@yahoo.com>
> >Sent: Saturday, April 21, 2012 3:19 PM
> >Subject: Re: [Dspam-user] retraining not working (bailing on error 22)
> >
> >
> >> >> >
> >> >> >dspam --source=error --class=spam --user tom \
> >> >> >--signature=4f8f82b4156573186765973
> >> >> >
> >> >> >Can you paste in a copy of that message?
> >> >
> >> >I pasted it in my previous email. I paste it again at the end of this
mail.
> >> >
> >> Sorry, I somehow didn't see it. So, I presume you are piping the contents
> >> on that message into your dspam command somehow?
> >
> >no. I use --signature. I asumed that dspam has got all the tokens of that
mail
> >already and that this data is connected to the signature of the mail.
> >So I thought that the command from above does actually re-train dspam.
> >Am I mistaken?
> >
> >I don't actually train in a script or via mail address, etc., I use dovecot
antispam, so, admitedly, not up to date on command line training. So, I
suppose since I re-reviewed the config file you sent and the command above,
you are not using pristine mode, I suppose it is not needed. I believe it's
needed in pristine mode, I am not reading so well today.
>
> Your signature looks weird though. Mine looks like:
>
> 15,4f931c4822126691269849
I think that's okay. I've seen different looking signatures on the web.
>
>
> What happens when you:
>
> select count(*) from dspam.dspam_signature_data where signature =
> "4f8f82b4156573186765973"
there is one column.
I also switched on statement-logging in PostgreSQL. Looks okay to me and at
least the last 5 SELECTs all return data:
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',1) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',2) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT typname FROM pg_type WHERE
typelem IN (SELECT atttypid FROM pg_attribute WHERE attname='token' AND
attrelid IN (SELECT oid FROM pg_class WHERE relname='dspam_token_data'));
2012-04-21 23:41:48 CEST LOG: statement: SELECT uid FROM dspam_virtual_uids
WHERE username=E'tom'
2012-04-21 23:41:48 CEST LOG: statement: SELECT preference,value FROM
dspam_preferences WHERE uid=1
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',1) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',2) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT typname FROM pg_type WHERE
typelem IN (SELECT atttypid FROM pg_attribute WHERE attname='token' AND
attrelid IN (SELECT oid FROM pg_class WHERE relname='dspam_token_data'));
2012-04-21 23:41:48 CEST LOG: statement: SELECT preference,value FROM
dspam_preferences WHERE uid=0
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',1) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',2) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT typname FROM pg_type WHERE
typelem IN (SELECT atttypid FROM pg_attribute WHERE attname='token' AND
attrelid IN (SELECT oid FROM pg_class WHERE relname='dspam_token_data'));
2012-04-21 23:41:48 CEST LOG: statement: SELECT preference,value FROM
dspam_preferences WHERE uid=0
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',1) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',2) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT
coalesce(substring(split_part(split_part(version(),' ',2),'.',3) FROM
E'\\d+')::int2,0)
2012-04-21 23:41:48 CEST LOG: statement: SELECT typname FROM pg_type WHERE
typelem IN (SELECT atttypid FROM pg_attribute WHERE attname='token' AND
attrelid IN (SELECT oid FROM pg_class WHERE relname='dspam_token_data'));
2012-04-21 23:41:48 CEST LOG: statement: SELECT uid FROM dspam_virtual_uids
WHERE username=E'tom'
2012-04-21 23:41:48 CEST LOG: statement: SELECT
uid,spam_learned,innocent_learned,spam_misclassified,innocent_misclassified,spam_corpusfed,innocent_corpusfed,spam_classified,innocent_classified
FROM dspam_stats WHERE uid=1
2012-04-21 23:41:48 CEST LOG: statement: SELECT data,length FROM
dspam_signature_data WHERE uid=1 AND signature=E'4f8f82b4156573186765973'
2012-04-21 23:41:48 CEST LOG: statement: SELECT * FROM
lookup_tokens(1,'{5334511981350707200}')
warm regards,
Tom
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
