Problem with a new Maia install
Andre Goree <[email protected]>
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
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=<[email protected]>, 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 -=-=-=-=-=- Email - andre at drenet.net Website - http://www.drenet.net PGP key - http://www.drenet.net/pubkey.txt -=-=-=-=-=- _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users