All posts by Geoff Jacobs

A new fish tank

I’ve started to set up a new fish tank in my lounge room this week.

It’s a new 3′ tank on a stand that I got from a friend. I’ve been reinforcing and fixing up the stand over the last couple of months, and it’s good to finally see it being used and holding some weight.

I’ve put some shell grit in the tank and will hopefully be adding some crushed coral shortly to break it up a bit. I’ll move my existing fish across in a few weeks if all goes well. It’ll be nice to have my kitchen bench space back (where my other 2 tanks are currently residing).

A few photos of the in-progress set-up:



A Bag of Potatoes

Finally found a use for those ‘environmentally friendly’ bags that you get from Coles and Woolworths.
A while ago I saw an episode of Jamie At Home where his gardener (Brian) planted potatoes directly into a bag of potting mix. It inspired me to try this out.
I basically put some potting mix in a bag, stuck some potatoes in there, watered them and waited a few weeks.

They’re outgrowing their current home though and I’ll be donating them to my sister’s new vegetable patch soon.

Bag of Potatoes

New battery for ClearOne Max Conference Phone

We have a ClearOne Max conference phone at work that has been in need of a new battery for a while. When we do get new batteries for it, they never seem to last as long as they should and always need to be ordered in.
Solution: Use an RC battery pack.
The battery in the conference unit is a 7.2V 1800mAh NiMH battery pack. The RC battery pack is 3000mAH so we get much longer out of it on a single charge.
We’re still able to use the normal charger that came with the phone too.

ClearOne Max conference phone battery mod

Sure it might be big and ugly (I’ve hot glued it to the phone) but it works amazingly well.

Utilising old desktops around the office

So over the years, we have some old desktops in the office which aren’t really good enough to use for development any more. I’ve started breathing new life into them by using them to backup our Subversion repositories by using svnsync.
By setting up cron jobs to sync every x minutes or even hours you can have a huge amount of redundancy for next to no cost.
The read only mirrors are also handy for other applications that create load on your repositories (build servers etc) so I use a near real-time mirror to run trac and our Bamboo server from.

mysql schema…. finally

I know this has taken waaay to long to post. But here it is if anyone still wants it.

# CREATE DATABASE voip;
# USE voip;

#
# TABLE STRUCTURE FOR TABLE 'allocation'
#

# DROP TABLE IF EXISTS allocation;
CREATE TABLE `allocation` (
`allocation_id` INT(11) NOT NULL AUTO_INCREMENT,
`asset_id` INT(11) NOT NULL DEFAULT '0',
`site_id` INT(11) NOT NULL DEFAULT '0',
`extension` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY  (`allocation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE STRUCTURE FOR TABLE 'asset'
#

# DROP TABLE IF EXISTS asset;
CREATE TABLE `asset` (
`asset_id` INT(11) NOT NULL AUTO_INCREMENT,
`manufacturer` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`model` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`serial` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`mac` VARCHAR(12) COLLATE latin1_general_ci NOT NULL DEFAULT '000000000000',
`phone_ip` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`purchase_price` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`purchase_date` DATE NOT NULL DEFAULT '0000-00-00',
`purchase_from` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`invoice_number` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`asset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE STRUCTURE FOR TABLE 'phoneline'
#

# DROP TABLE IF EXISTS phoneline;
CREATE TABLE `phoneline` (
`line_id` INT(11) NOT NULL AUTO_INCREMENT,
`phone_number` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`line_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE STRUCTURE FOR TABLE 'server'
#

# DROP TABLE IF EXISTS server;
CREATE TABLE `server` (
`server_id` INT(11) NOT NULL AUTO_INCREMENT,
`site_id` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`server_ip` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`server_hostname` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`server_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE STRUCTURE FOR TABLE 'site'
#

# DROP TABLE IF EXISTS site;
CREATE TABLE `site` (
`site_id` INT(11) NOT NULL AUTO_INCREMENT,
`site_name` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`street_number` INT(11) NOT NULL DEFAULT '0',
`street_name` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`city` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`state` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`country` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE STRUCTURE FOR TABLE 'user'
#

# DROP TABLE IF EXISTS USER;
CREATE TABLE `user` (
`user_id` INT(11) NOT NULL AUTO_INCREMENT,
`samaccountname` VARCHAR(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;