Page 1 of 1

CRITICAL - cannot connect to information_schema. Unknown

Posted: Thu Nov 19, 2020 6:22 am
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)

Re: CRITICAL - cannot connect to information_schema. Unknown

Posted: Thu Nov 19, 2020 4:28 pm
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.