Archive | March, 2013

Getting Old – Turning 35 Today – Happy Birthday To Me!

Posted March 21, 2013 at 9:45 am in Trips & Travel

Well another year has gone by, big year it was – with me getting married and all. Today, March 21st 2013 I have been on this earth for 35 eventful years. I’m not actually posting this right now, as one again (just like last year) my beautiful wife is taking me on a surprise vacation – so I have no idea where I’m going.

I do know, that it will be awesome – that’s for sure! Last year she took me to Pulau Weh, which was spectacular. We did some diving, which was spectacular!

SCUBA Diving Pulau Weh

We did a lot of chilling, eating and exploring – it was amazing, a true paradise.

Pulau Weh

I can’t wait to find out where we are going, I’ll probably know by the time you read this..Excites!

My birthday in –

2012 – Happy 34th Birthday To Me!
2011 – Happy Birthday To Me!
2010 – Random Blog Post #1 – What A Week & My Birthday
2009 – No post for some reason?!
2008 – My Surprise 30th Birthday Party / Being 30 – Happy Birthday to Me!
2007 – Happy Birthday to Me Again
2006 – Happy Birthday To Me.
2005 – The Triple Faggot Birthday Bonanza!
2004 – Hadn’t started blogging yet, and was still in the UK actually.

Tags: , , , , , , , ,

Continue Reading · 2 Comments · Trips & Travel

Fix Unknown Table Engine ‘INNODB’ Error For MySQL Munin Plugin

Posted March 8, 2013 at 9:45 am in Internet & Tech, Sys Admin & DevOps

If you are running Munin on a newish server, with a new version of MySQL and you have InnoDB disabled (as recommended by scripts like mysqltuner.pl), the Munin plugins for MySQL will fail with the following error:

DBD::mysql::st execute failed: Unknown table engine 'INNODB' at /etc/munin/plugins/mysql_connections line 958.

It’s a pretty easy fix though, just edit the follow file:

sudo nano /usr/share/munin/plugins/mysql_

And at line 960-965 (+960 in vim or CTRL+_ 960 in nano), replace this:

if ($@) {
if ($@ =~ /Cannot call SHOW INNODB STATUS because skip-innodb is defined/) {
$data->{_innodb_disabled} = 1;
return;
}
die $@;

With this:

if ($@) {
if ($@ =~ /Unknown table engine 'INNODB'|Unknown storage engine 'innodb'|Cannot call SHOW INNODB STATUS because skip-innodb is defined/i) {
$data->{_innodb_disabled} = 1;
return;
}
die $@;

Your MySQL plugins for Munin should now work fine 🙂

Tags: , , , , , , ,

Continue Reading · No Comments · Internet & Tech, Sys Admin & DevOps

MongoDB For Ubuntu Doesn’t Install A Logrotate Script

Posted March 6, 2013 at 4:08 pm in Internet & Tech, Sys Admin & DevOps

This tripped me up before, one of my servers very rapidly ran out of disk space and I had to figure out why – I scanned the server and found the culprit directory was /var/log/mongodb/ and there was a single multi GB log file in there.

I checked /etc/logrotate.d/ and indeed the Ubuntu MongoDB package directly from mongodb.org (mongodb-10gen) doesn’t install a lot rotate script (which is rather perilous).

So as I wanted to keep logs on rather than disabling them totally, I rolled up a logrotate script. All you need to do is:

nano /etc/logrotate.d/mongodb

Then paste inside:

/var/log/mongodb/*.log {
daily
rotate 30
compress
dateext
missingok
notifempty
sharedscripts
postrotate
/bin/kill -SIGUSR1 cat /var/lib/mongo/mongod.lock 2> /dev/null 2> /dev/null || true
endscript
}

That’s it, now your logs will be rotated and compressed and your server diskspace won’t explode.

Tags: , , , , ,

Continue Reading · No Comments · Internet & Tech, Sys Admin & DevOps

Upgrading Ubuntu 10.04 To Use SVN 1.7 Client

Posted March 4, 2013 at 9:45 am in Internet & Tech, Sys Admin & DevOps

If you are using ‘svn switch‘ on your deployer and you have older servers (Ubuntu 10.04 for example) the standard repo version of SVN will be 1.6, and won’t support the command.

What you need to do is upgrade the SVN client to version 1.7x with a PPA package. I suggest using the following commands:

sudo aptitude install python-software-properties;
sudo apt-add-repository ppa:svn/ppa;
sudo aptitude update;
sudo aptitude safe-upgrade

From top to bottom, it installs the software you need to add a PPA, adds the PPA, updates the repo index and then upgrades all packages (which will upgrade SVN too).

A PPA is a Personal Package Archives for reference.

Using a Personal Package Archive (PPA), you can distribute software and updates directly to Ubuntu users. Create your source package, upload it and Launchpad will build binaries and then host them in your own apt repository.

That means Ubuntu users can install your packages in just the same way they install standard Ubuntu packages and they’ll automatically receive updates as and when you make them.

The PPA above is from the SVN development team, so I assume it to be trustworthy.

After completing you should get this:

svn --version
svn, version 1.7.7 (r1393599)
compiled Oct 26 2012, 08:48:56

Have fun!

Tags: , , , , , , , , , ,

Continue Reading · No Comments · Internet & Tech, Sys Admin & DevOps