Extra/additional field needed in NAGIOSQL

[zaji_nms]

Dear Expert

While adding Service in NaigosXI via CCM, there is very limited fields just as below.

Config Name = Host
Description = Service
Display name = Display Name

These three fields are not enough for us at all, we added extra field via phpmyadmin but config unable to get apply. What steps we have to do so NagiosXI will accept new fields.

Error: Invalid service object directive 'isp_wan_ip'.
Error: Could not add object property in file '/usr/local/nagios/etc/services/my-new-router.cfg' on line 21.

these are the minimum fields we required, no issue if database grow, now-a-days advance hardware/OS can handle process/cpu.

isp_wan_ip
cust_lan_ip_1
cust_lan_ip_2
cust_lan_ip_3
cust_bgp_as_no
cust_location_gps_coord
cust_branch_name
isp_aggregation_pe
isp_switch_id
isp_switch_port
isp_dslam_id
isp_dslam_port
isp_circuit_id
cust_circuit_id
cust_quotation_no
isp_sales_so
isp_finance_acno

Regards

[Box293]

Adding a Free Variable or custom variable is what you are after.

Look at these articles:

https://assets.nagios.com/downloads/nag ... tvars.html

https://support.nagios.com/kb/article.php?id=362

In XI, these are added to a host or service via the MISC tab.

[zaji_nms]

Dear Mr.Troy

upon your guide, me just changed the variable name and added two variables starting with _(underscore). Its okay upto my expectation.
I will continue with my initial post of this thread (not using MISC tab of CCM). Me added two field manually by PHPMYADMIN and manually updated some text, I can see via CLI

_ISP_CID
_isp_wan_ip

mysql> select config_name,display_name,_ISP_CID,_isp_wan_ip from tbl_service where config_name="tst-test-22";
+-------------+-------------------------------------------------------+------------------+----------------+
| config_name | display_name | _ISP_CID | _isp_wan_ip |
+-------------+-------------------------------------------------------+------------------+----------------+
| tst-test-22 | Its My Disp Name | VviP 1HappY2 dAY | IP.10.20.40.90 |

even I can see via => more /usr/local/nagios/etc/services/tst-test-22.cfg (unwanted lines omitted)

define service {
host_name tst-test-22
service_description 1-9-33-0_Test_Port Extra
display_name Its My Disp Name
_ISP_CID VerY 1HappY2 dAY
_isp_wan_ip IP.10.20.40.90
}
but when I tried to display via NOCSCREEN or SERIVESTATUS , not giving any result, I think I have to initialize some where, but where? I do not know and hope you/NagiosTeam will help me and this forum.

nocscreenapi.php
ajaxhelpers-servicestatus.inc.php

<td>$x->display_name</td>\n Working Fine
<td>$_ISP_CID</td>\n tried without $x but Blank (no result)
<td>$x->_isp_wan_ip</td>\n tried with $x but Empty (not showing anything)

Regards

[tmcdonald]

Me added two field manually by PHPMYADMIN and manually updated some text, I can see via CLI

This is completely out of scope of what we can support. We are not able to assist with direct database manipulation, and altering the structure can cause unintended side-effects.

[zaji_nms]

Dear tmcdonald

we have done many minor changes and our life is very easy with Nagios/Nagvis. We not doing any major changes to Core/CCM, just little bit extra. We are customer more than 3+years and enjoying Nagios/Nagvis. We achieved via your little hint and our much R&D without adverse affect on our NMS.

Please take your time, don't be in hurry to reply as its not any outage, however keep in mind, your 5 minutes guide will make life easy of 1000s of Nagios lovers.

Regards

[tmcdonald]

I understand completely, but this is out of scope. You are free to make changes - we can't stop you, but those changes are not something we can support. If you wish to have these sorts of changes be supported, they will need to be added by our developers and tested internally first.

[Box293]

From what I understand, you want to be able to see these custom variables as an extra column on the NOCSCREEN or SERIVESTATUS. Currently there is no easy way to do this. It would need to be created as a feature request or custom developoment you pay for.

The only thing similar to what you are after is the Custom Column Component.

https://exchange.nagios.org/directory/A ... nt/details

However you will need some coding skill to make it work the way you intended as per:

This component adds the host notes field to the main status tables in Nagios XI. This component is intended to be a developer example of how to add a custom column to display additional information for hosts and/or services in the status tables of Nagios XI.

Also this was written for an old version of XI and may not work with the modern version.

[zaji_nms]

dear expert,
kindly help to get our task to be completed we are just one step away... we did customization
1. we added new field in CCM -- host managment ---- > _Field1 ( also manually in nagioql db and nagios db )
2. we saved and applied config its successfully completed nagiosql writes in localhost.cfg file but its not writing field1 data in nagios_hosts table why ? bcos of that we are not getting data what we enterned in to filed1 is not displayed on hoststatus page

all screenshot attached for ref plz need your kind support to get it work . we will highly appreciate your kind support

[lmiltchev]

As Box293 said:

It would need to be created as a feature request or custom development you pay for.

We can try to help on the support forum but this is something that will most probably need to get developers involved. There is no guarantee that we will be able to resolve the issue in a timely matter. We can test this in-house but we need to know what are the changes that you made to your system so far, while trying to implement this functionality.

1. we added new field in CCM -- host managment ---- > _Field1 ( also manually in nagioql db and nagios db )

Please, describe everything you did in details (include commands, configs, screenshots, etc.).

[zaji_nms]

Dear Expert

Sorry to continue this Topic

As we found NagiosXI is accommodate/fulfill our needs however as going further, our needs increasing more and more.

We simply want you (NagiosXI Team) to add 2+2 more fields. Two fields in HOST config, two fields in SERVICE config. We choosing the names as below. Extra_Host_Field_1 & Extra_Host_Info_2 ,,, Extra_Service_Field_1 & Extra_Service_Info_2. (64 characters)

under CCM (HOST MANAGEMENT)
exthstfld1
exthstinf2

under CCM (SERVICE MANAGEMENT)
extsrvcfld1
extsrvcinf2

Regards