Menu ▾ ▴

Tree [b2f3c0] master /
 History

HTTPS git://
HTTPS access

File Date Author Commit
 .settings 2014-09-09 log.searcher log.searcher [48b0f6] Initial commit
 myDB 2014-10-12 log.searcher log.searcher [b67e35] major update-Setup Server and Clean Data
 solr 2014-10-14 log.searcher log.searcher [761e72] updated solr config and delay when load page
 solr01data 2014-10-13 log.searcher log.searcher [a2caa0] update pom.xml
 src 2014-10-14 log.searcher log.searcher [b2f3c0] added setting
 tomcat.8080 2014-09-29 log.searcher log.searcher [5e9b1d] added chart dashboard
 webapp 2014-10-14 log.searcher log.searcher [0e31d0] update js
 .DS_Store 2014-09-09 log.searcher log.searcher [48b0f6] Initial commit
 .classpath 2014-10-12 log.searcher log.searcher [b67e35] major update-Setup Server and Clean Data
 .gitignore 2014-10-11 log.searcher log.searcher [408ec8] added function: setup server and clean data
 .project 2014-09-09 log.searcher log.searcher [48b0f6] Initial commit
 copyright.txt 2014-09-29 log.searcher log.searcher [48f2ed] added chart
 derby.log 2014-10-12 log.searcher log.searcher [b67e35] major update-Setup Server and Clean Data
 pom.xml 2014-10-13 log.searcher log.searcher [a2caa0] update pom.xml
 readme.md 2014-10-11 log.searcher log.searcher [5a40e4] update readme
 system.properties 2014-09-09 log.searcher log.searcher [48b0f6] Initial commit

Read Me

CONFIGURATION

  • Below referred the servers.xml configuration which is defining the location of the log files.
  • The configuration example below is supporting for local log files only.

  • The log files are defined 2 types which are "SystemOut.log" and "SystemOut.log.<rolling-number>"</rolling-number>

  • "search_server" table is working together with log4j with the example below.

    Source code: log4j.properties

    log4j.rootLogger=INFO, CONSOLE, ROLLING_FILE
    log4j.appender.ROLLING_FILE=org.apache.log4j.RollingFileAppender
    log4j.appender.ROLLING_FILE.Append=true
    log4j.appender.ROLLING_FILE.MaxFileSize=100KB
    log4j.appender.ROLLING_FILE.MaxBackupIndex=100
    log4j.appender.ROLLING_FILE.File=logs/SystemOut.log
    log4j.appender.ROLLING_FILE.layout=org.apache.log4j.PatternLayout
    log4j.appender.ROLLING_FILE.layout.ConversionPattern=[%d{MM/dd/yy HH\:mm\:ss\:SSS z}] %t %-5p %-15c > %m%n

RUN LOG SEARCHER Server

  • The source code is developed under Eclipse IDE with JDK 8

  • The java main class with start the embeded tomcat server on port 8080

    Java Main class source code: src/main/java/launch/LogSearcherMain.java

  • Access LogSearcher Web application on Web Browser on URL below.

    URL: http://localhost:8080/

DATABASE SCHEMA

  • Database vendor is Derby

  • Directory that store data is under myDB folder

  • "search_query_history" table is storing the executed query history

create table app.search_query_history (id varchar(255), email varchar(255), query varchar(255), created_date date, bookmarked boolean);

  • "search_server" table is storing the configuration of the server which defined source of log files.

create table app.search_server(id varchar(255), name varchar(50), description varchar(255), dirpath varchar(255), rolling_filename varchar(100), rolling_product_pattern varchar(100), start_date_tag varchar(10), end_date_tag varchar(10), date_pattern varchar(100), email varchar(255), status varchar(2));