Quiet Release MySQL Plugin — Bug Fixes

Dec 11, 2012 / By Alex Gorbachev

Tags: , , , ,

This is just a small bug-fix release of the plugin. It has actually been quietly released for a while now. If you have downloaded the plugin recently, you have the latest version. To be sure, check the version in the Console, or you can see it in the file name.

There are two bugs fixed:
1. Deployment on an OMS hosted on Solaris didn’t work. (And I suspect it could be the same for Agents on Solaris.)
2. Changing thresholds on the metrics caused the error “Modification of Target Monitoring Settings has Failed”. Also, applying monitoring template was failing for the same reason.

If you didn’t know that you could setup threshold and customized the thresholds that are set out of the box with the plugin, then you are not fully using Enterprise Manager. You can do that in the MySQL target menu — Monitoring -> Metric and Collection Settings. When alert or warning conditions are met, Oracle EM can raise incidents and send notification according to your settings. As I stated above, had a bug that prevented users from changing the thresholds.

Same known issues exist as for release.
Useful links:

Follow the same deployment procedure for upgrade — (1) import into EM12c using EMCLI, (2) upgrade on OMS by deploying on OMS, (3) upgrade on Agents byt deploying on agents.

Happy monitoring!

Share this article

13 Responses to “Quiet Release MySQL Plugin — Bug Fixes”

  • Is is “Quite release” or “Quiet release”?

    Or maybe it was not really quite a quiet release? :-)

  • Rob says:

    This is excellent, Alex. Fixed the metric and template issues I has having with the previous version. And works with both OEM and Nice job!

  • Spiker says:

    Hi Alex,

    we are using your MySQL-Plugin with Cloud Control and are really excited.
    Sadly, there is one problem. The monitored MySQL databases logs a warning in the error log every five minutes:
    [Warning] Aborted connection 7011 to db: ‘unconnected’ user: ‘our_user’ host: ‘our_host’ (Got an error reading communication packets)

    Perhaps, is there a missing close_mysql_connection or something else?


  • Spiker says:

    Hi Alex,

    solved it. I omitted the REPLICATION CLIENT right. We doesn’t use replication, so i thought this user right isn’t necessary.


  • Anuj Chopra says:

    Hi Alex,

    I am getting 404 file not found, when trying to download the plugin. Also, can you confirm if I need to buy any licenses from oracle to use these plugins. Just to give a bit of background, I am currently using cloud control to monitor my oracle databases. I am using a base installation of OEM with diagnostic and tuning packs enabled for oracle.

    The Mysql databases that I am planning to add are all community editions and I do not have any support for the same.


    • Anuj: I’ll ask out web team to check download issue. Must have missed links update on web-site relaunch which we’ve just completed.

      Regarding the costs — any cost to run EM12c and monitor any targets that Oracle provides is your responsibility. The free version of the MySQL plugin itself downloaded from Pythian web-site does not have licensing fees. However, any other targets you monitor is a different story including monitoring the host itself where you are running the MySQL and local agent if you monitor MySQL by deploying the client on the host.

      Commercial support for MySQL plugin is available too if you are interested — just fill Contact Us form.

  • Hi Alex,

    We are using cloud control version . To add MySQL server we only see the option to add MySQL Instance and not the MySQL Database.
    How can we add the MySQL database also.


  • Florin says:

    Hi Alex,

    We have CC 12104 and we have recently added the MySQL plug-in and started to monitor some My SQL databases. When we look into the Incident Manager in Cloud Control, we see that the My SQL incidents are the only ones that don`t have a Category assigned and our incident and notification rules are based on that. Do you know why the My SQL incidents don`t have a category associated with an incident?


  • Sean S. says:

    Hey Alex,
    So I’m trying to deploy the MySQL plugin into 12cR3. I get the plugin imported to the library and when I get ready to Deploy to the OMS Server it keeps failing with “java.sql.SQLException: ORA-01017: invalid username/password; logon denied.” I’ve verified that I’m giving it the right SYS password for my EM repository and I’m able to log in to the repository as sys from sqlplus. Any thoughts on what the real problem could be.


Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>