nagiosql and nagios databases missing!
-
cwscribner
- Posts: 316
- Joined: Thu Mar 31, 2011 9:54 am
- Location: Patten, ME
nagiosql and nagios databases missing!
Title says it all. Except for the performance graphs which don't work at all, everything seems to be functioning normally. But when I log into mysql as root, nagios, or nagiosql, both databases are missing. How do I fix that?
Last edited by cwscribner on Wed Feb 15, 2012 10:52 am, edited 1 time in total.
-
mguthrie
- Posts: 4380
- Joined: Mon Jun 14, 2010 10:21 am
Re: nagiosql and nagios databases missing!
Ok, lets back up just a little bit so we know where things are at. If you're able to log into Nagios XI at all, then those databases would have to be there, or somewhere, because those connections are required just to log in.
Sorry to ask an obvious question, but is mysql offloaded on a different machine?
Are you able to login to XI? Are you able to view status information?
Code: Select all
mysql -p'nagiosxi' nagios
show tables;
use nagiosql;
show tables;Are you able to login to XI? Are you able to view status information?
-
cwscribner
- Posts: 316
- Joined: Thu Mar 31, 2011 9:54 am
- Location: Patten, ME
Re: nagiosql and nagios databases missing!
Eff. Feel free to completely remove this thread...
I re-logged into the server and then mysql, now I can see the databases. Before all I could see was information_schema. I know this isn't a real problem per se but any thoughts on why I would need to re-login to see the databases?
I re-logged into the server and then mysql, now I can see the databases. Before all I could see was information_schema. I know this isn't a real problem per se but any thoughts on why I would need to re-login to see the databases?