Apache SQL analyser Apache SQL analyser can query Apache logfiles via SQL.
Download

Apache SQL analyser Ranking & Summary

Apache SQL analyser Tags

SQL log analyzer logger Apache Apache logger SQL logs

Apache SQL analyser Description

Apache SQL analyser can query Apache logfiles via SQL. Apache SQL analyser can query Apache logfiles via SQL.asql is a simple console shell which allows you to run SQL queries against an Apache logfile, something that can be very useful - especially at getting information which is not easily available via static logfile analysers.An overview of the usage of the shellOnce installed, either via the package or via the source download, please start the shell by typing "asql".Once the shell starts you have several commands available to you, enter help for a complete list. The three most commonly used commands would be:loadThis will load an Apache logfile into the temporary database which is created at startup. Single files, or globs are accepted so you may run something like this:load /var/log/apache2/acces*To save time parsing the input files more than once you may saving the resulting database with save and later restore it.selectThis allows you to run an actual query.showThis shows the table structure the logfile was parsed into.A sample sessionThe following sample session provides a demonstration of typical usage of the shell, it demonstrates the use of the alias command which may be used to create persistent aliases:asql v0.6 - type 'help' for help.asql> load /home/skx/hg/engaging/logs/access.logLoading: /home/skx/hg/engaging/logs/access.logsasql> select COUNT(id) FROM logs46asql> alias hits SELECT COUNT(id) FROM logsALIAS hits SELECT COUNT(id) FROM logsasql> alias ips SELECT DISTINCT(source) FROM logs;ALIAS ips SELECT DISTINCT(source) FROM logs;asql> hits46asql> aliasALIAS hits SELECT COUNT(id) FROM logsALIAS ips SELECT DISTINCT(source) FROM logs;(User-input is in bold for emphasis) What's New in This Release: · This release ensures that when importing Apache logs into the temporary SQL table that the HTTP status code is treated as an integer and not a string.

Apache SQL analyser Related Software