Bug 537203

Summary: MySQL plugin don't collect data from databases
Product: [Other] RHQ Project Reporter: Rodrigo A B Freire <rfreire>
Component: PluginsAssignee: RHQ Project Maintainer <rhq-maint>
Severity: low Docs Contact:
Priority: low    
Version: 1.3.1Keywords: SubBug
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
JON server 2.3.0
Last Closed: 2012-06-06 12:17:52 EDT Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
Bug Depends On:    
Bug Blocks: 565628    
Description Flags
agent.log from Jon Agent none

Description Rodrigo A B Freire 2009-11-12 14:25:39 EST
Description of problem:
The MySQL plugin (downloaded from https://www.jboss.org/community/wiki/jopr-releases) does not correcty add its database childs, altough the Server has the metrics collected, plotted and its availability computed. 

Version-Release number of selected component (if applicable):
JON 2.3.0
Jopr 2.3.1 (where I downloaded the plugin)

How reproducible:
See below. Same issue on two different JON servers (same release, same steps)

Steps to Reproduce:
1. Set up an MySQL on your machine. Assign an password for the root user.
2. Ensure that you have Abstract Database plugin on your JON Server
3. Add the rhq-mysql-plugin-1.3.1.jar to your plugin collection
4. On Platform, click on the computer platform and select its inventory
5. Scroll down the screen and on the "Manually Add", select MySql Server" (notice: it is not automatically detected by discovery routines) and click OK
6. Set up your database settings. Don't forget to change the MySql "Database Name" to mysql (case-sensitive). Set your root/password on the role name & password. Click OK.
7. Expand the MySql [mysql] server and you'll notice "Database (n)" as red
8. Expand the "Database (n)" category and click on any database. 

Actual results:
You'll notice that the availability tick on the right upper corner is set to an gray question mark and the "Database (n)" category is red colored.

Expected results:
The databases are supposed to be green colored and have its metrics correctly collected.

Additional info:
irc #jboss-on RodFreire
Comment 1 Rodrigo A B Freire 2009-11-12 14:40:19 EST
Created attachment 369302 [details]
agent.log from Jon Agent

Debug level
Comment 2 wes hayutin 2010-02-16 11:57:09 EST
Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs.

new = Tracking + FutureFeature + SubBug
Comment 3 wes hayutin 2010-02-16 12:02:10 EST
making sure we're not missing any bugs in rhq_triage
Comment 4 Corey Welton 2010-10-05 09:08:22 EDT
Lowering severity/priority - not an enterprise plugin
Comment 5 Heiko W. Rupp 2010-10-18 05:29:29 EDT
I've just pushed and update to the MySQL plugin by Steve Millidge 

Can you please check if your issue has vanished?
Comment 6 Heiko W. Rupp 2012-06-06 12:17:52 EDT
I think the plugin update from Steve has fixed this issue a long time ago -