Replacing wildcards in Excel

May 26th, 2009

I have the joy of working on an Excel spreadsheet right now.  To replace an asterisk or wildcard, you must escape the character with a tilde.  For example, changing all * to .+ would be Ctrl+H to bring up the Replace window, then use ~* for your search character and .+ for your replacement.

hackerspaces presentation

May 3rd, 2009

i just uploaded my hackerspaces presentation from the may first meeting.  thanks to everyone who came and listened and pretended that my realultimatepower.net inspired presentation was funny :-)

Google Brings 3D To Web With Open Source Plugin

April 21st, 2009

“Google has released an open source browser plugin that provides a JavaScript API for displaying 3D graphics in web content. Google hopes that the project will promote experimentation and help advance a collaborative effort with the Khronos Group and Mozilla to create open standards for 3D on the web. Google’s plugin offers its own retained-mode graphics API, called O3D, which takes a different approach from a similar browser plugin created by Mozilla. Google’s plugin is cross-platform compatible and works with several browsers. In an interview with Ars Technica, Google product manager Henry Bridge and engineering director Matt Papakipos say that Google’s API will eventually converge with Mozilla’s as the technology matures. The search giant hopes to bring programs like SketchUp and Google Earth to the browser space.”

-Slashdot

Chrome Experiments

April 4th, 2009

http://www.chromeexperiments.com

Cisco router gets hacked – attacker adds tunnel

March 30th, 2009

Wow, I mentioned this in a presentation a while back, talking about ‘remote sniffing’ via tunnels.  Looks like a perfect storm of holes allowed someone to actually try to pull this off.  Also, pay special attention to how the good guys caught it.

http://isc.sans.org/diary.html?storyid=6100

DNS Offenders

March 12th, 2009

I noticed some interesting DNS error messages in my syslog and wanted to find out who the biggest offenders were.

sudo grep named /var/log/syslog | awk -F”: ” ‘{print $3}’ | grep ‘^[0-9]‘ | sort > dns_harass_ip.txt
for ip in $(uniq dns_harass_ip.txt); do echo -n `grep -c “$ip” dns_harass_ip.txt` && echo ” — $ip”; done | sort -nr

Let’s break these down and explain.

  1. sudo grep named /var/log/syslog: Show any syslog messages from named
  2. awk -F”: ” ‘{print $3}’: Using the characters colon-space as a delimiter, print the third field (IP)
  3. grep ‘^[0-9]‘: Only show fields that start with a number (IP)
  4. sort > dns_harass_ip.txt: Sort and dump the IP addresses
  5. for ip in $(uniq dns_harass_ip.txt); do: For each unique IP address
    1. echo -n `grep -c “$ip” dns_harass_ip.txt`: Print, without a newline, the number of occurrences
    2. echo ” — $ip”: Then print, with a newline, the actual IP address
  6. sort -nr: Sort by numeric value in reverse, or descending, order

That’s all.  From there you can firewall any outstanding offenders or select a different course of action.