Nagios Support Forum

No error in httpd logs. host in cache has the correct coordinates.

Hi,

When I pin a host using the following coordinate, the marker shows up in Brazil instead of Weatherford, TX. This problem does not exist when I put this coordinate on Google Map itself. Please advise.

Coord: 32.728116,-97.786346

I restore from backup. It is good now. Please mark this close.

I'm getting the following error in the Operations Screen and many other areas within Nagios Xi.

SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus'

It looks like the nagios_servicestatus table may have been corrupted.

Please advise.

It's my mistake. The solution is posted below. Originally I had this ... the if will return the first row only. if (($rs = exec_sql_query(DB_NAGIOSQL, $sql))) { if (!$rs->EOF) { print strval($rs->fields["br_num"]) . "\n"; $rs->MoveNext(); } } Change if to while to go through all ...

I tried to do a "select * from tbl_host" using the built-in function exec_sql_query available from /usr/local/nagiosxi/html/includes/db.inc.php. exec_sql_query(DB_NAGIOSQL, $sql) However, it only returns the "first" row. The table itself, however, has 1139 rows and I'm expecting ...

Got it, thanks! You may close this topic.

Understood. Is there a way to tell Nagios Apply Config to ignore the new field added? I did not modify anything else on tbl_host other than added a new field.

I added the new field via mysql's web front end (phpmyadmin).

Apply Configuration in CCM threw these errors: Error: Invalid host object directive 'branch_id'. Error: Could not add object property in file '/usr/local/nagios/etc/hosts/p160042m.cfg' on line 33. It has something to do with the "branch_id" field we created for table "tbl_host" u...