Mar 24, 2012 2:06 AM
Setting up MySQL monitoring properly
-
Like (0)
Hi all.
I'm learning how to use zenoss really by stumbling around but I'm getting there. One thing I'm semi puzzled is I'm getting this error and I'm not sure how to fix it.
MySQL Error: (2003, "Can't connect to MySQL server on 'xx.xx.xx.xx' (113)")
(I remove my ip and replaced it with xx.xx.xx.xx of course. :-))
I thought I should go to this place to setup the mysql access configuration.
infrastructures>devices>configuration properties
zMySqlUsername
zMySqlPassword
Did I set it up correctly? If I did do I have to open up port 3306 in order for zenoss to monitor it? Which i hesitate doing of course and I'm hoping the snmp will take care of that..
Also under mysqlusername, do I just put the username as "username" or should I do"username@localhost"? Please advise? Many thanks in advance for all your help. :-) I'll get there one day. :-) Hopefully soon. :-)
You'll need to open up 3306, or use the MySQL SSH pack if you don't want to do that docs/DOC-5906
I believe username should just be username, without any "@localhost"
Roger that.
Thanks again dpetzel.. :-) I'll install the mysql ssh pack. Not a fan of opening up port since it can also be used by someone else for some other purpose that I may not like. :-)
Follow Us On Twitter »
|
Latest from the Zenoss Blog » | Community | Products | Services Resources | Customers Partners | About Us | ||
Copyright © 2005-2011 Zenoss, Inc.
|
||||||||