{"action":"created","issue":{"url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/5","repository_url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube","labels_url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/5/comments","events_url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/5/events","html_url":"https://github.com/Icinga/icingaweb2-module-cube/issues/5","id":193499528,"number":5,"title":"no postgresql support","user":{"login":"yoshi314","id":41782,"avatar_url":"https://avatars.githubusercontent.com/u/41782?v=3","gravatar_id":"","url":"https://api.github.com/users/yoshi314","html_url":"https://github.com/yoshi314","followers_url":"https://api.github.com/users/yoshi314/followers","following_url":"https://api.github.com/users/yoshi314/following{/other_user}","gists_url":"https://api.github.com/users/yoshi314/gists{/gist_id}","starred_url":"https://api.github.com/users/yoshi314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoshi314/subscriptions","organizations_url":"https://api.github.com/users/yoshi314/orgs","repos_url":"https://api.github.com/users/yoshi314/repos","events_url":"https://api.github.com/users/yoshi314/events{/privacy}","received_events_url":"https://api.github.com/users/yoshi314/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-12-05T13:43:57Z","updated_at":"2016-12-06T12:09:54Z","closed_at":null,"body":"```\r\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"WITH\"\r\nLINE 4: ...t_id GROUP BY c_os.varvalue) AS sub GROUP BY (os) WITH ROLLU...\r\n^, query was: SELECT rollup.os, rollup.hosts_cnt, rollup.hosts_nok, rollup.hosts_unhandled_nok FROM (SELECT sub.os, SUM(hosts_cnt) AS hosts_cnt, SUM(hosts_nok) AS hosts_nok, SUM(hosts_unhandled_nok) AS hosts_unhandled_nok FROM (SELECT c_os.varvalue AS os, COUNT(*) AS hosts_cnt, SUM(CASE WHEN hs.current_state = 0 THEN 0 ELSE 1 END) AS hosts_nok, SUM(CASE WHEN hs.current_state != 0 AND hs.problem_has_been_acknowledged = 0 AND hs.scheduled_downtime_depth = 0 THEN 1 ELSE 0 END) AS hosts_unhandled_nok FROM icinga_objects AS o\r\nINNER JOIN icinga_hosts AS h ON o.object_id = h.host_object_id AND o.is_active = 1\r\nLEFT JOIN icinga_hoststatus AS hs ON hs.host_object_id = h.host_object_id\r\nLEFT JOIN icinga_customvariablestatus AS c_os ON c_os.varname = 'os' AND c_os.object_id = o.object_id GROUP BY c_os.varvalue) AS sub GROUP BY (os) WITH ROLLUP) AS rollup ORDER BY (rollup.os IS NOT NULL) ASC, rollup.os ASC, (rollup.hosts_cnt IS NOT NULL) ASC, rollup.hosts_cnt ASC, (rollup.hosts_nok IS NOT NULL) ASC, rollup.hosts_nok ASC, (rollup.hosts_unhandled_nok IS NOT NULL) ASC, rollup.hosts_unhandled_nok ASC\r\n```\r\n\r\nI might give it a try, once i figure out all the queries the module does."},"comment":{"url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/comments/265134876","html_url":"https://github.com/Icinga/icingaweb2-module-cube/issues/5#issuecomment-265134876","issue_url":"https://api.github.com/repos/Icinga/icingaweb2-module-cube/issues/5","id":265134876,"user":{"login":"yoshi314","id":41782,"avatar_url":"https://avatars.githubusercontent.com/u/41782?v=3","gravatar_id":"","url":"https://api.github.com/users/yoshi314","html_url":"https://github.com/yoshi314","followers_url":"https://api.github.com/users/yoshi314/followers","following_url":"https://api.github.com/users/yoshi314/following{/other_user}","gists_url":"https://api.github.com/users/yoshi314/gists{/gist_id}","starred_url":"https://api.github.com/users/yoshi314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoshi314/subscriptions","organizations_url":"https://api.github.com/users/yoshi314/orgs","repos_url":"https://api.github.com/users/yoshi314/repos","events_url":"https://api.github.com/users/yoshi314/events{/privacy}","received_events_url":"https://api.github.com/users/yoshi314/received_events","type":"User","site_admin":false},"created_at":"2016-12-06T12:09:54Z","updated_at":"2016-12-06T12:09:54Z","body":"https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5#GROUPING_SETS.2C_CUBE_and_ROLLUP  \r\n\r\ndocumentation for the feature."}}
{"actor":{"display_login":"yoshi314"}}