DBD::mysql, MySQL and OS X Lion

Posted on August 2, 2011 by Simon

I downloaded and installed MySQL Community Server 5.5.15 from http://dev.mysql.com/downloads/mysql/5.5.html

Using CPAN, I then tried to install DBD::mysql on a fresh install of OS X Lion and was presented with an error saying it was unable to load the library.

#     Error:  Can’t load ‘/private/var/root/.cpan/build/DBD-mysql-4.019-H1RD6j/blib/arch/auto/DBD/mysql/mysql.bundle’ for module DBD::mysql: dlopen(/private/var/root/.cpan/build/DBD-mysql-4.019-H1RD6j/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: libmysqlclient.18.dylib
#   Referenced from: /private/var/root/.cpan/build/DBD-mysql-4.019-H1RD6j/blib/arch/auto/DBD/mysql/mysql.bundle

Continue reading →

Posted in Apple, Mac OSX, Programming | Tagged , | 1 Comment

Shartak internals – Maps and movement

Posted on July 22, 2011 by Simon

The map for Shartak is held in a database table with over 140,000 rows in it. Each row corresponds to a single location on the map, also called a tile. The initial island map was generated automatically based on a simple bitmap image with varying colours for the different terrain types. Since 2005 there have been many changes to it, most of which are done by manually editing the table one row at a time. Bear in mind that this system is probably not the best way to do it, but it works for Shartak and allows for some interesting map layouts if I ever need them.

Continue reading →

Posted in Programming, Shartak | Tagged , | Comments Off

IPv6 and Shartak

Posted on May 16, 2011 by Simon

Over the last couple of weeks I’ve been trying to figure out IPv6. Having worked through some of the IPv6 certification at http://ipv6.he.net/ I now have an IPv6 enabled web server and mail server as well as IPv6 connectivity at home via tunnelbroker.net

I thought I’d update Shartak to allow access via IPv6 as well as IPv4 – mostly nothing needed to be changed, however…

Continue reading →

Posted in Linux, Programming, Shartak | Tagged , , | 1 Comment

OSX, Remote Desktop and typing a hash

Posted on April 28, 2011 by Simon

I recently had the need to type a hash (#) into a Remote Desktop session from my OSX desktop to a Windows server. Unfortunately to get a hash on a UK keyboard requires pressing ALT + 3 as SHIFT + 3 results in a pound (£). Pressing ALT + 3 through the remote desktop connection didn’t do anything useful so I was somewhat stuck.

Continue reading →

Posted in Mac OSX | Comments Off

ip6tables and CentOS 5.6

Posted on April 24, 2011 by Simon

Having just recently obtained an IPv6 address for my server, I figured it would be a good idea to setup a firewall on the IPv6 address. Although most services are bound to the main IPv4 address only, it doesn’t hurt to be cautious.

Continue reading →

Posted in Linux | Tagged , | 1 Comment

iOS4.2 for the iPhone

Posted on November 22, 2010 by Simon

iOS 4.2 for the iPhone 4 (and other generations) is now available – it includes a number of new features related to printing from the iPhone over wifi (AirPrint), streaming audio and video to AirMusic and AppleTV devices. Neither of those are particularly exciting to me since we don’t have any of those devices. The one new feature that I will make use of is that you can apparently now have custom SMS/MMS text tones and separate tones per contact. Continue reading →

Posted in Apple | Comments Off

Conversion to WordPress3

Posted on October 9, 2010 by Simon

After two years of not posting anything and letting my blog stagnate, I figured it was about time I started posting again. The first job was to update all the software and it seems Moveable Type (MT) has moved on considerably from the really old version that I was running. Since I last posted I’ve used WordPress for other things a few times and it seemed like a good idea to convert my blog over to it. The fact that WordPress 3 was recently released also meant it was a good opportunity to try it out and see what had changed.
Continue reading →

Posted in Personal | Tagged , | Comments Off

Compiling on a 64 bit Linux

Posted on August 5, 2008 by Simon

I’m currently in the process of upgrading my old server to a nice new 64 bit CentOS 5 install and came across a few issues rebuilding some of the packages.
In general I try not to use customised versions of packages since it makes updating the machine so much easier when there’s nothing to rebuild, however some things I do customise slightly such as Apache and Exim.
Whilst rebuilding the Exim RPM I came across some strange errors which I assumed (correctly) were to do with the fact that it was a 64 bit OS not 32 bit.

Continue reading →

Posted in Linux | Tagged , | Comments Off

Upgrading CentOS4 to CentOS5 – rpm error

Posted on May 19, 2008 by Simon

After a recent upgrade of a server from CentOS 4.4 to 5.1 using yum, I ran into a bit of a problem with rpm.
Pretty much any rpm command would result in the following error:
rpmdb: Program version 4.3 doesn’t match environment version
error: db4 error(-30974) from dbenv->open: DB_VERSION_MISMATCH: Database environment version mismatch
error: cannot open Packages index using db3 – (-30974)
error: cannot open Packages database in /var/lib/rpm

Continue reading →

Posted in Linux | Tagged , | Comments Off

SMF and the case of the missing pound signs

Posted on April 1, 2008 by Simon

I’ve been helping a friend setup a new forum using Simple Machines Forum (SMF) and even though it worked fine on a previous installation I’d done, the pound signs (UK currency, not a #) just wouldn’t show up as anything but a ? once they were posted.

Continue reading →

Posted in Linux | Tagged , | Comments Off