Re: Problem with a new Maia install

On 01/27/2017 11:41 am, Andre Goree wrote:
> 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 |
>            |
> +------------------+------------------+------+-----+-------------+----------------+



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.


-- 
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