I was looking for a quick and painless way to determine what IP addresses used our web app the most and stumbled across this excellent post. I got reminded of the power of the command-line interface and that often, I underestimate the way these commands are supposed to make a sysad's life easier.

So here's a quick tip for counting unique visitors to your web app. Locate your web app's log file and do a quick scan of the last few lines. In my case, this is what I saw:

112.198.79.223 - - [10/Jul/2010:00:57:29 -0400] "POST /v2/api/execute.php?method=upload_time&ver=win1.1.15 HTTP/1.1" 200 116 "-" "Mozilla/5.0"
117.241.112.254 - - [10/Jul/2010:00:57:30 -0400] "POST /v2/api/execute.php?method=timestat&ver=win1.1.15 HTTP/1.1" 200 288 "-" "Mozilla/5.0"
80.249.84.105 - - [10/Jul/2010:00:57:29 -0400] "POST /v2/api/execute.php?method=offtime&ver=win1.1.15 HTTP/1.1" 200 19 "-" "Mozilla/5.0"
117.241.112.254 - - [10/Jul/2010:00:57:32 -0400] "POST /v2/api/execute.php?method=get_defaults&ver=win1.1.15 HTTP/1.1" 200 77 "-" "Mozilla/5.0"

In this log format, the IP address appears first, so we will only need to get the first set of characters, separated by a space. In order to count instances of an IP address, we sort the IP addresses so similar IP addresses are grouped together, then count them. Then we sort them again so that the sums are arranged. The number of unique IPs may give you pages of standard output, so optionally, if you only want to see which IP addresses accessed the web app the most, we look at the top results only.

So these are the commands used, piped one after the other, with the output:

[root@server2 ~]# cat /var/log/httpd/access_ssl.log | awk '{print $1}' | sort | uniq -c | sort -nr | head

71612 216.157.78.237
34094 120.28.205.244
30091 119.93.97.54
25078 120.28.214.104
18949 120.28.195.151
17929 58.107.64.40
14877 212.98.174.235
14752 117.241.112.143
14429 120.28.247.74
12864 117.241.113.183
[root@server2 ~]#

Happy counting, err reporting!

IMO, this is the answer to all your privacy-related concerns on Facebook. Can’t wait til it launches.

It’s not my business, but I’m really tired of all of these jejemon-bashing stuff I’m seeing in twitter and facebook. Why not make an effort to educate these language-challenged people?

Come on people, this monster’s been around a long time. It just took on a new name. Let’s do something productive. ^_^

Mindanaoans have already contributed hundreds of hours for Mother Earth in the last month. Spare us.

pinoytumblr:

lights out..

reblog. :)

I dare not say what we hope our daughter didn’t get that’s causing her on and off high fever since Tuesday night. We’re still hopeful that it’s some ordinary viral infection that’s been plaguing kids these hot El Nino days.

My wife and I are in distress due to lack of sleep, but we’re still hopeful. We were advised to wait until 6pm tonight to get another CBC exam. That’s because aside from her fever, she hasn’t been showing the other symptoms, e.g. nausea/vomiting, joint pains, tummy pains, etc.

Well, she’s known to not complain about pain unless it’s caused by a needle. So we’re not taking chances. After all, you’d do everything for your kids, right?