DBI connect failed: Malformed packet at /usr/lib/nagios/plugins/check_mysql_performance line 489

mysql_performance
(rico.neumann) #1

Hello everyone,
I have a problem with the plugin check_mysql_perfomance. I had a new monitoringserver and all checks have to move from old to new. at the moment both servers are running in parallel, in the old one all checks are running. I suspect it is missing perlmodule. I have already compared all the installed cpan modules, none are missing.

the following error message appears:
DBI connect(‘host=IP’,‘XXX’,…) failed: Malformed packet at ./check_mysql_performance line 489.
even if in the CLI with the following command
./check_mysql_performance --metricname Connections -H IP -c 30 -p password -u XXX -w 20

Here are some configurations:

object Host “ito-sql” {
import “generic-linux”
address = “IP”
vars.location = “esn”
vars.mysql_hostname = address
vars.mysql_user = “user”
vars.mysql_password = “password”
vars.mysql_health_username = “user”
vars.mysql_health_password = “password”
vars.mysql_performance_hostname = address
vars.mysql_performance_user = “user”
vars.mysql_performance_password = “password”
vars.disk["/var/lib/mysql"] = {
disk_path = “/var/lib/mysql”}
vars.disk["/var/log"] = {
disk_path = “/var/log”}
vars.mysql_health[“bufferpool wait-free”] = {
mysql_health_mode = “bufferpool-wait-free”}
vars.mysql_health[“Connection-Time”] = {
mysql_health_mode = “connection-time”}
vars.mysql_health[“log-waits”] = {
mysql_health_mode = “log-waits”}
vars.mysql_health[“table-lock-contention”] = {
mysql_health_mode = “table-lock-contention”}
vars.mysql_health[“bufferpool wait-free”] = {
mysql_health_mode = “bufferpool-wait-free”}
vars.mysql_performance[“Connections”] = {
mysql_performance_metricname = “Connections”
mysql_performance_warning = “20”
mysql_performance_critical = “30”}
vars.mysql_performance[“InnoDB Log Pending Writes”] = {
mysql_performance_metricname = “Innodb_os_log_pending_writes”
mysql_performance_warning = “20”
mysql_performance_critical = “30”}
vars.mysql_performance[“InnoDB Waits”] = {
mysql_performance_metricname = “Innodb_log_waits”
mysql_performance_warning = “20”
mysql_performance_critical = “30”}
vars.procstate[“Apache2”] = {
procstate = “apache2”
proc_minwarn = “2”
proc_maxwarn = “150”
proc_mincrit = “2”
proc_maxcrit = “200”}
}

object CheckCommand “mysql_performance” {
import “plugin-check-command”
command = [ PluginDir + “/check_mysql_performance” ]
arguments = {
“-H” = “$mysql_performance_hostname$”
“-D” = “$mysql_performance_dsn$”
“-u” = “$mysql_performance_user$”
“-p” = “$mysql_performance_password$”
“-w” = “$mysql_performance_warning$”
“-c” = “$mysql_performance_critical$”
“-t” = “$mysql_performance_timeout$”
“–metricname” = “$mysql_performance_metricname$”
“–perfdata” = “$mysql_performance_perfdata$”
}

I hope anyone can help
Best regards Rico