[dev.icinga.com #8707] Wizard: setup seems to fail with just one DB user

[icinga-migration]

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

Created by tgelf on 2015-03-12 09:51:05 +00:00

Assignee: jmeyer
Status: Resolved (closed on 2015-04-13 12:19:02 +00:00)
Target Version: 2.0.0-rc1
Last Update: 2015-04-13 12:19:02 +00:00 (in Redmine)

---

(please note that I didn't test this by myself)

I got the report that when you create a database for Icinga Web, GRANT ALL permissions on that specific database to that user, you have no chance to complete the wizard. Please ask mwaldmueller for farther details if required.

Thanks,
Thomas

Changesets

2015-04-13 12:10:24 +00:00 by jmeyer d038a27

Wizard: Differentiate between privileges required to create and setup a db

Fixes the bug that if a database and a login are already existing and only
the schema needs to be set up, which is possible using the resource's login,
the user is required to provide another login with the seemingly missing
privileges.

refs #8707

2015-04-13 12:13:02 +00:00 by jmeyer e0891ae

DbTool: Add mysql context identifiers for the REFERENCES privilege

Though this privilege is not in use until mysql version 5.7.6 it is registered
as privilege in the privilege tables in earlier versions.

refs #8707

2015-04-13 12:17:18 +00:00 by jmeyer a21d544

DbTool: Fix that all mysql privileges were checked regardless of their context

refs #8707

2015-04-13 12:18:27 +00:00 by jmeyer edaa51c

Merge branch 'bugfix/incorrect-db-privilege-checks-8707'

fixes #8707

[icinga-migration]

Updated by mwaldmueller on 2015-04-13 07:08:02 +00:00

Sorry for the delay. It was a MySQL database and I created a database (CREATE DATABASE icingaweb2;) and a user with full privileges before I ran the Icinga Web 2 setup wizard with: GRANT ALL PRIVILEGES ON icingaweb2.* TO icingaweb2@'localhost' IDENTIFIED BY 'PASSWORD';

So I expected that these rights are sufficient to create the tables with the setup wizard, but I was asked for the credentials for the 'root' user too and couldn't skip this.

[icinga-migration]

Updated by jmeyer on 2015-04-13 12:02:53 +00:00

• Category set to Installation
• Status changed from New to Assigned
• Assigned to set to jmeyer
• Target Version set to 2.0.0-rc1

[icinga-migration]

Updated by jmeyer on 2015-04-13 12:19:02 +00:00

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

Applied in changeset edaa51c.