Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[dev.icinga.com #13633] IDO MySQL schema not working on MySQL 5.7 #4877

Closed
icinga-migration opened this issue Dec 16, 2016 · 3 comments
Closed

[dev.icinga.com #13633] IDO MySQL schema not working on MySQL 5.7 #4877

icinga-migration opened this issue Dec 16, 2016 · 3 comments
Labels
area/db-ido Database output bug Something isn't working
Milestone
2.6.1

Comments

@icinga-migration
Copy link

This issue has been migrated from Redmine: https://dev.icinga.com/issues/13633

Created by mfrosch on 2016-12-16 09:28:48 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2017-01-11 16:39:24 +00:00)
Target Version: 2.6.1
Last Update: 2017-01-11 16:39:24 +00:00 (in Redmine)

Icinga Version: 2.6.0
Backport?: Not yet backported
Include in Changelog: 1

  Setting up mysql-server-5.7 (5.7.16-1) ...

...

  Preparing to unpack .../icinga2-ido-mysql_2.6.0-1_amd64.deb ...
  Unpacking icinga2-ido-mysql (2.6.0-1) ...
  Processing triggers for libc-bin (2.24-8) ...
  Setting up icinga2-ido-mysql (2.6.0-1) ...
  Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
  dbconfig-common: writing config to /etc/dbconfig-common/icinga2-ido-mysql.conf

  Creating config file /etc/dbconfig-common/icinga2-ido-mysql.conf with new version

  Creating config file /etc/icinga2/features-available/ido-mysql.conf with new version
  checking privileges on database icinga2 for icinga2@localhost: user creation needed.
  granting access to database icinga2 for icinga2@localhost: success.
  verifying access for icinga2@localhost: success.
  creating database icinga2: success.
  verifying database icinga2 exists: success.
  populating database via sql...  error encountered populating database:
  mysql said: ERROR 1101 (42000) at line 24: BLOB, TEXT, GEOMETRY or JSON column "comment_data" can"t have a default value
  dbconfig-common: icinga2-ido-mysql configure: noninteractive fail.
  dbconfig-common: icinga2-ido-mysql configure: ignoring errors from here forwards
  done.
  dbconfig-common: flushing administrative password
  Processing triggers for libc-bin (2.24-8) ...

Changesets

2016-12-16 10:34:02 +00:00 by mfrosch 5d1fd79

WIP: Update IDO MySQL schema for MySQL >= 5.7

refs #13633

2016-12-16 13:01:05 +00:00 by mfrosch a2ecc5c

WIP: Update IDO MySQL schema for MySQL >= 5.7

Including a Debian update file, we should probably include it in a 2.6.1
update.

refs #13633

2016-12-16 14:17:55 +00:00 by mfrosch a6b62a5

WIP: Update IDO MySQL schema for MySQL >= 5.7

Including a Debian update file, we should probably include it in a 2.6.1
update.

refs #13633

2016-12-16 14:51:12 +00:00 by mfrosch ac24ed8

Fix IDO MySQL schema for MySQL >= 5.7

Including an example upgrade removing the defaults.

NOTE: A schema update doesn"t seem to be needed, MySQL is updating
internally.

The problem comes up on fresh schema imports on MySQL 5.7.

refs #13633

2017-01-11 16:37:17 +00:00 by mfrosch 399827c

Fix IDO MySQL schema for MySQL >= 5.7

NOTE: A schema update doesn"t seem to be needed, MySQL is updating
internally.

The problem comes up on fresh schema imports on MySQL 5.7.

fixes #13633
@icinga-migration
Copy link
Author

Updated by mfriedrich on 2017-01-11 13:15:29 +00:00

  • Category changed from Documentation to DB IDO
  • Assigned to deleted mfrosch
  • Target Version set to 2.6.1

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2017-01-11 16:38:05 +00:00

  • Status changed from New to Assigned
  • Assigned to set to mfriedrich

@icinga-migration
Copy link
Author

Updated by mfrosch on 2017-01-11 16:39:25 +00:00

  • Status changed from Assigned to Resolved
  • Done % changed from 0 to 100

Applied in changeset 399827c.

@icinga-migration icinga-migration added bug Something isn't working area/db-ido Database output labels Jan 17, 2017
@icinga-migration icinga-migration added this to the 2.6.1 milestone Jan 17, 2017
@lazyfrosch lazyfrosch mentioned this issue Jan 24, 2017
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/db-ido Database output bug Something isn't working
Projects
None yet
Milestone
2.6.1
Development

No branches or pull requests
1 participant
@icinga-migration