Only idiots fly through Chicago in the winter

December 23rd, 2007

It’s a long-held article of truth among frequent travelers that avoiding O’Hare in the winter is a good idea. Actually, it’s avoiding O’Hare period, since the summer brings nasty thunderstorms.

I, like a fool, have disregarded The Truth, and I am paying for it as I wait for my plane to arrive on a two-plus hour delay. How bad is it? Well, this snapshot of the American flight status boards should tell you. Yellow indications on the boards indicate delays. Of the six displays in the picture, the left five are for departures. 26 flights are departing on time, out of, oh, lots…

American Airlines flight departure displays

The end of the PRISM era: Conexant stops wireless LAN chip development

November 5th, 2007

Once upon a time, a company called Harris produced a chipset called the PRISM. It was the chipset to use for building early 802.11 devices. Way back in 2000, I remember building the linux-wlan project driver on an ancient Pentium laptop to get the 802.11 card working. Back in those days, 802.11 was a Mbps standard, with the glimmer of an 11 Mbps “high speed” 802.11b in the distance.

(Interesting fact: “PRISM” was an acronym for the chip, which stood for “Programmable Radio in the ISM band.” ISM refers to the widely-used slice of spectrum around 2.4 GHz that all these devices use.)

Harris spun of the chip business as Intersil in February 2000, raising $500 million in what was at the time, the largest semiconductor IPO in history. Intersil chips were the chip to use. The venerable PRISM was succeeded by the PRISM-II, which added support for 802.11b. Intersil was flying high. As an example, in 2001, an analyst for thestreet.com wrote that you should ignore all of the brands you saw on 802.11 equipment (notably Apple, which had gained notice with the success of the AirPort access points). To bet on the future success of 802.11, he advised, buy Intersil stock:

Intersil is the enabler of the 802.11b revolution. Intersil’s Prism chipsets power more 802.11b networks than anyone else, and its technology is right out there on the bleeding edge. It is profitable, and Intersil is divesting itself of its slow-growth businesses, making it a pure play and developing a strong balance sheet at the same time.

In July 2003, Intersil sold its wireless LAN business to GlobespanVirata for about $350 million. A few months later in November 2003, Conexant systems then acquired the wireless LAN chip business through a $970 million acquisition of GlobespanVirata.

Last week, Conexant’s fourth quarter financial results press release announced the end of the line for the Prism:

Effective immediately, Conexant is discontinuing further investment in standalone wireless networking product development and will eliminate approximately 140 positions worldwide. Beginning in the second quarter of fiscal 2008, the company expects these actions to save approximately $5 million in quarterly operating expenses. The company plans to maintain the staffing levels required to support existing wireless networking customers with current solutions. Conexant’s remaining wireless employees will join the company’s Broadband Access organization and support DSL gateways that incorporate wireless connectivity.

The Prism chips have long been supplanted by newer vendors like Atheros, Intel, and Broadcom, but I still feel a little bit misty-eyed at the end of the era. It was an early Prism radio that inspired me to get involved in 802.11, and their early support of open source drivers like linux-wlan made them the nexus of experimentation on Linux until other vendors decided to get with the program.

Earthquake!

October 31st, 2007

Last night, shortly after 8 pm, there was an earthquake near San Jose. I’d just made it home after a particularly ugly BART delay, due to an apparent suicide at Powell Street station around 6 pm:

BART’s Powell Street station in San Francisco was reopened just before 8 p.m. tonight after authories shut it down for two hours to investigate a death on the tracks.

Up in San Francisco, the quake was fairly mild. I mistook the shaking for vehicles on the street at first, until I realized there was no noise and the shaking was continuing for much longer than I expected.

I was the first to fill out the shaking report from my ZIP code in San Francisco. (At the time I write this, there are now almost 250 reports.) Magnitude is an important measurement of earthquakes, but the Mercalli intensity scale is a more useful answer to the “how did it feel?” question. In the USGS map, brighter colors (yellow/orange/red) correspond to higher intensities:

October 30, 2007 quake intensity map (cropped)
(Click through for a full map with the color code.)

Most of the Bay Area reported intensity III (”Slight”), described as: “Felt quite noticeably by persons indoors, especially on the upper floors of buildings. Many do not recognize it as an earthquake. Standing motor cars may rock slightly. Vibration similar to the passing of a truck. Duration estimated.” In other words, it’s only slightly more than a non-event. Pay no attention to the breathless media news briefs squeezed into the gaps between TV shows.

New TV furniture has yet to catch up with new TVs

October 29th, 2007

One of the reasons why I’ve delayed buying a big-screen TV is trying to figure out how to store it. I’ve yet to find a way to store a big-screen TV that meets my requirements:

  1. Material and construction. No metal-and-glass here in earthquake country! The furniture should be made of wood. I’d strongly prefer that it not be a particle-board veneer, but that’s because most veneers are cheap. A high-quality real wood veneer, as opposed to a “wood-esque” plastic coating might work. Wall-mount brackets are a strong plus near to the Pacific Subduction Zone, too.
  2. Color. If we’re talking wood, I like dark colors. A deep red cherry stain is ideal, but that seems impossible unless I build the thing myself and pick out the stain color.
  3. Doors. It’d be nice to be able to close the doors on the TV and hide it from the world. Even with the existing small (20 inch!) set, it feels like the room is built around it. That feeling is only going to be worse with a large set.
  4. TV Size. I keep dancing around which TV to get, but I’m leaning towards the Sony SXRD line. I don’t need the ninja-rific space-savings of LCD or plasma, so I’d rather get an RPTV at half the price. In the Sony SXRD lineup, there are variety of TVs available in the 50″ to 60″ range. As much as I’d like to get an XBR-series TV, the only one in the current model lineup is a 70″ TV, set to come out next spring. I’m going to draw the line at a TV that has a diagonal that is almost my size. (I am 74 inches tall.) There’s a minor constraint here, in that the TV shelf needs to support about 80 pounds and have a shelf depth of about 16 inches, but most furniture easily accomodates that.
  5. Home Theater and Audio/Visual component size. This seems to be the biggest problem I have. Two of my components require a very deep shelf of about twenty inches, and they’re both vital components. One is the Yamaha A/V receiver, and the other is a home theater PC running MythTV. If they were unimportant components, I’d let it go and consider using a small rack of components to the side of the TV. However, the receiver is the hub of the system, and it’s pretty rare to use the TV without pulling the signal from the MythTV machine (whether live TV, time-shifted HDTV recordings, or DVDs). Both of the problematic components need to be accomodated in my storage unit.
  6. Reasonable ventilation. Stereo components hate heat. Computers hate it even worse. If the MythTV computer is getting stored in an enclosure, it’s going to have to stay ventilated to avoid disk failure. (Thankfully, I can use lm_sensors to monitor temperatures.)
  7. Cost. Oh, and in addition to being demanding on what I want, I don’t want to pay a lot, either. Preferably, it doesn’t cost more than the TV that it’s holding. Between the changes in TV, and the changes in video technology, I can’t feel comfortable buying a really expensive piece of furniture that will hold today’s technology. Any TV furniture that’s more than a few years old is great for 4:3 aspect ratio TVs, but I find that nearly everything I watch these days is letterboxed to 16:9. I wouldn’t want to bet on technology staying the same, so I’d like to feel comfortable replacing it.

Word of the day: pleonasm

October 29th, 2007

This blog is brought to you today by the word pleonasm.

It’s a fancy word that refers to redundant words in an expression. I’ve always been annoyed by the phrase “NIC card,” since the acronym “NIC” stands for “network interface card.” Technically, when you say “NIC card,” you’re saying “network interface card card,” and that just makes you sound silly.

After my recent visit to Los Angeles, a colleague pointed out that referring to “the La Brea Tar Pits” is even worse, since “la brea” means “the tar” in Spanish; technically, “the La Brea Tar Pits” translates as “the the tar tar pits.” Somehow, it doesn’t seem as silly when the phrase is a mix of different languages, though.

Life of AAA Eneloop batteries in remote control: 2 months

October 27th, 2007

A couple of months ago, I purchased a set of eneloop low-discharge rechargeable batteries for use in my programmable remote control. On August 19, I installed the first pack of four, promising to follow up when they needed replacement. I finally needed to do so last Thursday, for a lifetime of one day shy of two months.

The batteries that I installed were not fully charged. I pulled them directly from the packaging as they arrived at the house, and had whatever charge they had from the factory. (eneloops are shipped to retailers fully charged because they have such a low self-discharge rate.) I’ll continue to monitor my experiences and post further updates as I continue to gain experience.

No place like home?

October 27th, 2007

I was in Helsinki for an IEEE ad hoc meeting recently. On my last night in Helsinki, I went out for a walk after night, and took this picture of the statue of Kaarlo Juho Ståhlberg, the first President of Finland, in front of the Eduskuntatalo (house of the Finnish Parliament).

Kaarlo Juho Ståhlberg statue

What I found remarkable about the experience is that the statue is only the width of a driveway across from the front steps of the building. I pulled out my tripod and proceeded to fiddle with my camera to set everything up. Nobody approached me and told me that photography was forbidden, or that mysterious security rules dictated that I move along, even though I was only a few meters from the entrance to the building. The parliament may not have been in session, but I can’t imagine that I’d be allowed to set up my tripod anywhere I wanted to on the U.S. Capitol grounds.

More photos from Helsinki are in the Helsinki gallery here.

I’m a travelin’ man

October 27th, 2007

Since September, I’ve been traveling a lot and posting has been light. A few days ago, I logged in to the American web site, and I was greeted with a new elite status:

Executive Platinum status

(This month, I also re-gained elite status on United, due to a two-week period where I took four trans-Pacific flights.)

I’ve never been an Executive Platinum before. I’ve had lousy luck on using first-class upgrades most of the year, so I’m curious to see if my new status helps out my low percentage.

MythTV upgrade to 0.20.2 for SchedulesDirect support

September 14th, 2007

As a result of the Zap2It Labs shutdown, I recently had to upgrade my MythTV installation from 0.20.1 to 0.20.2.

Graciously, Zap2It Labs was scheduled to shut down on September 1, but they extended guide data past that date. For a few days after the shutdown, it was possible to fetch the full 14 days of upcoming data. Once the data service was deactivated, no more data was put into the database and the amount of remaining data dwindled. As I stared at the MythTV status screen, it was obvious that my schedule data would run out during an upcoming trip:

Zap2It Labs mythfilldatabase

(Furthermore, the new TV season starts in late September, so I’d also miss all the season openers on the week of the September 24!)

I’d been delaying the upgrade because Gentoo’s Portage system wanted to upgrade from MySQL version 4 to MySQL version 5. The database upgrade seemed like it had high potential to go wrong, and would not add obvious functionality to MythTV. I’d already experienced one crash that took out the database, and it was painful enough to recover from that.

However, my hand was forced by the Zap2It shutdown. I was out of the country attending an IEEE ad hoc meeting, and I didn’t want to do the upgrade remotely. Fortunately, Zap2It extended listing data beyond their September 1 shutdown date, so I had a few days grace period after returning home.

I wasn’t concerned about the switchover to SchedulesDirect within MythTV, which was described as drop-dead simple everywhere. It was getting there.

MySQL upgrade. Thankfully, I heeded the advice to back up the database before starting. The upgrade process doesn’t convert over the data, and it turned out to be much simpler just to delete the existing database, install MySQL 5 from scratch, and have MythTV set up the new database.

When I attempted to restore the database, I received the following error message:

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

That’s in part because the default character set needs to be configured on the database. What happened is that the table definition for the “people” table uses the name as a primary key, and it doesn’t allocate enough space for the table unless you restrict the character set that field is stored in.

mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;

However, when I attempted to restore the database from my backup snapshot, I received another error message:

ERROR 1062 (23000) at line 24800: Duplicate entry 'Monika Sanchez' for key 2

The error was caused by having two entries with the same text value:

mythtv@myth ~ $ cat mythtv_backup.sql | grep "Monika Sanchez"
INSERT INTO people (person, name) VALUES (2590,'Monika Sanchez');
INSERT INTO people (person, name) VALUES (622,'Mónika Sánchez');

At first, I tried removing the name “Monika Sanchez” from the database, but as it turns out, there are lots of duplicate spelling. The easiest thing to do is to not restore the people table.

mythtv@myth ~ $ cat mythtv_backup.sql | grep -v "INSERT INTO people" > mythtv_backup-nopeople.sql
Quick Code

After restoring the database, I figured the next step was to try repopulating the TV listings.

mythtv@myth ~ $ mythfilldatabase
2007-09-08 08:43:42.604 Using runtime prefix = /usr
QSqlDatabase: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
2007-09-08 08:43:42.619 New DB connection, total: 1
2007-09-08 08:43:42.620 Unable to connect to database!
2007-09-08 08:43:42.620 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-09-08 08:43:42.674 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-09-08 08:43:42.730 Failed to init MythContext, exiting.

According to the Gentoo wiki, that error message indicates that there is no support for MySQL in the QT library. So, I tried rebuilding QT, and and figured that I’d go all the way and upgrade MythTV, too.

At this point, I’m about six hours and fifteen minutes into the upgrade.

MythTV upgrade. This is one of the most uneventful builds I’ve ever watched. Interesting, the Gentoo system started by checking out the 0.20.2 source from the subversion repository, rather than downloading a compressed source code archive.

Myth plugins. Most of the plugins were uneventful, though the MythWeb plugin broke. To use it, I had to remove PHP4 and the older version of Apache that was installed, and then reinstall Apache and PHP5 from scratch. One small change was needed in php.ini to view pages. The “allow_url_fopen” parameter needs to be set to “on” instead of “off.”

MythTV reconfiguration. With MythTV running again, it seemed anticlimactic to switch over to Schedules Direct. Signing up for the service took a couple of minutes, and Bruce Markey’s Schedules Direct configuration procedure took another few. In about 8 minutes, it was over.

By running mythfilldatabase with the SQL debug command, I even noticed that the “people” table I’d been unable to restore was recreated without intervention.

Finally: THE END!

Finally, after about seven hours of work, only 15 minutes of which were related to signing up for and configuring SchedulesDirect, I once again had a two-week window of guide data:

SchedulesDirect mythfilldatabase

My lesson: don’t let MythTV upgrades slide so much in the future!

I heart SchedulesDirect

September 14th, 2007

Earlier this year, Zap2It Labs shut down and stopped giving free TV guide data to MythTV users. In response, the community set up SchedulesDirect, a non-profit organization to license the data for non-commercial uses.

Although I liked getting guide data for free (who doesn’t like free?), the initial SchedulesDirect plan seemed like a good price. SchedulesDirect asked $15 for three months of data. TiVo pricing is currently $16.95 for one month, or $299 for three years.

(Two notes on the TiVo plans: When I bought my current TiVo — now unplugged and retired — lifetime service for the device was $249. Today, their three-year plan advertises an “extra year for $20,” which is the yearly cost that SchedulesDirect hopes to get to if they can sign up enough subscribers.)

Yesterday, though, a good deal got even better. SchedulesDirect announced that $15 now buys six months of listing data:

We have now passed our second milestone and are lowering the membership fee to $15 for 6 months, effective immediately. For existing members, you’ll notice that the expiration date of your account has been extended an additional three months.

I had given SchedulesDirect money on September 12. Frequently, when a company drops its price, you have to contact them to get the improved price plan. More importantly for the cynics out there who grumbled that SchedulesDirect was going to benefit its founders financially, they are showing a clear committment to act like the community service organization that they claim to be.

But, that’s not all. It wasn’t enough just to give existing subscribers the same deal that new subscribers are getting. There’s a bonus for existing paid subscribers:

To thank you all for getting us to this point, we’ve also added an extra day for each day you’ve had a paid membership. It’s our way of showing our appreciation for your confidence in our organization.

Darn! I was out of the country when SchedulesDirect launched, so I couldn’t upgrade MythTV until I returned home on September 8. After a couple of days worth of testing, I only converted to a paid membership on September 12. Had I been in the country, I would have signed up on the first day!