Page 1 of 1
Limitation of display_name filed in nagios_services table
Posted: Thu Apr 16, 2020 7:02 am
by nms
Hi,
The nagios_services table has a field display_name which is limited to 64 characters (varchar(64)).
Code: Select all
mysql> describe nagios_services;
+-----------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------+--------------+------+-----+---------+----------------+
| display_name | varchar(64) | NO | | | |
Is it possible to set this with varchar(255) without disturbing anything or pushing any impact to the database?
Rgds,
Matthew
Re: Limitation of display_name filed in nagios_services tabl
Posted: Thu Apr 16, 2020 8:01 am
by scottwilkerson
As far as I can tell that should not have any adverse impact and should be ok to update
Re: Limitation of display_name filed in nagios_services tabl
Posted: Thu Apr 16, 2020 9:18 am
by nms
Thanks,
for a trial i changed that to varchar(10000)
However I still notice that the output does not give the whole display name. Maybe I'm missing something else due to the space in the monitor names?
Code: Select all
mysql> select display_name from nagios_services where display_name like '%ContentDailyMultipleOccurence%';
+------------------------------------------------------------------+
| display_name |
+------------------------------------------------------------------+
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
| 200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/m |
Where the actual name here for example is
Code: Select all
200_S-NCC-NCC014_File ContentDailyMultipleOccurence - /var/adm/messages [CC-Request-Type 3 received in state Idle]
My present setting:
Code: Select all
mysql> describe nagios_services;
+-----------------------------------+----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------+----------------+------+-----+---------+----------------+
| display_name | varchar(10000) | NO | | | |
Re: Limitation of display_name filed in nagios_services tabl
Posted: Thu Apr 16, 2020 9:32 am
by scottwilkerson
You will likely need to restart the nagios service after making the change to populate the table
Re: Limitation of display_name filed in nagios_services tabl
Posted: Thu Apr 16, 2020 9:39 am
by nms
Indeed. That solved it.
Thanks. You may kindly lock/close ticket
Re: Limitation of display_name filed in nagios_services tabl
Posted: Thu Apr 16, 2020 10:26 am
by scottwilkerson
nms wrote:Indeed. That solved it.
Thanks. You may kindly lock/close ticket
Great!
Locking thread