Nagios Support Forum

Hello,

I recently did some troubleshooting where I removed a Nagios XI instance from Fusion. However, when I tried to add it back to Fusion, I got an error message: "Something went wrong adding server."

The Nagios XI box is fine. Running curl -L -vvv https://<<nagios xi url>>/nagiosxi/api/v1/system/status?fusekey=<<fusekey>> from the Fusion box returns data just fine (certificate is accepted, and the JSON output looks like our other Nagios Xi boxes).

Running mysqlcheck --force --check --host=${db_host} --user=${db_user} --password=${db_pass} fusion, all the fusion tables are OK. So are the rest of the tables if I do --all-databases instead.

I generated a new fusekey for the XI box, which didn't help. I even logged in to MariaDB and looked at the fusion.servers table to see if there was any duplicate leftover cruft in there, but it looked clean with only rows for the other XI boxes I hadn't deleted.

Both Nagios XI and Fusion had upgrades available, so I got them current, but that didn't fix it either.

Finally, I cloned my Fusion VM, then deleted and reinstalled Fusion on the clone. The Nagios XI box fused in with no trouble and reported numbers within a few minutes.

I couldn't find any logs in Fusion that told me anything more specific. Any ideas what else I can look at? It's not the end of the world if I have to reconfigure Fusion from scratch, but if I can fix this one then I don't have to worry about overlooking any settings.

Thanks.

Hello @cbeattie-unitrends,

Thank you for reaching out!

This is definitely a strange issue to run into and would like to look into it a little more/attempt replicating it.

What distribution are you running your Fusion on?

I'm running it on CentOS Stream 9.

Hello @cbeattie-unitrends,

Thank you for updating me on the distribution!

I haven't been able to reproduce this issue yet, though I am still actively trying. I was however, able to track down that error message and can confirm it is related to Fusion being unable to insert the server data into the database successfully.

Have you attempted or been able to fuse any other servers?

Since the stakes were pretty low, I tried just banging the Nagios box back into Fusion manually. I logged in to the MariaDB client, looked at the servers table, copied the column names, and made an insert statement with the values from the Nagios box I was trying to add back in.

It seems to have worked. The Nagios XI box showed back up in the list of fused servers and within a couple minutes all its data were back in the dashlets.

I don't have any more Nagios XI boxes to try to fuse, so I don't know if I actually solved the problem. But it's doing what I need it to now, so I'll cross that bridge if I ever get to it.

Thanks!

Hello @cbeattie-unitrends,

Glad to hear you found a resolution!

Thank you again for reaching out. I will keep attempting to reproduce this issue, and will ensure a Fusion Changelog line gets added when I find a resolution!


Please feel free to reach out with any other questions, comments, or concerns!

Hi @cbeattie-unitrends, thanks for sharing your steps.
When you added the Nagios XI server data manually to the MariaDB database, was it hard to match the format Fusion needed? Can you share how you wrote the insert statement? It might help others with the same issue.
Thanks.