vCenter

 View Only
  • 1.  Unable to configure MySQL or Oracle with SQL Query Plugin.

    Posted May 31, 2011 09:12 PM
    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


  • 2.  RE: Unable to configure MySQL or Oracle with SQL Query Plugin.

    Posted Dec 21, 2011 09:39 AM
    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.


  • 3.  RE: Unable to configure MySQL or Oracle with SQL Query Plugin.

    Posted Dec 29, 2011 01:40 PM
    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.