1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

User Accounting

Discussion in 'Tomato Firmware' started by Ken Lebofsky, Mar 18, 2012.

  1. Ken Lebofsky

    Ken Lebofsky Networkin' Nut Member

    I have setup a Tomato base WRT54GL as a router for a library with 3 WAP54GPs connected with a wire. Everything works great, QOS and Access restrictions are doing thier job and the device list shows connections without fail.

    The library admins want to know how many unique connections per day are using the network. Is thier a mod for this? One (i think) way would be to log DHCP client assignments to a separate syslogd server and setup a script to parse the logs to strip out duplicates (sort -u), but was hoping for a simple way for the non technical person to look up this info

    I looked into hotspotsystems.com but it can not accommodate the 3 wired wap54gp's because it changes the ip scheme too much.
     
  2. mvsgeek

    mvsgeek Addicted to LI Member

    WallWatcher (www.wallwatcher.com) will log to a separate server (Windows PC in my case), and then WallReviewer has several options to format the results, e.g. summary listing of unique IP addresses with duplicates removed.
     
  3. Planiwa

    Planiwa LI Guru Member

    Could do something like:
    Code:
      cat /var/log/mes* | awk '/DHCPACK/{C[$1 " " $2 " " $9]++; D[$9]++}; END {for (i in C) print i, C[i];for (i in D) DD++; print -DD}'|sort -n -k2|awk '{U[$1 " " $2]++};END{for (i in U) print i,U[i]}'
     
    -10  1
    Mar 6 8
    Mar 7 7
    Mar 8 9
    Mar 9 5
    Mar 15 7
    Mar 16 8
    Mar 17 7
    Mar 18 7
    
    The first line counts the unique clients over the entire period (10), the other lines count clients per day.
     

Share This Page