On Wednesday 14 December 2016 at 23:06:55, François Meehan wrote: > Hi, > > I am trying to do an install of Icinga2 on a fresh install of Ubuntu server > 16.10.
Are you installing the Ubuntu package, or building Icinga from source? > When trying to populate the Database I get the following error: > > root@icinga2:~# mysql -u root -p icinga < > /usr/share/icinga2-ido-mysql/schema/mysql.sql > > Enter password: > > ERROR 1101 (42000) at line 24: BLOB, TEXT, GEOMETRY or JSON column > 'comment_data' can't have a default value Well, it's correct that MySQL doesn't allow a default value for a TEXT field: http://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html "BLOB, TEXT, GEOMETRY, and JSON columns cannot be assigned a default value." But see also https://bugs.mysql.com/bug.php?id=21532 and http://bugs.mysql.com/bug.php?id=19498 > Any ideas? If that really is in the current Icinga installation files, I suggest raising a bug report at https://dev.icinga.com/projects/icingaweb2/issues (click on "Register" top right to create an account, and then create a new "issue" of type "bug"). Regards, Antony. -- What do you call a dinosaur with only one eye? A Doyouthinkesaurus. Please reply to the list; please *don't* CC me. _______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
