Re: autolearn_status error Ubuntu 18.04 LTS

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