Hi All ,
I just finished Icinga-web(1.7.2) installation set all setting in
database.xml according doc , icinga +IdoUtils work OK i have local machine
and everything is green
The issue is when i get into Icinga-Web i get error for evry section i
choosing and top dashboard is missing, looking into /var/log/icinga-web
logs i get following error below:
i don't have such db icinga@localhost user and i don't know where i missed
configuration
Please advice.
Thanks
Debug log
[Tue Aug 21 09:39:15 2012] [error] Fetch failed with message PDO
Connection Error: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost'
(using password: YES)
Query: SELECT DISTINCT i2.current_state AS i2__current_state,
i2.current_state AS i2__0, COUNT(DISTINCT i.host_object_id) AS i__1,
i2.current_state AS i2__2, (i2.has_been_checked-1)*-1 AS i__3,
(i2.has_been_checked-1)*-1 AS i__4, COUNT(i2.current_state) AS i2__5,
COUNT(i2.current_state) AS i2__6 FROM icinga_hosts i INNER JOIN
icinga_hoststatus i2 ON i.host_object_id = i2.host_object_id INNER JOIN
icinga_objects i3 ON i.host_object_id = i3.object_id AND (i3.is_active = 1)
WHERE (i.config_type = ?) GROUP BY i2.current_state, i2.has_been_checked
TargetStore info (IcingaApiModel):
- Store target: IcingaHosts
- Searchtype:
ICINGA-WEB LOG
[Tue Aug 21 09:39:15 2012] [error] Fetch failed with message PDO
Connection Error: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost'
(using password: YES)
Query: SELECT DISTINCT i2.current_state AS i2__current_state,
i2.current_state AS i2__0, COUNT(DISTINCT i.host_object_id) AS i__1,
i2.current_state AS i2__2, (i2.has_been_checked-1)*-1 AS i__3,
(i2.has_been_checked-1)*-1 AS i__4, COUNT(i2.current_state) AS i2__5,
COUNT(i2.current_state) AS i2__6 FROM icinga_hosts i INNER JOIN
icinga_hoststatus i2 ON i.host_object_id = i2.host_object_id INNER JOIN
icinga_objects i3 ON i.host_object_id = i3.object_id AND (i3.is_active = 1)
WHERE (i.config_type = ?) GROUP BY i2.current_state, i2.has_been_checked
TargetStore info (IcingaApiModel):
- Store target: IcingaHosts
- Searchtype:
--
Tal Bar-or
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
