Re: autolearn_status error Ubuntu 18.04 LTS

Thanks for this info, these data points are useful. I will build a new
ubuntu 18.04 instance with a local DB and see if I can get a handle on this,

Interestingly, the maia DB server here is mariadb running on ubuntu 18,04.

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16670
Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64)
using readline 5.2

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