asql:一个玩具实用程序,可通过SQL处理Apache日志文件

  • G9_291335
    了解作者
  • 20.5KB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-29 06:55
    上传日期
asql:一个玩具实用程序,可通过SQL处理Apache日志文件
asql-master.zip
  • asql-master
  • t
  • modules.sh
    564B
  • no-tabs.t
    1.9KB
  • perl-syntax.t
    1.4KB
  • pod.t
    295B
  • Makefile
    165B
  • modules.t
    685B
  • debian
  • source
  • format
    12B
  • compat
    2B
  • changelog
    4.5KB
  • docs
    16B
  • rules
    1.1KB
  • control
    542B
  • copyright
    788B
  • bin
  • asql
    32.6KB
  • make-cmds
    1.3KB
  • README.md
    2.1KB
  • Makefile
    1.3KB
  • .gitignore
    127B
  • .release
    427B
内容介绍
Homepage: http://www.steve.org.uk/Software/asql/ Git Repository: http://github.com/skx/asql/ asql ---- ASQL is a simple tool to allow you to query Apache common logfiles via SQL. (Only "Apache common" logfiles are currently supported.) When asql starts up it creates a temporary SQLite database to hold the contents of the parsed logfile(s) you might load. This temporary database may then be queried directly via SQL. Why might you want to do this? Well it does allow you to make certain queries very easily. Aliases ------- Using the 'alias' command you may record and replay previous queries by name, along with variable expansion. For example the following query will show the number of hits against your server: SELECT COUNT(id) FROM logs; You could save this query via this: ALIAS hits SELECT COUNT(id) FROM logs; Now at any future point entering 'hits' would run the query. If you wish you can use variables in aliases such as: ALIAS hitsagent SELECT * FROM logs where agent like '%$1%'; The text `$1` will be replaced by the first argument you supply to the alias when running it: hitsagent mozilla hitsagent Slurp You can use variables from $1 to $9. (Aliases persist between sessions via the file `~/.asql.aliases`.) Example Queries --------------- The following examples give an idea of the kind of power an SQL query allows you: Greediest downloaders: SELECT source,SUM(size) AS Number FROM logs GROUP BY source ORDER BY Number DESC, source A count of each distinct referers: SELECT referer,COUNT(referer) AS number from logs WHERE referer NOT LIKE '%steve.org.uk%' GROUP BY referer ORDER BY number DESC,referer LIMIT 0,10 See which Debian packages were downloaded the most: SELECT request,COUNT(request) AS Number FROM logs WHERE request LIKE '%.deb' GROUP BY request ORDER BY Number DESC, request; See who has downloaded me: select * FROM logs WHERE request='/etch/pool/main/a/asql/asql_0.6-1_all.deb'; Dependencies ------------ For parsing IPv6 log entries the `Regexp::IPv6` module is required. Steve --
评论
    相关推荐
    • puppet-apache
      什么apache会影响OPTIONAL 如果很明显您的模块涉及到什么,则可以跳过此部分。 例如,人们可能会发现您的mysql_instance模块会影响他们MySQL实例。 但是,如果还有更多他们应该知道的地方,这里是要提到的地方: ...
    • Apache的java解析sql工具包
      Apache的java解析sql工具包,实现java对sql语句 的解析
    • apache mysql monitor
      apache mysql monitor
    • apache-rocketmq
      apatch-rocketmq.tar.gz rocketmq linux下的安装包。直接使用tar进行解压
    • sql-parser
      sql-parser
    • write apache module
      apache module的工具书,可以作为参考手册,英文,pdf格式
    • apache,PHP, Sql三合一解压版
      apache,PHP, Sql三合一解压版
    • PL/SQL for Apache-开源
      DSP代表Data Server Pages,即APACHE HTTP服务器模块,它为PL / SQL Server脚本提供变量注入预处理器,并在Oracle数据库后端具有有效的授权和认证框架。
    • SQL漏洞测试平台
      SQL漏洞测试平台,安装WAMP,然后项目部署在WAMP_HOME\apache2\htdocs下,即可。可作为SQL注入漏洞的入门平台
    • GaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz
      guassdb100在redhat上安装包,单机部署的包,安装步骤请看我的文中介绍,经过大量实验搭建总结出来的文档