email issue: Unable to bind parameters & Statement not prepared

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Post Reply
User avatar
JohnFLi
Posts: 511
Joined: Mon Jun 17, 2013 3:11 pm

email issue: Unable to bind parameters & Statement not prepared

Post by JohnFLi »

Our Nagios version: 5.10.0
our nagios xi is set to use 'send mail'
in trying to find out why some (only some) messages are not being sent out for alerting.

I look in /usr/local/nagios/var/nagios.log file and i see:
[1687186711] NDO-3: ndo_return = 1 (Statement not prepared)
[1687186711] NDO-3: ndo_handle_system_command(ndo-handlers.c:334): Unable to bind parameters
[1687186711] NDO-3: ndo_return = 1 (Statement not prepared)
[1687186711] NDO-3: ndo_handle_system_command(ndo-handlers.c:334): Unable to bind parameters
[1687186711] NDO-3: ndo_return = 1 (Statement not prepared)
[1687186711] NDO-3: ndo_handle_system_command(ndo-handlers.c:334): Unable to bind parameters
[1687186711] NDO-3: ndo_return = 1 (Statement not prepared)
[1687186711] NDO-3: ndo_handle_system_command(ndo-handlers.c:334): Unable to bind parameters

any thoughts?
Everybody is somebody else’s weirdo
kg2857
Posts: 233
Joined: Wed Apr 12, 2023 5:48 pm

Re: email issue: Unable to bind parameters & Statement not prepared

Post by kg2857 »

I'd guess the DB needs a repair.
Marilian
Posts: 5
Joined: Sun Jun 25, 2023 11:31 pm

Re: email issue: Unable to bind parameters & Statement not prepared

Post by Marilian »

All data that is not specific to the hosts is placed into one or more templates that I design. Then, have a script generate the template, hostname, and address into separate host.
amanda the adventurer
Post Reply