Actions Component

[gregwhite]

Sorry I haven't responded sooner.
In answer to your first question, yes this is a production server. This same behavior was happening on our test server so we are trying to solve it there first. The first time we had noticed not having the links from the action component was when we converted from mysql to MariaDB. Could this have caused it?

Thanks,
Greg

[benjaminsmith]

Hi Greg,

It likely something happened between the conversion from MySQL to MariaDB. What version of MariaDB did you install?

Let's start with the test server first. when you run the following command on it, are you seeing the data?

Code: Select all

echo "select value from xi_options where name='actions_component_options';" | mysql -u root -pnagiosxi nagiosxi

If not, do you have a backup? let's restore the nagisoxi database from a recent backup and see if it loads properly.

If you do see the data, please send over the /etc/my.cnf file and let me know what version you are running. I can run some tests here.

Thanks,
Benjamin

[benhank]

Hi I'm am going to be heading up getting this resolved.
We did some tests on our end and it seems that the data is in the table nagiosxi /xi options. However I think that something went wrong with the conversion and the component cant read the table. I have pmmed you the data that we need to populate the component.

[benjaminsmith]

Hi Ben,

I ran this by another team member for additional help and we think the strict trans setting is/was enabled, so please follow the article below to turn that off (on both systems) if that's the case.

Nagios XI - STRICT_TRANS_TABLES

We also believe the table options in the other server are different from the new system. Please run the following command to increase the table settings on xi_options.

Code: Select all

echo 'alter table xi_options modify value MEDIUMTEXT;' | mysql -u root -pnagiosxi nagiosxi

The data is probably corrupted, so you'll likely need to run the restore script again. Let me know if the issue is resolved. Thanks, Benjamin