squid proxy server reporting directly in mysql

[benns1id]

how to connect a squid proxy server to generate logs in mysql directly the present scenario is squid proxy server generates log of acces in .txt notepad file i wanna directly make these log files in mysql so that it is better to go through them by the admin its for a college project any advice or help is useful

 

[stillblue]

how to connect a squid proxy server to generate logs in mysql directly the present scenario is squid proxy server generates log of acces in .txt notepad file i wanna directly make these log files in mysql so that it is better to go through them by the admin its for a college project any advice or help is useful

Don't know for that but if you install Sarg it will generate reports in html which are very good and could be viewed by your admins over the network.

 

[Alabalcho]

@Benn, do a proper Google/Bing/Yahoo search. Mine was "squid log mysql", and first couple of hits contained a solution.

It seems that the way to do this is to make Squid execute external program for logging, and this program in turn to write logs to a (MySql) database, or whatever.