# Copyright (c) 2010 Flowerfire, Inc.  All Rights Reserved.
winroute = {

  # The name of the log format
  log.format.format_label = "Kerio Winroute Firewall Log Format"
  log.miscellaneous.log_data_type = "firewall"  
  log.miscellaneous.log_format_type = "proxy_server"

  # The log is in this format if any of the first ten lines match this regular expression
  log.format.autodetect_regular_expression = "^\\[[0-9][0-9]/[A-Z][a-z][a-z]/[0-9][0-9][0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]\\] [A-Z]+ \"[^\"]*\" packet "

  # Parse with this regular expression

  # Entries are called accesses
  statistics.miscellaneous.entry_name = "accesses"

  # The format of dates and times in this log
  log.format.date_format = "dd/mmm/yyyy:hh:mm:ss"
  log.format.time_format = "dd/mmm/yyyy:hh:mm:ss"

  # Log fields
  log.fields = {

    date_time = {
      label = "$lang_stats.field_labels.date_time"
      type = "date_time"
      index = 0
      subindex = 0
      hierarchy_dividers = ""
      left_to_right = false
      leading_divider = "false"
    } # date_time

    action = {
      label = "$lang_stats.field_labels.action"
      type = "flat"
      index = 0
      subindex = 0
    } # action

    rule = {
      label = "$lang_stats.field_labels.rule"
      type = "flat"
      index = 0
      subindex = 0
    } # rule

    direction = {
      label = "$lang_stats.field_labels.direction"
      type = "flat"
      index = 0
      subindex = 0
    } # direction

    proto = {
      label = "$lang_stats.field_labels.proto"
      type = "flat"
      index = 0
      subindex = 0
    } # proto

    len = {
      label = "$lang_stats.field_labels.len"
      type = "flat"
      index = 0
      subindex = 0
    } # len

    src = {
      label = "$lang_stats.field_labels.src"
      type = "host"
      index = 0
      subindex = 0
      hierarchy_dividers = "."
      left_to_right = false
      leading_divider = "false"
    } # src

    src_port = {
      label = "$lang_stats.field_labels.src_port"
      type = "flat"
      index = 0
      subindex = 0
    } # src_port

    dst = {
      label = "$lang_stats.field_labels.dst"
      type = "flat"
      index = 0
      subindex = 0
    } # dst

    dst_port = {
      label = "$lang_stats.field_labels.dst_port"
      type = "flat"
      index = 0
      subindex = 0
    } # dst_port

    udplen = {
      label = "$lang_stats.field_labels.udplen"
      type = "flat"
      index = 0
      subindex = 0
    } # udplen

    tcplen = {
      label = "$lang_stats.field_labels.tcplen"
      type = "flat"
      index = 0
      subindex = 0
    } # tcplen

    flags = {
      label = "$lang_stats.field_labels.flags"
      type = "flat"
      index = 0
      subindex = 0
    } # flags

    seq = {
      label = "$lang_stats.field_labels.seq"
      type = "flat"
      index = 0
      subindex = 0
    } # seq

    ack = {
      label = "$lang_stats.field_labels.ack"
      type = "flat"
      index = 0
      subindex = 0
    } # ack

    win = {
      label = "$lang_stats.field_labels.win"
      type = "flat"
      index = 0
      subindex = 0
    } # win

  } # log.fields


  #          
  # Log Parsing Filters
  log.parsing_filters = {

    # Parse out the date and time
    1 = {
      label = "1"
      comment = ""
      value = "collect_fields_using_regexp('^()\\[([0-9][0-9]/[A-Z][a-z][a-z]/[0-9][0-9][0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9])\\] ([A-Z]*) \"([^\"]*)\" (packet [frtom]+ [^,]+), proto:([^,]*), len:([0-9]+), ip/port:([0-9.]*):([0-9]+) -> ([0-9.]*):([0-9]+),', '*KEY*,date_time,action,rule,direction,proto,len,src,src_port,dst,dst_port')"
    } # 1

    # Parse UDP information
    udp = {
      label = "UDP"
      comment = ""
      value = "collect_fields_using_regexp('()proto:UDP,.*udplen:([0-9]+)', '*KEY*,udplen')"
    } # udp

    # Parse TCP information
    tcp = {
      label = "TCP"
      comment = ""
      value = "collect_fields_using_regexp('()proto:TCP,.*flags:([^,]*), seq:([^ ]*) ack:([^ ]*), win:([^ ]*), tcplen:([^ ]*)', '*KEY*,flags,sql,ack,win,tcplen')"
    } # tcp

    # Accept this entry
    3 = {
      label = "3"
      comment = ""
      value = "accept_collected_entry_using_regexp('()', false)"
    } # 3


  } # log.parsing_filters


  # Database fields
  database.fields = {

    date_time = {
      label = "$lang_stats.field_labels.date_time"
      log_field = "date_time"
      type = "string"
      suppress_top = 0
      suppress_bottom = 3
      display_format_type = "date_time"
    } # date_time

    day_of_week = {
      label = "$lang_stats.field_labels.day_of_week"
      log_field = "day_of_week"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
      display_format_type = "day_of_week"
    } # day_of_week

    hour_of_day = {
      label = "$lang_stats.field_labels.hour_of_day"
      log_field = "hour_of_day"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
      display_format_type = "hour_of_day"
    } # hour_of_day

    action = {
      label = "$lang_stats.field_labels.action"
      log_field = "action"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # action

    rule = {
      label = "$lang_stats.field_labels.rule"
      log_field = "rule"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # rule

    direction = {
      label = "$lang_stats.field_labels.direction"
      log_field = "direction"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # direction

    proto = {
      label = "$lang_stats.field_labels.proto"
      log_field = "proto"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # proto

    src = {
      label = "$lang_stats.field_labels.src"
      log_field = "src"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # src

    src_port = {
      label = "$lang_stats.field_labels.src_port"
      log_field = "src_port"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # src_port

    dst = {
      label = "$lang_stats.field_labels.dst"
      log_field = "dst"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # dst

    dst_port = {
      label = "$lang_stats.field_labels.dst_port"
      log_field = "dst_port"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # dst_port

    flags = {
      label = "$lang_stats.field_labels.flags"
      log_field = "flags"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # flags

    seq = {
      label = "$lang_stats.field_labels.seq"
      log_field = "seq"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # seq

    ack = {
      label = "$lang_stats.field_labels.ack"
      log_field = "ack"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # ack

    win = {
      label = "$lang_stats.field_labels.win"
      log_field = "win"
      type = "string"
      suppress_top = 0
      suppress_bottom = 2
    } # win

  } # database.fields


  # Log Filters
  log.filters = {


    # Use "source IP" as the visitor id

    mark_entry = {
      label = '$lang_admin.log_filters.mark_entry_label'
      comment = '$lang_admin.log_filters.mark_entry_comment'
      value = 'accesses = 1;'
    } # mark_entry

  } # log.filters

  database.numerical_fields = {

    accesses = {
      label = "$lang_stats.field_labels.accesses"
      default = true
      requires_log_field = false
      type = "int"
      display_format_type = "integer"
      entries_field = true
    } # accesses

    visitors = {
      label = "$lang_stats.field_labels.visitors"
      default = false
      requires_log_field = true
      log_field = "src"
      type = "unique"
      display_format_type = "integer"
    } # visitors

    len = {
      label = "$lang_stats.field_labels.len"
      default = false
      requires_log_field = true
      log_field = "len"
      type = "float"
      display_format_type = "bandwidth"
    } # len

    udplen = {
      label = "$lang_stats.field_labels.udplen"
      default = false
      requires_log_field = true
      log_field = "udplen"
      type = "float"
      display_format_type = "bandwidth"
    } # udplen

    tcplen = {
      label = "$lang_stats.field_labels.tcplen"
      default = false
      requires_log_field = true
      log_field = "tcplen"
      type = "int"
      display_format_type = "integer"
    } # tcplen

  } # database.numerical_fields


  create_profile_wizard_options = {
    date_time_tracking = true
    host_tracking = true

    # How the reports should be grouped in the report menu
    report_groups = {
      date_time_group = ""
      actions_group = {
        action = true
        rule = true
      }
      source_group = {
        src = true
        src_port = true
        direction = true
      }
      destination_group = {
        dst = true
        dst_port = true
      }
      other_group = {
        proto = true
        flags = true
        seq = true
        ack = true
        win = true
      }
    } # report_groups

  } # create_profile_wizard_options

  not_supported = {
    pageviews = true
    sessionpages = true
  } # not_supported

} # winroute