[SOLVED]amavisd error after last upgrade

[LinuxRocks]

Hey all,

After the upgrade the other day:

Code: [Select]

Start-Date: 2012-03-02  11:23:01
Upgrade: zentyal-monitor (2.2.2, 2.2.3), zentyal-network (2.2.5, 2.2.6), zentyal-mailfilter (2.2, 2.2.1), zentyal-core (2.2.5, 2.2.6), zentyal-antivirus (2.2, 2.2.1), zentyal-ids (2.2.1, 2.2.2), zentyal-ebackup (2.2.2, 2.2.3), zentyal-software (2.2.2, 2.2.3), zentyal-squid (2.2.2, 2.2.4), zentyal-remoteservices (2.2.3, 2.2.5)
End-Date: 2012-03-02  11:24:37

I am now getting these errors in cron.daily:

Code: [Select]

/etc/cron.daily/amavisd-new:
bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
/etc/cron.daily/zentyal:
Undefined subroutine &EBox::Report::DiskUsage::partitionsFileSystems called at /usr/share/perl5/EBox/SysInfo.pm line 404.

Any idea of these are of any worry or just noisy cron jobs after the upgrade?

Thanks!
Joe

[jsalamero]

Did you change your partitions schema?

Enable debug = yes and check zentyal.log for relevant messages.

[LinuxRocks]

Ok, here is the output...

Please let me know if you need any additional information.

Thanks!

Code: [Select]

2012/03/06 17:31:33 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080288.M884267P29411.homeserver,S=1819,W=1856' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255
2012/03/06 17:31:36 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080292.M416735P29429.homeserver,S=3072,W=3144' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255
2012/03/06 17:34:40 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080474.M875804P29501.homeserver,S=2743,W=2809' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255
2012/03/06 17:34:48 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080485.M866423P29526.homeserver,S=1400,W=1439' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255
2012/03/06 17:35:11 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080509.M317244P29560.homeserver,S=2833,W=2882' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255
2012/03/06 17:35:20 ERROR> Sudo.pm:213 EBox::Sudo::_rootError - root command su amavis -c 'sa-learn --spam  /tmp/1331080515.M927577P29584.homeserver,S=2830,W=2879' failed.
Error output: bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 bayes: database version 0 is different than we understand (3), aborting! at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 189.
 ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /usr/bin/sa-learn line 493.

Command output: Learned tokens from 0 message(s) (1 message(s) examined)
.
Exit value: 255

Joe

[LinuxRocks]

Oh, to answer your first question, no, I did not change anything. I just did an apt-get update && apt-get upgrade and the previously mentioned packages were upgraded.

Thanks!
Joe

[Javier Amor Garcia]

Hello

the SQL error I think is a consequence of this bug -> http://trac.zentyal.org/ticket/3898 (the ticket has recovery instructions)

An the EBox::Report::DiskUsage::partitionsFileSystems error is solved there -> https//trac.zentyal.org/ticket/3807 . To fix it change the line 404 of /usr/share/perl5/EBox/SysInfo.pm to call EBox::FileSystem::partitionsFileSystems () instead of EBox::Report::DiskUsage::partitionsFileSystem()

Regards,

Javier

[LinuxRocks]

Hello

the SQL error I think is a consequence of this bug -> http://trac.zentyal.org/ticket/3898 (the ticket has recovery instructions)

An the EBox::Report::DiskUsage::partitionsFileSystems error is solved there -> https//trac.zentyal.org/ticket/3807 . To fix it change the line 404 of /usr/share/perl5/EBox/SysInfo.pm to call EBox::FileSystem::partitionsFileSystems () instead of EBox::Report::DiskUsage::partitionsFileSystem()

Regards,

Javier

Thanks, Javier!

I have made the changes you recommended and tried the daily cron job for amavisd (amavisd-new) and did not get any errors this time.

Will have to wait to test the other issue (Not sure which cron job run that script), but I will let you know if it worked or not tomorrow.

Thanks again for your help!
Joe

[LinuxRocks]

OK, after making those changes, the daily cron job is now running as it should.

Thanks for the help!

Joe

[ronmcmilli]

Is it possible you could post the solution? The issue has since been removed.

[expertgeeks]

Found in the Internet Archive;

Hello Smashe,

this is a setup error and it is solved in [3b02cba]

However to fix any system with the mailfilter module, already installed and enabled, you should use the following commands

    sudo -s
    su postgres -c'psql -c"create database spamassassin" '
    su postgres -c'psql spamassassin < /usr/share/zentyal-mailfilter/sql/spamassassin.sql'
    /etc/init.d/zentyal mailfilter restart

Some misplaced tables will be left in the eboxlogs database, you could remove if they bother you. They are bayes_expire ,bayes_global_vars, bayes_seen, bayes_token and bayes_vars

Regards,

Javier