VMware Cloud Community
feda_hyperic
Contributor
Contributor

Hyperic cannot find mysqld process

Hyperic HQ ver. 3.1.1-490-x86-linux
cannot find mysqld process while configuring "Configuration Properties" of MySQL Process 5.x
process query=State.Name.eq=mysqld
jdbcUrl=jdbc:mysql://localhost/mysql

it says:

"The configuration has not been set for this resource due to : Invalid configuration: Error retrieving value: Failed to invoke getProcCpu[State.Name.eq=mysqld]: Query did not match any processes: State.Name.eq=mysqld"

But mysqld is running:
[root@db agent-3.1.1]# ps ax|grep mysql
5832 pts/0 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql...
5865 pts/0 Sl 1:50 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql...

Please help !
0 Kudos
3 Replies
feda_hyperic
Contributor
Contributor

I found workaround:
Changed process query to "Pid.PidFile.eq=/var/run/mysqld.pid"
0 Kudos
JohnMarkOrg
Hot Shot
Hot Shot

Excellent - glad that worked for you. What distro are you using? I'm running Ubuntu 7.04, which has a similar MySQL setup, but I don't recall seeing this error.

-John Mark
0 Kudos
feda_hyperic
Contributor
Contributor

Distro is
CentOS release 4.4 (Final) (kern. 2.6.9-023stab044.4-enterprise)
mysql Ver 14.12 Distrib 5.0.27
0 Kudos