Objective: create downloadable PDF reports

The user should choose between a full report or sleecting the modules in which he is interested. He must also choose the time priod of the report.

Report contents

• the graphs and tabular data for the modules and the time period selected.
• aletrs for the modules selected
• summary page of the server. This has the problem that in the timeperiod the configuration can change several times. One option is to use the actual and forget from previous changes. This is easiest bz old changes are NOT recorded.
• tops for web proxy

Contents by module

antivirus

• we can put the last av database update

asterisk

• calls. Currently there is not log of this

ca

• we can put the expiration datqa of the CA certificate

captiveportal

• accesses. Currently there is not log

dhcp

• log whcih contain leases and realeases. Cuurently is not summarizes so we had to summarize it first

dns

• requests. Currently there is not log

ebackup

• it would be cool to have the dates of the last backups. However at the moment there is not any log.

egroupware

• access dato. Not log implemented

firewall

• summarized log data (dropped packets)

ids

• summarized log (number of alerts)
• top acttackers and attack types (this ata is not currently logged)

improxy

• traffic summary. Currently there is not log

jabber

• traffic summary. Currently there is not log

l7-protocols

mail

• log data., currently not summarized. We could sumamrize it to show the aggregate number of messages sent and received.

mailfilter

• summarized report of smtp filter (number of messags in each category)
• summarized report of transaprent pop filter (number of messags in each category)

monitor

• monitoring graphics. They are system load, cpu usage, file system usage and physical emmory usage They re stored as rrds.

network

• speed conneciton (feature neither implemented nor logged)

ntp

• wether is enabled and which ntp sever we are using

objects

*nothing to report here

openvpn

• "Client Connection" and "Connection to server" events. Currently the logs are not summarized
• speed connection in each VPN (feature neither implemented nor logged)
• total traffic size in each VPN (feature neither implemented nor logged)

printers

• "Queued" log events. Currently arent summarized

radius

• Number of successful and failed authorizations?. Currenty ther isnt log

remoteservices

• Status of subscription. Time left in subscription?

samba

• Samba access logs. Currently not summarized
• Samba antivirus logs. Currently not summarized
• Samba quarantine logs. Currently not summarized

services

• Nothing here...

software

• show the version numbers of ebox components and whether updates are avaialble
• we can give the number of system packages needing updating or list them

squid

• summarized request data
• tops:

Tops for web proxy

• 10, 20 or 25 more visited domains
• for each domain 10 user whom visted the most?. This schema ha sconsolidation problems bz the inherent data loss but could do the trick
• top of N user which most visit banend and filtered domains
• it may be good idea to be able to specify domain exceptions to the top list (i.e: intranet site, punch-in application, etc)

trafficshaping

usersandgroups

• Slave or master mode
• log slave oeprations?
• number of users and groups

webserver

• number of accesses. Currently there is not log

Send automatic report

Maybe it would be a good idea to autmatically email the report to configured addreses, allowing in this fashion some mon itorization without having real administraction access

PDF creation

Seeing the difficult to use PDF::Creator and the like, we will try to create a html and then use html2pdf or some similair tool to convert to PDF.

Graphs

We use a JS library to generate graphs that could not export to any graphical file so we must look for other method to plot our data. The data itself is stored in a postgresql database so we can use a external tool.

Perl is lacking of "pretty" plot libraries (we have used i nthe past the Chart perl library) so we will not use a perl package.

One option would be to ocnvert the data to rrd and use the library already develoepd to export in PNG format, but I will rather to avoid the data conversion to rrd.

Other options:

• gnuplot
• sphinx