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

Curiouser and curiouser, maia is told not to alter the subject, and yet if
a spam message passes through your system now, the subject is altered?
There's a conundrum there, and I'm not sure what could cause a disconnect
like that.

Jake

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

> Yes N for all.
>
> On Sat, May 16, 2020 at 1:53 PM jjs - mainphrame <[email protected]>
> wrote:
> >
> > How about the column to the left of the one that shows "1 for all"? Is
> it 'N' for all?
> >
> > Jake
> >
> > On Sat, May 16, 2020 at 10:48 AM Manny Marinho <[email protected]>
> wrote:
> >>
> >> Looks like I get 60 rows back, first column show 1 for all, second
> >> column 5 for all and third column 5 for all.
> >>
> >> On Sat, May 16, 2020 at 1:36 PM jjs - mainphrame <[email protected]>
> wrote:
> >> >
> >> > 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