You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@bugzilla.spamassassin.org on 2018/12/04 11:02:06 UTC
[Bug 7663] New: bug about awl.sql
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7663
Bug ID: 7663
Summary: bug about awl.sql
Product: Spamassassin
Version: 3.4.2
Hardware: PC
OS: Linux
Status: NEW
Severity: trivial
Priority: P2
Component: spamassassin
Assignee: dev@spamassassin.apache.org
Reporter: natan@iq.pl
Target Milestone: Undefined
Probably another problem with awl_mysql.sql and SA
In latest version of SA (3.4.2)count was renamed to msgcount
https://svn.apache.org/viewvc/spamassassin/branches/3.4/sql/awl_mysql.sql?revision=1844306&view=markup&pathrev=1844485
mysql> desc awl;
+----------+----------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|
+----------+----------------+------+-----+-------------------+-----------------------------+
| username | varchar(100) | NO | PRI | |
|
| email | varbinary(255) | NO | PRI | |
|
| ip | varchar(40) | NO | PRI | |
|
| msgcount | int(11) | NO | | 0 |
|
| totscore | float | NO | | 0 |
|
| signedby | varchar(255) | NO | PRI | |
|
| last_hit | timestamp | NO | | CURRENT_TIMESTAMP | on update
CURRENT_TIMESTAMP |
+----------+----------------+------+-----+-------------------+-----------------------------+
8 rows in set (0.00 sec)
But in logs i found:
"SQL error: Unknown column 'count' in 'field list'"
I added "count" to table awl
mysql> desc awl;
+----------+----------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|
+----------+----------------+------+-----+-------------------+-----------------------------+
| username | varchar(100) | NO | PRI | |
|
| email | varbinary(255) | NO | PRI | |
|
| ip | varchar(40) | NO | PRI | |
|
| msgcount | int(11) | NO | | 0 |
|
| count | int(11) | NO | | 0 |
|
| totscore | float | NO | | 0 |
|
| signedby | varchar(255) | NO | PRI | |
|
| last_hit | timestamp | NO | | CURRENT_TIMESTAMP | on update
CURRENT_TIMESTAMP |
+----------+----------------+------+-----+-------------------+-----------------------------+
8 rows in set (0.00 sec)
and works perfectly
mysql> select * from awl limit 10;
+-----------------------------------+-----------------------------------------+---------+----------+-------+----------+----------+---------------------+
| username | email |
ip | msgcount | count | totscore | signedby | last_hit |
+-----------------------------------+-----------------------------------------+---------+----------+-------+----------+----------+---------------------+
| xxxxxxxx@xxxxxxx.pl | sebastian@foo.bar.pl |
185.111 | 0 | 1 | -4.999 | | 2018-12-04 11:31:23 |
| a.nazarenka@xyxyxyxyx.pl | powiadomienie@foobar.pl |
94.130 | 0 | 1 | 3.594 | | 2018-12-04 11:31:37 |
| a.users@anotherdomain.pl | beyhan@another.foo.bar.de |
85.215 | 0 | 1 | -1.699 | | 2018-12-04 11:31:31 |
| a.user2@anotherdomain1.com | agnieszka@foo.bar.com |
87.204 | 0 | 1 | -4.589 | | 2018-12-04 11:31:13 |
+-----------------------------------+-----------------------------------------+---------+----------+-------+----------+----------+---------------------+
10 rows in set (0.00 sec)
Server version: 5.5.62-0+deb8u1 (Debian)
Os debian 8.11
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7663] bug about awl.sql
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7663
natan <na...@iq.pl> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |natan@iq.pl
--- Comment #2 from natan <na...@iq.pl> ---
This is not very cool.
I get latest SA
https://www-eu.apache.org/dist//spamassassin/source/Mail-SpamAssassin-3.4.2.tar.gz
from website (1h time ago) and when I run it and found in logs some SQl error
like this:
"amavis-ng3 amavis[7819]: (07819-01) SA info: auto-whitelist: sql-based
get_addr_entry etteyld@intersport.biz.ua|none: SQL error: Unknown column
'last_hit' in 'order clause'"
and i add to my sql
alter table awl add msgcount int(11) NOT NULL default '0';
alter table awl add last_hit timestamp NOT NULL default CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP;
alter table awl add KEY last_hit (last_hit);
and work perfectly
Probably Mail-SpamAssassin-3.4.2.tar.gz need this to work
and second in logs I found many many times:
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns3.allegro.pl
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns4.allegro.pl
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns2.allegro.pl
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns1.allegro.pl
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns3.onet.pl
Dec 20 12:20:57 amavis-ng3 amavis[22186]: (22186-17) SA info: dns:
new_dns_packet: domain is utf8 flagged: dns1.onet.pl
log level in now 1
Why normal domain is flagged utf8 ?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7663] bug about awl.sql
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7663
--- Comment #3 from Giovanni Bechis <gi...@paclan.it> ---
last_hit field has been added in r1844485 and will be available in upcoming
3.4.3.
For the second problem refer to
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7632
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 7663] bug about awl.sql
Posted by bu...@bugzilla.spamassassin.org.
https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7663
Giovanni Bechis <gi...@paclan.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |giovanni@paclan.it
Status|NEW |RESOLVED
Resolution|--- |INVALID
--- Comment #1 from Giovanni Bechis <gi...@paclan.it> ---
Spamassassin 3.4.2 has been released on 9/16/18 and the commit that changes awl
database has been done later.
The awl/txrep database fix will be available on next SA release.
--
You are receiving this mail because:
You are the assignee for the bug.