Alias Character Limit

[emartine]

I've seen a lot of posts on this but I thought I would get a more concrete answer for myself. In my older core configuration I had alias/description fields with server description, server location and owner information. This showed up perfectly fine when someone clicked on the host in my older core 3 and the newer core 4. In Nagios XI 2014R2.6 when someone tries to view this information the Alias at the top that lists this information is cut off at ~64 characters which defeats the purpose of having it there in the first place and I have to get folks to login to core instead to read the full info. Is there any way to increase the displayed character limit for aliases in Nagios XI? This is a business need since we have pages that are rotating for hosts.

[abrist]

The "alias" field in the ndo database is set to 64 characters, whereas the the "alias" field in the nagiosql database is set to 255 characters. Run the following query to increase the field size for the ndo nagios_hosts "alias" field:

Code: Select all

echo "alter table nagios.nagios_hosts modify alias varchar(255);" | mysql -pnagiosxi

[emartine]

Excellent. Thank you. Before I do this.... Is this a change that needs to be done every time an update to nagios xi occurs? Does this affect the performance of the server?

[abrist]

Is this a change that needs to be done every time an update to nagios xi occurs?

Nope, once changed, the db field should be unaffected by future updates (unless the update specifically alters the field size - which I doubt will ever happen).

Does this affect the performance of the server?

No, not to any degree that matters.

[emartine]

Awesome. Thank you!

[cmerchant]

We'll go ahead and close the thread. Thanks.