{"action":"created","issue":{"url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/36","repository_url":"https://api.github.com/repos/Icinga/puppet-icingaweb2","labels_url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/36/comments","events_url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/36/events","html_url":"https://github.com/Icinga/puppet-icingaweb2/pull/36","id":149027801,"number":36,"title":"Support DB initialization on Ubuntu and Debian","user":{"login":"ngoduykhanh","id":6447444,"avatar_url":"https://avatars.githubusercontent.com/u/6447444?v=3","gravatar_id":"","url":"https://api.github.com/users/ngoduykhanh","html_url":"https://github.com/ngoduykhanh","followers_url":"https://api.github.com/users/ngoduykhanh/followers","following_url":"https://api.github.com/users/ngoduykhanh/following{/other_user}","gists_url":"https://api.github.com/users/ngoduykhanh/gists{/gist_id}","starred_url":"https://api.github.com/users/ngoduykhanh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ngoduykhanh/subscriptions","organizations_url":"https://api.github.com/users/ngoduykhanh/orgs","repos_url":"https://api.github.com/users/ngoduykhanh/repos","events_url":"https://api.github.com/users/ngoduykhanh/events{/privacy}","received_events_url":"https://api.github.com/users/ngoduykhanh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-18T03:08:50Z","updated_at":"2016-04-18T06:42:13Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/pulls/36","html_url":"https://github.com/Icinga/puppet-icingaweb2/pull/36","diff_url":"https://github.com/Icinga/puppet-icingaweb2/pull/36.diff","patch_url":"https://github.com/Icinga/puppet-icingaweb2/pull/36.patch"},"body":"There 3 adjustments:\r\n- Add Debian/Ubuntu in if statement\r\n- Add `path` in order to avoid `not qualified and no path was specified` issue in puppet.\r\n- specify host, user, password instead of `.my.cnf`. There are cases that icingaweb2 and database are located on difference servers. As far as I know, your `.my.cnf` is created from mysql module `::mysql::client`"},"comment":{"url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/comments/211227907","html_url":"https://github.com/Icinga/puppet-icingaweb2/pull/36#issuecomment-211227907","issue_url":"https://api.github.com/repos/Icinga/puppet-icingaweb2/issues/36","id":211227907,"user":{"login":"ngoduykhanh","id":6447444,"avatar_url":"https://avatars.githubusercontent.com/u/6447444?v=3","gravatar_id":"","url":"https://api.github.com/users/ngoduykhanh","html_url":"https://github.com/ngoduykhanh","followers_url":"https://api.github.com/users/ngoduykhanh/followers","following_url":"https://api.github.com/users/ngoduykhanh/following{/other_user}","gists_url":"https://api.github.com/users/ngoduykhanh/gists{/gist_id}","starred_url":"https://api.github.com/users/ngoduykhanh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ngoduykhanh/subscriptions","organizations_url":"https://api.github.com/users/ngoduykhanh/orgs","repos_url":"https://api.github.com/users/ngoduykhanh/repos","events_url":"https://api.github.com/users/ngoduykhanh/events{/privacy}","received_events_url":"https://api.github.com/users/ngoduykhanh/received_events","type":"User","site_admin":false},"created_at":"2016-04-18T06:42:13Z","updated_at":"2016-04-18T06:42:13Z","body":"Hi @arioch , is it breaking the CentOS spect test or CentOS support ?\r\n\r\nI've just checked the [spec test](https://github.com/Icinga/puppet-icingaweb2/blob/master/spec/classes/icingaweb2_spec.rb#L290), it is checking the mysql command which use `.my.cnf`\r\n\r\n```\r\nmysql --defaults-file='/root/.my.cnf' icingaweb2 < /usr/share/icingaweb2/etc/schema/mysql.schema.sql\r\n```\r\n\r\nIs it ok to modify the test?"}}