Migrate to Offload MySQL now Wizards dont work

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
pfsweb
Posts: 47
Joined: Fri Jun 27, 2014 9:01 am

Migrate to Offload MySQL now Wizards dont work

Post by pfsweb »

I could really use some help. We have gone through the steps to offload mysql to a different mysql server. Everything appeared to work correctly until I tried to use a Host Wizard for a windows server to add a new host and services. It ran through the process but after about 15 minutes of waiting no host or service would appear. We have reset the credentials and double checked the offload document for accuracy.
We need to use the wizards and it also seems to happen when the create new user function tries to create a contact. Please help.
Thank you.

1.Linux Distribution and version? - CentOS 6.5
2.32 or 64bit? - 64bit
3.VMware Image or Manual Install of XI? - Manual Install
4.Are there special configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL? No SSL, No Proxy, No Gnome, MySQL is on a seperate server utilizing the Nagios XI MySQL Offload
5.**If you are encountering multiple issues that may not be related, start a thread for each issue


PFSWEB. :D
You do not have the required permissions to view the files attached to this post.
pfsweb
Posts: 47
Joined: Fri Jun 27, 2014 9:01 am

Re: Migrate to Offload MySQL now Wizards dont work

Post by pfsweb »

**Update**
When I run a wizard in Nagios XI it says everything created correctly.
2014-06-29 08:06:32 28746 Nagios CCM SECURITY nagiosxi localhost nagiosxi successfully logged into Nagios CCM
2014-06-29 08:06:31 28745 Nagios CCM MODIFY nagiosxi localhost Login successful
2014-06-29 08:06:31 28744 Nagios CCM MODIFY nagiosxi localhost File imported - File \[overwite flag\]: /usr/local/nagios/etc/import/u9lvb9il.tmp.cfg \[1\]
2014-06-29 08:06:30 28743 Nagios CCM MODIFY nagiosxi localhost File imported - File \[overwite flag\]: /usr/local/nagios/etc/import/prodxenapp04.<domain>.com.cfg \[1\]
2014-06-29 08:06:30 28742 Nagios CCM SECURITY nagiosxi localhost nagiosxi successfully logged into Nagios CCM

When I look in /usr/local/nagios/etc/hosts/ there is no new config file for the proxenapp04.<mydomain>.com
As well when I look in /usr/local/nagios/etc/import there are no files.

Hope this helps.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Migrate to Offload MySQL now Wizards dont work

Post by slansing »

There should not be anything in the import directory, however, if the apply configuration at the end of your wizard has three green check marks and completed, you should have a new host 'providing you did not use the same host address in the wizard.' Can you post the output of your last modified times from this?:

Code: Select all

ls -la /usr/local/nagios/etc/hosts
Does it match with when you last applied config?
Everything appeared to work correctly until I tried to use a Host Wizard for a windows server to add a new host and services.
We're you able to successfully run other wizards and create hosts/services after you had offloaded? Or are you saying you have only tested with the Windows Server wizard?
pfsweb
Posts: 47
Joined: Fri Jun 27, 2014 9:01 am

Re: Migrate to Offload MySQL now Wizards dont work

Post by pfsweb »

Can you post the output of your last modified times from this?: Yes. (attached)
Does it match with when you last applied config?: No.
We're you able to successfully run other wizards and create hosts/services after you had offloaded? No.
Or are you saying you have only tested with the Windows Server wizard? - I have tested all of the Wizards and When I create a new User and choose create contact it will not create the contact.
You do not have the required permissions to view the files attached to this post.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Migrate to Offload MySQL now Wizards dont work

Post by abrist »

Can you open up a ticket by sending an email to [email protected] ?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
pfsweb
Posts: 47
Joined: Fri Jun 27, 2014 9:01 am

Re: Migrate to Offload MySQL now Wizards dont work

Post by pfsweb »

will do right now.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Migrate to Offload MySQL now Wizards dont work

Post by tmcdonald »

Closing for now since ticket is in place.
Former Nagios employee
Locked