RE: Re[4]: [dspam-users] merging users with pgsql driver

I've noticed this bug since dspam-3.2.4, there was a problem in
tools/dspam_merge.c, where it called _ds_setall_spamrecords (CTX, freq),
and at that point CTX->operating_mode == DSM_TOOLS, and new users are not
created in this mode with the PG driver.

I haven't got the cleanest fix to that, I simply set CTX->operating_mode =
DSM_PROCESS before the above call and restored it afterwards. But that's a
good hint at the problem.

> -----Original Message-----
> From: owner-dspam-users@lists.nuclearelephant.com
> [mailto:owner-dspam-users@lists.nuclearelephant.com]On Behalf Of Elliot
> Finley
> Sent: August 9, 2005 7:43 PM
> To: Buck
> Cc: dspam-users@lists.nuclearelephant.com
> Subject: Re: Re[4]: [dspam-users] merging users with pgsql driver
>
>
> I have a bunch of those errors in my Postgres log also, but they
> didn't come
> from the dspam_merge.
>
> ----- Original Message -----
> From: "Buck" <dspam@fatcat.ru>
> To: "Elliot Finley" <efinleywork@efinley.com>
> Cc: <dspam-users@lists.nuclearelephant.com>
> Sent: Tuesday, August 09, 2005 4:18 PM
> Subject: Re[4]: [dspam-users] merging users with pgsql driver
>
>
> > Hey,
> >
> > it doesn't work for me either.
> > Postgre complains with lots of similar lines in the log:
> >
> > ERROR: duplicate key violates unique constraint
> "dspam_token_data_token_key"
> >
> > Buck
> >
> > #>> dspam_merge efinley@efinley.com efinleywork@efinley.com -o
> > > global@efinley.com
> > > Merging user: efinley@efinley.com
> > > processed 164641 tokens
> > > Merging user: efinleywork@efinley.com
> > > processed 397591 tokens
> > > storing merged tokens...
> > > completed.
> >
> > > but there is no global@efinley.com created in the dspam_virtual_uids
> table,
> > > and I can't find where the merged tokens are stored. So basically, I
> don't
> > > get any errors either, but neither do I get a merged user.
> >
> > > Elliot
> >
> > > ----- Original Message -----
> > > From: "Buck" <dspam@fatcat.ru>
> > > To: "Elliot Finley" <efinleywork@efinley.com>
> > > Cc: <dspam-users@lists.nuclearelephant.com>
> > > Sent: Tuesday, August 09, 2005 11:29 AM
> > > Subject: Re[2]: [dspam-users] merging users with pgsql driver
> >
> >
> > >> Hey Elliot!
> > >>
> > >> Doesn't it merge data? I tried on bogus user accounts and at least it
> > >> doesn't produce any errors. What's your case?
> > >>
> > >>
> > >> > Anyone? Is there a way to merge users using the Postgres driver?
> > >>
> > >> > ----- Original Message -----
> > >> > From: "Elliot Finley" <efinleywork@efinley.com>
> > >> > To: <dspam-users@lists.nuclearelephant.com>
> > >> > Sent: Monday, August 08, 2005 5:49 PM
> > >> > Subject: [dspam-users] merging users with pgsql driver
> > >>
> > >>
> > >> >> how do you do the equivalent of a dspam_merge user1 user2 -o user3
> if
> > >> > you're
> > >> >> using Postgres?
> > >> >>
> > >> >> Elliot
> > >> >>
> >
> >
> >
> >
> >
> >
> > ***********************************************
> > EMERY TELCOM SPAM FILTERING CHECK: Innocent
> > ***********************************************
> > If you consider this e-mail to be spam, please click on the URL below.
> > Emery Telcom's free spam detector service will be adjusted
> accordingly for
> future e-mails.
> >
> http://postmaster.etv.net:8080/reclassify?user=6566696e6c6579776f7
26b406566696e6c65792e636f6d&signature=42f92bdf569609573284269&result=496e6e6
f63656e74
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.10.4/66 - Release Date: 8/9/2005
>
>

!DSPAM:42f93f7c324343525437210!
Received on Tue Aug 9 22:23:57 2005