Feb 282005
 

As of today (Feb­ru­ary 28, 2005), I work for Sun Microsys­tems. And no, it’s not what you think. It’s actu­ally all Eve Maler’s fault. She and I have enjoyed work­ing togeth­er on the XML Con­fer­ence and the CSW XML Sum­mer School for a couple of years, so when an open­ing came up in her group at Sun that she thought I was suited for, it was too good an oppor­tun­ity to pass up. I filled in the applic­a­tion, Eve made sure the right people saw it, and everything worked out! We did try to keep it secret from Tim for a while, but that ended up not being prac­tic­al. After all, he had already figured out the issues with liv­ing in Canada and work­ing for a U.S.-based group and knew the right people to talk to.

My title is Seni­or Tech­nic­al Pro­gram Man­ager; like Eve I will be work­ing on inter­op­er­ab­il­ity and tech­no­logy part­ner­ships. I’m look­ing for­ward to it, although since I’ve nev­er worked for a big com­pany before, I’m not quite sure what to expect in many ways. I do know that blog­ging is encouraged!

And then there are my oth­er activ­ites. Since the W3C Pro­cess Doc­u­ment does not allow two mem­bers of the W3C Advis­ory Board to come from the same com­pany, and Eduardo Gutentag was recently elec­ted, I am resign­ing from the AB after almost three years. I’ve learned a lot from the AB mem­bers and the W3C Team and I thank them. 

I will chair the XML Con­fer­ence again this year, but Eve won’t be on the Plan­ning Com­mit­tee. And I’ll be in Oxford in July for the XML Sum­mer School as well.

Feb 242005
 

I’ve been wait­ing patiently for the updated Word­Press to come out. Once it did, I decided I should really update MySQL as well, so that I could finally serve pages prop­erly as UTF‑8. I’d been run­ning MySQL 3.23, and so I needed to upgrade to 4.0 to get real UTF‑8 sup­port. I also con­tem­plated upgrad­ing to MySQL 4.1.

The pro­cess was just com­plic­ated enough that I figured I should do the backup brain thing and dump the pro­ced­ure here; it might help someone else to have the gory details doc­u­mented, and it will cer­tainly help me when I come to upgrade!

I haven’t really used a Unix sys­tem since I had to move to Win­dows in 1996; for­tu­nately Debi­an makes upgrad­ing and installing really easy (who­ever came up with the apt-get sys­tem deserves lots of praise). I run the stable ver­sion of Debi­an because it was set up on stable in the first place and I’ve nev­er really needed to change that and I’d rather have the secur­ity patches be applied auto­mat­ic­ally. Except for, the Debi­an stable ver­sion of MySQL is, of course, 3.23 and not 4.0. The best solu­tion to this seemed to be to install the back­port of MySQL 4.0 from backports.org. In the­ory this is really easy, of course in prac­tice it does take a cer­tain know­ledge of how Debi­an works. This is because Debi­an Does Everything Dif­fer­ently (DDED). I’m sure there is lots of logic in how Debi­an does things, I just have nev­er quite taken the time to fig­ure it out. And up till now, I did­n’t need to. I did have one big advant­age though, Edd Dum­bill was online and was able to help me fig­ure out those little details that make the dif­fer­ence between frus­tra­tion and success.

So here’s the step-by-step upgrade details I needed. Debi­an experts have no need to read any further…

  1. Add the line deb http://www.backports.org/debian stable mysql-dfsg into your /etc/apt/sources.list file (I don’t know why it’s called dfsg and I’m not sure I want to know).
  2. Run apt-get update and then apt-get upgrade, or apt-get dist-upgrade.
  3. Find that although the pack­age list gets updated, noth­ing hap­pens and the mes­sage is “0 to install”
  4. Edd sug­gests check­ing the policy with apt-cache policy mysql-server.
  5. This shows that Sur­prise! the upgrade isn’t being installed.
  6. To increase the pri­or­ity, we need to pin the back­port. Edd tells me the magic incant­a­tion, which is to cre­ate a /etc/apt/preferences file with the contents
    Package: *
    Pin: release a=backports.org
    Pin-Priority: 995
  7. apt-get upgrade now works! Hurrah!
  8. Next to run mysql_fix_privilege_tables to fix the GRANT tables etc. Except for, the MySQL data­base root account has spaces in the pass­word and this script does­n’t like that. Even hard­cod­ing the pass­word in the script does­n’t work.
  9. Use mysqladmin to change the root pass­word so it no longer has spaces in it (BTW, does any­one else find it annoy­ing that some MySQL things use executable u=username and oth­ers use executable u username? For­tu­nately PHPMy­Ad­min makes most of my MySQL admin duties much easier).
  10. Suc­cess! The blog still works, the tables appear to have been fixed, and life goes back to nor­mal. I decide to not upgrade to MySQL 4.1 just yet, since I don’t really need to. This box in the base­ment acts as my fire­wall, DSL con­nec­tion, and web­site host; stick­ing with a stable con­fig­ur­a­tion strikes me as being a good idea most of the time.
Feb 222005
 

The North­ern Voice blog­ging con­fer­ence was on Sat­urday. I was on the organ­iz­ing com­mit­tee and I was glad that all our efforts paid off. People seemed to really enjoy them­selves, chaos did­n’t even threaten to take over, and because some registered attendees did­n’t show up, we even man­aged to fit every­one in without exceed­ing the fire depart­ment reg­u­lated capa­city! There’s some­thing relaxed about put­ting on a con­fer­ence that only costs $CAD 20 to attend (of which a quarter went on the cof­fee and tea, so it was nice that we were praised for the tea selec­tion). We also had a good num­ber of spon­sors.

The con­fer­ence con­tents have been exhaust­ively covered in oth­er post­ings — I have nev­er been to an event that was so logged, blogged, and pho­to­graphed in my life! The first posts and pho­tos were going up 15 minutes in to the con­fer­ence — just check out the 566 pho­tos on Flickr, the Pub­Sub feed, the Tech­nor­ati feed, or the del.icio.us list­ing to get a fla­vour of the day. 

This was a small. light­weight con­fer­ence with lots of scope for people to talk. At $20, people could afford to come who knew little about tech­no­logy (e.g., the woman who asked Tim Bray what Sun Microsys­tems does, as she’d nev­er heard of it) but we also had people from way out­side Van­couver (Bay area, the UK, Toronto…) which I would­n’t have expec­ted. And they all seemed to get some­thing from it and star­ted ask­ing about next year. 

Per­son­al take-aways: I should­n’t be so form­al in what I write; writ­ing more rather than being per­fect is what I should focus on (I blame too many years spent writ­ing form­al sci­entif­ic papers). The RSS excerpt vs full feed debate goes on; one way to make sure Robert Scoble does­n’t read what you write is to only put head­lines in your feed, for example, and short excerpts are also likely to get your blog dumped from his feed list (one could per­haps think about wheth­er this is an advant­age or not, depend­ing on wheth­er you want someone in Microsoft pay­ing atten­tion to what you write). The biggest buzzwords were authen­ti­city and trans­par­ency and how to find the line between reveal­ing enough of your­self to be your­self, without com­prom­ising your or oth­er people’s pri­vacy. I also dis­covered that even in a con­fer­ence with only two tracks you can miss out on a lot and pod­casts only go so far in alle­vi­at­ing that. And that if people enjoy the day, they want to buy the t‑shirt.

Upgrading

 WordPress  Comments Off on Upgrading
Feb 212005
 

As you’ve prob­ably noticed by the dif­fer­ent look to Any­way, I’ve upgraded to ver­sion 1.5 of Word­Press. It will take a little while before I have everything imple­men­ted the way I want it; in the mean­time please let me know if any­thing is broken!

/* ]]> */