Note: Technical Talk being moved to:

Thursday, 24 February 2011

Obtaining a Cricket Postmark

Thanks to some fabulous advice from Colleen of Australian PictorMarks I was able to obtain this awesome cricket postmark through Australia Post on an Ashes Cover.

I think the end result is quite pleasing to the eye.

The Great Forgery!!

As the Sydney Cricket Ground turned pink for Jane McGrath this summer, I found myself the lucky recipient of a signed and framed Test Shirt from Phil Hughes, courtesy of the McGrath Foundation.

Whilst awaiting my prize, I asked my daughter to illustrate the shirt for my work newsletter. Looking at her handiwork alongside the now received shirt, I feel quite satisfied that should she fall upon hard times in the future, she may well have a decent career in forgery!

Monday, 21 February 2011

SQL Server - Query Backups Taken

Note to self ... Good place to check backups taken:


Friday, 18 February 2011

PeopleSoft - Access Log Table

A good place to check login/logout activity

Thursday, 3 February 2011

MySQL Global Options File - Storing Password

New to MySQL, but will make notes for my benefit, and for the odd person who stumbles on this post via Google. I need to write a few cron scripts for a MySQL database and I don't think I should put the connect string in them for the world to see.

A reasonable solution found is to simply store the password in the /etc/my.cnf (options) file.

Added the following text to achieve this. Also decided to store the default database name as well to make life simpler.

For this setting to take affect, just had to restart the database. So now the cron script can simply connect to the correct database by typing in "mysql".

Need to assess security implications of this decision as I proceed to learn the nuances of MySQL.

Wednesday, 2 February 2011

Check O/S Version

uname -a

Also .....

cat /etc/issue

oslevel -r (shows technology level)
oslevel -s (shows service pack)