RobotSkirts

This weekend @SanMo (original post) started freaking out and reposting the same tweets over and over again. Code superstar Chris Finke wasn’t available to help me track down the issue so I reanimated Chris Nelson for assistance. My initial thought was that Twitter had changed the way it served mentions. retweet.py stores the status_id of each status it retweets in a sqlite database so it doesn’t repeat itself. Browsing the database, I noticed that the two tweets it was repeating were the first with ids above 10 billion (a recent milestone). Chris pointed out that running sqlite> SELECT MAX(status_id) FROM retweets; Returned the id ’9663742534′ and not the true maximum. The table that retweet.py creates has two text columns, one for status_id and one for the timestamp. Changing the status_id column to integer causes MAX() to work properly (I’m not sure what the technical reason behind this failure is). To get retweet.py running again, I did the following (via Chris) from the command line:

# sqlite3 sanmo.sqlite
sqlite> CREATE TABLE retweets2 (status_id INTEGER PRIMARY KEY, timestamp TEXT);
sqlite> INSERT INTO retweets2 SELECT * FROM retweets;
sqlite> DROP TABLE retweets;
sqlite> ALTER TABLE retweets2 RENAME TO retweets;
sqlite> .quit


That will shift all the old data into a new table. The initial database creation routine needs to be fixed in retweet.py and will probably be in version 1.3. The fix above works for me but your mileage may vary.

This is a fun little trick I learned while traveling this weekend. When I’m not on my home network, I often use ssh -D to dynamically forward all of my traffic via SOCKS proxy to a remote server. This weekend though, I found myself trapped in a network with only an HTTP proxy to access the internet, so I couldn’t even check my email via HTTPS. The solution was to use connect.c to relay SSH through the HTTP proxy. I temporarily added two lines to my SSH config that proxied all host connections through the HTTP proxy.


Host *
ProxyCommand connect -H xxx.xx.xxx.x:80 %h %p


Then I set up my SSH SOCKS proxy as usual.


ssh -ND 8822 eliot@example.org


I used connect.c, but a friend had success with corkscrew.

Goozex is a videogame and DVD trading service I’ve been using and I’m quite happy with it. Each game or DVD has a point value based on the age and demand. You earn points by giving items and spend points to receive items. Each trade costs the receiver 1 dollar. Points can be purchased 100 for $5. New games usually enter the market at 1000 points and age in 50 point increments.

(more…)

I came to OSX from a Linux environment so there are often times when I’m using Finder and thinking, “Damnit, this would be faster with a command line.” I thought I’d share two tools that I’ve found alleviate some GUI pain. The first is Marc Liyanage’s Open Terminal Here which drops you into a shell in the current folder. In my experience, command line mplayer is the least crashy/clunky media player on OSX for playing odd codecs, so I just open terminal here when I find the file(s) I want to play. The second tool is Jim DeVona’s LSelect which lets you select files using shell style globbing just like you would with ls. It’s much faster than the GUI for even the simplest of tasks like selecting just one file type. I’m using both of these with Henrik Nyh’s fine icons. I hope you find these tools useful.

Shareaholic is a browser addon that streamlines the process of using bookmarking services. When it originally debuted, I wasn’t using Digg or delicious that often. I’ve recently accumulated a lot of bookmarklets that I use fairly frequently and decided to give Shareaholic another go. These are the services I’m using Shareaholic for:

• Bit.ly – When I want to share a link on Twitter, Bit.ly is my goto. It shortens and gives you free stat pr0n.
• Google Reader – I’ve got a fun group of people on Reader and this makes it easy to inject stories into my shared items.
• Instapaper – I’m guessing I’d get more mileage out of this if I was an iPhone user.
• Tumblr – Used most often for adding posts to Fucking Curated.
• WordPress – For posting here.
• Amazon Universal Wish List – I always wanted to make more use of this and Shareaholic makes it easy.
• Gmail – Sending links via Gmail was all I every used Mozilla’s Ubiquity for.

I installed the extension on Firefox and now that the dev channel of Chrome for Mac has extensions I’ve got it there too.

Unfortunately, leaving Hack a Day means a lot of reshuffling online. I had only launched this blog two months before starting there so much of my online identity is tied to HaD. My main email address was a Gmail account eliot.hackaday and my AIM account was similar. I decided to start using this domain as my primary contact. Here is what I had to do and a few of the missteps: (more…)

I’ve yet to really get into the MacHeist bundle I purchased. I was investigating Pixelmator when I found a pretty good overview video from ScreenCastsOnline. I looked around and found a few more covering the software in the bundle:

• Pixelmator
• 1Password
• Launchbar: 1, 2, 3
• Speed Download: 1, 2

I know a lot about security, but rarely ever practice it (I leave my WiFi open, I just turn off the SSID ). With Shmoocon coming up I decided I should at least try to lockdown a little. I’m just hoping my EVDO Rev A card shows up so I don’t have to use any of the local networks. Bastille is a long standing *nix project that guides you through turning off services, setting security policies, and securing your firewall. Last fall Jay Beale released a beta version for OS X users after this Defcon talk pointing out that the OS X firewall doesn’t really do what it says. The install is pretty easy: Download and install instructions can be found here. You’ll need to install Tk following these directions. The only possible slip is that you need to run ‘bastille -b’ to apply the changes as noted here.

I found this talk on FileVault cracking while I was searching. I love all of the little accelerated cracking projects David Hulton has been doing with FPGAs lately.

I joked to Blaine how my idea of holiday fun was learning PHP. He suggested if I was starting from scratch anyway I might as well learn Ruby on Rails. That sounded like a grand idea to me and reminded me of a great blog post I read last year:

Cory and many others from Rackspace put in an incredible amount of work helping with the Katrina relief efforts. Here is his story: “Shelter Famous”, or, How To Build Disaster Relief Software (with Rails)

If you can’t tell from the title, my Christmas has been a blast . I kid, but I decided to take on a coding project (something more than duct tape). I decided to get Apache, MySQL, PHP, and Xcode installed on my MacBook Pro to facilitate this. Here are some links to make this easier on the next person.

• Enabling PHP
• Installing MySQL
• Installing phpMyAdmin
• PHP with Xcode

I haven’t played with Xcode yet. I figure I’ll use TextWrangler till I get into something big. For the curious: I’m starting at the very beginning.