Hi there,
We have developed a parser that dumps access.log data from Squid to data into a MySQL table.
The bad thing is that we also needed to create some dinamic charting using PHP + JpGraph.
Our intention is to use only Zabbix charting tools.
Is is possible?
How could we extract data from this MySQL access log, dump data into
Zabbix table schemes and then be able to generate monitoring charts answering questions such as:
* who are the top 10 users (MB downloaded) of the month/day/last hour?
* what are the top 10 links (MB downloaded) of the month/day/last hour?
* who are the top departments/companies of the month/day/last hour?
(beyond basic info stored by access.log of squid, we also have created extra fields in MySQL
to store department of the user, and the company which department is linked to )
any comments will be appreciated.
thanks in advance
We have developed a parser that dumps access.log data from Squid to data into a MySQL table.
The bad thing is that we also needed to create some dinamic charting using PHP + JpGraph.
Our intention is to use only Zabbix charting tools.
Is is possible?
How could we extract data from this MySQL access log, dump data into
Zabbix table schemes and then be able to generate monitoring charts answering questions such as:
* who are the top 10 users (MB downloaded) of the month/day/last hour?
* what are the top 10 links (MB downloaded) of the month/day/last hour?
* who are the top departments/companies of the month/day/last hour?
(beyond basic info stored by access.log of squid, we also have created extra fields in MySQL
to store department of the user, and the company which department is linked to )
any comments will be appreciated.
thanks in advance