[Maia-users] Problem with a new Maia install

[Andre Goree]

Maia is throwing this error in the logs on a brand-new install (FreeBSD
11.0) whenever I try to receive and email (sent from an external
domain):

maiad[69818]: (69818-10) TROUBLE in check_mail: Take Action! FAILED:
DBD::mysql::st execute failed: Column 'autolearn_status' cannot be null
at /usr/local/sbin/maiad line 4410, <GEN46> line 137.
Jan 25 15:38:29 anet2 maiad[69818]: (69818-10) PRESERVING EVIDENCE in
/var/maiad/tmp/maia-20170125T153829-69818
Jan 25 15:38:29 anet2 postfix/smtp[20578]: 227C6EBFEB:
to=<***@SCRUBBED.SCRUB>, relay=127.0.0.1[127.0.0.1]:10024,
delay=1.5, delays=1.3/0/0.01/0.16, dsn=4.5.0, status=deferred (host
127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=69818-10,
Take Action! FAILED: DBD::mysql::st execute failed: Column
'autolearn_status' cannot be null at /usr/local/sbin/maiad line 4410,
<GEN46> line 137.



I do see that this happened before, but was related to a different
version of Maia and was fixed (from what I can tell). See:
http://lists.purplehat.org/pipermail/pho-postfix/2015-April/001122.html
http://www.ipsure.com/blog/2012/trouble-in-check_mail-spam_scan-failed-dbdmysqlst-execute-failed-column-theme_id-cannot-be-null-at-usrlocalsbinmaiad-line-3408-error-message-thrown-by-maia-mailguard/


Has anyone else run into this issue?


Here are relevant parts of my maia_mail table
(Hopefully this formatting isn't horrid on everyone's email client)

mysql> show columns from maia_mail;
+------------------+------------------+------+-----+-------------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+------------------+------------------+------+-----+-------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL |
auto_increment |
| received_date | datetime | NO | MUL | NULL |
|
| size | int(10) unsigned | NO | | NULL |
|
| sender_email | varbinary(255) | NO | MUL | NULL |
|
| envelope_to | blob | NO | | NULL |
|
| subject | varchar(255) | NO | MUL | NULL |
|
| contents | longblob | NO | | NULL |
|
| score | float | YES | MUL | NULL |
|
| autolearn_status | varchar(15) | NO | | unavailable |
|
+------------------+------------------+------+-----+-------------+----------------+

[Andre Goree]

Post by Andre Goree
Maia is throwing this error in the logs on a brand-new install
(FreeBSD 11.0) whenever I try to receive and email (sent from an
DBD::mysql::st execute failed: Column 'autolearn_status' cannot be
null at /usr/local/sbin/maiad line 4410, <GEN46> line 137.
Jan 25 15:38:29 anet2 maiad[69818]: (69818-10) PRESERVING EVIDENCE in
/var/maiad/tmp/maia-20170125T153829-69818
delay=1.5, delays=1.3/0/0.01/0.16, dsn=4.5.0, status=deferred (host
127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=69818-10,
Take Action! FAILED: DBD::mysql::st execute failed: Column
'autolearn_status' cannot be null at /usr/local/sbin/maiad line 4410,
<GEN46> line 137.
I do see that this happened before, but was related to a different
http://lists.purplehat.org/pipermail/pho-postfix/2015-April/001122.html
http://www.ipsure.com/blog/2012/trouble-in-check_mail-spam_scan-failed-dbdmysqlst-execute-failed-column-theme_id-cannot-be-null-at-usrlocalsbinmaiad-line-3408-error-message-thrown-by-maia-mailguard/
Has anyone else run into this issue?
Here are relevant parts of my maia_mail table
(Hopefully this formatting isn't horrid on everyone's email client)
mysql> show columns from maia_mail;
+------------------+------------------+------+-----+-------------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+------------------+------------------+------+-----+-------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL |
auto_increment |
| received_date | datetime | NO | MUL | NULL |
|
| size | int(10) unsigned | NO | | NULL |
|
| sender_email | varbinary(255) | NO | MUL | NULL |
|
| envelope_to | blob | NO | | NULL |
|
| subject | varchar(255) | NO | MUL | NULL |
|
| contents | longblob | NO | | NULL |
|
| score | float | YES | MUL | NULL |
|
| autolearn_status | varchar(15) | NO | | unavailable |
|
+------------------+------------------+------+-----+-------------+----------------+

Wanted to bump this, in hopes that I just have something misconfigured
and that I don't need to go through the tedious task of trying to
reinstall from scratch (which may or may not fix this...)

I must add that this is for a secondary domain pointed to the same mail
server. I'm _pretty_ sure I've added that domain to Maia properly...but
perhaps not?

Thanks in advance for any insight.