Nagios Support Forum

CentOS Appliance
5.6.14
VMWare
----

Hi all,

We are running a POC with the nagios appliance in our organization.

Currently running a RedHat server with nagios installed in our production enviroment and we want to migrate the data from this machine to the appliance via backup/restore.
Both the RHEL server and the appliance are running version 5.6.14.

I have created a tarball backup of the original Nagios data and attempt to import to the appliance through the restore_xi script.

I'm getting the error:

"Can't create database 'nagios'(errno:28)
Error restoring MySQL database 'nagios' - check the password in this script!"

The source server is indeed using a different mysql root password.
I know you can edit the password variable within this script to match an alternate mysql password and have done this to match the source, but to no avail.

I've also tried to change the root password for mysql on the applaince to match the source password but still the error persisted.

Anyone have any idea what is actually required and how to solve this?

Thanks in advance

The error 28 is typically caused be the hard drive running out of space. Does the server you are restoring to have enough space?

tgriep wrote:The error 28 is typically caused be the hard drive running out of space. Does the server you are restoring to have enough space?

Now that you mention this, i checked and after i got the error message I checked with df and noticed that the root volume was indeed full!

The error message was a bit confusing and got me searching in the wrong direction. Will extend the disk and try again, I will post the results.

UPDATE: Seems like the issue has been resolved by extending disk space indeed!
Thanks for the suggestion.

I'm getting some errors regarding to httpd now after the import, but that's a whole other issue which i will try to resolve myself first.

Tilburg wrote:UPDATE: Seems like the issue has been resolved by extending disk space indeed!
Thanks for the suggestion.

Great!

Locking this thread, please feel free to open another if you cannot resolve the other issue