more weirdness with remote mysql instance

[kultardotnet]

Hey All,

Nagios XI trial install is done with mysql offloaded to another host.

I'm having issues where I am unable to utilize the monitoring wizards as the hosts do not get added into the database (I see no errors in logs).

I am able to successfully add hosts/services/hostgroups/etc via CCM, but I experience issues inserting into the remote db.

Can someone help me sort this out? Any instructions for remote db repair? Any suggestions on sorting out the wizards?

[tmcdonald]

What XI version is this? What OS and version?
What wizard/s are you using? Can you go to Admin -> Manage Config Wizards and tell us their versions?
Do you see any errors in the remote server's logs?

[kultardotnet]

Hey There,

Sorry for the delay -- long weekend of other things going wrong >.<

Anywho..

Logs on remote host aren't showing any failures that I can find.


OS: centos 6.5 x64
XI: 2014R1.3

Here's the versions from the manage config wizards page


Auto-Discovery
Version: 1.3.1

BPI Wizard
Version: 1.1

Bulk Host Cloning and Import
Version: 1.9.1

DHCP
Version: 1.1

DNS Query
Version: 1.1

Domain Expiration
Version: 1.1.0

Email Delivery
Version: 2.0

Websensor
Version: 1.1

Exchange Server
Version: 1.2

FTP Server
Version: 1.51

Generic Network Device
Version: 1.0

LDAP Server
Version: 1.3

Linux Server
Version: 1.4.1

Linux SNMP
Version: 1.4.1

Mac OS/X
Version: 1.2.1

Mail Server
Version: 1.2

MongoDB Database
Version: 1.0

MongoDB Server
Version: 1.0

MSSQL Database
Version: 1.53

MSSQL Query
Version: 1.51

MSSQL Server
Version: 1.81

MySQL Query
Version: 1.2

MySQL Server
Version: 1.3

Nagiostats Wizard
Version: 1.1

Nagios XI Server
Version: 1.2

NCPA Agent
Version: 1.2

Nagios Network Analyzer
Version: 1.0

NRPE
Version: 1.3.1

Oracle Query
Version: 1.3

Oracle Serverspace
Version: 1.5

Oracle Tablespace
Version: 1.5

Passive Check
Version: 1.2

Unconfigured Passive Object
Version: 1.1

Postgres Database
Version: 1.4

Postgres Query
Version: 1.1

Postgres Server
Version: 1.2

Printer
Version: 1.1

RADIUS Server
Version: 1.3

SNMP
Version: 1.5.1

SNMP Trap
Version: 1.4

SNMP Walk
Version: 1.3

Solaris
Version: 1.2.1

SSH Proxy
Version: 1.5.1

Network Switch / Router
Version: 2.1.2

TCP/UDP Port
Version: 1.3

VMware
Version: 1.6

WatchGuard
Version: 1.3

Website
Version: 1.2

Website Defacement
Version: 1.1.2

Website URL
Version: 1.33

Web Transaction
Version: 1.2

Windows Desktop
Version: 1.4

Windows Event Log
Version: 1.3

Windows Server
Version: 1.4.1

Windows SNMP
Version: 1.4.1

Windows WMI
Version: 1.10.1

[tmcdonald]

Which actual wizards are you using? MySQL Query? MySQL Server?

[kultardotnet]

I've tried every wizard with the same results, sadly.

[tmcdonald]

You have tried *every* wizard? Do you mean every MySQL wizard or truly every wizard you listed?

Either way, are you certain the host does not already exist in the CCM? Be sure to search for both the host name and the IP address.

[kultardotnet]

Morning,

Any way I can expedite this? i know i sound like a jerk for asking that but if I can't get this sorted, that means I can't spend several grand purchasing xi.

But anyway...

I'm trying to migrate several nagios core instances into xi, and i wanted to utilize the wizards to make life easier. I don't mind going through the few thousand hosts to make sure everything is up to snuff.

What this means is, I have every type of host for every wizard so it made troubleshooting easy.

1. I can successfully run *any* wizard.
2. At the completion of *any* wizard, I get all green on all tasks
3. The hosts that I add via the wizards do not show up anywhere.

Point 3 is the problem.

Suggestions?

[tmcdonald]

Any way I can expedite this? i know i sound like a jerk for asking that but if I can't get this sorted, that means I can't spend several grand purchasing xi.

We do offer a free quickstart session for new users, which is a one-hour remote session where we can help get started or fix specific issues:

http://www.nagios.com/downloadxi

Filling out that form will allow us to reach out and schedule a session with you.