I was trying to find a simple CLI tool (for Linux) to parse apache log, do some stats and create a plain text output with some simple aggregate data (ex: view counter). Then, this plain text output would be submitted to MySQL via cronjob.

The advantage I see by doing this way, is that the database would be hit outside the page request and in batches.

I could find several tools to plot graphs and do some realtime monitoring (ex: GoAccess, AWStats, ApacheTop ...), but none that would create a simple plain text output. Hence, I was left only with bad alternatives:

• Create myself a parser script using 'awk', 'grep', 'cut', 'sed', 'tail -f' ...
• Or, use LogStash. Which is an overkill for me.

Question

Any recommendation of a simple CLI tool to parse Apache Logs into plain text ?