Author: javier

uHOWTO: Speed up RAID resync

So you’re tired of watching the grass grow while your Linux RAID2 array rebuilds itself. Let’s take care of it: $ echo 10000 > /proc/sys/dev/raid/speed_limit_min This should give you a 10x speedup over the 1000kB/sec default — subject to the

Posted in Debian, Linux, SysAdmin

A brief note about Spamhaus Policy Block List

After getting in closer-than-usual acquaintance with my mail server logs I thought I’d share a brief note I found in the Spamhaus PBL FAQ: The first thing to know is: THE PBL IS NOT A BLACKLIST. Oh, and since you’re

Posted in Debian, General, Linux, Rant, SysAdmin, Tech

DiskAid: access the files in your iPhone or iPod Touch

A few weeks ago I upgraded my wife’s iPod Touch to 2.1, and I just can’t believe that iTunes won’t let you backup your content even if it means a paid firmware upgrade. I would have used PodsBlitz to back

Posted in Gadgets, Hack!, iPod, Rant, Tech

uHOWTO: Use your N95 8G as a bluetooth modem under Linux with Telcel

For completeness, here’s a followup to my post about using a Nokia N95 as a bluetooth modem under Linux. This is a working wvdial configuration for use with Telcel in Mexico. Remember to enter your SIM’s PIN in pin-telcel, and

Posted in Debian, Gadgets, General, Linux, Nokia N95 8G, SysAdmin, Tech Tagged with: , , , , , ,

HOWTO: Use your Nokia N95 Cellphone as a Bluetooth modem for Linux

Did you know that you can use your data-enabled N95 to get a thethered Internet connection from Linux? The access mode and speed will depend on your actual coberture, and as usual YMMV, but I’ve been using this setup for

Posted in Debian, General, Linux, Nokia N95 8G, SysAdmin, Tech Tagged with: , , , ,

Assign a consecutive number to each row in a mySQL table

Say that you need to add a unique index to an existing catalog table, so you decide to add a new column with a consecutive number in it. You may make it an auto_increment column, but that would work only

Posted in General

Solved mysterious Firefox 3.0.1 crashes

A few months ago I installed a Firefox 3 beta in my Linux laptop to… well you know, just to fool around. And it crashed spectacularly. I tried again with RC1. No such luck. When 3.0 came around I installed

Posted in General

X forwarding through SSH in HP-UX

If you try to do X forwarding by SSHing to an HP-UX host, you may get the dreaded “Can’t get IP address for X11 DISPLAY.” error. This is more common than you might think, and the reason is that an

Posted in General, SysAdmin Tagged with: , , , ,

update…where id in (select…) and mySQL ERROR 1093

What’s wrong with this picture? mysql> UPDATE IGNORE flight SET intl=1 WHERE id IN (SELECT f.id AS id FROM flight f LEFT JOIN airport a ON a.id=f.origin WHERE a.country<>‘mx’ FOR UPDATE); ERROR 1093 (HY000): You can‘t specify target table ‘flight‘

Posted in Code, General, SQL

Farewell to Arthur C. Clarke

I just found out -thorugh an email from Thinkgeek, of all ways- that Arthur C. Clarke has passed away. 2001 was a mesmerizing experience for me when I first saw it. I think I was about 8 years old then.

Posted in Science, Tech