newer
[hobbit] BBtest

[hobbit] graphs with external script

older
User Contribution site?

Etienne.Roulland＠cvf.fr

16 Aug 2005 16 Aug '05

2:23 p.m.

Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day (16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE" and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

...

Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts : x.x.x.x box1.cvf.fr # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-07-25 11:25:56 RRD update param 04: '1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- Etienne Roulland -- CVF Bordeaux

Show replies by date

Etienne.Roulland＠cvf.fr

17 Aug 17 Aug

1:49 p.m.

Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i don't see GRAPHS tag but a TRENDS one anyway it doesn't seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

...

Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day (16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE" and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

...
Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts : x.x.x.x box1.cvf.fr # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-07-25 11:25:56 RRD update param 04: '1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- Etienne Roulland -- CVF Bordeaux

Etienne.Roulland＠cvf.fr

25 Aug 25 Aug

10:38 a.m.

Hi,

i'm sorry to insist.

Is anybody could show me the right way to graphs result from mysql test ?

My RRD files are updated, i have sql section in trends columns but no graphes..

Rgds,

Etienne

...

Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i don't see GRAPHS tag but a TRENDS one anyway it doesn't seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

...
Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day (16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE" and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

...
Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts : x.x.x.x box1.cvf.fr # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-07-25 11:25:56 RRD update param 04: '1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- Etienne Roulland -- CVF Bordeaux

etienne.grignon＠gmail.com

26 Aug 26 Aug

7:40 a.m.

Hi Etienne,

Did you put the name of your trends in the different configuration files ?

You should have add information in :

the rrd part in hobbitgraph.cfg the rrdstatus in hobbitlaunch.cfg the TEST2RRD and GRAPHS in hobbitserver.cfg

We have created different types of trends and it works well. We only customize he extra-rrd.sh to an perl script extra-rrd.pl from the existing hobbit distribution.

2005/8/25, Etienne Roulland <Etienne.Roulland at cvf.fr>:

...

Hi,

i'm sorry to insist.

Is anybody could show me the right way to graphs result from mysql test ?

My RRD files are updated, i have sql section in trends columns but no graphes..

Rgds,

Etienne

...
Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i don't see GRAPHS tag but a TRENDS one anyway it doesn't seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

...
Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day (16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE" and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

...
Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts : x.x.x.x box1.cvf.fr <http://box1.cvf.fr> # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03:

'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'

...
2005-07-25 11:25:56 RRD update param 04: '1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- Etienne Roulland -- CVF Bordeaux

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Etienne GRIGNON

Etienne.Roulland＠cvf.fr

1:38 p.m.

...

Hi Etienne,

Hi Etienne ;)

...

Did you put the name of your trends in the different configuration files ?

You should have add information in :

the rrd part in hobbitgraph.cfg

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

...

the rrdstatus in hobbitlaunch.cfg

[rrdstatus] ENVFILE /usr2/hobbit/server/etc/hobbitserver.cfg NEEDS hobbitd CMD hobbitd_channel --channel=status --log= $BBSERVERLOGS/rrd-status.log hobbitd_rrd --rrddir=$BBVAR/rrd --debug

My RRD files seem to be correctly updated:

2005-08-26 15:31:55 RRD update param 00: 'rrdupdate' 2005-08-26 15:31:55 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-26 15:31:55 RRD update param 02: '-t' 2005-08-26 15:31:55 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-26 15:31:55 RRD update param 04: '1125063115:211:359216582:801:30426:3:511:71.713'

...

the TEST2RRD and GRAPHS in hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv, $PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperat....

GRAPHS="la,mysql,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,apache,bind,sendmail....

But no graphes ...

Etienne

olivier＠qalpit.com

3:25 p.m.

Hi,

Are the mysql rrd file in the hobbit/data/rrd/ filesystem ? are they updated ?

are the "mysqlslow" and "mysqlthread" present in your $GRAPHS variable ?

Regards,

Olivier

Selon Etienne Roulland <Etienne.Roulland at cvf.fr>:

...

...
Hi Etienne,

Hi Etienne ;)

...
Did you put the name of your trends in the different configuration files ?

You should have add information in :

the rrd part in hobbitgraph.cfg

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

...
the rrdstatus in hobbitlaunch.cfg

[rrdstatus] ENVFILE /usr2/hobbit/server/etc/hobbitserver.cfg NEEDS hobbitd CMD hobbitd_channel --channel=status --log= $BBSERVERLOGS/rrd-status.log hobbitd_rrd --rrddir=$BBVAR/rrd --debug

My RRD files seem to be correctly updated:

2005-08-26 15:31:55 RRD update param 00: 'rrdupdate' 2005-08-26 15:31:55 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-26 15:31:55 RRD update param 02: '-t' 2005-08-26 15:31:55 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-26 15:31:55 RRD update param 04: '1125063115:211:359216582:801:30426:3:511:71.713'

...
the TEST2RRD and GRAPHS in hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv,

$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperat....

...

GRAPHS="la,mysql,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,apache,bind,sendmail....

...

But no graphes ...

Etienne

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Olivier Beau

Etienne.Roulland＠cvf.fr

3:57 p.m.

Hi,

...

Are the mysql rrd file in the hobbit/data/rrd/ filesystem ? are they updated ?

Yep.

...

are the "mysqlslow" and "mysqlthread" present in your $GRAPHS variable ?

Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

and

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

Etienne

olivier＠qalpit.com

4:35 p.m.

...

Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

Etienne.Roulland＠cvf.fr

5:46 p.m.

Olivier Beau wrote:

...

...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

TRENDS in man but doesn't seems to be regognized by hobbit, i found an Henrik's post which said GRAPHS. Any way i tried both without success. When i look into the info status of hoobit i see "Other tags:GRAPHS:*,mysql:mysqlslow,mysqlthread" with GRAPHS tag and nothing with TRENDS....

...

...
a,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Not better...

Etienne.Roulland＠cvf.fr

5:50 p.m.

Oupps last mail was sent a little bit quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

...

...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...
in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

liu-zm＠neusoft.com

29 Aug 29 Aug

3:52 a.m.

New subject: graphs with external script

the /var/log/larrd-status.log : 2005-08-29 11:46:25 RRD error updating /home/monitor/data/rrd/proxy.neusoft.com/concurrent.rrd from 192.168.20.87: illegal attempt to update using time 1125287185 when last update time is 1125287185 (minimum one second step) what is it? thank you

Etienne.Roulland＠cvf.fr

9:37 a.m.

Hi,

i've checked ont more time my setting and still see where i made a mistake...

I use this night snapshot, my rrd files are updated as i can see :

2005-08-29 11:11:36 RRD update param 00: 'rrdupdate' 2005-08-29 11:11:36 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-29 11:11:36 RRD update param 02: '-t' 2005-08-29 11:11:36 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-29 11:11:36 RRD update param 04: '1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have

In my bb-hosts:

10.1.1.8 sql-test.cvf # noping TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne

On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

...

Oupps last mail was sent a little bit quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

...
...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...
in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Etienne Roulland -- CVF Bordeaux

eroulland＠cvf.fr

2 Sep 2 Sep

9:15 p.m.

Hi,

sorry for boring everybody with my problem..

But i made all check that i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..

Etienne

...

Hi,

i've checked ont more time my setting and still see where i made a mistake...

I use this night snapshot, my rrd files are updated as i can see :

2005-08-29 11:11:36 RRD update param 00: 'rrdupdate' 2005-08-29 11:11:36 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-29 11:11:36 RRD update param 02: '-t' 2005-08-29 11:11:36 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-29 11:11:36 RRD update param 04: '1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

In my bb-hosts:

10.1.1.8 sql-test.cvf # noping TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne

On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

...
Oupps last mail was sent a little bit quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

...
...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...
in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

Etienne.Roulland＠cvf.fr

6 Sep 6 Sep

9:28 a.m.

Hi ..

I'm using 2 versions of hobbit today (09/06) snapshot and 4.1.1.

Is anybody could just answer me what can be wrong in my setting ? I have my rrd files updated, got "mysql" section on trends columns.. All seems ok there.

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=disk&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> show me disk trends

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> "Unknown graph requested"

(I have [mysqlslow] & [mysqlthread] in my hobbitgraph.cfg)

Please... I have checked many many many times all my config and still not see where i could make a mistake.

Maybe a bug ?

Heeeeelp

rgds,

Etienne

...

Hi,

sorry for boring everybody with my problem..

But i made all check that i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..

Etienne

...
Hi,

i've checked ont more time my setting and still see where i made a mistake...

I use this night snapshot, my rrd files are updated as i can see :

2005-08-29 11:11:36 RRD update param 00: 'rrdupdate' 2005-08-29 11:11:36 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-29 11:11:36 RRD update param 02: '-t' 2005-08-29 11:11:36 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-29 11:11:36 RRD update param 04: '1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

In my bb-hosts:

10.1.1.8 sql-test.cvf # noping TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne

On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

...
Oupps last mail was sent a little bit quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

...
...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...
in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Etienne Roulland -- CVF Bordeaux

Etienne.Roulland＠cvf.fr

10:07 a.m.

New subject: [SEGFAULT] Re: [hobbit] graphs with external script

Re hi,

with the help of Nicolas Figaro (many thanks to him)

with the real hostname (got the stupid idea of trying to mask real ones....) i got a segmentation fault...

QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh Segmentation fault

Regards,

On Tue, 2005-09-06 at 11:28 +0200, Etienne Roulland wrote:

...

Hi ..

I'm using 2 versions of hobbit today (09/06) snapshot and 4.1.1.

Is anybody could just answer me what can be wrong in my setting ? I have my rrd files updated, got "mysql" section on trends columns.. All seems ok there.

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=disk&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> show me disk trends

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> "Unknown graph requested"

(I have [mysqlslow] & [mysqlthread] in my hobbitgraph.cfg)

Please... I have checked many many many times all my config and still not see where i could make a mistake.

Maybe a bug ?

Heeeeelp

rgds,

Etienne

...
Hi,

sorry for boring everybody with my problem..

But i made all check that i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..

Etienne

...
Hi,

i've checked ont more time my setting and still see where i made a mistake...

I use this night snapshot, my rrd files are updated as i can see :

2005-08-29 11:11:36 RRD update param 00: 'rrdupdate' 2005-08-29 11:11:36 RRD update param 01: '/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd' 2005-08-29 11:11:36 RRD update param 02: '-t' 2005-08-29 11:11:36 RRD update param 03: 'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg' 2005-08-29 11:11:36 RRD update param 04: '1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have

[mysqlslow] DEF:slow=mysql.rrd:Slowqueries:AVERAGE TITLE MySQL Slow Queries LINE2:slow#00CCCC:Slow Queries COMMENT:\n GPRINT:slow:LAST: \: %5.1lf (cur) GPRINT:slow:MAX: \: %5.1lf (max) GPRINT:slow:MIN: \: %5.1lf (min) GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread] DEF:threads=mysql.rrd:Threads:AVERAGE TITLE MySQL Active Threads AREA:threads#00CCCC:Threads COMMENT:\n GPRINT:threads:LAST: \: %5.1lf (cur) GPRINT:threads:MAX: \: %5.1lf (max) GPRINT:threads:MIN: \: %5.1lf (min) GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

In my bb-hosts:

10.1.1.8 sql-test.cvf # noping TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne

On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

...
Oupps last mail was sent a little bit quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

...
...
Options in bb-hosts for this box

noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

...
in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Olivier

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Etienne Roulland -- CVF Bordeaux

henrik＠hswn.dk

21 Sep 21 Sep

1:58 p.m.

New subject: [hobbit] [SEGFAULT] Re: [hobbit] graphs with external script

In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> writes:

...

QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must provide all of the environment variables that the webserver normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment variable to be set. So:

QUERY_STRING="host=...." export QUERY_STRING REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}" export REQUEST_URI ./hobbitgraph.sh

Henrik

rower.master＠gmail.com

23 Sep 23 Sep

6:20 p.m.

New subject: [hobbit] [SEGFAULT] Re: [hobbit] graphs with external script

Henrik, I'm already generating a graph for my ext clientside script in the trends column, but I would like to show the first graph(last 48 hours) in the service column page. I've put this line into the ext script GRAP="<A HREF=/hobbit-cgi/hobbitgraph.sh host=express&service=synclog&disp=express&action=menu><IMG BORDER=0 SRC=/hobbit-cgi/hobbitgraph.sh?host=express&service=synclog&disp=express&graph=hourly&action=view

...

</a>" and $BB $BBDISP "status $MACHINE.$TEST $COLOR $DATE - $STATUS - $STATUS1 $L2 $GRAP" This show the graph but starts some erros of DS in the larrd-status.log Any hint or a easy and clean way? Thanks in advance my friend, Mario. On 9/21/05, Henrik Storner <henrik at hswn.dk> wrote:

In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland < Etienne.Roulland at cvf.fr> writes:

...
QUERY_STRING="host= sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must provide all of the environment variables that the webserver normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment variable to be set. So:

QUERY_STRING="host=...." export QUERY_STRING REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}" export REQUEST_URI ./hobbitgraph.sh

Henrik

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

Etienne.Roulland＠cvf.fr

29 Sep 29 Sep

3:55 p.m.

New subject: [hobbit] [SEGFAULT] Re: [hobbit] graphs with external script

Thanks Henrik,

2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph ncv, but no graph-definition

I've add [mysql] DEF:questions=mysql.rrd:Questions:AVERAGE TITLE MySQL Request AREA:questions#00CCCC:Questions COMMENT:\n GPRINT:questions:LAST: \: %5.1lf (cur) GPRINT:questions:MAX: \: %5.1lf (max) GPRINT:questions:MIN: \: %5.1lf (min) GPRINT:questions:AVERAGE: \: %5.1lf (avg)\n

after the :

Nothing changed..

On Wed, 2005-09-21 at 13:58 +0000, Henrik Storner wrote:

...

In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> writes:

...
QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must provide all of the environment variables that the webserver normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment variable to be set. So:

QUERY_STRING="host=...." export QUERY_STRING REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}" export REQUEST_URI ./hobbitgraph.sh

Henrik

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Etienne Roulland -- CVF Bordeaux

henrik＠hswn.dk

8:13 p.m.

New subject: [hobbit] [SEGFAULT] Re: [hobbit] graphs with external script

In <1128009355.7465.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> writes:

...

2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph ncv, but no graph-definition

...

I've add [mysql]

Add ",mysql" to the GRAPHS setting in hobbitserver.cfg.

Henrik

Etienne.Roulland＠cvf.fr

8:20 p.m.

New subject: [hobbit] [SEGFAULT] Re: [hobbit] graphs with external script

This is my GRAPHS line:

GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,appache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,mysql"

I already have the mysql entry..

Etienne

Henrik Storner wrote:

...

In <1128009355.7465.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> writes:

...
2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph ncv, but no graph-definition

...
I've add [mysql]

Add ",mysql" to the GRAPHS setting in hobbitserver.cfg.

Henrik

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

7573

Age (days ago)

7617

Last active (days ago)

List overview

Download

19 comments

7 participants

participants (7)

eroulland＠cvf.fr
etienne.grignon＠gmail.com
Etienne.Roulland＠cvf.fr
henrik＠hswn.dk
liu-zm＠neusoft.com
olivier＠qalpit.com
rower.master＠gmail.com