Re: MySQL error under Xenial
"Ian R. Justman" <ianj-/[email protected]>
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
On 11/03/2016 22:48, Janky Jay, III wrote: > Hi Ian, > > On 11/03/2016 09:54 PM, Ian R. Justman wrote: >> >> Hi, all. >> >> I found a solution to my issues with MySQL in my installation: >> >> Don't use MySQL at all. >> run >> 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. >> > > Was this a fresh install? The maia db creation file (even the update > file) should set these values to non-NULL (or perhaps "NULL" which is > considered non-null). Was this an update? If so, update from what > version and did you run any upgrade scripts to update the database? > > Regards, > Janky Jay, III No, this was from an existing setup which worked fine on an older version of MySQL under Trusty Tahr. And that setup was transplanted from another, older-yet system running Saucy Salamander(? will have to verify my old backups). Besides, I'm thinking of going MariaDB anyway, since we have no idea what Oracle is going to do with MySQL as I understand that its covenant to keep it in the GPL may be expiring soon. As for MySQL and new installations, I can test it by building up another server to see how that works. More as I get that. Semi-related, and as one other user said, there's also the issue of newer versions of PHP, e.g. 7.0 and 7.1, which I can confirm that it won't work. Thanks for the followup. --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