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.

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

add permission alter to idomysql docs #214

Closed
lbetz opened this issue Jan 23, 2017 · 0 comments
Closed

add permission alter to idomysql docs #214

lbetz opened this issue Jan 23, 2017 · 0 comments
Labels
Milestone

Comments

@lbetz
Copy link
Contributor

lbetz commented Jan 23, 2017

got this one:
Notice: /Stage[main]/Icinga2::Feature::Idomysql/Exec[idomysql_import_schema]/returns: ERROR 1142 (42000) at line 1436: ALTER command denied to user 'icinga2'@'localhost' for table 'icinga_servicestatus'
Error: mysql -h '127.0.0.1' -u 'icinga2' -p'icinga2' 'icinga2' < '/usr/share/icinga2-ido-mysql/schema/mysql.sql' returned 1 instead of one of [0]
Error: /Stage[main]/Icinga2::Feature::Idomysql/Exec[idomysql_import_schema]/returns: change from notrun to 0 failed: mysql -h '127.0.0.1' -u 'icinga2' -p'icinga2' 'icinga2' < '/usr/share/icinga2-ido-mysql/schema/mysql.sql' returned 1 instead of one of [0]

means alter is missing into grant
grant => ['SELECT', 'INSERT', 'UPDATE', 'DELETE', 'DROP', 'CREATE VIEW', 'CREATE', 'INDEX', 'EXECUTE'],

@bobapple bobapple added the bug label Jan 23, 2017
@bobapple bobapple added this to the v1.0.2 milestone Jan 23, 2017
n00by pushed a commit to n00by/puppet-icinga2 that referenced this issue Apr 26, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants