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

That shouldn't be happening, since the DB dictates that behavior. You do
seem to come up with some interesting corner cases.

I see you're allowing all spam for every protection level except for high,
but if everyone's on high I guess that's academic.

Just as a sanity check, you might run a query:

MariaDB [maia]> select
id,spam_modifies_subj,spam_tag_level,spam_tag2_level,spam_kill_level from
policy;

On this db, they all pretty much look like this, except for the superuser
account:

| 28 | N                  |           -999 |               5 |
  5 |

jake

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

> Thank you! So I've made those changes and re-started the maia daemon
> but I'm still seeing the subject being modified here's what I have now
> for those lines:
>
>  $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','5','999','999'),
>
>                          'high'    => array
> ('N','N','N','N','N','N','N','N','N','N','N','N','N','1','5','5')
>
>
> Nothing is set in the DB right now either:
>
> MariaDB [maia]> select id,spam_modifies_subj from policy where
> spam_modifies_subj = 'Y';
>
> Empty set (0.000 sec)
>
> All my users/domains are currently set to high protection level.
>
>
> -Manny
>
> On Sat, May 16, 2020 at 12:09 PM jjs - mainphrame <[email protected]>
> wrote:
> >
> > 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