skx / asql Goto Github PK
View Code? Open in Web Editor NEWA toy utility to process Apache log files via SQL.
Home Page: https://steve.fi/Software/asql/
A toy utility to process Apache log files via SQL.
Home Page: https://steve.fi/Software/asql/
Every time asql
is run it shows the following message (Ubuntu 18.04 x86_64, Perl: v5.26.1):
asql --load access.log
Name "Regexp::IPv6::IPv6_re" used only once: possible typo at /usr/bin/asql line 1534.
It's shown irrespective any IPv6 IPs being present or not in the access log file.
Running make test
does not execute the commands specified in the Makefile
. Instead, it shows that the 'test' is up to date (Ubuntu 18.04 x86_64).
make test
make: 'test' is up to date.
Also, a check
target appears to be missing, not that is must be there, just it'd be nice to have it for consistency.
asql v1.7
I noticed that "method" was always empty, this seems to fix it:
$ diff asql asql.update
1424a1425
> my $method = $results->{ 'method' } || "";
1475c1476
< $protocol, $refer, $agent, $version,
---
> $method, $refer, $agent, $version,
Trying to load an access log from a shared hosting results in an empty database and yet no warnings or errors.
The log format is fairly common, pretty much the default, somewhat modified combined format (have a server name and IP appended at the end, also have '-' for ident and userid). (sample attached, 7 records are expected).
wc -l access.log
7 access.log
asql --load access.log
asql v1.7 - type 'help' for help.
asql> select count(*) from logs;
0
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.