Corrupted DB

[rodrigojuarez]

I was tasked with the migration of some objects from one installation to another.

While doing so, I found out some configuration file's file names had tabulator characters in their name, so I'm blaming that as the reason.

Now there are issues with both hosts and services names, some being garbled, some without names, some of them have time period definition's as names and some others have contact group's names as names.

When clicked, the ones that have names, they show "Object Does Not Exist".

I already ran mysqlcheck and the tables showed either "Ok" or "The storage engine for the table doesn't support repair", depending on the database.

Short than scraping the server and starting from scratch again, what can I do?

Thanks in advance.

[gormank]

Since CCM writes the .cfg files I use only underscores and alphanumeric chars in object names. One thing to keep in mind is if a host/service is to be defined, you want to make sure it's subobjects (templates, hostgroups, etc.) are defined first.
How did you migrate the objects?

[rodrigojuarez]

Hello gormank.

Yes, I usually only use alphanumeric characters but this server was already there.

I didn't notice the problem with the characters until there was garbage in the hosts and services.

What I did was to copy the contents of /usr/local/nagios/hosts and /usr/local/nagios/services directories over from the old server.

Unfortunately the errors piled up enough for the server to be trustworthy so I scrapped it.

I'm in the process of doing it over again with the previos problems fixed beforehand.

Thanks for your response.

[gormank]

If you're using XI you can't just copy the files. You'd need to copy them to the import dir and run apply changes or run the reconfigure script.