I started my new job as an Analyst Programmer with Citi today and so far I don’t have a login, my own machine or a permanent pass card and I’m not completely sure what exactly it is I’ll actually be doing but I have mastered the use of the coffee machine. It’s all good :)

MySQL upgrade

I finally got sick of not being able to use SQL subqueries and decided to upgrade my MySQL installation from 4.0.x to 5.0.x.

I had wanted to do this previously but was afraid I’d end up breaking something and be left without a working development environment or a website either, for that matter, so I resorted to complicating my custom queries in CakePHP with JOIN statements :(

I couldn’t find a 5.0.x package for Slackware 10.0 in the package browser, so I bit the bullet and downloaded the source archive…

I extracted the files, issued the immortal ./configure && make commands, left things for a while and was pleasantly surprised when the compilation succeeded. removepkg got rid of the old package, a new one was easily produced using checkinstall and installpkg installed it for me.

The only problem I had was when I went to fire up the daemon and nothing happened. It turned out that the startup script was expecting mysqld_safe to be found in /usr/bin instead of /usr/local/bin where it had been installed to: that was quickly remedied with the creation of a symbolic link. From there it was plain sailing, all my databases were functional.

But enough techno-gibberish. The point of the matter is that I managed to build a package from source, get it up and running and the system as a whole still worked! Linux administration definitely appears to coming more natural to me. Bob be praised :)

Neuromancer re-re-revisited

NeuromancerI was having a quick look through some second-hand books last weekend and happened across a copy of Neuromancer by William Gibson, the “father of cyber-punk”. I had to have it and this marked the third time I’ve purchased a copy of this seminal work.

I started into it on the bus home yesterday and it still seems fresh. Neuromancer is one of the very few books I’ve read more than once and I’ve enjoyed it every time, so much so I’ve lost track of the exact number of times I’ve read it.

I’m a huge Gibson fan and can’t wait to get a copy of his latest book, Spook Country :)