Return code of 255 is out of bounds

[Box293]

Thanks for those.

We'll get you to send through an email to [email protected] as I want to look at some more sensitive information which I won't get you to post here.

Along with the email can you please send me your system profile:

• Click the Admin menu
  System Config > System Profile
  Click the Download Profile button and send us that file

[lmiltchev]

Hm-m, this is strange. Is the postgres database local or on a remote server? Did you add the Nagios XI server's IP to the "trusted connections" in the "/var/lib/pgsql/data/pg_hba.conf"?

I haven't been able to recreate the issue. I am using check_postgres.pl version 2.12.0.

My check works from the CLI:

Code: Select all

/usr/local/nagios/libexec/check_postgres.pl -H 192.168.4.127 --port=5432 --dbuser=nagiosxi --dbname=postgres --dbpass="nagiosxi" --action=connection
POSTGRES_CONNECTION OK: DB "postgres" (host:192.168.4.127) version 8.4.13 | time=0.01

and also in the GUI:

example01.PNG

[iptribe]

Hi Box293,

I have sent you the system profile to your [email protected], and let me know if you need more information.

Hi lmiltchev,

Yup, I know it's very weird. I have installed postgresql server(without implement high availability)on another host in my lab and my lab nagiosxi is successfully monitor it.
However, on the production environment the postgresql server is implemented with high availability (two host server share a virtual ip). Is it this feature causing this issue?

[lmiltchev]

I have sent you the system profile to your [email protected], and let me know if you need more information.

We haven't received your email, yet. What email did you send your message from? If your email is not in our system, your message will bounce back.

[iptribe]

Hi lmiltchev,

My email did rejected by Nagios team. Anyway, my email is [email protected]

Is there any way to accept my emails?

[iptribe]

Hi all,

I think I found out the issue which causing this problem. This is due to the database password contains some special characters such as "!,$,&,(,)", you can try it on your Postgresql database and see the output.E.g."Abc1234$" as your database password.

Any ideas how to fix this?

[abrist]

You may need to use user macros to use strings with special characters:
http://assets.nagios.com/downloads/nagi ... Macros.pdf

[iptribe]

Thanks everyone, after using the user macros everything is working fine.