How to display items in charts

[LePascal]

Hello,

I'm using zabbix 2.0

I check 56 rooters by snmp. I can see all the WAN traffic (kbit/s in and out) on each rooter. The check is every 60s.

I need to make a synthetic chart of every rooter.
Each chart must indicate the average kbit/s with by hour.

That mean : from 8:00 to 9:00 we notice that kbit/s average is 120.
from 9:00 to 10:00 we notice that kbit/s average is 180.
etc...up to 18:00

How can y do this ?

[steveboyson]

Zabbix has no exact idea of "what is 8:00" but knows "what is one hour".

So if it is ok to have the average of the last hour (two hours, six hours, one day, and so on) you could work with calclulated items and the avg function.

But if you need the specifiv values for a particular given time period, you need to do some scripting with direct queries to the history_* tables of zabbix.

[LePascal]

Thanks for the response

Yes it's possible to make a checj each hour. But how can i displaiy the values in a chart ? Actually i just know how to display a graph, but not the values.

I tried to connetc on the mysql database. But y have the following error :

Error 1130. Host(my IP) is not allowed to connect to this MySQL server

[steveboyson]

So you want the previously achieved values in a report-like table and no charts/graphs?
That cannot be done directly.

For querying the database, you need to enable access before. See the mysql docs for that.

The gathered values are in different tables named history{_*}, according to the item's value-type. It is advisable to have a DB and/or SQL Pro onboard for that.

[LePascal]

Thanks.

I found the solution here for the MySQL access : http://www.thegeekstuff.com/2010/08/...nt-connection/

I'll try to understand the database now.

Thank you