Re: autolearn_status error Ubuntu 18.04 LTS

Hope that fixes everything.

In the meantime, I'm trying to puzzle out why that restriction has been
ignored all along until now.

Jake

On Tue, May 12, 2020 at 2:10 PM <[email protected]> wrote:

> Sounds good, I can do a reinstall pretty quick
>
>
>
> Thanks!
>
>
>
> *From:* jjs - mainphrame <[email protected]>
> *Sent:* Tuesday, May 12, 2020 5:05 PM
> *To:* [email protected]
> *Cc:* Maia-Users Mailing List <[email protected]>
> *Subject:* Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
>
>
>
> Well, this is very interesting.
>
> We built 2 ubuntu-18.04 maia instances, identical except one uses mysql,
> and the other uses mariadb.
> The one running mariadb works perfectly, but the one running mysql shows
> this error, just as you reported:
>
> May 12 13:58:34 maiatest2 maiad[17588]: (17588-01) TROUBLE in check_mail:
> Take Action! FAILED: DBD::mysql::st execute failed: Column
> 'autolearn_status' cannot be null at /var/lib/maia/maiad line 4408, <GEN10>
> line 54.
> May 12 13:58:34 maiatest2 maiad[17588]: (17588-01) PRESERVING EVIDENCE in
> /var/lib/maia/tmp/maia-20200512T135833-17588
>
> So, I'm just going to do a quick workaround and sidestep the issue for
> now. I'm updating the ubuntu installers to install mariadb instead of mysql.
>
> Pushing the changes in a few moments.
>
> Jake
>
>
>
> On Tue, May 12, 2020 at 11:34 AM <[email protected]> wrote:
>
> Jake, I used the default install with the local db server.
>
>
>
> mysql  Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using  EditLine wrapper
>
>
>
>
>
> I did try to set the value in the DB to NO/YES but it doesn’t seem to take
>
>
>
> 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
> |                |
>
>
> +------------------+------------------+------+-----+-------------+----------------+
>
> 9 rows in set (0.01 sec)
>
>
>
>
>
> Thanks,
>
> Dave
>
>
>
> *From:* jjs - mainphrame <[email protected]>
> *Sent:* Tuesday, May 12, 2020 2:24 PM
> *To:* [email protected]
> *Cc:* Maia-Users Mailing List <[email protected]>
> *Subject:* Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
>
>
>
> Just out of curiosity, was this a default install of a local maia db, or
> did it use an existing db server?
>
> If so, what db version is it? I'm looking through the schema, and in the
> maia logs here, and I'm not seeing this rule enforced anywhere
>
> jake
>
>
>
>
>
>
>
> On Tue, May 12, 2020 at 9:02 AM jjs - mainphrame <[email protected]>
> wrote:
>
> Is this happening on every message? Sounds like an error in the DB schema.
>
> 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
>
>

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users