Ton Voon wrote:
Sorry. The error is similar.
There's a hardcoded reference to opsview. Apply this
patch: https://secure.opsera.com/wsvn/wsvn/opsview?op=comp&compare
<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.
Hi,
That works now and the interface is displaying all the hosts without the
"Host group id 1 not found" error. Thanks.
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:
mysql> select * from nagios_instances;
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
| 1 | default | |
+-------------+---------------+----------------------+
1 row in set (0.01 sec)
mysql> insert into nagios_instances values ('2', 'test', '');
Query OK, 1 row affected (0.01 sec)
mysql> select * from nagios_instances;
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
| 1 | default | |
| 2 | test | |
+-------------+---------------+----------------------+
2 rows in set (0.00 sec)
mysql> delete from nagios_instances where instance_id=2;
Query OK, 1 row affected (0.01 sec)
mysql> select * from nagios_instances;
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
| 1 | default | |
+-------------+---------------+----------------------+
1 row in set (0.00 sec)
Works fine, adequate permissions.
But the errors in the log persist and hosts/services still have a last
check time from before the MySQL backup was taken.
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
