Re: Maia-users Digest, Vol 172, Issue 18

Hi Manny,

The option to alter the Subject line with the ***SPAM*** tag is in the
policy table of the maia db, which can be modified based on the user
selection of a protection level in the web interface.

To verify, in the db:

MariaDB [maia]> select id,spam_modifies_subj from policy where
spam_modifies_subj = 'Y';

You can set them all to not mark:

MariaDB [maia]> update policy set spam_modifies_subj = 'N';

There's a legacy setting in config.php, that has maia modify the subject
line when the spam protection level is set to medium, which needs to be
changed if you don't want a user to inadvertently set their preferences to
alter the header. We'll change it in the repo, since we'll just quarantine
the spam instead of marking it.

Your config.php should look like this, around lines 163-167: (Last column
before the numbers is the subject modify option, it should be "N")

  $protection = array( 'off'     => array
('Y','Y','Y','Y','Y','Y','Y','Y','N','N','N','N','N','999','999','999'),
                         'low'     => array
('N','Y','Y','Y','N','Y','Y','Y','N','N','N','N','N','999','999','999'),
                         'medium'  => array
('N','N','Y','Y','N','N','Y','Y','N','N','N','N','N','-999','7','7'),
                         'high'    => array
('N','N','N','N','N','N','N','N','N','N','N','N','N','-999','5','5')
        );


Apologies for not catching the mysql error sooner. We just hadn't seen it
in any vanilla builds until ubuntu 18.04

Jake

On Sat, May 16, 2020 at 8:23 AM Manny Marinho <[email protected]>
wrote:

> So I finally got maia working on my new CentOS7 server but I also
> encountered this autolearn_status error yesterday while creating a new
> maia db which drove me nuts until I found this thread. I'm using mySQL
> MARIA DB. I simply pulled the new maia-mysql.sql script from GitHub
> and dropped/re-created the db manually with the the new SQL and that
> issue is now resolved.
>
> TROUBLE in check_mail: deal_with_spam FAILED: DBD::mysql::st execute
> failed: Column 'autolearn_status' cannot be null at ./maiad line 4410,
> <GEN8> line 3242.
>
> After many months of being down I finally have a working maia setup,
> thanks Jake and all others that assisted! One odd thing I'm seeing
> which I've never seen before is that for messages that are in the spam
> cache all messages for all domains/users are getting the subject
> re-written with ***SPAM*** and I can't figure out how to disable this.
> I see the purpose of it but I don't want to use it as it will cause
> confusion for my users.
>
> -Manny
>
> On Wed, May 13, 2020 at 3:00 PM <[email protected]> wrote:
> >
> > Send Maia-users mailing list submissions to
> >         [email protected]
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> >         http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
> > or, via email, send a message with subject or body 'help' to
> >         [email protected]
> >
> > You can reach the person managing the list at
> >         [email protected]
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Maia-users digest..."
> >
> >
> > Today's Topics:
> >
> >    1. Re: autolearn_status error Ubuntu 18.04 LTS (jjs - mainphrame)
> >    2. Re: autolearn_status error Ubuntu 18.04 LTS ([email protected])
> >    3. Re: autolearn_status error Ubuntu 18.04 LTS (jjs - mainphrame)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Tue, 12 May 2020 15:44:35 -0700
> > From: jjs - mainphrame <[email protected]>
> > To: [email protected]
> > Cc: Maia-Users Mailing List <[email protected]>
> > Subject: Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
> > Message-ID:
> >         <CABkzw7w-m=0KiRvT=u2sMgEJWDOc+8d+-BvxbjWpp=
> [email protected]>
> > Content-Type: text/plain; charset="utf-8"
> >
> > Now the database issue is sorted, you'll find that maiad isn't able to
> talk
> > to clamav as configured.
> >
> > That's been fixed in the current install scripts, but  in the meantime
> you
> > can either edit maiad.conf around lines 393-394 to use the unix socket,
> or
> > run dpkg-reconfigure clamav-daemon to use tcp.
> >
> > We'd changed the default install to have maiad talk to clamd via tcp
> after
> > jumping through way too many hoops fixing the path, ownership and
> > permissions of the unix socket every time there was a software update.
> But
> > YMMV, as they say.
> >
> > 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
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> http://www.renaissoft.com/pipermail/maia-users/attachments/20200512/5d00f99a/attachment-0001.html
> >
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Wed, 13 May 2020 06:47:12 -0400
> > From: <[email protected]>
> > To: "'jjs - mainphrame'" <[email protected]>
> > Cc: 'Maia-Users Mailing List' <[email protected]>
> > Subject: Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
> > Message-ID: <[email protected]>
> > Content-Type: text/plain; charset="utf-8"
> >
> > No biggie It’s a work in progress, its easy at least for me to wipe the
> vm and try a clean install so I will give it a go.
> >
> >
> >
> > From: jjs - mainphrame <[email protected]>
> > Sent: Tuesday, May 12, 2020 6:45 PM
> > To: [email protected]
> > Cc: Maia-Users Mailing List <[email protected]>
> > Subject: Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
> >
> >
> >
> > Now the database issue is sorted, you'll find that maiad isn't able to
> talk to clamav as configured.
> >
> > That's been fixed in the current install scripts, but  in the meantime
> you can either edit maiad.conf around lines 393-394 to use the unix socket,
> or run dpkg-reconfigure clamav-daemon to use tcp.
> >
> > We'd changed the default install to have maiad talk to clamd via tcp
> after jumping through way too many hoops fixing the path, ownership and
> permissions of the unix socket every time there was a software update. But
> YMMV, as they say.
> >
> > Jake
> >
> >
> >
> >
> >
> > On Tue, May 12, 2020 at 8:36 AM <[email protected] <mailto:
> [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]
> <mailto:[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] <mailto:[email protected]>
> > http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
> >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> http://www.renaissoft.com/pipermail/maia-users/attachments/20200513/44608c16/attachment-0001.html
> >
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Wed, 13 May 2020 08:09:14 -0700
> > From: jjs - mainphrame <[email protected]>
> > To: [email protected]
> > Cc: Maia-Users Mailing List <[email protected]>
> > Subject: Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
> > Message-ID:
> >         <
> CABkzw7zxbrrfu1udYRTGQ-qYbYTm-HkC8tuikn4L+ZSRUJLUUA-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>
> > Content-Type: text/plain; charset="utf-8"
> >
> > David,
> >
> > Your feedback is helpful, thank you.
> >
> > Jake
> >
> > On Wed, May 13, 2020 at 3:47 AM <[email protected]> wrote:
> >
> > > No biggie It’s a work in progress, its easy at least for me to wipe
> the vm
> > > and try a clean install so I will give it a go.
> > >
> > >
> > >
> > > *From:* jjs - mainphrame <[email protected]>
> > > *Sent:* Tuesday, May 12, 2020 6:45 PM
> > > *To:* [email protected]
> > > *Cc:* Maia-Users Mailing List <[email protected]>
> > > *Subject:* Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
> > >
> > >
> > >
> > > Now the database issue is sorted, you'll find that maiad isn't able to
> > > talk to clamav as configured.
> > >
> > > That's been fixed in the current install scripts, but  in the meantime
> you
> > > can either edit maiad.conf around lines 393-394 to use the unix
> socket, or
> > > run dpkg-reconfigure clamav-daemon to use tcp.
> > >
> > > We'd changed the default install to have maiad talk to clamd via tcp
> after
> > > jumping through way too many hoops fixing the path, ownership and
> > > permissions of the unix socket every time there was a software update.
> But
> > > YMMV, as they say.
> > >
> > > 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
> > >
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> http://www.renaissoft.com/pipermail/maia-users/attachments/20200513/7f71b087/attachment-0001.html
> >
> >
> > ------------------------------
> >
> > Subject: Digest Footer
> >
> > _______________________________________________
> > Maia-users mailing list
> > [email protected]
> > http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
> >
> >
> > ------------------------------
> >
> > End of Maia-users Digest, Vol 172, Issue 18
> > *******************************************
> _______________________________________________
> 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