You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "Dimitar G. Katerinski" <dg...@tropot.net> on 2006/08/20 20:21:31 UTC
MySQL, DBI, transactions problem
Hello,
I'm trying to setup Spamassassin to use mysql for bayes storage. However I'm
experiencing problems with DBI complaining about "Transactions not supported
by database at /usr/lib/perl5/DBI.pm line 670."
I know that this is not strictly a spamassassin issue, but maybe someone from
this list came upon such problem.
Here's my setup:
OS: debian unstable
libdbi-perl - 1.51-2
mysql: 5.0.24
~# spamassassin -V
SpamAssassin version 3.1.4
running on Perl version 5.8.8
/etc/spamassassin/local.cf:
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:mysql:spamassassin:localhost
bayes_sql_username <username>
bayes_sql_password <password>
Regards,
Dimitar
Re: MySQL, DBI, transactions problem
Posted by Benny Pedersen <me...@junc.org>.
On Mon, August 21, 2006 03:02, Mark Martinec wrote:
>> On Sun, August 20, 2006 20:21, Dimitar G. Katerinski wrote:
>> > I'm trying to setup Spamassassin to use mysql for bayes storage. However
>> > I'm experiencing problems with DBI complaining about "Transactions not
>> > supported by database at /usr/lib/perl5/DBI.pm line 670."
>>
>> yep see bug
>> http://bugs.gentoo.org/show_bug.cgi?id=143107
>
> In my case it helped reinstalling DBD::mysql, after upgrading DBI.
> (Mail::SpamAssassin::BayesStore::MySQL, DBD::mysql 3.0006, DBI 1.52)
> Didn't investigate further.
thanks, it solved it here aswell
mysql 4.1.21
DBD-mysql 3.0004
DBI 1.50
the magic must be to recompile
i will close the bug on gentoo
--
Benny
Re: MySQL, DBI, transactions problem
Posted by Mark Martinec <Ma...@ijs.si>.
> On Sun, August 20, 2006 20:21, Dimitar G. Katerinski wrote:
> > I'm trying to setup Spamassassin to use mysql for bayes storage. However
> > I'm experiencing problems with DBI complaining about "Transactions not
> > supported by database at /usr/lib/perl5/DBI.pm line 670."
>
> yep see bug
> http://bugs.gentoo.org/show_bug.cgi?id=143107
In my case it helped reinstalling DBD::mysql, after upgrading DBI.
(Mail::SpamAssassin::BayesStore::MySQL, DBD::mysql 3.0006, DBI 1.52)
Didn't investigate further.
Mark
Re: MySQL, DBI, transactions problem
Posted by Mark Martinec <Ma...@ijs.si>.
> Nope. I didn't write it clear, sorry about that. I want to make amavisd-new
> use sql for all *_ quarantine_method, but DBI is complaining about the same
> thing.
I understood. It is the same problem, once you resolve the problem with
Mail::SpamAssassin::BayesStore::MySQL, amavisd logging and quarantining
to SQL will work too.
Mark
Re: MySQL, DBI, transactions problem
Posted by "Dimitar G. Katerinski" <dg...@tropot.net>.
On Monday 21 August 2006 15:27, Mark Martinec wrote:
> > A little bit off topic on this list, but since you are involved with
> > amavisd-new, do you know how to avoid the same problem in amavisd-new?
>
> With Bayes db? Fix it within SpamAssassin, and amavisd-new will be happy
> too. Like I mentioned previously, I've seen it too and it helped to
> reinstall DBD::mysql and DBI modules, but I'm not sure what is behind.
Nope. I didn't write it clear, sorry about that. I want to make amavisd-new
use sql for all *_ quarantine_method, but DBI is complaining about the same
thing.
Regards,
Dimitar
Re: MySQL, DBI, transactions problem
Posted by Mark Martinec <Ma...@ijs.si>.
> A little bit off topic on this list, but since you are involved with
> amavisd-new, do you know how to avoid the same problem in amavisd-new?
With Bayes db? Fix it within SpamAssassin, and amavisd-new will be happy too.
Like I mentioned previously, I've seen it too and it helped to reinstall
DBD::mysql and DBI modules, but I'm not sure what is behind.
Mark
Re: MySQL, DBI, transactions problem
Posted by "Dimitar G. Katerinski" <dg...@tropot.net>.
On Monday 21 August 2006 13:45, Mark Martinec wrote:
> > > > /etc/spamassassin/local.cf:
> > > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
> > >
> > > change to sql there, mysql does not work, sql does
> >
> > Тhanks a lot, that fixed the problem ;-)
>
> That just avoided the problem by using a less efficient plugin
> which does not need transactions.
>
> Mark
A little bit off topic on this list, but since you are involved with
amavisd-new, do you know how to avoid the same problem in amavisd-new?
Regards,
Dimitar
Re: MySQL, DBI, transactions problem
Posted by Mark Martinec <Ma...@ijs.si>.
> > > /etc/spamassassin/local.cf:
> > > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
> >
> > change to sql there, mysql does not work, sql does
>
> Тhanks a lot, that fixed the problem ;-)
That just avoided the problem by using a less efficient plugin
which does not need transactions.
Mark
Re: MySQL, DBI, transactions problem
Posted by "Dimitar G. Katerinski" <dg...@tropot.net>.
On Monday 21 August 2006 03:44, Benny Pedersen wrote:
> On Sun, August 20, 2006 20:21, Dimitar G. Katerinski wrote:
> > I'm trying to setup Spamassassin to use mysql for bayes storage. However
> > I'm experiencing problems with DBI complaining about "Transactions not
> > supported by database at /usr/lib/perl5/DBI.pm line 670."
>
> yep see bug
>
> http://bugs.gentoo.org/show_bug.cgi?id=143107
>
> > I know that this is not strictly a spamassassin issue, but maybe someone
> > from this list came upon such problem.
> >
> > Here's my setup:
> > OS: debian unstable
> > libdbi-perl - 1.51-2
> > mysql: 5.0.24
> >
> > ~# spamassassin -V
> > SpamAssassin version 3.1.4
> > running on Perl version 5.8.8
> >
> > /etc/spamassassin/local.cf:
> > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
>
> change to sql there, mysql does not work, sql does
Тhanks a lot, that fixed the problem ;-)
Re: MySQL, DBI, transactions problem
Posted by Benny Pedersen <me...@junc.org>.
On Sun, August 20, 2006 20:21, Dimitar G. Katerinski wrote:
> I'm trying to setup Spamassassin to use mysql for bayes storage. However I'm
> experiencing problems with DBI complaining about "Transactions not supported
> by database at /usr/lib/perl5/DBI.pm line 670."
yep see bug
http://bugs.gentoo.org/show_bug.cgi?id=143107
> I know that this is not strictly a spamassassin issue, but maybe someone from
> this list came upon such problem.
>
> Here's my setup:
> OS: debian unstable
> libdbi-perl - 1.51-2
> mysql: 5.0.24
>
> ~# spamassassin -V
> SpamAssassin version 3.1.4
> running on Perl version 5.8.8
>
> /etc/spamassassin/local.cf:
> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
change to sql there, mysql does not work, sql does
i downgrade to mysql 4.1.20 on gentoo, i do not know if that is needed on debian
> bayes_sql_dsn DBI:mysql:spamassassin:localhost
> bayes_sql_username <username>
> bayes_sql_password <password>
--
Benny