Unable to configure MySQL or Oracle with SQL Query Plugin.

[jawedkhan]

I am unable to configure MySQL or Oracle with SQL Query Plugin. I am able to see the New Platform Service on the Tools menu. I am able to get the Inventory page for the new service appears which is in step 4 under http://support.hyperic.com/display/DOC/SQL+Query+Plugin.

When I Edit in the "Configuration Properties", it showing only jdbcPassword.
After entering the password, when I click on OK button, it comes back with
The configuration has not been set for this resource due to : Invalid configuration: Error reported by Agent @ 10.16.52.240:-1: Timeout occurred waiting on agent response.

Below is mysqlclrrepo-plugin.xml for mysql version.
<plugin>
<service name="MySQLRepo">

<config>
<option name="jdbcDriver"
description="JDBC Driver Class Name"
default="com.mysql.jdbc.Driver"/>
<option name="jdbcUrl"
description="JDBC Connection URL"
default="jdbc:mysql://myserver.dev.com:3306/metric_dev"/>
<option name="funcuser"
description="JDBC User"/>
<option name="abc123" type="secret"
optional="true"
description="JDBC Password"/>

</config>

<metric name="ServerMethodName"
template="sql:SELECT COUNT(*) FROM METRIC_L0_25"
indicator="true"/>

</service>
</plugin>

server-4.5.1.2-EE
agent-4.5.1.2-EE
WindowsXP
Java 1.6.0_23

[marc4242]

Hi, I also get a timeout error when trying to enter my username and password for the jdbc connection, any suggestions as to what to look for? I can successfully connect to the database using the database client tool.

[silverrain]

Did you try using the db-root-user (root) as username?
If root works, it's most likely a problem with the user's permissions.