On 4 Feb 2010, at 16:44, Andy Ashley wrote:
Hmm,
Just realised this is quite similar to an issue I asked for help on
a while back:
http://lists.opsview.org/lurker/message/20090729.110957.a78e8577.en.html
Not sure if it's related?
Sorry. The error is similar.
In the query:
[2010/02/04 15:51:38] [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
"]
There's a hardcoded reference to opsview. Apply this patch: https://secure.opsera.com/wsvn/wsvn/opsview?op=comp&compare
[]=%2ftr...@3896&compare[]=%2ftr...@3897
We'll find a way to test this so this doesn't slip through again.
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
