On 7 Feb 2010, at 11:34, Andy Ashley wrote:
Hi,
That works now and the interface is displaying all the hosts without
the "Host group id 1 not found" error. Thanks.
Great. We've changed our processes so internally our dev servers are
setup with non-standard database names so we should catch this much
earlier next time.
However, the checks dont seem to be running and updating so I looked
at the log:
# tail -f /var/log/messages
Feb 7 11:15:11 mon01 ndo2db: Error: mysql_query() failed for
'SELECT instance_id FROM nagios_instances WHERE
instance_name='default''
Feb 7 11:15:11 mon01 ndo2db: mysql_error: 'SELECT command denied to
user 'opsviewruntime'@'localhost' for table 'nagios_instances''
Feb 7 11:15:11 mon01 ndo2db: Error: mysql_query() failed for
'INSERT INTO nagios_instances SET instance_name='default''
Feb 7 11:15:11 mon01 ndo2db: mysql_error: 'INSERT command denied to
user 'opsviewruntime'@'localhost' for table 'nagios_instances''
Feb 7 11:15:11 mon01 ndo2db: Did not find instance_name 'default' -
retrying
Feb 7 11:15:12 mon01 ndo2db: Error: mysql_query() failed for
'SELECT instance_id FROM nagios_instances WHERE
instance_name='default''
Feb 7 11:15:12 mon01 ndo2db: mysql_error: 'SELECT command denied to
user 'opsviewruntime'@'localhost' for table 'nagios_instances''
Feb 7 11:15:12 mon01 ndo2db: Error: mysql_query() failed for
'INSERT INTO nagios_instances SET instance_name='default''
Feb 7 11:15:12 mon01 ndo2db: mysql_error: 'INSERT command denied to
user 'opsviewruntime'@'localhost' for table 'nagios_instances''
Feb 7 11:15:12 mon01 ndo2db: Did not find instance_name 'default' -
retrying
(constantly logging)
To make sure, I run:
# /usr/local/nagios/bin/db_mysql
(set correct permissions)
# mysql -u opsviewruntime -p
Enter password:
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.
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
