PHP on Ubuntu Gutsy Gibbon with PDO and PDO_mysql
This version of PHP is the default one that comes with this version, 5.2.3. Check you have installed the php5-common package from aptitude as this includes the pdo.so file. If you check phpinfo you should see that PDO is listed as a module although you don’t have any drivers.
Then you should do:
sudo aptitude install php5-mysql
Restart apache and check its error log in case there are any problems. Then simply refresh your phpinfo page and pdo_mysql should be listed.
For earlier versions of ubuntu/kubuntu have a look at this excellent tutorial from theatons, I followed this but its slightly out of date now which is why I’ve posted an update. Most of the rest of the tutorial is still correct though.
Ubuntu/Kubuntu and mod_rewrite
The solution was very simple and I found the answer in this post about ubuntu and apache. Basically, AllowOverride is set to None for both / and /var/www/ by default on ubuntu, which is nice and secure but it caught me out on this occasion. Change the settings to AllowOverride All and create a symlink in mods-enabled to mods-available/rewrite.conf and restart apache – everything should then start playing nicely.
Geshi and Serendipity for Code Snippets
About GeSHi
I thought “geshi” was a word but I just looked it up to link to it and it turns out its actually GeSHi (Generic Syntax Hilighter) which is a very humane way of pronouncing the thing. It is a very popular way to render source code on the web and was originally intended for phpBB. Geshi is great, it has lots of pre-made syntax highlighting rules so the odds are that it can probably already render whatever language you are coding in very nicely, however if it doesn’t then that’s fine too – it is an open standard and you can jump in and write your own.
Using GeSHi
Back to this blog, I added the “Markup: Geshi” plugin from SPARTACUS (the serendipity plugin repository) and added it as an event plugin. I had a lot of problems getting it working – putting it first in the list of event plugins eventually did the trick for me. You use geshi by adding geshi tags around the code you want to show, for example:
phpinfo();phpinfo();Styling GeSHi
Another problem I had initially was with the default resulting fonts, however these are easy enough to change and I now have colours I chose myself (illustrated in my posts about a SOAP server and PHP compilation) which is really quite easy to do. The plugin has files with all the language highlight in them and if you scroll down and look at the “color” entries towards the end of these, it is possible to just replace the red/green/blue defaults with colours that fit in with your look and feel (pink in my case, obviously!). For me the syntax files are in serendipity/plugins/serendipity_event_geshi/geshi – this is also a good place to look to see what languages you have that are supported.
I commonly use:
- php
- bash
- xml
- sql
A useful tip for styling is that the code block is placed into a div with a class named the same as the “lang” attribute – so for example I’ve got some of them resized by adding an entry to my overall css file.
Hope this helps someone, I remember having problems finding much info about using geshi in this way when I first added the plugin. If anyone is having problems feel free to post comments, I have this working on my serendipity installation so I am happy to try to help out.
Adding Markup to Comments in Serendipity
Another thing I’ve been missing is the ability to add markup in comments, such as images. Well, its back! I’ve turned on textile for comments on this site, there is a link under the comments box to a page that shows you the syntax, so feel free to add richer content to this site from now on :)
Bank Holiday Weekend To Do List
- coal hole sorted out – we have the original coal cellar in our hose which was full of DIY stuff and other junk when we bought it – not much has come out and we’ve put a lot more stuff in, to the point where you now can’t get in the door and can’t find anything!
- workshop space sorted – this follows on from the previous point – all the tools and stuff are in B&Q bags all over the floor in the other basement room because we haven’t got any usable storage
- garden digging – got about the last 20 ft square of digging to do in the garden before we can lay turf … weather forecast is lousy though so I doubt that will happen
- runs to the tip – many many of these I should think, hopefully taking some of the junk out of the garage
- living room woodwork – skirting boards and dado rails need cutting to fit, sanding, staining and actually fitting. Fireplace needs sanding and staining and reassembling. Window sill needs staining. Window frame needs repairing. Door needs a new handle. After that we might start on the shelving we’re going to build
We do have help (anyone else at a loose end please feel free to come over as well!) but if we get half of this done it’ll be a miracle, wish us luck and have a good weekend yourself :)
Debian Change Keyboard Layout
dpkg-reconfigure console-data
and then followed the online prompts. For reference (i.e. the next time I have this problem), the | (pipe) symbol on a US keyboard is mapped to the ~ (tilde) on a UK one.
Kubuntu Installation – Disk Partitioning
An error occurred while writing the changes to the storage devices.
The resize operation is aborted
To get around this I resized the main partition in Windows and created a new partition but left it unformatted. When I went back to the Live CD install I got the option “Use largest contiguous space” and that worked fine.
Hope this helps someone!
First Manchester Girl Geek Dinner
I’m based in Leeds, so it was about an hours drive over to Manchester. Thanks to the wonderful world of satellite navigation, I found the venue with no problems. The evening started with some mingling and drinks, and then we were all invited to take seats and help ourselves to the buffet, which was excellent. After the meal we had a variety of talks which were actually really good, I hadn’t been thinking of the talks as the highlight but they certainly were!
During the course of the drinks, the meal, and a few minutes after the talks (although it was a very late finish, 10pm or so, I didn’t leave until half past and then had to drive back to Leeds), I was able to meet and speak with an amazing selection of women of various ages, professions and backgrounds and had some interesting and valuable conversations.
Its early days for this version of this event and the plan is for it to be quarterly, I am looking forward to the next installment.
Grand Entrance Hall

Please admire the retro red and orange floorboards!!
Anyway, things are looking a lot better now – we’ve got a new floor!! I am so excited by this that I am providing a cartoon strip style display :)




I forgot to photograph the doormat we got – its in the porch, fitted rubber-backed doormat stuff that you lay like a carpet. So first impressions on entering our place are now quite different (so long as you ignore the holes in the wall)
