You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Jim Knuth <jk...@jkart.de> on 2005/12/21 18:20:17 UTC
bayes_token empty
Hello spamassassin-users,
I use mysql for spamassassin (with amavisd-new).
since I changed the format of the tables (SA)
awl InnoDB
bayes_expire InnoDB
bayes_global_vars InnoDB
bayes_seen InnoDB
bayes_token InnoDB
bayes_vars InnoDB
of InnoDB, I don`t see no entrys in bayes_token, the table is
empty. Is it normal?
OS Debian stable, SA 3.1, amavisd-new 2.3.3, MySQL mysql Ver
12.22 Distrib 4.0.24
--
Viele Grüße, Kind regards,
Jim Knuth
jk@jkart.de
ICQ #277289867 - VoIP: +49 (0) 322 212 044 67
Key ID: 0x1F78066F
----------
Zufalls-Zitat
----------
Alles, das erfunden werden kann, ist erfunden worden.
(Charles H. Duell, Beauftragter, USA Office von Patenten,
1899)
----------
Der Text hat nichts mit dem Empfänger der Mail zu tun
----------
Virus free. Checked by NOD32 Version 1.1332 Build 6489 21.12.2005
Re: bayes_token empty
Posted by Jim Knuth <jk...@jkart.de>.
Heute (22.12.2005/07:41 Uhr) schrieb Michael Parker (parkerm@pobox.com),
> Jim Knuth wrote:
>>
>> yes, this is what I`ve used. I`ve now changed of
>>
>> bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>>
>> bayes_sql_dsn DBI:mysql:spamassassin:localhost:3306
>>
>> and will shown what happens. Or is it the InnoDB format wrong?
>>
> Not much use running with InnoDB in that configuration, it will just
> slow things down. You might as well just stick with MyISAM.
yes. That`s what I`ve done now. And all works fine again. thank
you.
> Michael
--
Viele Grüße, Kind regards,
Jim Knuth
jk@jkart.de
ICQ #277289867 - VoIP: +49 (0) 322 212 044 67
Key ID: 0x1F78066F
----------
Zufalls-Zitat
----------
Glück, der 29,5 Sekunden Orgasmus. (Udo Lindenberg)
----------
Der Text hat nichts mit dem Empfänger der Mail zu tun
----------
Virus free. Checked by NOD32 Version 1.1332 Build 6489 21.12.2005
Re: bayes_token empty
Posted by Michael Parker <pa...@pobox.com>.
Jim Knuth wrote:
>
> yes, this is what I`ve used. I`ve now changed of
>
> bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>
> bayes_sql_dsn DBI:mysql:spamassassin:localhost:3306
>
> and will shown what happens. Or is it the InnoDB format wrong?
>
Not much use running with InnoDB in that configuration, it will just
slow things down. You might as well just stick with MyISAM.
Michael
Re: bayes_token empty
Posted by Jim Knuth <jk...@jkart.de>.
Heute (21.12.2005/19:06 Uhr) schrieb Michael Parker (parkerm@pobox.com),
> Jim Knuth wrote:
>> Hello spamassassin-users,
>>
>> I use mysql for spamassassin (with amavisd-new).
>>
>> since I changed the format of the tables (SA)
>>
>> awl InnoDB
>> bayes_expire InnoDB
>> bayes_global_vars InnoDB
>> bayes_seen InnoDB
>> bayes_token InnoDB
>> bayes_vars InnoDB
>>
>> of InnoDB, I don`t see no entrys in bayes_token, the table is
>> empty. Is it normal?
>>
>> OS Debian stable, SA 3.1, amavisd-new 2.3.3, MySQL mysql Ver
>> 12.22 Distrib 4.0.24
>>
>>
> You give very few details about your configuration (ie which bayes
> storage module you are using) so I will have to assume you are using
> Mail::SpamAssassin::BayesStore::MySQL.
yes, this is what I`ve used. I`ve now changed of
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:spamassassin:localhost:3306
and will shown what happens. Or is it the InnoDB format wrong?
> If that is the case, I'm not surprised you are having issues. That
> storage module, as stated in the documentation, does not support the 4.0
> version of MySQL. Try upgrading and see how you do then.
> If the assumption was incorrect, then no it is not normal and you will
> have to provide more details.
> Michael
--
Viele Grüße, Kind regards,
Jim Knuth
jk@jkart.de
ICQ #277289867 - VoIP: +49 (0) 322 212 044 67
Key ID: 0x1F78066F
----------
Zufalls-Zitat
----------
Stehst du einmal schlecht im Futter, halt dich an die dicke
Mutter.
(Al Bundy)
----------
Der Text hat nichts mit dem Empfänger der Mail zu tun
----------
Virus free. Checked by NOD32 Version 1.1332 Build 6489 21.12.2005
Re: bayes_token empty
Posted by Michael Parker <pa...@pobox.com>.
Jim Knuth wrote:
> Hello spamassassin-users,
>
> I use mysql for spamassassin (with amavisd-new).
>
> since I changed the format of the tables (SA)
>
> awl InnoDB
> bayes_expire InnoDB
> bayes_global_vars InnoDB
> bayes_seen InnoDB
> bayes_token InnoDB
> bayes_vars InnoDB
>
> of InnoDB, I don`t see no entrys in bayes_token, the table is
> empty. Is it normal?
>
> OS Debian stable, SA 3.1, amavisd-new 2.3.3, MySQL mysql Ver
> 12.22 Distrib 4.0.24
>
>
You give very few details about your configuration (ie which bayes
storage module you are using) so I will have to assume you are using
Mail::SpamAssassin::BayesStore::MySQL.
If that is the case, I'm not surprised you are having issues. That
storage module, as stated in the documentation, does not support the 4.0
version of MySQL. Try upgrading and see how you do then.
If the assumption was incorrect, then no it is not normal and you will
have to provide more details.
Michael