asql software package provides Run SQL queries against apache logs, you can install in your Ubuntu 14.04 LTS (Trusty Tahr) by running the commands given below on the terminal,
$ sudo apt-get update $ sudo apt-get install asql
asql is installed in your system.
Make ensure the asql package were installed using the commands given below,
$ sudo dpkg-query -l | grep asql *
You will get with asql package name, version, architecture and description in a table
| Distro | Ubuntu 14 04 lts trusty tahr |
| Section | Administration Utilities |
| Package | asql |
| Version | 1.6-1 |
| Description | Run SQL queries against apache logs |
| Sub Section | Admin |