Hi james thanks for your reply yes I createed the public/private key pair
and send the key to the slave server as user Nagios.but iam stick at this
point
nag...@master$ scp /usr/local/nagios/installer/check_reqs
/usr/local/nagios/bin/profile {slave}:
Error is permission denined.
I am using vms on both server and client which I downloaded from ops view
site.
If you could help me determining the problem.
Thanks a lot.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, February 01, 2010 1:37 AM
To: [email protected]
Subject: Opsview-users Digest, Vol 32, Issue 1
Send Opsview-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.opsview.org/lists/listinfo/opsview-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific than
"Re: Contents of Opsview-users digest..."
Today's Topics:
1. Upgrade issue - Host group id 1 not found (Andy Ashley)
2. Re: Opsview slave configuration errors (James Whittington)
3. notifications per host/contact possible ? (Ronny Roethof)
4. scheduled reports bug (Luis F. Periquito)
----------------------------------------------------------------------
Message: 1
Date: Sun, 31 Jan 2010 16:16:40 +0100
From: Andy Ashley <[email protected]>
Subject: [opsview-users] Upgrade issue - Host group id 1 not found
To: Opsview Users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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.
------------------------------
Message: 2
Date: Sun, 31 Jan 2010 11:09:23 -0500
From: James Whittington <[email protected]>
Subject: Re: [opsview-users] Opsview slave configuration errors
To: Opsview Users <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
Okay reading through you post I am assuming you are trying to do the direct
ssh master slave model where the master will initiate ssh to the slave
server.
The other method if the reverse ssh method, where slave initiates ssh
session with the master and leaves a reverse ssh channel open to itself.
Anyway if you are doing the direct ssh method
Have you created the nagios user on the slave server and granted it specific
sudo rights?
Can you ssh as user nagios from the master server to the slave?
What linux distro is being used?
Did you create the public/private key pair and send the key to the slave
server as user Nagios? The step where you do "ssh-copy-id -i .ssh/id_dsa.pub
slave hostname" .
Just trying to determine where you might be stuck in the process.. It sounds
like the ssh certificate isn't in place if you can't do ssh command from
master to slave without being prompted for credentials.
James Whittington
VC3, Inc.
From: [email protected]
[mailto:[email protected]] On Behalf Of jibran
Sent: Friday, January 29, 2010 7:47 AM
To: [email protected]
Subject: [opsview-users] Opsview slave configuration errors
Hi I installed vm ops view on one network and also the same vm ops view
downloaded from opsview on other network.I tried to setup master/slave using
opsview vms on different networks.I have forwarded ports 22 on both networks
routers and ssh connection is working on both sides.I putty from slave and
on step 6 where we have to copy files from server Copy the check_reqs and
profile scripts from the master onto the slave as the nagios user. This
should work without prompting for authentication:
Copy the check_reqs and profile scripts from the master onto the slave as
the nagios user. This should work without prompting for authentication:
nag...@master$ scp /usr/local/nagios/installer/check_reqs
/usr/local/nagios/bin/profile {slave}:
I am getting this error I used ip of the slave network like {58.27.23.215}
:
The error I am getting is.
nag...@opsview-demo:~$ scp /usr/local/nagios/installer/check_reqs
/usr/local/nagios/bin/profile 58.27.245...@opsview-demo:
58.27.245...@opsview-demo's password:Password iam giving is default (conf)
which is set by vm and also gave the default nagios password
Permission denied, please try again.
I am stuck here kindly help me here to keep the slave network running.I
really need to make this working.Will really appreciate some ones positive
response.
Thanks alot
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.opsview.org/lurker/list/opsview-users.html/attachments/2010013
1/b0cb346d/attachment.htm>
------------------------------
Message: 3
Date: Sun, 31 Jan 2010 23:15:43 +0100
From: Ronny Roethof <[email protected]>
Subject: [opsview-users] notifications per host/contact possible ?
To: opsview-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello everyone,
In Nagios it is possible to set notifications per host per contact.
I have some servers that we need to monitor, and one of our customers
needs to be notified when a few of these machine's are down, etc.
Is it anyway possible to specify which contacts need to be notified per
server ?
With regards,
Ronny Roethof
------------------------------
Message: 4
Date: Mon, 1 Feb 2010 09:34:39 +0000
From: "Luis F. Periquito" <[email protected]>
Subject: [opsview-users] scheduled reports bug
To: "[email protected]"
<[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
Hi,
I have scheduled to receive some reports automatically on the 1st of the
month.
This month the exception detail page of the pdf shows week 53 as being from
2011-01-03 to 2010-01-31. Any ideas on how to correct this?
Regards.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.opsview.org/lurker/list/opsview-users.html/attachments/2010020
1/88b124a8/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: reports.png
Type: image/png
Size: 26550 bytes
Desc: reports.png
URL:
<http://lists.opsview.org/lurker/list/opsview-users.html/attachments/2010020
1/88b124a8/attachment.png>
------------------------------
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
End of Opsview-users Digest, Vol 32, Issue 1
********************************************
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
