Page 1 of 1

Alias Character Limit

Posted: Fri Mar 06, 2015 11:18 am
by 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.

Re: Alias Character Limit

Posted: Fri Mar 06, 2015 11:46 am
by 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

Re: Alias Character Limit

Posted: Fri Mar 06, 2015 12:00 pm
by 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?

Re: Alias Character Limit

Posted: Fri Mar 06, 2015 12:03 pm
by abrist
emartine wrote: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).
emartine wrote:Does this affect the performance of the server?
No, not to any degree that matters.

Re: Alias Character Limit

Posted: Fri Mar 06, 2015 4:11 pm
by emartine
Awesome. Thank you!

Re: Alias Character Limit

Posted: Mon Mar 09, 2015 8:25 am
by cmerchant
We'll go ahead and close the thread. Thanks.