ObjectNotes Bug
Posted: Tue May 27, 2014 9:45 pm
Nagios XI 2012R2.9
RHEL 6.5 x64
Manual Install
I updated some hosts with objectnotes notes and it was fine.
When I renamed one of the hosts, the notes disappeared.
The problem seems to be the hostname is hardcoded as text in the name column in table xi_options.
I suppose this will be the same problem for services name changes also.
The old entries is left orphaned in the table.
Example: Hostname
objectnotes_SST_SGR_ATM_FSDM_WN__
Shouldn't this be normalised and referred to via host /service reference codes?
All the other changes in CCM seems to be fine even if the name is changed.
The fix is to manually update the PostgreSQL DB
update xi_options set name = 'objectnotes_newname__' where name ='objectnotes_oldname__';
Please advice on this. Thanks
RHEL 6.5 x64
Manual Install
I updated some hosts with objectnotes notes and it was fine.
When I renamed one of the hosts, the notes disappeared.
The problem seems to be the hostname is hardcoded as text in the name column in table xi_options.
I suppose this will be the same problem for services name changes also.
The old entries is left orphaned in the table.
Example: Hostname
objectnotes_SST_SGR_ATM_FSDM_WN__
Shouldn't this be normalised and referred to via host /service reference codes?
All the other changes in CCM seems to be fine even if the name is changed.
The fix is to manually update the PostgreSQL DB
update xi_options set name = 'objectnotes_newname__' where name ='objectnotes_oldname__';
Please advice on this. Thanks