Category: General

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

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 AS id FROM flight f LEFT JOIN airport a ON WHERE<>‘mx’ FOR UPDATE); ERROR 1093 (HY000): You can‘t specify target table ‘flight‘

Posted in Code, General, SQL

Whitespace Matters

Mark Jason Dominus just released SuperPython 0.91, “a Perl source filter for the SuperPython language, allowing SuperPython code to be embedded into Perl programs”. In terms of language, it goes way beyond python itself to give proper semantics to whitespace.

Posted in Code, General, Perl, Python, Tech

Attansic L1 Gigabit Ethernet driver for Debian

I just got a new ASUS M2V motherboard to replace a braindead server that would lock up on POST about 75% of the time. The new motherboard has a built-in Attansic L1 Gigabit Ethernet Adapter that is supported in Linux

Posted in Debian, General, Linux, SysAdmin

Gecko/20070601 C64/Commodore

I tought this was just a SpreadFirefox stunt, but I just found the most strange User-Agent in an Apache server log *heh!* I guess it takes another Commodore fan to appreciate this kind of humor. [tags]Mozilla, Firefox, Commodore, C64[/tags]

Posted in General, Hack!, SysAdmin, Tech