Ton Voon wrote:
I wonder if you have changed the password as part of problem diagnosis?
ndo2db uses the /usr/local/nagios/etc/ndo2db.cfg file for credential
information. This is generated on an Opsview reload. However, you need
to restart the ndo2db daemon to take effect.
Check if the password is correct in there and if so, restart opsview:
/etc/init.d/opsview restart
If not, reload and check password again then restart.
Hi,
Checked ndo2db.cfg and although the password was the same, a restart
(killed process manually) did the trick. Thanks.
However, seems I have uncovered other problems :-(
1. There are no hosts or services visible again, this time the error is:
"No matching hosts"
2. Errors in the log: tail -f /var/log/opsview/opsviewd.log
Although this was only once, cant seem to reproduce them, they dont look
like something I should ignore.
[2010/02/08 10:45:26] [Opsview.Web.Controller.Admin.Reload] [INFO]
Running asynchronous reload
[2010/02/08 10:58:58] [Catalyst] [WARN] Calling $c->model() will return
a random model unless you specify one of: at
/usr/local/opsview-web/script/../lib/Opsview/Web/ControllerBase/Admin.pm
line 87
[2010/02/08 10:58:58] [Catalyst] [WARN] * $c->config->{default_model} #
the name of the default model to use
[2010/02/08 10:58:58] [Catalyst] [WARN] * $c->stash->{current_model} #
the name of the model to use for this request
[2010/02/08 10:58:58] [Catalyst] [WARN] *
$c->stash->{current_model_instance} # the instance of the model to use
for this request
[2010/02/08 10:58:58] [Catalyst] [WARN] NB: in version 5.80, the
"random" behavior will not work at all.
[2010/02/08 12:25:49] [ndoutils_configdumpend] [FATAL] DBD::mysql::db do
failed: Column count doesn't match value count at row 1 [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/02/08 12:25:52] [ndoutils_configdumpend] [INFO] End
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
