You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "Gary W. Smith" <ga...@primeexalia.com> on 2006/08/08 09:29:44 UTC
Bayes DB version issue 3.1.3 => 3.1.4
Hello,
I can't remember smoking crack when copying the config files over but
anything's possible.
I built out a new machine today and installed SA. We have a list of
CPAN modules that were installed (same list as from the 3.1.3 servers).
I copied everything in the /etc/mail/spamassassin from our productions
servers to the test server and after starting we receive errors. I have
checked and the MySQL data instance is accessible from this server.
There are also several rules that are errors as well.
I know that someone has asked this question already but I didn't find
the answer in the thread archive.
Here are the contents of the log file:
Aug 7 21:45:59 labtest01c spamd[2693]: config: score: the non-numeric
score (.8) is not valid, a numeric score is required
Aug 7 21:45:59 labtest01c spamd[2693]: config: SpamAssassin failed to
parse line, "SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677" is not valid for
"score", skipping: score SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677
Aug 7 21:46:01 labtest01c spamd[2693]: bayes: database version 0 is
different than we understand (3), aborting! at
/usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm line
135.
Aug 7 21:46:03 labtest01c spamd[2693]: bayes: database version 0 is
different than we understand (3), aborting! at
/usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm line
135.
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DIGEST_MULTIPLE
has undefined dependency 'RAZOR2_CHECK'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DIGEST_MULTIPLE
has undefined dependency 'DCC_CHECK'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DRUGS_ERECTILE
has undefined dependency '__DRUGS_ERECTILE7'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_SUB_ACCEPT_CCARDS has undefined dependency '__SARE_SUB_FROM_PAYPAL'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_SPEC_PROLEO_M2a has dependency 'MIME_QP_LONG_LINE' with a zero
score
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_XMAIL_SUSP2'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_HEAD_XAUTH_WARN'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_HEAD_SUBJ_RAND has dependency 'X_AUTH_WARN_FAKED' with a zero score
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
has undefined dependency 'SARE_RD_SAFE_MKSHRT'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
has undefined dependency 'SARE_RD_SAFE_GT'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
has undefined dependency 'SARE_RD_SAFE_TINY'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG50'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG55'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG65'
Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG75'
Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
VIRUS_WARNING_DOOM_BNC has undefined dependency 'VIRUS_WARNING_MYDOOM4'
Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
SARE_OBFU_CIALIS has undefined dependency 'SARE_OBFU_CIALIS2'
Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test FP_MIXED_PORN3
has undefined dependency 'FP_PENETRATION'
Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server started on port
783/tcp (running version 3.1.4)
Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server pid: 2693
Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
spawned child process, pid 2700
Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
spawned child process, pid 2701
Aug 7 21:46:07 labtest01c spamd[2693]: prefork: child states: II
Any help would be greatly appreciated.
Gary Wayne Smith
RE: Bayes DB version issue 3.1.3 => 3.1.4
Posted by "Gary W. Smith" <ga...@primeexalia.com>.
I've created a new database in UTF8 format. I will see how this works
out. I might try to copy the data from the Latin database to the UTF8
database but in past experience this hasn't worked that great. I might
also make a backup as well and try that.
-----Original Message-----
From: Gary W. Smith [mailto:gary@primeexalia.com]
Sent: Tuesday, August 08, 2006 2:23 PM
To: users@spamassassin.apache.org
Subject: RE: Bayes DB version issue 3.1.3 => 3.1.4
Okay, I have a little more information now. I run the same command that
sql.pm would run. It appears to be a collation issue. Can we force the
collation with 3.1.4 to a specific type? In my case the database is in
latin because 3.1.3 choked on UTF8. This was on RHEL4 (which defaults
to UTF8). The kernel is 2.6.9.
I'm trying to get this to run on rPath Linux which is on 2.6.16. I
would suspect that they have implemented more libraries in UTF8 now than
back on kernel 2.6.9.
Anyway, here is the command I issued to catch this point:
echo "SELECT value FROM bayes_global_vars WHERE variable = 'VERSION';" |
mysql -u user -D database -h 10.0.13.13 -ppassword
ERROR 1267 (HY000) at line 1: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
Any help would be greatly appreciated.
Gary Wayne Smith
-----Original Message-----
From: Gary W. Smith [mailto:gary@primeexalia.com]
Sent: Tuesday, August 08, 2006 8:06 AM
To: Daryl C. W. O'Shea
Cc: users@spamassassin.apache.org
Subject: RE: Bayes DB version issue 3.1.3 => 3.1.4
Daryl,
Thanks for the info. I will update the .8. As for the database, which
is the primary concern, the user account is correct. I have logged into
the database from that server using the same credentials from the
local.cf file. I had thought that we might have restricted by subnet so
I did indeed try that last night.
[root@labtest01c spamassassin]# mysql -u xxxxxxx -h xx.xx.xx.xx -D
spamassassin -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6649341 to server version: 4.1.7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+------------------------+
| Tables_in_spamassassin |
+------------------------+
| awl |
| bayes_expire |
| bayes_global_vars |
| bayes_seen |
| bayes_token |
| bayes_vars |
| userpref |
+------------------------+
7 rows in set (0.00 sec)
mysql> select * from bayes_global_vars;
+----------+-------+
| variable | value |
+----------+-------+
| VERSION | 3 |
+----------+-------+
1 row in set (0.00 sec)
mysql>
-----Original Message-----
From: Daryl C. W. O'Shea [mailto:spamassassin@dostech.ca]
Sent: Tuesday, August 08, 2006 12:38 AM
To: Gary W. Smith
Cc: users@spamassassin.apache.org
Subject: Re: Bayes DB version issue 3.1.3 => 3.1.4
On 8/8/2006 3:29 AM, Gary W. Smith wrote:
> Hello,
>
> I can't remember smoking crack when copying the config files over but
> anything's possible.
>
> I built out a new machine today and installed SA. We have a list of
> CPAN modules that were installed (same list as from the 3.1.3
servers).
> I copied everything in the /etc/mail/spamassassin from our productions
> servers to the test server and after starting we receive errors. I
have
> checked and the MySQL data instance is accessible from this server.
> There are also several rules that are errors as well.
>
> I know that someone has asked this question already but I didn't find
> the answer in the thread archive.
>
> Here are the contents of the log file:
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: score: the non-numeric
> score (.8) is not valid, a numeric score is required
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: SpamAssassin failed to
> parse line, "SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677" is not valid for
> "score", skipping: score SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677
".8" requires a leading zero.
> Aug 7 21:46:01 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
>
> Aug 7 21:46:03 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
SQL server privilege issue?
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'RAZOR2_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'DCC_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DRUGS_ERECTILE
> has undefined dependency '__DRUGS_ERECTILE7'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SUB_ACCEPT_CCARDS has undefined dependency
'__SARE_SUB_FROM_PAYPAL'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SPEC_PROLEO_M2a has dependency 'MIME_QP_LONG_LINE' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_XMAIL_SUSP2'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_HEAD_XAUTH_WARN'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has dependency 'X_AUTH_WARN_FAKED' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_MKSHRT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_GT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_TINY'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG50'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG55'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG65'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG75'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> VIRUS_WARNING_DOOM_BNC has undefined dependency
'VIRUS_WARNING_MYDOOM4'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> SARE_OBFU_CIALIS has undefined dependency 'SARE_OBFU_CIALIS2'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
FP_MIXED_PORN3
> has undefined dependency 'FP_PENETRATION'
Not errors, just info.
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server started on port
> 783/tcp (running version 3.1.4)
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server pid: 2693
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2700
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2701
>
> Aug 7 21:46:07 labtest01c spamd[2693]: prefork: child states: II
Normal startup info.
Daryl
RE: Bayes DB version issue 3.1.3 => 3.1.4
Posted by "Gary W. Smith" <ga...@primeexalia.com>.
Okay, I have a little more information now. I run the same command that
sql.pm would run. It appears to be a collation issue. Can we force the
collation with 3.1.4 to a specific type? In my case the database is in
latin because 3.1.3 choked on UTF8. This was on RHEL4 (which defaults
to UTF8). The kernel is 2.6.9.
I'm trying to get this to run on rPath Linux which is on 2.6.16. I
would suspect that they have implemented more libraries in UTF8 now than
back on kernel 2.6.9.
Anyway, here is the command I issued to catch this point:
echo "SELECT value FROM bayes_global_vars WHERE variable = 'VERSION';" |
mysql -u user -D database -h 10.0.13.13 -ppassword
ERROR 1267 (HY000) at line 1: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
Any help would be greatly appreciated.
Gary Wayne Smith
-----Original Message-----
From: Gary W. Smith [mailto:gary@primeexalia.com]
Sent: Tuesday, August 08, 2006 8:06 AM
To: Daryl C. W. O'Shea
Cc: users@spamassassin.apache.org
Subject: RE: Bayes DB version issue 3.1.3 => 3.1.4
Daryl,
Thanks for the info. I will update the .8. As for the database, which
is the primary concern, the user account is correct. I have logged into
the database from that server using the same credentials from the
local.cf file. I had thought that we might have restricted by subnet so
I did indeed try that last night.
[root@labtest01c spamassassin]# mysql -u xxxxxxx -h xx.xx.xx.xx -D
spamassassin -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6649341 to server version: 4.1.7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+------------------------+
| Tables_in_spamassassin |
+------------------------+
| awl |
| bayes_expire |
| bayes_global_vars |
| bayes_seen |
| bayes_token |
| bayes_vars |
| userpref |
+------------------------+
7 rows in set (0.00 sec)
mysql> select * from bayes_global_vars;
+----------+-------+
| variable | value |
+----------+-------+
| VERSION | 3 |
+----------+-------+
1 row in set (0.00 sec)
mysql>
-----Original Message-----
From: Daryl C. W. O'Shea [mailto:spamassassin@dostech.ca]
Sent: Tuesday, August 08, 2006 12:38 AM
To: Gary W. Smith
Cc: users@spamassassin.apache.org
Subject: Re: Bayes DB version issue 3.1.3 => 3.1.4
On 8/8/2006 3:29 AM, Gary W. Smith wrote:
> Hello,
>
> I can't remember smoking crack when copying the config files over but
> anything's possible.
>
> I built out a new machine today and installed SA. We have a list of
> CPAN modules that were installed (same list as from the 3.1.3
servers).
> I copied everything in the /etc/mail/spamassassin from our productions
> servers to the test server and after starting we receive errors. I
have
> checked and the MySQL data instance is accessible from this server.
> There are also several rules that are errors as well.
>
> I know that someone has asked this question already but I didn't find
> the answer in the thread archive.
>
> Here are the contents of the log file:
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: score: the non-numeric
> score (.8) is not valid, a numeric score is required
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: SpamAssassin failed to
> parse line, "SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677" is not valid for
> "score", skipping: score SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677
".8" requires a leading zero.
> Aug 7 21:46:01 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
>
> Aug 7 21:46:03 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
SQL server privilege issue?
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'RAZOR2_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'DCC_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DRUGS_ERECTILE
> has undefined dependency '__DRUGS_ERECTILE7'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SUB_ACCEPT_CCARDS has undefined dependency
'__SARE_SUB_FROM_PAYPAL'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SPEC_PROLEO_M2a has dependency 'MIME_QP_LONG_LINE' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_XMAIL_SUSP2'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_HEAD_XAUTH_WARN'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has dependency 'X_AUTH_WARN_FAKED' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_MKSHRT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_GT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_TINY'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG50'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG55'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG65'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG75'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> VIRUS_WARNING_DOOM_BNC has undefined dependency
'VIRUS_WARNING_MYDOOM4'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> SARE_OBFU_CIALIS has undefined dependency 'SARE_OBFU_CIALIS2'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
FP_MIXED_PORN3
> has undefined dependency 'FP_PENETRATION'
Not errors, just info.
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server started on port
> 783/tcp (running version 3.1.4)
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server pid: 2693
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2700
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2701
>
> Aug 7 21:46:07 labtest01c spamd[2693]: prefork: child states: II
Normal startup info.
Daryl
RE: Bayes DB version issue 3.1.3 => 3.1.4
Posted by "Gary W. Smith" <ga...@primeexalia.com>.
Daryl,
Thanks for the info. I will update the .8. As for the database, which
is the primary concern, the user account is correct. I have logged into
the database from that server using the same credentials from the
local.cf file. I had thought that we might have restricted by subnet so
I did indeed try that last night.
[root@labtest01c spamassassin]# mysql -u xxxxxxx -h xx.xx.xx.xx -D
spamassassin -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6649341 to server version: 4.1.7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+------------------------+
| Tables_in_spamassassin |
+------------------------+
| awl |
| bayes_expire |
| bayes_global_vars |
| bayes_seen |
| bayes_token |
| bayes_vars |
| userpref |
+------------------------+
7 rows in set (0.00 sec)
mysql> select * from bayes_global_vars;
+----------+-------+
| variable | value |
+----------+-------+
| VERSION | 3 |
+----------+-------+
1 row in set (0.00 sec)
mysql>
-----Original Message-----
From: Daryl C. W. O'Shea [mailto:spamassassin@dostech.ca]
Sent: Tuesday, August 08, 2006 12:38 AM
To: Gary W. Smith
Cc: users@spamassassin.apache.org
Subject: Re: Bayes DB version issue 3.1.3 => 3.1.4
On 8/8/2006 3:29 AM, Gary W. Smith wrote:
> Hello,
>
> I can't remember smoking crack when copying the config files over but
> anything's possible.
>
> I built out a new machine today and installed SA. We have a list of
> CPAN modules that were installed (same list as from the 3.1.3
servers).
> I copied everything in the /etc/mail/spamassassin from our productions
> servers to the test server and after starting we receive errors. I
have
> checked and the MySQL data instance is accessible from this server.
> There are also several rules that are errors as well.
>
> I know that someone has asked this question already but I didn't find
> the answer in the thread archive.
>
> Here are the contents of the log file:
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: score: the non-numeric
> score (.8) is not valid, a numeric score is required
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: SpamAssassin failed to
> parse line, "SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677" is not valid for
> "score", skipping: score SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677
".8" requires a leading zero.
> Aug 7 21:46:01 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
>
> Aug 7 21:46:03 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm
line
> 135.
SQL server privilege issue?
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'RAZOR2_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DIGEST_MULTIPLE
> has undefined dependency 'DCC_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
DRUGS_ERECTILE
> has undefined dependency '__DRUGS_ERECTILE7'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SUB_ACCEPT_CCARDS has undefined dependency
'__SARE_SUB_FROM_PAYPAL'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SPEC_PROLEO_M2a has dependency 'MIME_QP_LONG_LINE' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_XMAIL_SUSP2'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_HEAD_XAUTH_WARN'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has dependency 'X_AUTH_WARN_FAKED' with a zero
score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_MKSHRT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_GT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_TINY'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG50'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG55'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG65'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG75'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> VIRUS_WARNING_DOOM_BNC has undefined dependency
'VIRUS_WARNING_MYDOOM4'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> SARE_OBFU_CIALIS has undefined dependency 'SARE_OBFU_CIALIS2'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
FP_MIXED_PORN3
> has undefined dependency 'FP_PENETRATION'
Not errors, just info.
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server started on port
> 783/tcp (running version 3.1.4)
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server pid: 2693
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2700
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2701
>
> Aug 7 21:46:07 labtest01c spamd[2693]: prefork: child states: II
Normal startup info.
Daryl
Re: Bayes DB version issue 3.1.3 => 3.1.4
Posted by "Daryl C. W. O'Shea" <sp...@dostech.ca>.
On 8/8/2006 3:29 AM, Gary W. Smith wrote:
> Hello,
>
> I can’t remember smoking crack when copying the config files over but
> anything’s possible.
>
> I built out a new machine today and installed SA. We have a list of
> CPAN modules that were installed (same list as from the 3.1.3 servers).
> I copied everything in the /etc/mail/spamassassin from our productions
> servers to the test server and after starting we receive errors. I have
> checked and the MySQL data instance is accessible from this server.
> There are also several rules that are errors as well.
>
> I know that someone has asked this question already but I didn’t find
> the answer in the thread archive.
>
> Here are the contents of the log file:
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: score: the non-numeric
> score (.8) is not valid, a numeric score is required
>
> Aug 7 21:45:59 labtest01c spamd[2693]: config: SpamAssassin failed to
> parse line, "SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677" is not valid for
> "score", skipping: score SUBJ_HAS_UNIQ_ID .8 0.212 0.682 1.677
".8" requires a leading zero.
> Aug 7 21:46:01 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm line
> 135.
>
> Aug 7 21:46:03 labtest01c spamd[2693]: bayes: database version 0 is
> different than we understand (3), aborting! at
> /usr/lib/perl5/site_perl/5.8.7/Mail/SpamAssassin/BayesStore/SQL.pm line
> 135.
SQL server privilege issue?
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DIGEST_MULTIPLE
> has undefined dependency 'RAZOR2_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DIGEST_MULTIPLE
> has undefined dependency 'DCC_CHECK'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test DRUGS_ERECTILE
> has undefined dependency '__DRUGS_ERECTILE7'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SUB_ACCEPT_CCARDS has undefined dependency '__SARE_SUB_FROM_PAYPAL'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_SPEC_PROLEO_M2a has dependency 'MIME_QP_LONG_LINE' with a zero score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_XMAIL_SUSP2'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has undefined dependency 'SARE_HEAD_XAUTH_WARN'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_HEAD_SUBJ_RAND has dependency 'X_AUTH_WARN_FAKED' with a zero score
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_MKSHRT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_GT'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test SARE_RD_SAFE
> has undefined dependency 'SARE_RD_SAFE_TINY'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG50'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG55'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG65'
>
> Aug 7 21:46:05 labtest01c spamd[2693]: rules: meta test
> SARE_MSGID_LONG45 has undefined dependency '__SARE_MSGID_LONG75'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> VIRUS_WARNING_DOOM_BNC has undefined dependency 'VIRUS_WARNING_MYDOOM4'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test
> SARE_OBFU_CIALIS has undefined dependency 'SARE_OBFU_CIALIS2'
>
> Aug 7 21:46:06 labtest01c spamd[2693]: rules: meta test FP_MIXED_PORN3
> has undefined dependency 'FP_PENETRATION'
Not errors, just info.
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server started on port
> 783/tcp (running version 3.1.4)
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server pid: 2693
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2700
>
> Aug 7 21:46:07 labtest01c spamd[2693]: spamd: server successfully
> spawned child process, pid 2701
>
> Aug 7 21:46:07 labtest01c spamd[2693]: prefork: child states: II
Normal startup info.
Daryl