• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

parsing logfile

 
ranga shreya
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,
I am getting a appache logfile so I have to parse the file and and store it in a database table what are the steps involved here...
i mean how to parse the log file.
sample line from my log file.
216.148.244.91 - - [11/Mar/2005:11:05:27 -0500] "GET /tracker.html?retailer=Test+Retailer&order=xyz123&uniqueId=12345&sku=sku-00005&prodName=the%20greatest%20product%20in%20all%20the%20world&qty=1&unitPrice=15.25 HTTP/1.0" 200 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)"
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34974
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ranga,
Before you go about trying to do this yourself, take a look at log4j's database appender. It looks like this is from a web server access log, rather than log4j, but you can still get some ideas.

Then you can decide on what your schema should be. For example, it looks like it would be useful to store the IP address, date/time, etc.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic