In order to support a new product development I mentioned in an earlier blog post, I re-did my existing waypoint database as a PostGIS geographical database. I also added some foreign keys and some other cleanup that I’ve been meaning to do for a while. But obviously, I don’t want to support two databases, so today I’ve been converting one of my existing waypoint generator perl scripts to use the new PostGIS database instead of the MySQL database it was on before, but without any actual GIS functionality. And Houston? We have a problem. Doing a full US + Canada data load on the MySQL version takes about a minute and a half. Doing the same load on the PostGIS version takes twenty five minutes. Something tells me that I need to make some adjustments here.
Category: Rant
That was close!
The theme I have been using for a couple of years on this blog (Maple) didn’t work very well with WordPress 2.5 and I can’t find an updated copy anywhere. Since I’ve hacked the shit out of it over the years, I decided it was time to make a fresh start with a theme that’s actually supported. So the first thing I did was copy the default theme, and try to make it look more like Maple. That wasn’t fun, and I’m not 100% satisfied with the results. So I decided to look at other themes.
I couldn’t find what I wanted at the official themes site, mostly because their search engine doesn’t categorize themes by category, and also because their “preview” function doesn’t work. But I found this other site, whose name I won’t mention but it had the word “free” in the URL. I found a bunch of nifty themes there, and downloaded them. I was just customizing one theme to add gravatar support and give the comments an alternating colour scheme, when I noticed something weird down at the bottom. It looked like spam. I grepped the theme code for the spammy urls, and couldn’t find them. But I figured the offending code must be in footer.php. Sure enough, all the themes I’d downloaded from this site had encrypted code in footer.php. I couldn’t read it or decrypt it, but it obviously was there to insert spam code in your blog. I tried replacing the footer.php with one from the default theme, and that broke other stuff. Crafty buggers.
Anyway, I’ve removed all traces of this crap, and I guess we’re all stuck with the psuedo-Maple theme until the official site starts working again.
And it just gets worse
On March 25th, I ranted about a developer who had checked in a bunch of stuff that required a special “upgrade DVD” without telling the other developer that this would be required in Rants and Revelations » Developer dumbassedness. Well, it turns out it’s worse than that. Far worse. Not only didn’t he not tell us about the magic DVD, but he hadn’t even tested the damn DVD. It’s now 2 weeks later, and his DVD *still* doesn’t work.
So now I’m caught in a vice – I had to “rebase” my development environment to the new build in order to deliver some bug fixes, and now my development environment and my test system are at different builds, which makes it hard to test things, and especially hard to use the remote debugger in Eclipse. And I can’t get them back in sync until this damn DVD is ready.
I’d also like to mention that I did a much more ambitious upgrade DVD a few years ago, where his DVD is upgrading from CentOS 5.0 to CentOS 5.1 and reformatting the content partition from ext3 to xfs, mine was upgrading from RedHat 7.3 to CentOS 3.3. And I didn’t leave the rest of the developers out to dry because I tested the hell out of it on my test system, reformatting it back to RedHat 7.3 and running versions of my upgrade script over and over for weeks before I put it into the development stream.
Oh, that’s not good
I got an email from one of the sysadmins at NCF saying that the news directory has run out of space. After poking around a bit, I’ve discovered that:
- cron jobs, including the nightly expire job, haven’t run since March 18th
- I haven’t been receiving emails sent to the NCF news account, possibly for even longer than that, which is why I didn’t notice when the system throttled 3 days ago. Normally newswatcher sends these emails which I have forwarded to SMS so I don’t miss them.
The sysadmin wonders if the cron jobs not running has anything to do with the DST change. The machine is ancient, and running an ancient version of Solaris.
Of course, the fact that I didn’t notice the lack of the daily news admin email in my morning scan-and-delete folder isn’t good, either.
Successories
I’ve got an idea: When you’re trying to motivate people, don’t try to promote the concept of “Teamwork” by showing something that was built by slaves at the whim of a despot, which killed millions of the people involved in its construction, and which failed miserably at its design goal. Just sayin’.