CRITICAL - cannot connect to information_schema. Unknown

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
dbasupport
Posts: 12
Joined: Tue Oct 08, 2019 11:48 am

CRITICAL - cannot connect to information_schema. Unknown

Post by dbasupport »

Hi Team ,

I unable to configure the monitors on the Maria DB through Nagios ,getting below error .
I am able to login with user mysql_monitor and its password locally on the server but through Nagios application throwing below error


[[email protected] ~]$ /usr/local/nagios/libexec/check_mysql_health --hostname=IPRFDECSQABD01 --port=3306 --username=mysql_monitor --password="********* " --database=information_schema --mode connection-time --warning 1 --critical 5
CRITICAL - cannot connect to information_schema. Unknown MySQL server host '' (2)
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: CRITICAL - cannot connect to information_schema. Unknown

Post by dchurch »

/usr/local/nagios/libexec/check_mysql_health --hostname=IPRFDECSQABD01
The --hostname argument needs to be a resolvable address. Unless you're using some different (NIS+, yp, wins) methods of looking up hosts, this should be set to the fully qualified DNS or IP address of the MySQL server.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Locked