We were working on a remote machine last week, and had vnc tunnelling through ssh to use some of the gui utitlities on the machine. And after spending a bunch of time looking for a web browser on the remote machine, I realised, I could just set up a tunnel to the webbrowser and then Bob and Mason could hit the website on my ipnumber.

So I showed Bob and Mason how to set up a tunnel in putty, which is pretty easy, there is a section under connections called tunnels where you can specify the port at the remote and local end. It certainly makes life a lot easier than trying to debug a page in lynx.

Currently there is a bug in the Koha installer, in that one of the columns in one of the tables is using a word that is reserved in MySQL 5, but wasn’t in MySQL 4. This will be fixed for new versions of Koha, but for now the fix for it is detailed here.

The way joins are handled have changed slightly to, the way to fix them (at least until 2.2.6 is out and you upgrade to that) is detailed here.

This post is as much for me as for anyone else. We have one client who has quite a mixed printing environment and its sometimes quite tricky to get Koha printing to the many different printers around their branches. We are using CUPS to handle the printqueues, here are some links I found very useful in setting up the printqueues.

• Printing to windows PCs
• Adding your first printer
• man lpadmin

Perhaps these might be of use to someone else too.

Although I spend 90% of my working life in my office at home, occasionally I need to work on site.
Sometimes you can’t beat being there in person and talking face to face.
For example a week or so ago I spent about 5 and a half hours on site and got a lot of work done. It would have still been about 5 and a half hours work at home, but it would have taken me at least 10 hours to do. With all the waiting for emails and talking on the phone it adds a bunch of time to the task.

(more…)

So last night, for the fun of it, I tried to build the Koha opac title search using Ajax. And with the help of the most excellent CGI::Ajax module, I ended up with a module Koha::Ajax which is 138 lines long, most of that is pod and html. (more…)

So a couple of nights ago we came across a weird problem. A chunk of code in one of the Koha modules was causing a script that called it to hang. Only when called from the web though, it works fine from the command line. (more…)