Limitation of display_name filed in nagios_services table

[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

[scottwilkerson]

As far as I can tell that should not have any adverse impact and should be ok to update

[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   |     |         |                |

[scottwilkerson]

You will likely need to restart the nagios service after making the change to populate the table

[nms]

Indeed. That solved it.

Thanks. You may kindly lock/close ticket

[scottwilkerson]

Indeed. That solved it.

Thanks. You may kindly lock/close ticket

Great!

Locking thread