I got cacti running the mysql monitoring templates (http://mysql-cacti-templates.googlecode.com/files/better-cacti-templates-1.1.8.tar.gz). I have multiple servers with each running multiple mysql instances on different ports. I'm getting tons of errors along the lines of

"WARNING: Result from CMD not valid. Partial Result: MySQL: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 "

The weird thing is some of the checks are working properly. It doesn't seem to be 100% failure per host or per port.

What's going on?


It seems that you should check your ports configurations as well as try to increase maximum number of connections allowed by adding in your configuration file the following


where N is large enough. Then restart mysql. You can also see here (http://forums.cacti.net/viewtopic.php?f=21&t=44773). If it is your question there, probably it is better to post here that you've resolved your problem and what was the matter.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.