pcp
[Top] [All Lists]

Re: [pcp] PCP 3.6.9 and the mysql pmda

To: Nathan Scott <nathans@xxxxxxxxxx>
Subject: Re: [pcp] PCP 3.6.9 and the mysql pmda
From: Chandana De Silva <chandana@xxxxxxxxxxxxx>
Date: Thu, 01 Nov 2012 21:31:32 +1100
Cc: pcp@xxxxxxxxxxx
In-reply-to: <980055469.20169025.1351762391414.JavaMail.root@xxxxxxxxxx>
References: <980055469.20169025.1351762391414.JavaMail.root@xxxxxxxxxx>
Reply-to: chandana@xxxxxxxxxxxxx
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121011 Thunderbird/16.0.1
On 01/11/12 20:33, Nathan Scott wrote:
$ sudo /sbin/chkconfig --list  | grep pcp
$ sudo /sbin/chkconfig --list  | grep pmcd
pmcd           	0:off	1:off	2:on	3:on	4:on	5:on	6:off
$ sudo /sbin/chkconfig --list  | grep pmlogger
pmlogger       	0:off	1:off	2:on	3:on	4:on	5:on	6:off

Or it might be something else entirely.
sudo /sbin/chkconfig --list|  egrep "pcp|pmcd|pmlogger"
pmcd            0:off   1:off   2:on    3:on    4:on    5:on    6:off
pmlogger        0:off   1:off   2:on    3:on    4:on    5:on    6:off

So, (this is a puppet issue) do I stipulate that there is no service named "pcp", and that instead of managing the "pcp" service, puppet should manage the "pmcd" and "pmlogger" services ?
> 
*nod*

> Is this clearly explained somewhere ?. I am not sure if I am reading
> the
> correct document at
> http://techpubs.sgi.com/library/tpl/cgi-bin/getdoc.cgi?coll=0650&db=bks&srch=&fname=/SGI_Developer/PCP_PG/sgi_html/ch02.html#id5189820
> 
Yep, thats a good source.  Usually I just see what another pmda
(linux) does in the same situation, when I have to remind myself
on the order of those fields.
I will go through the new variables very carefully and send you an update.

The change you asked me to test works, but I am not sure of the significance.
<nathans> diff --git a/src/pmdas/mysql/pmdamysql.pl b/src/pmdas/mysql/pmdamysql.pl
<nathans> index 71e7dfb..fa9e6dd 100644
<nathans> --- a/src/pmdas/mysql/pmdamysql.pl
<nathans> +++ b/src/pmdas/mysql/pmdamysql.pl
<nathans> @@ -1755,6 +1755,7 @@ $pmda->add_indom($process_indom, \@process_instances,
<nathans>  $pmda->set_fetch_callback(\&mysql_fetch_callback);
<nathans>  $pmda->set_fetch(\&mysql_connection_setup);
<nathans>  $pmda->set_refresh(\&mysql_refresh);
<nathans> +$pmda->set_user('mysql');
<nathans>  $pmda->run;
I am assuming that the pmda is going to run under the mysql os account. You still need a login/password for the database. I do not think mysql has 'trusted' users in the same way that PostgreSQL has. Also, there is no gurantee that there will always be a mysql os user.

Chandana

<Prev in Thread] Current Thread [Next in Thread>