amavis problem

rafalek · 08-18-2010, 11:43 PM

Hi.

I install postfix with amavis-new few days ago, but every day I receive mail with following content:

Code:

/etc/cron.daily/amavisd-new:
Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 133.
Use of uninitialized value $db_ver in numeric ne (!=) at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 135.
Use of uninitialized value $db_ver in concatenation (.) or string at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 136.
bayes: database version  is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 136.
Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 180.
Use of uninitialized value $db_ver in numeric ne (!=) at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 182.
Use of uninitialized value $db_ver in concatenation (.) or string at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 183.
bayes: database version  is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 183.

I use Ubuntu - server edition. Every packets are new.

Is somebody can help me to fix it?
I don't know if this is important but every mail I receive on this server is scored above 7

Thanks

bathory · 08-19-2010, 05:06 AM

How did you install the whole spamassassin/amavisd thing?
It looks like you're using sql database to store bayes data and you miss the version value. If you're using mysql take a look at bayes_mysql.sql:

Quote:

CREATE TABLE bayes_expire (
id int(11) NOT NULL default '0',
runtime int(11) NOT NULL default '0',
KEY bayes_expire_idx1 (id)
) TYPE=MyISAM;

CREATE TABLE bayes_global_vars (
variable varchar(30) NOT NULL default '',
value varchar(200) NOT NULL default '',
PRIMARY KEY (variable)
) TYPE=MyISAM;

INSERT INTO bayes_global_vars VALUES ('VERSION','3');