Phasor Burn

Archive for the 'System Administration' Category

City Hall

Wednesday, March 10th, 2010

City Hall, originally uploaded by SmugBastard.ca.

Taken on my way to the police station to apply for CPIC background check for datacentre access at Telus.

Telus takes the CPIC paperwork, plus another several pages of their own forms signed by everyone under the sun, and then sits on them for a month before granting access to their datacentres.

Compare this to Q9 where the person paying the bill sets up authorized users via telephone or web control panel. New person just has to fill out a short one page form and show picture id, and immediately gets their finger print enrolled and an access card.

Q9’s datacentres seem to be just as secure. More so even, as I have yet to catch one of their guards sleeping on the job, or letting people into the guard room, or leaving doors open and waving people through without checking that they are allowed in… (all seen at Telus over the years)

Posted in General, Work, System Administration, photography | No Comments »

dev meets ops, ops meet dev

Monday, March 8th, 2010

A Cautionary Tale

Friday, March 5th, 2010

Stay Focused, Stay Healthy Part 1, Part 2

Reminds me of the previous workplace. I didn’t get quite as far gone as this guy, but it was definitely a road I was heading down.

Thankfully, I’m in a much better place now.

Posted in General, Work, System Administration | No Comments »

Apache Bandwidth from access.log

Wednesday, March 3rd, 2010

Quick and dirty Apache Bandwidth graphs with GnuPlot

#!/bin/bash PATH=/opt/local/bin:$PATH


TMP=/tmp/`basename $0`.$$

trap "/bin/rm ${TMP} >/dev/null 2>&1" 0 1 15
gzcat *access.log.*.gz |\

 sed -e 's/\[//g' -e 's/\]//g' |\

   awk ' 
	{

		day=substr($4,0,2)

		month=substr($4,4,3)

		year=substr($4,8,4)

		hhmm=substr($4,13,5)

		if ( month =="Jan" ) month="01"

		if ( month =="Feb" ) month="02"

		if ( month =="Mar" ) month="03"

		if ( month =="Apr" ) month="04"

		if ( month =="May" ) month="05"

		if ( month =="Jun" ) month="06"

		if ( month =="Jul" ) month="07"

		if ( month =="Aug" ) month="08"

		if ( month =="Sep" ) month="09"

		if ( month =="Oct" ) month="10"

		if ( month =="Nov" ) month="11"

		if ( month =="Dec" ) month="12"

		timestamp=year"-"month"-"day"-"hhmm

		hits[timestamp]++

		bytes[timestamp] += int($(10))

	}
    END { for (timestamp in hits)

                  printf("%s %10d %20d\n",

                             timestamp,

                             hits[timestamp],

                             bytes[timestamp]*8/60/1024)

}
' | sort > ${TMP}
# Now we have YYYY-MM-DD-HH:MM hitspermin and Kbps
cat < < EOF_GNUPLOT_SCRIPT  | gnuplot

  set terminal png enhanced size 1024,768

  set xdata time

  set timefmt "%Y-%m-%d-%H:%M"

  set format x "%d-%H:00"

  set xlabel "time"

  set grid

  set style data points

  set xrange [ "2010-02-24-00:00" : "2010-03-02-23:59" ]

  set output "hits.png"

  set ylabel "Hits per minute"

  set title "Apache Hits"

  plot "$TMP" using 1:2 title ""

EOF_GNUPLOT_SCRIPT

cat << EOF_GNUPLOT_SCRIPT | gnuplot set terminal png enhanced size 1024,768 set xdata time set timefmt "%Y-%m-%d-%H:%M" set format x "%d-%H:00" set xlabel "Time" set grid set style data points set xrange [ "2010-02-24-00:00" : "2010-03-02-23:59" ] set yrange [ 0 : 6000 ] set output "bandwidth.png" set ylabel "Kbps" set title "Apache Bandwidth Past Week" plot "$TMP" using 1:3 title "" EOF_GNUPLOT_SCRIPT