It looks like the fine DebianAdmin.com site is at it agian:
- how to setup cisco router enable pasword
- Original source: Cisco Certifided Network Associate Study Guide : 3rd Edition
Word-for-word copyright infringement by the user "admin". See the other cisco articles for more infringements.
(OK I'm still bitter their site is pimped all over the place, including wiki.debian.org, and their name is confusingly similar to my sites...)
After yesterdays frustrations with SQL::YASP I moved to parsing logfiles to an temporary SQLite database.
I now have a tool which you may use to load an arbitary number of Apache logfiles to, and query via SQL. It looks something like this:
asql> load /var/log/apache2/acc* Creating tables Loading: /var/log/apache2/access.log Loading: /var/log/apache2/access.log.1 asql> SELECT referer,COUNT(referer) AS number from logs GROUP BY referer ORDER BY number DESC,referer - 4807 http://localhost/stats/ 2 http://foo.ocm/stats/ 2 asql>
The package now stands at 0.4 and is essentially done. It has tab completion on filenames and does enough for me. It might be nice to allow it to auto-read certain files on startup, or persist the database but I'll not bother unless people ask for it.