Mailing List Archive: Some new SQL activity with 3.4.3?

Some new SQL activity with 3.4.3?

Dec 14, 2019, 9:08 PM

Post #1 of 4 (831 views)

I suddenly find stuff like this in mail.log. What is this? Where can I
get the schema?

Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry 5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry jarif@fredriksson.dy.fi|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry jarif@fredriksson.dy.fi|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|-10|spam|jarif@fredriksson.dy.fi|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry root@mail.bitwell.biz|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry root@mail.bitwell.biz|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|-10|spam|root@mail.bitwell.biz|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry root@mail.bitwell.biz|bitwell.biz: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|0.649|spam|root@mail.bitwell.biz|bitwell.biz|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry bitwell.biz|bitwell.biz: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|0.649|spam|bitwell.biz|bitwell.biz|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry 127.0.0.1|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|0.649|spam|127.0.0.1|none: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based get_addr_entry 5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183: SQL error: Unknown column 'msgcount' in 'field list'
Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based add_score/update 1|0.649|spam|5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183|none: SQL error: Unknown column 'msgcount' in 'field list'

Re: Some new SQL activity with 3.4.3? [ In reply to ]

sausers-20150205 at billmail

Dec 14, 2019, 9:54 PM

Post #2 of 4 (831 views)

Permalink

On 15 Dec 2019, at 0:08, Jari Fredriksson wrote:

> I suddenly find stuff like this in mail.log. What is this? Where can I
> get the schema?
>
> Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based
> get_addr_entry
> 5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183: SQL
> error: Unknown column 'msgcount' in 'field list'[wtc...]

Read the UPGRADE file. It includes steps required for anyone using
SQL-based AWL or TxRep.

--
Bill Cole
bill@scconsult.com or billcole@apache.org
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not For Hire (currently)

Re: Some new SQL activity with 3.4.3? [ In reply to ]

jarif at iki

Dec 15, 2019, 4:27 AM

Post #3 of 4 (829 views)

Permalink

On 15.12.2019 7.54, Bill Cole wrote:
> On 15 Dec 2019, at 0:08, Jari Fredriksson wrote:
>
>> I suddenly find stuff like this in mail.log. What is this? Where can
>> I get the schema?
>>
>> Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based
>> get_addr_entry
>> 5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183: SQL
>> error: Unknown column 'msgcount' in 'field list'[wtc...]
>
> Read the UPGRADE file. It includes steps required for anyone using
> SQL-based AWL or TxRep.
>
Hmm. Need to somehow find that file. I upgraded using CPAN so I do not
have the files. Maybe they are somewhere in /root/.cpan on some box...

br. jarif

Re: Some new SQL activity with 3.4.3? [ In reply to ]

giovanni at paclan

Dec 15, 2019, 4:31 AM

Post #4 of 4 (829 views)

Permalink

Il 15 dicembre 2019 13:27:03 CET, Jari Fredriksson <jarif@iki.fi> ha scritto:
>
>On 15.12.2019 7.54, Bill Cole wrote:
>> On 15 Dec 2019, at 0:08, Jari Fredriksson wrote:
>>
>>> I suddenly find stuff like this in mail.log. What is this? Where can
>
>>> I get the schema?
>>>
>>> Dec 15 07:03:04 gauntlet spamd[19176]: auto-whitelist: sql-based
>>> get_addr_entry
>>> 5c2a750a32f249155ecf3ade17358fa1a98b2db7@sa_generated|1576386183:
>SQL
>>> error: Unknown column 'msgcount' in 'field list'[wtc...]
>>
>> Read the UPGRADE file. It includes steps required for anyone using
>> SQL-based AWL or TxRep.
>>
>Hmm. Need to somehow find that file. I upgraded using CPAN so I do not
>have the files. Maybe they are somewhere in /root/.cpan on some box...
>
>br. jarif

you can find it here:
https://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_release_3_4_3/UPGRADE
Giovanni