Nagios Support Forum

Strange issue after migrating off of my Centos 6 VM Appliance I have used for the past 7 years. I migrated to Centos 8 clean install as per instructions and installed Oracle 18.5 instant client all went well. I use NCPA for most of my monitoring and that is all working well.
What has been perplexing is I can't get my one custom check for Oracle working in XI but it is working in Core just fine.See the very bottom of the image attached.

I migrated first tries using backup and restore mostly worked but My custom Oracle select did not. Finally did a clean install and setup all my services manually.
Installed Version: 5.7.2

My Custom service seemed to fail so I deleted because it stayed in pending. After deleting it stayed in pending and now is the Null Pending service. See at the top of attached image.

Since my SQL works fine in Centos Terminal I decided to proceed and install my 4 Custom services that check for user with highest connection counts. They just stay in pending too.

I discovered they are working but I can't get out of pending status or get them to show counts in XI but I can see they are working in Core and it will report if the counts exceed my set points.

I have restarted reinstalled and I am just getting nowhere.
Thanks

Hi @tkaufman,

Welcome to the Nagios Support Forum! Let's try upgrading to the latest version as we've made some important updates in the backend database application. The check results are not getting written to the database as expected.

We always recommend that customers update a test server before upgrading the production environment. Your Nagios XI license allows for 3 activations.

Upgrading Nagios XI

Let me if you need any assistance.

Hello benjaminsmith
I have tried that still same issue.

I still have the old VM so I am good on a fallback

HI,

Good to know you have a backup. If you're still having the problem on 5.7.3, can you send me a profile from this system so we can review the logs? That would be much appreciated.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.

Hello,
I uploaded the profile.zip as requested in a private message.

Thank you

I don't know if this helps but setting mysql mode to

[mysqld]
sql_mode=""

in /etc/my.cnf seems to have resolved my issue.
Not sure I can pass my security audit now but at least the services I configure now show in XI

Hi,

That's interesting. What value did you have the parameter set to before the upgrade?

I did notice ndo3 related errors in the nagios logs, if the problem persists, let me know and I'll have you truncated a few tables to help clear this out.

[1599247556] NDO-3: The following query failed while MySQL appears to be connected:

as far as I know this is the default from the install I downloaded.
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

I think I did not answer your question correctly.
/etc/my.cnf did not have any entry for mysqld

I added this
[mysqld]
sql_mode=""

After reading this kb https://support.nagios.com/kb/article/n ... n-822.html

Since this Server is a VM and I just took a snapshot I figured I would give it a shot

tkaufman wrote:I think I did not answer your question correctly.
/etc/my.cnf did not have any entry for mysqld

I added this
[mysqld]
sql_mode=""

After reading this kb https://support.nagios.com/kb/article/n ... n-822.html

Since this Server is a VM and I just took a snapshot I figured I would give it a shot

Thanks for sharing!

Closing thread