I have installed MySQL 5.1 on a Red hat machine, but the hyperic agent autodiscovered MySQL as MySQL Stats 4.1.x.
I am not able to get the metrics of MySQL..
The following Error is being logged at agent.log
2009-04-26 06:50:10,963 INFO [Thread-1] [RuntimeAutodiscoverer] Running runtime autodiscovery for Net Services
2009-04-26 06:50:10,967 INFO [Thread-1] [RuntimeAutodiscoverer] Net Services discovery took 0
2009-04-26 06:50:10,967 INFO [Thread-1] [RuntimeAutodiscoverer] Running runtime autodiscovery for MySQL Stats 4.1.x
2009-04-26 06:50:10,973 ERROR [Thread-1] [RuntimeAutodiscoverer] Unexpected error running autodiscoverer for plugin: MySQL Stats 4.1.x: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
org.hyperic.hq.product.PluginException: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at org.hyperic.hq.plugin.mysql_stats.MySqlServerDetector.discoverServices(MySqlServerDetector.java:118)
at org.hyperic.hq.product.ServerDetector.discoverResources(ServerDetector.java:203)
at org.hyperic.hq.autoinventory.agent.server.RuntimeAutodiscoverer.doRuntimeScan_internal(RuntimeAutodiscoverer.java:272)
at org.hyperic.hq.autoinventory.agent.server.RuntimeAutodiscoverer.doRuntimeScan(RuntimeAutodiscoverer.java:205)
at org.hyperic.hq.autoinventory.ScanManager.mainRunLoop(ScanManager.java:165)
at org.hyperic.hq.autoinventory.ScanManager.access$000(ScanManager.java:41)
at org.hyperic.hq.autoinventory.ScanManager$1.run(ScanManager.java:107)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3340)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.hyperic.hq.plugin.mysql_stats.MySqlServerDetector.getConnection(MySqlServerDetector.java:185)
at org.hyperic.hq.plugin.mysql_stats.MySqlServerDetector.discoverServices(MySqlServerDetector.java:113)
... 6 more
2009-04-26 06:50:10,974 INFO [Thread-1] [RuntimeAutodiscoverer] Running runtime autodiscovery for HQ Agent
2009-04-26 06:50:11,007 INFO [Thread-1] [RuntimeAutodiscoverer] HQ Agent discovery took 0
2009-04-26 06:50:11,007 INFO [Thread-1] [RuntimeAutodiscoverer] Running runtime autodiscovery for Tomcat 6.0
2009-04-26 06:50:11,013 ERROR [Thread-1] [RuntimeAutodiscoverer] Unexpected error running autodiscoverer for plugin: Tomcat 6.0: Unable to get MBean info: Incorrect response from monitored server
org.hyperic.hq.product.PluginException: Unable to get MBean info: Incorrect response from monitored server
at org.hyperic.hq.plugin.servlet.ServletDiscoveryPlugin.getMBeanInfo(ServletDiscoveryPlugin.java:111)
at org.hyperic.hq.plugin.servlet.Tomcat60RuntimeADPlugin.discoverResources(Tomcat60RuntimeADPlugin.java:75)
at org.hyperic.hq.autoinventory.agent.server.RuntimeAutodiscoverer.doRuntimeScan_internal(RuntimeAutodiscoverer.java:272)
at org.hyperic.hq.autoinventory.agent.server.RuntimeAutodiscoverer.doRuntimeScan(RuntimeAutodiscoverer.java:205)
at org.hyperic.hq.autoinventory.ScanManager.mainRunLoop(ScanManager.java:165)
at org.hyperic.hq.autoinventory.ScanManager.access$000(ScanManager.java:41)
at org.hyperic.hq.autoinventory.ScanManager$1.run(ScanManager.java:107)
thanks
