Re: autolearn_status error Ubuntu 18.04 LTS

Just merged a relevant maiad fix from technion, not seeing any more "NULL"
entries in maia_maia.autolearn_status, will continue to monitor.

jake

On Sun, May 17, 2020 at 10:25 AM jjs - mainphrame <[email protected]>
wrote:

> There's something about this autolearn_status issue that's nagging at me.
> From what i can see, it was supposed to work in conjunction with bayes
> training and spam reporting, but for some reason that field is getting set
> to null.
>
> I'm going to have to dig deeper, and try to find out where we went off the
> rails. My guess is that at one point this field was being used, but somehow
> fell through the cracks at some point.
>
> The process-quarantine script contains 7 mentions of that parameter, e.g:
>
>     #   List any confirmed spam (C), confirmed ham (G),
>     #   autolearnable spam (S), and autolearnable ham (H),
>     #   filtered by the $spamonly and $hamonly flags.
>     my $query = <<EOQ;
> SELECT maia_mail.id,
>        maia_mail_recipients.recipient_id,
>        maia_mail_recipients.type,
>        maia_mail.size,
>        maia_mail.score,
>        maia_mail.autolearn_status
> FROM   maia_mail, maia_mail_recipients
> WHERE  maia_mail.id = maia_mail_recipients.mail_id
> EOQ
>
> Related parameters appear in maia.conf:
> --
> # If Bayes training is enabled, automatically learn items
> # with extreme scores, even without user confirmation.
> # Set these values conservatively, or undef to disable.
>
> $autolearn_ham_threshold = undef;   # e.g. -5
> $autolearn_spam_threshold = undef;  # e.g. 10
> --
>
> In any case, I'm looking to recover lost functionality. If any maia gurus
> remember how it used to work, your insights would be welcome.
>
> Jake
>
>
> On Tue, May 12, 2020 at 8:36 AM <[email protected]> wrote:
>
>> Hello Everyone,
>>
>> I've been out of the loop for a long while and decided to try the latest
>> build using the install script on Ubuntu 18.04 LTS. Everything seemed to go
>> along just fine and I am testing with a domain and getting the following
>> error.
>>
>> May 12 14:04:59 maia postfix/lmtp[33612]: EECC1859E0: to=<[email protected]>,
>> relay=127.0.0.1[127.0.0.1]:10024, delay=0.35, delays=0.22/0/0/0.12,
>> dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error
>> in processing, id=21314-03, Take Action! FAILED: DBD::mysql::st execute
>> failed: Column 'autolearn_status' cannot be null at /var/lib/maia/maiad
>> line 4408, <GEN20> line 156. (in reply to end of DATA command))
>>
>> The Maia server is at the head end, the user account was created in the
>> web interface and there is a transport file and relay_domain mappings file
>> to the recipient email server.
>>
>> Seems like its something minor but A google search isn’t helping me out
>>
>> Thanks,
>> Dave
>>
>>
>> _______________________________________________
>> Maia-users mailing list
>> [email protected]
>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>>
>

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users