I have just performed an upgrade from Version: 3.1.0 to Version:
3.5.1.
The upgrade went smoothly but when logging in to the new web
interface and attempting to view "Host group heirarchy", "Host
detail" and "Service detail" I get:
Host group id 1 not found
Nothing else is displayed and I cant interact with any hosts or
services.
The rest of the menus and links seem to work as expected.
When looking at the logs: (excuse the very long output)
# [2010/01/31 11:41:02] [opsviewd] [INFO] Running 'web_reload' with
args:
[2010/01/31 11:41:03] [create_and_send_configs] [INFO] Starting
overall
[2010/01/31 11:41:06] [create_and_send_configs] [INFO] Ending
overall with error=0
[2010/01/31 11:41:11] [ndoutils_configdumpend] [INFO] Start
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'contacts' [for Statement "
INSERT INTO opsview_contact_services_temporary
SELECT c.id, s.service_object_id
FROM
opsviewcore.contacts c,
nagios_objects o,
nagios_contactgroup_members cgm,
nagios_contactgroups cg,
nagios_service_contactgroups scg,
nagios_services s
WHERE
o.objecttype_id=10
AND binary c.username = o.name1
AND o.object_id = cgm.contact_object_id
AND cgm.contactgroup_id = cg.contactgroup_id
AND cg.contactgroup_object_id = scg.contactgroup_object_id
AND scg.service_id = s.service_id
AND s.config_type = 1
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'hostgroups' [for Statement
"INSERT INTO opsview_hostgroups_tmp SELECT id, parentid, name, lft,
rgt, matpath FROM opsviewcore.hostgroups"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'hosts' [for Statement "
INSERT INTO opsview_hostgroup_hosts_tmp
SELECT parent.id, o.host_object_id
FROM opsviewcore.hosts oh, opsview_hostgroups node,
opsview_hostgroups parent, temp_hosts o
WHERE
oh.hostgroup = node.id
AND node.lft BETWEEN parent.lft AND parent.rgt
AND o.hostname = oh.name
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'monitoringservers' [for
Statement "
INSERT INTO opsview_monitoringclusters_tmp
SELECT monitoringservers.id, monitoringservers.name, oh.name, oh.ip
FROM
opsviewcore.monitoringservers monitoringservers
LEFT JOIN
opsviewcore.hosts oh
ON
monitoringservers.host = oh.id
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'monitoringclusternodes' [for
Statement "
INSERT INTO opsview_monitoringclusternodes_tmp
SELECT monitoringclusternodes.id, oh.name, oh.ip
FROM
opsviewcore.monitoringclusternodes monitoringclusternodes,
opsviewcore.hosts oh
WHERE
monitoringclusternodes.host = oh.id
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'hosts' [for Statement "
INSERT INTO opsview_hosts_tmp
SELECT temp_hosts.host_object_id, oh.id, temp_hosts.hostname, oh.ip,
icons.filename, oh.hostgroup, oh.monitored_by, h2mcn.primary_node,
h2mcn.secondary_node
FROM opsviewcore.hosts oh
LEFT JOIN opsviewcore.temporary_hostmonitoredbynode h2mcn
ON oh.id = h2mcn.hostid
JOIN temp_hosts, opsviewcore.icons icons
WHERE temp_hosts.hostname = oh.name
AND oh.icon = icons.name
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'servicechecks' [for
Statement "
INSERT INTO opsview_host_services_tmp
SELECT s.host_object_id, o.name1, o.object_id, o.name2,
(s.notes_url != ''), sc.markdown_filter, hosts.icon_filename
FROM nagios_objects o
LEFT JOIN opsview.servicechecks sc
ON sc.name = o.name2
JOIN nagios_services s
ON o.object_id = s.service_object_id
JOIN opsview_hosts hosts
ON s.host_object_id = hosts.id
WHERE
o.objecttype_id=2 AND s.config_type = 1
"]
[2010/01/31 11:41:11] [ndoutils_configdumpend] [FATAL]
DBD::mysql::db do failed: SELECT command denied to user
'opsviewruntime'@'localhost' for table 'keywords' [for Statement "
INSERT INTO opsview_viewports_tmp
SELECT
kh.keywordid,
k.name,
ohs.hostname,
ohs.servicename,
ohs.host_object_id,
ohs.service_object_id
FROM
opsviewcore.keywords as k,
opsviewcore.keywordhosts as kh,
opsviewcore.hosts as h,
opsviewcore.keywordservicechecks as ksc,
opsviewcore.servicechecks as sc,
opsviewruntime.opsview_host_services ohs
WHERE
ksc.keywordid = kh.keywordid
AND kh.hostid = h.id
AND ksc.servicecheckid = sc.id
AND ohs.hostname = h.name
AND ohs.servicename = sc.name
AND kh.keywordid = k.id
"]
[2010/01/31 11:41:12] [ndoutils_configdumpend] [INFO] End
Research says that it could be to do with permissions on the 'proc'
table.
However, I think this is due to a previous failed upgrade which
maybe altered the schema or something.
