hyperic-hq-discuss

[Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[smith K. <sma...@fi...>]

Two days ago i installed new hypericHQ 3.0 server and client on ubunu 6.10. and Solaris9
Before i have used hypericHQ 2.7 on the same servers.

I could monitor MYsql 5.0 Process(server) and Mysql 5.0 service(table, etc..) On Hyperic 2.7.
But there is no service of MySQL on Hyperic3.0
So to check why, i moved plugin/mysql-plugin.jar of 2.7 to mysql-plugin.jar of 3.0
Let me check agent.log and  server.log 
I found out this message on server.log

2007-03-13 09:44:32,531 INFO  [org.hyperic.hq.autoinventory.server.session.RuntimeReportProcessor] Processing Runtime AI Report: [CompositeRRR
        Report #0 from reporting server=10057:
                Platform #0 ID=null FQDN=sun.ficas.co.kr
                        Server #0 ID=10057 Name=sun Linux FileServer Stype=FileServer serviceCount=7
        Report #1 from reporting server=10055:
                Platform #0 ID=null FQDN=sun.ficas.co.kr
                        Server #0 ID=null Name=sun MySQL 5.x phpbb2 Stype=MySQL 5.x serviceCount=60
                        Server #1 ID=null Name=sun MySQL 5.x smf Stype=MySQL 5.x serviceCount=41
                        Server #2 ID=null Name=sun MySQL 5.x vanilla Stype=MySQL 5.x serviceCount=16
                        Server #3 ID=null Name=sun MySQL 5.x information_schema Stype=MySQL 5.x serviceCount=16
                        Server #4 ID=null Name=sun MySQL 5.x confluence Stype=MySQL 5.x serviceCount=27
                        Server #5 ID=null Name=sun MySQL 5.x vinilla Stype=MySQL 5.x serviceCount=0
                        Server #6 ID=null Name=sun MySQL 5.x mysql Stype=MySQL 5.x serviceCount=17
                        Server #7 ID=null Name=sun MySQL 5.x jiradb Stype=MySQL 5.x serviceCount=86
                        Server #8 ID=null Name=sun MySQL 5.x phpbb_db Stype=MySQL 5.x serviceCount=0


But i cann't watch any information on autodiscovery.

Please Help me.

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[Noah S. <noa...@hy...>]

When you wrote "there is not service of MySQL on Hyperic3.0" did you mean Server or Service or both?

In Hyperic HQ Server and Service are different things. If you go to Browse Resources are there any MySQL entries in either the Server or Service list?

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[smith K. <sma...@fi...>]

Mysql server is ok..Mysql 5.0 process is found on HyperHQ..
but there is service about Mysql table service...

This service is ok in HypericHQ 2.7

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[Chip W. <chi...@hy...>]

Was there a mysql-plugin.jar file in the plugin directory before you copied the 2.7 version into the 3.0 directory?

Were there any errors or was there any information in the logs about the MySQL auto-discovery process prior to your plugin change?

It might be interesting to restore the 3.0 plugin (if you still have it), and then initiate the MySQL discovery process in standalone mode from the command-line. You can do this by cd-ing into the agent directory, and issuing the following command from the command-line:

# java -jar pdk/lib/hq-product.jar -p mysql -m discover

The output may provide us with some clues.

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[smith K. <sma...@fi...>]

This is the result using mysql-plugin.jar in HypericHQ 3.0.1

java -jar ../lib/hq-product.jar -p mysql -m discover
1 servers detected

Server: sun MySQL Process 5.x [/usr]
 config...
 product..{process.query=State.Name.eq=mysqld}
 metric...null
 control..null

This is the result using mysql-plugin.jar in HypericHQ 2.7

java -jar ../lib/hq-product.jar -p mysql -m discover
1 servers detected

Server: sun MySQL Process 5.x [/usr]
 config...
 product..{process.query=State.Name.eq=mysqld}
 metric...null
 control..null

The results are same..But the there is no MYsql Service(table)  when use HypericHQ 3.0.1

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[Noah S. <noa...@hy...>]

You may need to set your configuration properties for MySQL. 

In HQ go to Browse Resources -> Servers and select your MySQL server. Then click the Configuration Properties link towards the bottom of the page. Click Edit to modify the configuration.

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[smith K. <sma...@fi...>]

Thanks Mr.(Or Ms.)Noah

>In HQ go to Browse Resources -> Servers and select your MySQL server. Then click the 
> Configuration Properties link towards the bottom of the page. Click Edit to modify the configuration.

i already did your suggestion...
let me change installed path and ID/Pass for mysql.

My point is

on the same system(ubuntu 6.10 and mysql 5.*) 
Hyperic 2.7 agent is ok
but HypericHQ 3.0 is not ok.

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[Charles L. <cl...@hy...>]

Hah!  Ms. Noah.

We have identified a possible bug with HQ 3.0 that potentially affects Server types which get auto-discovered.  It's logged as: http://jira.hyperic.com/browse/HHQ-765?page=all.

Charles

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[John S. <jo...@hy...>]

This problem has been fixed, the patch can be found in the JIRA issue  
Charles referenced earlier in the thread:

http://jira.hyperic.com/browse/HHQ-765

Re: [Hyperic-hq-discuss] No MYsql Service in HypericHQ 3.0.1

[John M. W. <joh...@hy...>]

Re:  MySQL configuration... what does it mean when it says "Enter the full path of the directory where the server software is installed." Does that mean, the full path where the data lives? Or is it where the mysqld binary lives? In my case, Ubuntu 6.06, the former is /var/lib/mysql and the latter is /usr/sbin/

Anyone? Bueler?