Re: MySQL error under Xenial

Hi, all.

I found a solution to my issues with MySQL in my installation:

Don't use MySQL at all.

Instead, use MariaDB if you need MySQL compatibility.  I don't use PgSQL 
in my inventory just yet, so I can't say how well it works.

Hope this helps.

--Ian.

On 11/02/2016 00:34, Ian R. Justman wrote:
>
> Hi, all.
>
> I am in the process of building up a server which is running Xenial
> Xerus, coming from Trusty Tahr.  However, I'm running into a bit of a snag.
>
> I'm trying to test the server and I'm running into trouble.  Everything
> else works up until it goes to insert the message received into the
> database, whereupon it errors out with the following:
>
> DBD::mysql::st execute failed: Column 'autolearn_status' cannot be null
> at /usr/sbin/amavisd-new line 4410, <GEN64> line 53.
>
> I tried the exact same thing on my current production server and it
> worked just fine.
>
> Any ideas?  I'd like to be able to get what the values of the row that's
> about to be inserted.
>
> For some additional reference, the versions of Perl are as follows:
>
> Trusty:  5.18.2-2ubuntu1.1
> Xenial:  5.22.1-9
>
> Versions of MySQL (which may also be an issue) are:
>
> Trusty:  5.5.52-0ubuntu0.14.04.1
> Xenial:  5.7.16-0ubuntu0.16.04.1
>
> Thanks for any ideas out there!
>
> --Ian.
>

-- 
Ian R. Justman
UNIX hacker.  Anime fan.  Any questions?
ianj (at) ian-justman.com
Please direct business correspondence to my new address, biz (at) 
ian-justman.com. (04/27/2015)
_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users