Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.543.299 Times

Apache SQL analyser 1.5

Company: Steve Kemp
Date Added: August 19, 2013  |  Visits: 179

Apache SQL analyser

Report Broken Link
Printer Friendly Version


Product Homepage
Download (18 downloads)



Apache SQL analyser can query Apache logfiles via SQL.<br /><br />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.<br /><br />An overview of the usage of the shell<br /><br />Once installed, either via the package or via the source download, please start the shell by typing "asql".<br /><br />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:<br /><br />load<br /><br />This 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:<br /><br />load /var/log/apache2/acces*<br /><br />To save time parsing the input files more than once you may saving the resulting database with save and later restore it.<br /><br />select<br /><br />This allows you to run an actual query.<br /><br />show<br /><br />This shows the table structure the logfile was parsed into.<br /><br />A sample session<br /><br />The 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:<br /><br />asql v0.6 - type 'help' for help.<br /><br />asql> load /home/skx/hg/engaging/logs/access.log<br />Loading: /home/skx/hg/engaging/logs/access.log<br /><br />sasql> select COUNT(id) FROM logs<br />46<br /><br />asql> alias hits SELECT COUNT(id) FROM logs<br />ALIAS hits SELECT COUNT(id) FROM logs<br /><br />asql> alias ips SELECT DISTINCT(source) FROM logs;<br />ALIAS ips SELECT DISTINCT(source) FROM logs;<br /><br />asql> hits<br />46<br /><br />asql> alias<br />ALIAS hits SELECT COUNT(id) FROM logs<br />ALIAS ips SELECT DISTINCT(source) FROM logs;<br /><br />(User-input is in bold for emphasis)

Requirements: No special requirements
Platforms: *nix, Linux
Keyword: Alias Analyser Apache Apache Sql Apache Sql Analyser Commands Countid Database Distinctsource Files Logfile Logsalias Logsasqlgt Resulting Sample Select Shell Sql Sql Analyser Structure Usage
Users rating: 0/10

License: Freeware Size: 10.24 KB
USER REVIEWS
More Reviews or Write Review


APACHE SQL ANALYSER RELATED
Network & Internet  -  Apache XML Project
Apache XML Projects goals are: - to provide commercial-quality standards-based XML solutions that are developed in an open and cooperative fashion, - to provide feedback to standards bodies (such as IETF and W3C) from an implementation...
 
Database Tools  -  PgWorksheet 1.8
PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. PgWorksheet allow you to execute SQL queries and psql commands against a PostgreSQL database with a GUI. The...
174.08 KB  
Libraries  -  Apache XML Graphics Commons 1.1
Apache XML Graphics Commons project is a library that consists of several reusable components used by Apache Batik and Apache FOP. Many of these components can easily be used separately outside the domains of SVG and XSL-FO. You will find...
 
Web Authoring  -  Apache Derby 10.1
Apache Derby, an Apache DB subproject, is a relational database implemented entirely in Java. Some key advantages include: small footprint -- about 2 megabytes for the base engine and embedded JDBC driver. Derby is based on the Java, JDBC, and SQL...
10 MB  
Web Browsers  -  Xlogan 2.0 Beta 1
Xlogan is an easy-to-use web server log file analyser which works with Apache-format log files (NCSA combined format or Common Log Format). It features an integrated FTP browser to allow you to fetch your log files straight from your web server,...
1.71 MB  
MS Office Add-Ins  -  SQL Excel 1.01
The points below gives you a brief overview of the SQL Excel Add-in. - SQL Excel adds easy database access to MS Excel. SQL Excel has a very easy to use interface and you will only take minutes to set up and start to use. After install an...
196 KB  
Database Tools  -  Microsoft SQL Server Compact 4.0.8482.1
SQL Server Compact is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP1 and Synchronization Services for...
 
Database Tools  -  DBSync for MS Access & MS SQL 3.5.0
DBSync for MS Access & MSSQL is a database synchronizer which performs MS Access (mdb) to MS SQL server and MSSQL to Access database conversion and synchronization simply by configuring several options in wizard-like application. DBSync for MS...
 
Specialized Tools  -  SQL ICE 2.1
If your application is implemented on a relational database and you know SQL and the application's schema, then SQL ICE can: * Generate applications from simple data definitions using the included My Data on the Web * Build complete internet...
37.84 MB  
Database Tools  -  Cache Monitor 0.22
Cache Monitor is an SQL development tool designed for InterSystems database Cache It supports developers with many features: Advanced SQL Query Editor (SQL Query Analyzer) Cache-SQL Syntax highlighting SQL Code completion...
2.44 MB  
NEW DOWNLOADS IN LINUX SOFTWARE, NETWORK & INTERNET
Linux Software  -  Polling Autodialer Software 3.4
ICTBroadcast Auto Dialer software has a survey campaign for telephone surveys and polls. This auto dialer software automatically dials a list of numbers and asks them a set of questions that they can respond to, by using their telephone keypad....
488 B  
Linux Software  -  Total Video Converter Mac Free 3.5.5
Total Video Converter Mac Free developed by EffectMatrix Ltd is the official legal version of Total Video Converter which was a globally recognized brand since 2006. Total Video Converter Mac Free is a free but powerful all-in-one video...
17.7 MB  
Linux Software  -  Skeith mod_log_sql Analyzer 2.10beta2
Skeith is a php based front end for analyzing logs for Apache using mod_log_sql.
47.5 KB  
Linux Software  -  SLAX 6.0+
Slax is a modern, portable, small and fast Linux operating system with a modular approach and outstanding design. Despite its small size, Slax provides a wide collection of pre-installed software for daily use, including a well organized graphical...
190 KB  
Linux Software  -  GTK+ 2.5
GTK+, which stands for the GIMP Toolkit, is a library for creating graphical user interfaces for the X Window System. It is designed to be small, efficient, and flexible. GTK+ is written in C with a very object-oriented approach. Language bindings...
60 MB  
Network & Internet  -  Free WiFi Hotspot 3.3.1
Free WiFi Hotspot is a super easy solution to turn your laptop or notebook into a portable Wi-Fi hotspot, wirelessly sharing your internet connections like DSL, Cable, Bluetooth, Mobile Broadband Card, Dial-Up, etc. through the built-in wireless...
1.04 MB  
Network & Internet  -  Easy Uploads 1.8
Easy uploads is a file storage media streaming application designed by Filestreamers that allows you to upload, store, and stream your files from their virtually unlimited file storage server. Easy Uploads can backup,share, and stream your files...
615.97 KB  
Network & Internet  -  IPv6 CARE 3.2b
IPv6 CARE, "IPv6 Compliant Automatic Runtime Environment", is a Linux tool able to patch ipv6-agnostic programs on-the-fly ('patch' mode). It can also generate a diagnosis about the IPv6 compliance of an application ('check' mode).
409.6 KB  
Network & Internet  -  PacketFence ZEN 3.1.0
PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) system. Boosting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, 802.1X...
1024 MB  
Network & Internet  -  django-dbstorage 1.3
A Django file storage backend for files in the database.
10.24 KB