Search found 7 matches

by prmmover
Thu Jun 14, 2012 9:34 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

Ok, so after many more hours of fiddling, I figured out the problem, but I'm not sure I like the answer. You apparently cannot change the username or password of the db user for the ndoutils on the remote DB side. For the nagios database, you need to keep the same ndoutils user/password credentials,...
by prmmover
Wed Jun 13, 2012 8:36 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

Ok, so putting back the original config files pointing to localhost and starting the local mysql db makes everything right again. Everything starts up OK, logging in shows no error, and no errors are showing on any of the status pages. Re-editing the files to point to the remote db (and checking to ...
by prmmover
Wed Jun 13, 2012 8:22 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

No, just the config.inc.php file. I went searching through a bunch of things, but didn't edit any as I didn't see any that had relevant db config info in them. Only other file I changed was the one under /var/www/html/nagiosxi/config to set the db credentials for the Core Config Manager. I'm going t...
by prmmover
Wed Jun 13, 2012 4:10 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

I'll PM you the file in a sec, here's the output of the directory listing: [root@pscls0105 var]# cd /usr/local/nagiosxi/html/ [root@pscls0105 html]# ls -l total 216 drwxr-xr-x 2 nagios nagios 4096 Jun 12 16:40 about drwxr-xr-x 2 nagios nagios 4096 Jun 12 16:40 account drwxr-xr-x 2 nagios nagios 4096...
by prmmover
Wed Jun 13, 2012 3:19 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

On login, I get a popup box with the initial error message. Then, pretty much any page on the left navigation pane that has to deal with the status' like tactical overview, open/all service problems, hostgroup/service status, etc. Although it's primarily showing this table as missing, it isn't limit...
by prmmover
Wed Jun 13, 2012 2:34 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Re: Offloaded MySQL db - table not found

Sorry, should have posted those configs initially as well. Everything looks like it should there: "ndoutils" => array( "dbtype" => 'mysql', "dbserver" => '10.2.50.46', "user" => 'xxxxx', "pwd" => 'xxxxxxx', "db" => 'nagios', "nagiosql&...
by prmmover
Wed Jun 13, 2012 2:02 pm
Forum: Nagios XI
Topic: Offloaded MySQL db - table not found
Replies: 12
Views: 2445

Offloaded MySQL db - table not found

system - nagiosXI 2011R3.1 O/S - RHEL6 64-bit Virtual Machine on Citrix Xenserver remote DB - MySQL 5.5 on RHEL6 physical machine I've followed the steps in the library topic for offloading MySQL to a remote server )http://assets.nagios.com/downloads/nagiosxi/docs/Offloading_MySQL_to_Remote%20Server...