SQUID Individual User reports email



  • I am looking for a solution which will allow individual user reports to be sent to a specific email address at a predefined time period.  Specifically, using PFSense/SQUID at a school, and automatically emailing student user reports on a weekly basis to parent's email address. If this is possible using PFSense, it will save the school thousands of $$.



  • @ritterskampj:

    I am looking for a solution which will allow individual user reports to be sent to a specific email address at a predefined time period.  Specifically, using PFSense/SQUID at a school, and automatically emailing student user reports on a weekly basis to parent's email address. If this is possible using PFSense, it will save the school thousands of $$.

    I do not know any good and easy solution for emailing things but for doing reports on squid access log you can use the SARG package on pfsense. Another package is "Mail reports" but I do not know what it mails. But perhaps it gives you a point to start an change some code and email reports from SARG package. As far as I know SARG reports are HTML sites.


  • Rebel Alliance Developer Netgate

    The mail reports package can run any custom command you want and the output is included in the e-mail inline as text, however it can only e-mail to one address (the one configured to receive notifications)

    That's not to say it someone couldn't use that code as a base to do what you're after. All the functionality is there to e-mail anywhere there's just not an option in the GUI to set that up. (to e-mail people, not to generate the user reports)

    If someone can come up with a way to make the reports per-user using a command line script, then the mail reports package could do what you're after with some modifications.


Log in to reply