Hi,
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.
Unfortunately the attempted upgrade was too long ago to still have the
backups before the upgrade was done and now Im really not sure how to
progress.
Regards,
Andy.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
