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?
Andy.
Andy Ashley wrote:
Ton Voon wrote:
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
...
My guess is permissions on the mysql database. Either the credentials
in /usr/local/nagios/etc/opsview.conf are incorrect, or mysql does
not have the necessary permissions assigned for those credentials.
http://docs.opsview.org/doku.php?id=opsview-community:faq#how_do_i_change_mysql_passwords_post_installation
Ton
Hi,
I dropped and recreated the databases, still seeing an error though:
/usr/local/nagios/bin/db_opsview db_install
/usr/local/nagios/bin/db_runtime db_install
/usr/local/nagios/bin/db_odw db_install
/usr/local/nagios/bin/db_reports db_install
tail -f /var/log/opsview/opsviewd.log &
/usr/local/nagios/bin/rc.opsview gen_config
[2010/02/04 15:51:31] [create_and_send_configs] [INFO] Starting overall
Thu Feb 4 15:51:33 2010 Starting
Thu Feb 4 15:51:33 2010 --> Writing config files for Master
Monitoring Server
Thu Feb 4 15:51:33 2010 28 commands written to checkcommands.cfg
Thu Feb 4 15:51:33 2010 16 service definitions written to services.cfg
Thu Feb 4 15:51:33 2010 1 hosts written to hosts.cfg
Thu Feb 4 15:51:33 2010 1 hostgroups written to hostgroups.cfg
Thu Feb 4 15:51:33 2010 1 contacts written to contacts.cfg
Thu Feb 4 15:51:33 2010 1 contacts written to htpasswd.users
Thu Feb 4 15:51:33 2010 3 groups written to contactgroups.cfg
Written nagios.cfg
Written cgi.cfg
Written misccommands.cfg
Written timeperiods.cfg
Written snmptraps.cfg
Written nsca.cfg
Written send_nsca.cfg
Written ndo2db.cfg
Written ndomod.cfg
Thu Feb 4 15:51:33 2010 0 dependencies written to services.cfg
Nagios config re-generated in 0.217 seconds
[2010/02/04 15:51:34] [create_and_send_configs] [INFO] Ending overall
with error=0
[r...@mon01 ~]# [2010/02/04 15:51:38] [ndoutils_configdumpend] [INFO]
Start
[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
"]
[2010/02/04 15:51:38] [ndoutils_configdumpend] [INFO] End
Tried to make sure MySQL has the right permissions:
mysql> GRANT ALL ON opsviewruntime.* TO opsviewrunt...@localhost
IDENTIFIED BY 'opsviewruntimepassword';
Query OK, 0 rows affected (0.00 sec)
But still get that error..
Thanks.
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
