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.

Advertisements

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.

Frantic

I’m starting a contract job at Durridge next Monday, so I’m trying
to get my life in order. I’ve asked Barney to walk the dog every
afternoon, so that should be ok.

DVD’s

I borrowed some Zone 2 dvd’s from John and Miyuki. They play fine on
the new dvd writer. I get a “wrong zone” error message on the
downstairs DVD player. I have looked up the firmware change for
making the DVD zone-free, and it’s here.
My serial number starts with C1500 and is on a white label.

MBTA

It looks like I can ride the bus from Alewife. To do it all the time,
I’d need a combo pass, which is seventy-some dollars a month. So gas
is probably more expensive, or similar. So if the air-conditioning
works on the bus, and you can generally get seats, it might be worth
it.

Gig, and backups

DVD writer

I got it working yesterday. The big deal was getting the scsi
emulation; I’d only had SCSI cd-writers, so I had to get the ide-scsi
module loaded right. After that, the dvdplusrw tools seem to be the
way to go. It’s really nice being able to add stuff after you’ve
burned.

The backup script I have is pretty rudimentary, and at the moment, to
fit the backup on one dvd, I’m having to delete most derived files,
and compress the rest. Also it doesn’t do things like backup the
database. But it’s a lot better than nothing, and if I leave the
right dvd in the drive, I can run it automatically at night, but I
need to write a program to check for that first. For now, maybe I’ll
just kick it off when I go to bed.

I have to practice this morning, since we’ll be leaving for the gig at
about 3, so I’ll leave fidling with the new hard drive for later in
the week. I’m sort of concerned it might not work, since I know I had
the jumpers right at least once, so I should get to it soon if it
might have to go back. But I certainly don’t have time tomorrow
either.

New DVD writer installed

Simply messing about with computer Hardware

I got the new dvd-writer and 120G hard drive late Wednesday, but I
sprained my ankle Wednesday night, and Thursday I spent in bed with my
foot elevated, and Friday I spent catching up from the things I didn’t
do on Thursday.

So this morning I got up, took care of the important email, and
shut down the computer.

I was replacing the old dvd reader with the new dvd writer, so I
just looked at the cables and jumpers on the old one and put the new
ones on the same way. This turned out to work.

I have tested cd reading, and it’s fine. DVD playing is even
better than with the old one, at least for Zone 1 DVD’s. There’s
apparently a firmware patch for the Creative DVD reader, but you can
only install it under windows. So I’m saving the drive in case I ever
put it on a Windows system and run it. Or I’ll give it to someone.

I’m now looking into testing the dvd-writing. The current page
that looks useful is this one.

I also installed dvdplusrw. It looks like at some point cdrecord
did dvd-RW but not DVD+RW. This may no longer be true, but also the
interface for dvdplusrw might be better. (They’d have to work hard to
make it worse.)

It’s lunchtime now, so I may not get much more done on this today, but
it looks good.

Complicated messing about with computer hardware

I tried 2 different jumper settings and still didn’t get the bios to
recognize the new hard drive.

Also, since I’m retiring the SCSI enclosure that had the CD-writer in
it (also the busted tape drive), I need to find a different cable for
the scanner, so it can connect directly to the SCSI card instead of
daisy-chaining through the enclosure.

I don’t think I’ll do any more on either of those things today.

BRS

Emailed Bruce about Alan.

Emailed status to the Board. Mary Briggs doesn’t see why I don’t
ask for more discount on the summer sessions.

West Gallery and da Rore

Music Publishing

I promised to copy the da Rore for Anne, and in order to practice the
divisions it’s easier to have a transcription with the tune and the
two divisions in score. So since I’ll see Anne this afternoon at West
Gallery, I’ll try to get the transcription made.

I want to check out the lily 2.2 lyricsto command. It looks like it
would help. Lily
documentation
says that you write melisma and melismaEnd around
notes that are all on one syllable. But I think upgrading to lily 2.2
is too much work for this morning.