Irish tenor serpent

The tenor serpent has decided that he’s the next John McCormick.
So I’ve been learning “How are things in Gloccamora?” and letting it
loose on “I’ll take you home again Kathleen” and such.

It’s much better at staying on pitch than it used to be, and when
it doesn’t spend a lot of time above middle C, it’s usually pretty
close to on when I check it.

So the right way to be practicing it would be with chant or
something and a drone, but it want to sing the McCormick repertoire.

More work on the website(s)

I wasn’t up to tackling the lilypond scripts, so I sent the test css
page url to a bunch of people, and put favicons on both laymusic and
brs.

The way I found to get a favicon was to use display to generate a
square image of the right size, and then use png2ico to get the icon.
I gave it both 16×16 and 32×32 icons. The serpent is OK, but the
recorder is only recognizable if you already know what it is.

Planning the site redesign

There are two main things I’m going to work on in the next week or
two about the site. One is improving the format, hopefully so that
those pesky IE5.0 on Mac OSX people can read it, and also because the
current design with all the site links in the right column is starting
to be unwieldy, now that I have the google ads (which might be
producing useful checks some day). So I’m going to try out some
three-column designs, and see what happens.

The other big problem is the lilypond version problem. I have
written out a lot of my thoughts on this problem in an email to the
lilypond
user list
. I’m hoping to work on fixing and redesigning the
db2htm.py script over the weekend.

Log entry for John’s problem browser

I got John to look at the blosxom log on the main site, and here’s
what the log thinks he’s using:

64.12.116.14 – – [03/Feb/2005:23:33:25 -0500] “GET
/cgi-bin/blosxom.cgi HTTP/1.0” 200 13750 “-” “Mozilla/4.0 (compatible;
MSIE 5.1b1; AOL 5.1; Mac_PowerPC)”

64.12.117.5 – – [03/Feb/2005:23:33:58 -0500] “GET /cgi-bin/blosxom.cgi/cantabile HTTP/1.0” 200 8813 “http://www.laymusic.org/cgi-bin/blosxom.cgi” “Mozilla/4.0 (compatible; MSIE 5.1b1; AOL 5.1; Mac_PowerPC)”

More blogging implemented, google in the works

I managed to set up categories on blosxom. The categories plugin
doesn’t work for me, but the categorylist one does exactly what I wanted
out of the box.

So now I have categories on both my
personal blog
, and the laymusic.org
one
.

I also set up a link from the http://www.laymusic.org one to the
serpent.laymusic.org one. This is the first time I’ve put a link to
serpent.laymusic.org from http://www.laymusic.org; I doubt that my little
webserver will be overwhelmed, but we’ll see.

I have written John to see whether he can read the blogs. If so, I’ll
change the css so that it works more like the blosxom html flavour.

I also applied for having google ads on the page. I don’t expect to
get rich this way, but I’m getting a couple of thousand hits a day, so
it could be a small income stream if they’re the kind of hits that
lead to clickthroughs.

How to keep permanent links permanent

“touch -r” changed the modification date to be the date of the file.
So if you want to change a file without changing its modification
date, you make sure you have a fresh buffer in emacs and then say
“touch -r file~ file”.

I think it’s a good idea to change the color of the added code, the
way Peter Flynn does at his blog.

Update: Feb. 10, 2005
This seems to be the way to write the html for that. The way to
actually get the date to stay the same seems to be to name the file
with the date
and use the permtimez plugin.

Or maybe just date the update the way Philip Greenspun does in his blog.

header of blog item title

I’ve changed the markup for the blog entry to be equivalent to
header 2. So if a subsidiary item should be on the same level as the
title, like this one, use header 2, if it should be a lower level, use
header 3.

Walkabout

Gorgeous scenery. I didn’t make as much sense of the plot as I
might have liked to. I asked John Littler whether he’d been there,
and apparently he had, although he hadn’t seen the movie. But he’d
bee in desert areas north of Adelaide.

Installing OpenZaurus 3.5.2

To set up network translation:

On tuba:

route add -host 192.168.129.201 usb0;
iptables -t nat -F;
iptables -t nat -A POSTROUTING -j SNAT -o eth0 –to 192.168.1.100;
echo 1 > /proc/sys/net/ipv4/ip_forwardpp;

On zink:

route add -host 192.168.129.1 usbd0;
route delete -net 192.168.129.0/24 usbd0;
route add default gw 192.168.129.1;

(This is from the website I was using
http://www.ruault.com/Zaurus/ethernet-over-usb-howto.html — history doesn’t work on the
OZ shell.)

It looks like the zink side survives a reboot, but the tuba side does not.

weblogging

Figured out again how to set up user scripts. The answer is that
you need the script in the directory /usr/lib/cgi-bin. So I have a
user-owned directory under there, and a line in the public_html
Makefile to install all .cgi scripts to the user-owned directory.

Have done this for lconrad; need to do it for sixtoe, but the
script for sixtoe doesn’t work, so I’d need to look at that.

So I have now installed Blosxom, and will be looking at the plugins
and using it with css, etc.

BACK to www.laymusic.org

I have got the schema (roughly) into the mysql database on
http://www.laymusic.org.

When I try to get the data in from the postgresql dump, I get:

$ mysql -pjsb1750 laymusi_musicpublish
ERROR 1064 at line 3: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COPY piece (id, title, composer_id, copyright, Directory_name,

So I’m going to have to research mysql sql, or see if some kind person
has written a script to turn pg_dump output into mysql input.

The answer turns out to be that you run pg_dump with the –inserts
option. So the data is now in the mysql database; now I have to check
it, and modify abc2db.py to put the data into the mysql database, and
db2html.py to get the data out of the mysql database.